The pinpoint-docker-pinot-init service failed to start #193
Comments
|
{"code":400,"error":"TableConfigs: systemMetricDataType already exists. Use PUT to update existing config"} |
|
connection refused => restart pinot-init after pinot cluster is initialized please provide pinpoint-web logs if |
ERROR o.s.b.w.s.s.ErrorPageFilter -- Forwarding to error page from request [/uriStat/summary.pinpoint] due to exception [ Error querying database. Cause: java.sql.SQLException: Failed to execute query : SELECTThe error may exist in class path resource [mapper/uristat/UriStatMapper.xml]The error may involve com.navercorp.pinpoint.uristat.web.dao.PinotUriStatDao.uriStatApplicationSummary-InlineThe error occurred while setting parameters |
|
can you access pinot web at localhost:9000 ? |
Port 9000 is accessible, but upon checking the logs, it seems that port 8099 is being refused. The corresponding IP is pinpoint-batch, a container, and indeed, telnet to this IP on port 8099 is not successful." Caused by: java.net.ConnectException: Connection refused: /172.24.0.12:8099 |
It seems your understanding is correct. If the YML file specifies that the pinpoint-docker-pinot-broker-0 container corresponds to port 8099, but in practice when accessing it attempts to connect to the pinpoint-batch container and fails, there may be some confusion or errors in the configuration. I suggest carefully checking the YML file to ensure that the pinpoint-docker-pinot-broker-0 container and its corresponding port 8099 are correctly specified. |
|
well if you haven't changed compose files, pinpoint-batch container is on port 8079. |
i haven't changed compose files ,So I don't quite understand why it would attempt to access port 8099 of the batch container. pinpoint-batch/.env:BATCH_SERVER_PORT=8079 |
|
You have to check if BATCH_SERVER_PORT=8079 in /.env. |
log--->> Error querying database. Cause: java.sql.SQLException: Failed to execute query : SELECTThe error may exist in class path resource [mapper/uristat/UriStatMapper.xml]The error may involve com.navercorp.pinpoint.uristat.web.dao.PinotUriStatDao.uriStatApplicationSummary-InlineThe error occurred while setting parametersSQL: SELECT uri, sum(apdexRaw) as apdexRaw, sum("count") as totalCount, max(maxLatencyMs) as maxTimeMs, sum(totalTimeMs) as totalTimeMs, sum(failureCount) as failureCount, version FROM uriStat WHERE tenantId = ? AND applicationName = ? AND "timestamp" BETWEEN ? AND ? GROUP BY uri, version ORDER BY totalCount desc LIMIT ?Cause: java.sql.SQLException: Failed to execute query : SELECT; uncategorized SQLException; SQL state [null]; error code [0]; Failed to execute query : SELECT Error querying database. Cause: java.sql.SQLException: Failed to execute query : SELECTThe error may exist in class path resource [mapper/uristat/UriStatMapper.xml]The error may involve com.navercorp.pinpoint.uristat.web.dao.PinotUriStatDao.uriStatApplicationSummary-InlineThe error occurred while setting parametersSQL: SELECT uri, sum(apdexRaw) as apdexRaw, sum("count") as totalCount, max(maxLatencyMs) as maxTimeMs, sum(totalTimeMs) as totalTimeMs, sum(failureCount) as failureCount, version FROM uriStat WHERE tenantId = ? AND applicationName = ? AND "timestamp" BETWEEN ? AND ? GROUP BY uri, version ORDER BY totalCount desc LIMIT ?Cause: java.sql.SQLException: Failed to execute query : SELECT; uncategorized SQLException; SQL state [null]; error code [0]; Failed to execute query : SELECT Error querying database. Cause: java.sql.SQLException: Failed to execute query : SELECT DISTINCT hostGroupNameThe error may exist in URL [jar:file:/pinpoint/pinpoint-web-boot.jar!/BOOT-INF/lib/pinpoint-metric-2.5.3.jar!/pinot-web/mapper/pinot/HostInfoMapper.xml]The error may involve com.navercorp.pinpoint.metric.web.dao.pinot.PinotSystemMetricHostInfoDao.selectHostGroupNameList-InlineThe error occurred while setting parametersSQL: SELECT DISTINCT hostGroupName FROM systemMetricTag WHERE tenantId = ? AND hostGroupName IS NOT NULLCause: java.sql.SQLException: Failed to execute query : SELECT DISTINCT hostGroupName; uncategorized SQLException; SQL state [null]; error code [0]; Failed to execute query : SELECT DISTINCT hostGroupName Error querying database. Cause: java.sql.SQLException: Failed to execute query : SELECT DISTINCT hostGroupNameThe error may exist in URL [jar:file:/pinpoint/pinpoint-web-boot.jar!/BOOT-INF/lib/pinpoint-metric-2.5.3.jar!/pinot-web/mapper/pinot/HostInfoMapper.xml]The error may involve com.navercorp.pinpoint.metric.web.dao.pinot.PinotSystemMetricHostInfoDao.selectHostGroupNameList-InlineThe error occurred while setting parametersSQL: SELECT DISTINCT hostGroupName FROM systemMetricTag WHERE tenantId = ? AND hostGroupName IS NOT NULLCause: java.sql.SQLException: Failed to execute query : SELECT DISTINCT hostGroupName; uncategorized SQLException; SQL state [null]; error code [0]; Failed to execute query : SELECT DISTINCT hostGroupName |
pinot-broker-0 Nothing seems unusual Feb 27, 2024 9:09:27 AM org.glassfish.grizzly.http.server.NetworkListener start |
|
The exception regarding uri stat page is ==> you need to wait until pinot cluster is stable after full restart. Another exception occurred when you tried system metrics page ==> your pinot-broker was started at 2024/02/27 09:09:43.819 with ip 172.24.0.13:8099, but pinpoint web is trying to access 172.24.0.12:8099 and you said your pinpoint-batch is on 172.24.12:8079. Currently containers except pinpoint-collector doesn't have fixed ip, so when restarted it can have different IP. |
I restarted all containers with docker-compose and still have this problem. I really don’t know where to start. 02-28 05:49:53.053 [nio-8080-exec-3] ERROR o.s.b.w.s.s.ErrorPageFilter -- Forwarding to error page from request [/uriStat/summary.pinpoint] due to exception [ Error querying database. Cause: java.sql.SQLException: Failed to execute query : SELECTThe error may exist in class path resource [mapper/uristat/UriStatMapper.xml]The error may involve com.navercorp.pinpoint.uristat.web.dao.PinotUriStatDao.uriStatApplicationSummary-InlineThe error occurred while setting parametersSQL: SELECT uri, sum(apdexRaw) as apdexRaw, sum("count") as totalCount, max(maxLatencyMs) as maxTimeMs, sum(totalTimeMs) as totalTimeMs, sum(failureCount) as failureCount, version FROM uriStat WHERE tenantId = ? AND applicationName = ? AND "timestamp" BETWEEN ? AND ? GROUP BY uri, version ORDER BY totalCount desc LIMIT ?Cause: java.sql.SQLException: Failed to execute query : SELECT; uncategorized SQLException; SQL state [null]; error code [0]; Failed to execute query : SELECT Error querying database. Cause: java.sql.SQLException: Failed to execute query : SELECTThe error may exist in class path resource [mapper/uristat/UriStatMapper.xml]The error may involve com.navercorp.pinpoint.uristat.web.dao.PinotUriStatDao.uriStatApplicationSummary-InlineThe error occurred while setting parametersSQL: SELECT uri, sum(apdexRaw) as apdexRaw, sum("count") as totalCount, max(maxLatencyMs) as maxTimeMs, sum(totalTimeMs) as totalTimeMs, sum(failureCount) as failureCount, version FROM uriStat WHERE tenantId = ? AND applicationName = ? AND "timestamp" BETWEEN ? AND ? GROUP BY uri, version ORDER BY totalCount desc LIMIT ?Cause: java.sql.SQLException: Failed to execute query : SELECT; uncategorized SQLException; SQL state [null]; error code [0]; Failed to execute query : SELECT |
|
Does this error still occur when you clean up all the docker volume data and start all afresh? |
When attempting to use the URL Statistic feature in version 2.5.3, an error occurred. Modifications were made during the startup process:
"Error querying the database. The cause was java.sql.SQLException: Failed to execute the query: SELECT uri, sum(apdexRaw) as apdexRaw, sum("count") as totalCount, max(maxLatencyMs) as maxTimeMs, sum(totalTimeMs) as totalTimeMs, sum(failureCount) as failureCount, version FROM uriStat WHERE tenantId = 'pinpoint'."
When checking the Docker logs, it shows:
"2024/02/27 03:47:20.476 INFO [AddTableCommand] [main] Executing command: AddTable -tableConfigFile null -offlineTableConfigFile null -realtimeTableConfigFile /opt/test/dataTypeTable.json -schemaFile /opt/test/dataTypeSchema.json -controllerProtocol http -controllerHost pinot-controller -controllerPort 9000 -user null -password [hidden] -exec. java.net.ConnectException: Connection refused (Connection refused)."
Could you help answer this, please? Thank you.
The text was updated successfully, but these errors were encountered: