search

pinpoint-apm / pinpoint-docker

Official Dockerized components of the Pinpoint
http://pinpoint-apm.github.io/pinpoint/
Apache License 2.0
460 stars 227 forks source link

v2.5.1 URI Metric and Infrastructure SQL errror #174

Closed CN-RexYeung closed 1 year ago

CN-RexYeung commented 1 year ago

I have installed version v2.5.1 using Docker Compose, and the servermap and inspector functions are normal, but the URI Metric and Infrastructure functions indicate SQL errors. After my simple investigation, it was found that there are missing data tables in the database. Do I need to perform additional SQL initialization?

CN-RexYeung commented 1 year ago

image

CN-RexYeung commented 1 year ago

image

ga-ram commented 1 year ago 
docker-compose -f docker-compose.yml -f docker-compose-metric.yml restart pinot-init

above command will restart pinot initializing process and will create necessary tables.

Current docker compose script just waits a few seconds after starting up the pinot containers and then run the init commands, and it seems like the waiting time is not enough (and it varies according to each environment also). It would be great if you can contribute to modify that script so that it can wait until all the containers are ready and then run the init commands.

CN-RexYeung commented 1 year ago

Thank you very much. I ran the above command according to your suggestion and found the reason for the missing data table. The log prompt for the Pinot init container was found to be 'curl: (35) OpenSSL SSL_connect: SSL_ERROR_SYSCALL in connection to raw. gitubusercontent. com: 443', which may be a network or DNS issue.