search

pinpoint-apm / pinpoint-docker

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

The pinpoint-docker-pinot-init service failed to start #193

Open lxxxxxxk opened 9 months ago

lxxxxxxk commented 9 months ago

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.

lxxxxxxk commented 9 months ago

{"code":400,"error":"TableConfigs: systemMetricDataType already exists. Use PUT to update existing config"} If an error occurs, it exits immediately

ga-ram commented 9 months ago

connection refused => restart pinot-init after pinot cluster is initialized table already exists => table already exists. it means pinot-init was not needed.

please provide pinpoint-web logs if error querying the database still occurs.

lxxxxxxk commented 9 months ago

贡献 Thank you for your response. I'm still encountering an error querying the database. Upon checking the web logs, it appears to be a connection refused error. Is this related to querying HBase?"

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 : 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'
      AND applicationName = 'HSAYMDM'
      AND "timestamp" BETWEEN 1709084834000 AND 1709085134000
    GROUP BY uri, version
    ORDER BY totalCount desc
    LIMIT 50

The error may exist in class path resource [mapper/uristat/UriStatMapper.xml]

The error may involve com.navercorp.pinpoint.uristat.web.dao.PinotUriStatDao.uriStatApplicationSummary-Inline

The error occurred while setting parameters

ga-ram commented 9 months ago

can you access pinot web at localhost:9000 ? full pinpoint web logs would be very much appreciated

lxxxxxxk commented 9 months ago

can you access pinot web at localhost:9000 ? full pinpoint web logs would be very much appreciated

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 at org.asynchttpclient.netty.channel.NettyConnectListener.onFailure(NettyConnectListener.java:179) ~[async-http-client-2.12.3.jar!/:?] at org.asynchttpclient.netty.channel.NettyChannelConnector$1.onFailure(NettyChannelConnector.java:108) ~[async-http-client-2.12.3.jar!/:?] at org.asynchttpclient.netty.SimpleChannelFutureListener.operationComplete(SimpleChannelFutureListener.java:28) ~[async-http-client-2.12.3.jar!/:?] at org.asynchttpclient.netty.SimpleChannelFutureListener.operationComplete(SimpleChannelFutureListener.java:20) ~[async-http-client-2.12.3.jar!/:?] at io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:578) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.concurrent.DefaultPromise.notifyListeners0(DefaultPromise.java:571) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.concurrent.DefaultPromise.notifyListenersNow(DefaultPromise.java:550) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:491) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.concurrent.DefaultPromise.setValue0(DefaultPromise.java:616) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.concurrent.DefaultPromise.setFailure0(DefaultPromise.java:609) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.concurrent.DefaultPromise.tryFailure(DefaultPromise.java:117) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.fulfillConnectPromise(AbstractNioChannel.java:321) ~[netty-transport-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.finishConnect(AbstractNioChannel.java:337) ~[netty-transport-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:710) ~[netty-transport-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:658) ~[netty-transport-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:584) ~[netty-transport-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:496) ~[netty-transport-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:995) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] ... 1 more Caused by: io.netty.channel.AbstractChannel$AnnotatedConnectException: Connection refused: /172.24.0.12:8099

lxxxxxxk commented 9 months ago

can you access pinot web at localhost:9000 ? full pinpoint web logs would be very much appreciated

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.

ga-ram commented 9 months ago

well if you haven't changed compose files, pinpoint-batch container is on port 8079.

lxxxxxxk commented 9 months ago

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 pinpoint-batch/docker-compose.yml: - "${BATCH_SERVER_PORT:-8079}" pinpoint-batch/docker-compose.yml: - "${BATCH_SERVER_PORT:-8079}:${BATCH_SERVER_PORT:-8079}"

ga-ram commented 9 months ago

You have to check if BATCH_SERVER_PORT=8079 in /.env. In docker-compose-metric.yml pinot-broker-0 is exposed on port 8099. Please check if your pinot-broker-0 container is up without error. If another application is already using that port there would be errors when starting up pinot-broker-0 container.

lxxxxxxk commented 9 months ago

您必须检查 /.env 中的 BATCH_SERVER_PORT=8079 。 在 docker-compose-metric.yml 中，pinot-broker-0 在端口 8099 上公开。 请检查您的 pinot-broker-0 容器是否正常运行。 如果另一个应用程序已在使用该端口，则启动 pinot-broker-0 容器时将会出现错误。 This is the complete log. I noticed that first create broker list

log--->> 02-28 02:54:21.021 [nio-8080-exec-1] INFO o.a.p.c.Connection -- Created connection to broker list [172.24.0.14:8099, 172.24.0.11:8099, 172.24.0.13:8099, 172.24.0.12:8099, 172.24.0.16:8099] 02-28 02:54:22.022 [nio-8080-exec-1] 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 : 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'
      AND applicationName = 'HSAYMDM'
      AND "timestamp" BETWEEN 1709042976000 AND 1709086176000
    GROUP BY uri, version
    ORDER BY totalCount desc
    LIMIT 50

The error may exist in class path resource [mapper/uristat/UriStatMapper.xml]

The error may involve com.navercorp.pinpoint.uristat.web.dao.PinotUriStatDao.uriStatApplicationSummary-Inline

The error occurred while setting parameters

SQL: 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

        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'
      AND applicationName = 'HSAYMDM'
      AND "timestamp" BETWEEN 1709042976000 AND 1709086176000
    GROUP BY uri, version
    ORDER BY totalCount desc
    LIMIT 50

; uncategorized SQLException; SQL state [null]; error code [0]; Failed to execute 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' AND applicationName = 'HSAYMDM' AND "timestamp" BETWEEN 1709042976000 AND 1709086176000 GROUP BY uri, version ORDER BY totalCount desc LIMIT 50; nested exception is java.sql.SQLException: Failed to execute 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' AND applicationName = 'HSAYMDM' AND "timestamp" BETWEEN 1709042976000 AND 1709086176000 GROUP BY uri, version ORDER BY totalCount desc LIMIT 50] org.springframework.jdbc.UncategorizedSQLException:

Error querying database. Cause: java.sql.SQLException: Failed to execute 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'
      AND applicationName = 'HSAYMDM'
      AND "timestamp" BETWEEN 1709042976000 AND 1709086176000
    GROUP BY uri, version
    ORDER BY totalCount desc
    LIMIT 50

The error may exist in class path resource [mapper/uristat/UriStatMapper.xml]

The error may involve com.navercorp.pinpoint.uristat.web.dao.PinotUriStatDao.uriStatApplicationSummary-Inline

The error occurred while setting parameters

SQL: 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

        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'
      AND applicationName = 'HSAYMDM'
      AND "timestamp" BETWEEN 1709042976000 AND 1709086176000
    GROUP BY uri, version
    ORDER BY totalCount desc
    LIMIT 50

; uncategorized SQLException; SQL state [null]; error code [0]; Failed to execute 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' AND applicationName = 'HSAYMDM' AND "timestamp" BETWEEN 1709042976000 AND 1709086176000 GROUP BY uri, version ORDER BY totalCount desc LIMIT 50; nested exception is java.sql.SQLException: Failed to execute 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' AND applicationName = 'HSAYMDM' AND "timestamp" BETWEEN 1709042976000 AND 1709086176000 GROUP BY uri, version ORDER BY totalCount desc LIMIT 50 at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92) ~[mybatis-spring-2.0.7.jar!/:2.0.7] at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) ~[mybatis-spring-2.0.7.jar!/:2.0.7] at com.sun.proxy.$Proxy105.selectList(Unknown Source) ~[?:?] at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224) ~[mybatis-spring-2.0.7.jar!/:2.0.7] at com.navercorp.pinpoint.uristat.web.dao.PinotUriStatDao.getUriStatApplicationPagedSummary(PinotUriStatDao.java:65) ~[pinpoint-uristat-web-2.5.3.jar!/:2.5.3] at com.navercorp.pinpoint.uristat.web.dao.PinotUriStatDao$$FastClassBySpringCGLIB$$53083096.invoke() ~[pinpoint-uristat-web-2.5.3.jar!/:2.5.3] at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.3.24.jar!/:5.3.24] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793) ~[spring-aop-5.3.24.jar!/:5.3.24] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.3.24.jar!/:5.3.24] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.24.jar!/:5.3.24] at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137) ~[spring-tx-5.3.24.jar!/:5.3.24] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.24.jar!/:5.3.24] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.24.jar!/:5.3.24] at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708) ~[spring-aop-5.3.24.jar!/:5.3.24] at com.navercorp.pinpoint.uristat.web.dao.PinotUriStatDao$$EnhancerBySpringCGLIB$$84f0ec9e.getUriStatApplicationPagedSummary() ~[pinpoint-uristat-web-2.5.3.jar!/:2.5.3] at com.navercorp.pinpoint.uristat.web.service.UriStatServiceImpl.getUriStatApplicationPagedSummary(UriStatServiceImpl.java:71) ~[pinpoint-uristat-web-2.5.3.jar!/:2.5.3] at com.navercorp.pinpoint.uristat.web.controller.UriStatController.getUriStatPagedSummary(UriStatController.java:71) ~[pinpoint-uristat-web-2.5.3.jar!/:2.5.3] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:?] at java.lang.reflect.Method.invoke(Unknown Source) ~[?:?] at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205) ~[spring-web-5.3.24.jar!/:5.3.24] at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150) ~[spring-web-5.3.24.jar!/:5.3.24] at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117) ~[spring-webmvc-5.3.24.jar!/:5.3.24] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) ~[spring-webmvc-5.3.24.jar!/:5.3.24] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808) ~[spring-webmvc-5.3.24.jar!/:5.3.24] at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.3.24.jar!/:5.3.24] at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1071) ~[spring-webmvc-5.3.24.jar!/:5.3.24] at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:964) ~[spring-webmvc-5.3.24.jar!/:5.3.24] at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) ~[spring-webmvc-5.3.24.jar!/:5.3.24] at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898) ~[spring-webmvc-5.3.24.jar!/:5.3.24] at javax.servlet.http.HttpServlet.service(HttpServlet.java:670) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) ~[spring-webmvc-5.3.24.jar!/:5.3.24] at javax.servlet.http.HttpServlet.service(HttpServlet.java:779) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.70.jar!/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.70.jar!/:?] at com.navercorp.pinpoint.web.servlet.RewriteForV2Filter.doFilter(RewriteForV2Filter.java:94) ~[pinpoint-web-2.5.3.jar!/:2.5.3] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:106) ~[spring-web-5.3.24.jar!/:5.3.24] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) ~[spring-web-5.3.24.jar!/:5.3.24] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:126) ~[spring-boot-2.7.7.jar!/:2.7.7] at org.springframework.boot.web.servlet.support.ErrorPageFilter.access$000(ErrorPageFilter.java:64) ~[spring-boot-2.7.7.jar!/:2.7.7] at org.springframework.boot.web.servlet.support.ErrorPageFilter$1.doFilterInternal(ErrorPageFilter.java:101) ~[spring-boot-2.7.7.jar!/:2.7.7] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) ~[spring-web-5.3.24.jar!/:5.3.24] at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:119) ~[spring-boot-2.7.7.jar!/:2.7.7] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) ~[spring-web-5.3.24.jar!/:5.3.24] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) ~[spring-web-5.3.24.jar!/:5.3.24] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:177) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:891) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1784) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat-embed-core-9.0.70.jar!/:?] at java.lang.Thread.run(Unknown Source) ~[?:?] Caused by: java.sql.SQLException: Failed to execute 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' AND applicationName = 'HSAYMDM' AND "timestamp" BETWEEN 1709042976000 AND 1709086176000 GROUP BY uri, version ORDER BY totalCount desc LIMIT 50 at org.apache.pinot.client.PinotPreparedStatement.executeQuery(PinotPreparedStatement.java:188) ~[pinot-jdbc-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at com.navercorp.pinpoint.pinot.datasource.WrappedPinotPreparedStatement.execute(WrappedPinotPreparedStatement.java:66) ~[pinpoint-pinot-datasource-2.5.3.jar!/:2.5.3] at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:80) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:65) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:333) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142) ~[mybatis-3.5.12.jar!/:3.5.12] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:?] at java.lang.reflect.Method.invoke(Unknown Source) ~[?:?] at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ~[mybatis-spring-2.0.7.jar!/:2.0.7] ... 71 more Caused by: org.apache.pinot.client.PinotClientException: Query had processing exceptions: [{"errorCode":305,"message":"null:\n1 segments unavailable: [uriStat00__20240226T1117Z]"}] at org.apache.pinot.client.Connection.execute(Connection.java:124) ~[pinot-java-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at org.apache.pinot.client.Connection.execute(Connection.java:93) ~[pinot-java-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at org.apache.pinot.client.PinotPreparedStatement.executeQuery(PinotPreparedStatement.java:180) ~[pinot-jdbc-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at com.navercorp.pinpoint.pinot.datasource.WrappedPinotPreparedStatement.execute(WrappedPinotPreparedStatement.java:66) ~[pinpoint-pinot-datasource-2.5.3.jar!/:2.5.3] at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:80) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:65) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:333) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142) ~[mybatis-3.5.12.jar!/:3.5.12] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:?] at java.lang.reflect.Method.invoke(Unknown Source) ~[?:?] at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ~[mybatis-spring-2.0.7.jar!/:2.0.7] ... 71 more 02-28 02:55:28.028 [nio-8080-exec-9] ERROR o.s.b.w.s.s.ErrorPageFilter -- Forwarding to error page from request [/systemMetric/hostGroup.pinpoint] due to exception [

Error querying database. Cause: java.sql.SQLException: Failed to execute query : SELECT DISTINCT hostGroupName

    FROM systemMetricTag
    WHERE tenantId = 'pinpoint' AND hostGroupName IS NOT NULL LIMIT 2147483647

The 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-Inline

The error occurred while setting parameters

SQL: SELECT DISTINCT hostGroupName FROM systemMetricTag WHERE tenantId = ? AND hostGroupName IS NOT NULL

Cause: java.sql.SQLException: Failed to execute query : SELECT DISTINCT hostGroupName

    FROM systemMetricTag
    WHERE tenantId = 'pinpoint' AND hostGroupName IS NOT NULL LIMIT 2147483647

; uncategorized SQLException; SQL state [null]; error code [0]; Failed to execute query : SELECT DISTINCT hostGroupName FROM systemMetricTag WHERE tenantId = 'pinpoint' AND hostGroupName IS NOT NULL LIMIT 2147483647; nested exception is java.sql.SQLException: Failed to execute query : SELECT DISTINCT hostGroupName FROM systemMetricTag WHERE tenantId = 'pinpoint' AND hostGroupName IS NOT NULL LIMIT 2147483647] org.springframework.jdbc.UncategorizedSQLException:

Error querying database. Cause: java.sql.SQLException: Failed to execute query : SELECT DISTINCT hostGroupName

    FROM systemMetricTag
    WHERE tenantId = 'pinpoint' AND hostGroupName IS NOT NULL LIMIT 2147483647

The 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-Inline

The error occurred while setting parameters

SQL: SELECT DISTINCT hostGroupName FROM systemMetricTag WHERE tenantId = ? AND hostGroupName IS NOT NULL

Cause: java.sql.SQLException: Failed to execute query : SELECT DISTINCT hostGroupName

    FROM systemMetricTag
    WHERE tenantId = 'pinpoint' AND hostGroupName IS NOT NULL LIMIT 2147483647

; uncategorized SQLException; SQL state [null]; error code [0]; Failed to execute query : SELECT DISTINCT hostGroupName FROM systemMetricTag WHERE tenantId = 'pinpoint' AND hostGroupName IS NOT NULL LIMIT 2147483647; nested exception is java.sql.SQLException: Failed to execute query : SELECT DISTINCT hostGroupName FROM systemMetricTag WHERE tenantId = 'pinpoint' AND hostGroupName IS NOT NULL LIMIT 2147483647 at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92) ~[mybatis-spring-2.0.7.jar!/:2.0.7] at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) ~[mybatis-spring-2.0.7.jar!/:2.0.7] at com.sun.proxy.$Proxy105.selectList(Unknown Source) ~[?:?] at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224) ~[mybatis-spring-2.0.7.jar!/:2.0.7] at com.navercorp.pinpoint.metric.web.dao.pinot.PinotSystemMetricHostInfoDao.selectHostGroupNameList(PinotSystemMetricHostInfoDao.java:50) ~[pinpoint-metric-2.5.3.jar!/:2.5.3] at com.navercorp.pinpoint.metric.web.dao.pinot.PinotSystemMetricHostInfoDao$$FastClassBySpringCGLIB$$476ecd59.invoke() ~[pinpoint-metric-2.5.3.jar!/:2.5.3] at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.3.24.jar!/:5.3.24] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793) ~[spring-aop-5.3.24.jar!/:5.3.24] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.3.24.jar!/:5.3.24] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.24.jar!/:5.3.24] at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137) ~[spring-tx-5.3.24.jar!/:5.3.24] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.24.jar!/:5.3.24] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.24.jar!/:5.3.24] at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708) ~[spring-aop-5.3.24.jar!/:5.3.24] at com.navercorp.pinpoint.metric.web.dao.pinot.PinotSystemMetricHostInfoDao$$EnhancerBySpringCGLIB$$89f54c7.selectHostGroupNameList() ~[pinpoint-metric-2.5.3.jar!/:2.5.3] at com.navercorp.pinpoint.metric.web.service.SystemMetricHostInfoServiceImpl.getHostGroupNameList(SystemMetricHostInfoServiceImpl.java:54) ~[pinpoint-metric-2.5.3.jar!/:2.5.3] at com.navercorp.pinpoint.metric.web.controller.SystemMetricController.getHostGroup(SystemMetricController.java:67) ~[pinpoint-metric-2.5.3.jar!/:2.5.3] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:?] at java.lang.reflect.Method.invoke(Unknown Source) ~[?:?] at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205) ~[spring-web-5.3.24.jar!/:5.3.24] at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150) ~[spring-web-5.3.24.jar!/:5.3.24] at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117) ~[spring-webmvc-5.3.24.jar!/:5.3.24] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) ~[spring-webmvc-5.3.24.jar!/:5.3.24] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808) ~[spring-webmvc-5.3.24.jar!/:5.3.24] at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.3.24.jar!/:5.3.24] at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1071) ~[spring-webmvc-5.3.24.jar!/:5.3.24] at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:964) ~[spring-webmvc-5.3.24.jar!/:5.3.24] at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) ~[spring-webmvc-5.3.24.jar!/:5.3.24] at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898) ~[spring-webmvc-5.3.24.jar!/:5.3.24] at javax.servlet.http.HttpServlet.service(HttpServlet.java:670) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) ~[spring-webmvc-5.3.24.jar!/:5.3.24] at javax.servlet.http.HttpServlet.service(HttpServlet.java:779) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.70.jar!/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.70.jar!/:?] at com.navercorp.pinpoint.web.servlet.RewriteForV2Filter.doFilter(RewriteForV2Filter.java:94) ~[pinpoint-web-2.5.3.jar!/:2.5.3] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:106) ~[spring-web-5.3.24.jar!/:5.3.24] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) ~[spring-web-5.3.24.jar!/:5.3.24] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:126) ~[spring-boot-2.7.7.jar!/:2.7.7] at org.springframework.boot.web.servlet.support.ErrorPageFilter.access$000(ErrorPageFilter.java:64) ~[spring-boot-2.7.7.jar!/:2.7.7] at org.springframework.boot.web.servlet.support.ErrorPageFilter$1.doFilterInternal(ErrorPageFilter.java:101) ~[spring-boot-2.7.7.jar!/:2.7.7] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) ~[spring-web-5.3.24.jar!/:5.3.24] at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:119) ~[spring-boot-2.7.7.jar!/:2.7.7] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) ~[spring-web-5.3.24.jar!/:5.3.24] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) ~[spring-web-5.3.24.jar!/:5.3.24] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:177) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:891) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1784) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat-embed-core-9.0.70.jar!/:?] at java.lang.Thread.run(Unknown Source) ~[?:?] Caused by: java.sql.SQLException: Failed to execute query : SELECT DISTINCT hostGroupName FROM systemMetricTag WHERE tenantId = 'pinpoint' AND hostGroupName IS NOT NULL LIMIT 2147483647 at org.apache.pinot.client.PinotPreparedStatement.executeQuery(PinotPreparedStatement.java:188) ~[pinot-jdbc-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at com.navercorp.pinpoint.pinot.datasource.WrappedPinotPreparedStatement.execute(WrappedPinotPreparedStatement.java:66) ~[pinpoint-pinot-datasource-2.5.3.jar!/:2.5.3] at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:80) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:65) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:333) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142) ~[mybatis-3.5.12.jar!/:3.5.12] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:?] at java.lang.reflect.Method.invoke(Unknown Source) ~[?:?] at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ~[mybatis-spring-2.0.7.jar!/:2.0.7] ... 71 more Caused by: org.apache.pinot.client.PinotClientException: java.util.concurrent.ExecutionException: java.util.concurrent.ExecutionException: java.net.ConnectException: Connection refused: /172.24.0.12:8099 at org.apache.pinot.client.JsonAsyncHttpPinotClientTransport.executeQuery(JsonAsyncHttpPinotClientTransport.java:125) ~[pinot-java-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at org.apache.pinot.client.Connection.execute(Connection.java:122) ~[pinot-java-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at org.apache.pinot.client.Connection.execute(Connection.java:93) ~[pinot-java-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at org.apache.pinot.client.PinotPreparedStatement.executeQuery(PinotPreparedStatement.java:180) ~[pinot-jdbc-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at com.navercorp.pinpoint.pinot.datasource.WrappedPinotPreparedStatement.execute(WrappedPinotPreparedStatement.java:66) ~[pinpoint-pinot-datasource-2.5.3.jar!/:2.5.3] at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:80) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:65) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:333) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142) ~[mybatis-3.5.12.jar!/:3.5.12] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:?] at java.lang.reflect.Method.invoke(Unknown Source) ~[?:?] at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ~[mybatis-spring-2.0.7.jar!/:2.0.7] ... 71 more Caused by: java.util.concurrent.ExecutionException: java.util.concurrent.ExecutionException: java.net.ConnectException: Connection refused: /172.24.0.12:8099 at org.apache.pinot.client.JsonAsyncHttpPinotClientTransport$BrokerResponseFuture.get(JsonAsyncHttpPinotClientTransport.java:233) ~[pinot-java-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at org.apache.pinot.client.JsonAsyncHttpPinotClientTransport$BrokerResponseFuture.get(JsonAsyncHttpPinotClientTransport.java:181) ~[pinot-java-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at org.apache.pinot.client.JsonAsyncHttpPinotClientTransport.executeQuery(JsonAsyncHttpPinotClientTransport.java:123) ~[pinot-java-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at org.apache.pinot.client.Connection.execute(Connection.java:122) ~[pinot-java-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at org.apache.pinot.client.Connection.execute(Connection.java:93) ~[pinot-java-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at org.apache.pinot.client.PinotPreparedStatement.executeQuery(PinotPreparedStatement.java:180) ~[pinot-jdbc-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at com.navercorp.pinpoint.pinot.datasource.WrappedPinotPreparedStatement.execute(WrappedPinotPreparedStatement.java:66) ~[pinpoint-pinot-datasource-2.5.3.jar!/:2.5.3] at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:80) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:65) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:333) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142) ~[mybatis-3.5.12.jar!/:3.5.12] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:?] at java.lang.reflect.Method.invoke(Unknown Source) ~[?:?] at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ~[mybatis-spring-2.0.7.jar!/:2.0.7] ... 71 more Caused by: java.util.concurrent.ExecutionException: java.net.ConnectException: Connection refused: /172.24.0.12:8099 at java.util.concurrent.CompletableFuture.reportGet(Unknown Source) ~[?:?] at java.util.concurrent.CompletableFuture.get(Unknown Source) ~[?:?] at org.asynchttpclient.netty.NettyResponseFuture.get(NettyResponseFuture.java:206) ~[async-http-client-2.12.3.jar!/:?] at org.apache.pinot.client.JsonAsyncHttpPinotClientTransport$BrokerResponseFuture.get(JsonAsyncHttpPinotClientTransport.java:221) ~[pinot-java-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at org.apache.pinot.client.JsonAsyncHttpPinotClientTransport$BrokerResponseFuture.get(JsonAsyncHttpPinotClientTransport.java:181) ~[pinot-java-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at org.apache.pinot.client.JsonAsyncHttpPinotClientTransport.executeQuery(JsonAsyncHttpPinotClientTransport.java:123) ~[pinot-java-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at org.apache.pinot.client.Connection.execute(Connection.java:122) ~[pinot-java-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at org.apache.pinot.client.Connection.execute(Connection.java:93) ~[pinot-java-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at org.apache.pinot.client.PinotPreparedStatement.executeQuery(PinotPreparedStatement.java:180) ~[pinot-jdbc-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at com.navercorp.pinpoint.pinot.datasource.WrappedPinotPreparedStatement.execute(WrappedPinotPreparedStatement.java:66) ~[pinpoint-pinot-datasource-2.5.3.jar!/:2.5.3] at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:80) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:65) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:333) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142) ~[mybatis-3.5.12.jar!/:3.5.12] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:?] at java.lang.reflect.Method.invoke(Unknown Source) ~[?:?] at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ~[mybatis-spring-2.0.7.jar!/:2.0.7] ... 71 more Caused by: java.net.ConnectException: Connection refused: /172.24.0.12:8099 at org.asynchttpclient.netty.channel.NettyConnectListener.onFailure(NettyConnectListener.java:179) ~[async-http-client-2.12.3.jar!/:?] at org.asynchttpclient.netty.channel.NettyChannelConnector$1.onFailure(NettyChannelConnector.java:108) ~[async-http-client-2.12.3.jar!/:?] at org.asynchttpclient.netty.SimpleChannelFutureListener.operationComplete(SimpleChannelFutureListener.java:28) ~[async-http-client-2.12.3.jar!/:?] at org.asynchttpclient.netty.SimpleChannelFutureListener.operationComplete(SimpleChannelFutureListener.java:20) ~[async-http-client-2.12.3.jar!/:?] at io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:578) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.concurrent.DefaultPromise.notifyListeners0(DefaultPromise.java:571) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.concurrent.DefaultPromise.notifyListenersNow(DefaultPromise.java:550) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:491) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.concurrent.DefaultPromise.setValue0(DefaultPromise.java:616) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.concurrent.DefaultPromise.setFailure0(DefaultPromise.java:609) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.concurrent.DefaultPromise.tryFailure(DefaultPromise.java:117) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.fulfillConnectPromise(AbstractNioChannel.java:321) ~[netty-transport-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.finishConnect(AbstractNioChannel.java:337) ~[netty-transport-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:710) ~[netty-transport-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:658) ~[netty-transport-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:584) ~[netty-transport-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:496) ~[netty-transport-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:995) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] ... 1 more Caused by: io.netty.channel.AbstractChannel$AnnotatedConnectException: Connection refused: /172.24.0.12:8099 Caused by: java.net.ConnectException: Connection refused at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method) ~[?:?] at sun.nio.ch.SocketChannelImpl.finishConnect(Unknown Source) ~[?:?] at io.netty.channel.socket.nio.NioSocketChannel.doFinishConnect(NioSocketChannel.java:337) ~[netty-transport-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.finishConnect(AbstractNioChannel.java:334) ~[netty-transport-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:710) ~[netty-transport-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:658) ~[netty-transport-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:584) ~[netty-transport-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:496) ~[netty-transport-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:995) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] ... 1 more

lxxxxxxk commented 9 months ago

您必须检查 /.env 中的 BATCH_SERVER_PORT=8079 。 在 docker-compose-metric.yml 中，pinot-broker-0 在端口 8099 上公开。 请检查您的 pinot-broker-0 容器是否正常运行。 如果另一个应用程序已在使用该端口，则启动 pinot-broker-0 容器时将会出现错误。

pinot-broker-0 Nothing seems unusual

Feb 27, 2024 9:09:27 AM org.glassfish.grizzly.http.server.NetworkListener start INFO: Started listener bound to [0.0.0.0:8099] Feb 27, 2024 9:09:27 AM org.glassfish.grizzly.http.server.HttpServer start INFO: [HttpServer] Started. 2024/02/27 09:09:43.819 INFO [StartServiceManagerCommand] [Start a Pinot [BROKER]] Started Pinot [BROKER] instance [Broker_172.24.0.13_8099] at 52.082s since launch

ga-ram commented 9 months ago

The exception regarding uri stat page is 

02-28 02:54:22.022
Caused by: org.apache.pinot.client.PinotClientException: Query had processing exceptions:
[{"errorCode":305,"message":"null:\n1 segments unavailable: [uriStat__0__0__20240226T1117Z]"}]

==> you need to wait until pinot cluster is stable after full restart.

Another exception occurred when you tried system metrics page

02-28 02:55:28.028
Caused by: org.apache.pinot.client.PinotClientException: java.util.concurrent.ExecutionException: java.util.concurrent.ExecutionException: java.net.ConnectException: Connection refused: /172.24.0.12:8099

==> 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. By any chance have you restarted some of the containers with docker commands other than docker-compose -f docker-compose.yml -f docker-compose-metric.yml restart?

lxxxxxxk commented 9 months ago

有关 uri 统计页面的例外情况是

02-28 02:54:22.022
Caused by: org.apache.pinot.client.PinotClientException: Query had processing exceptions:
[{"errorCode":305,"message":"null:\n1 segments unavailable: [uriStat__0__0__20240226T1117Z]"}]

==> 完全重启后需要等待pinot集群稳定。

当您尝试系统指标页面时发生另一个异常

02-28 02:55:28.028
Caused by: org.apache.pinot.client.PinotClientException: java.util.concurrent.ExecutionException: java.util.concurrent.ExecutionException: java.net.ConnectException: Connection refused: /172.24.0.12:8099

==> 你的 pinot-broker 于 2024/02/27 09:09:43.819 启动，ip 172.24.0.13:8099，但 pinpoint web 正在尝试访问 172.24.0.12:8099 并且你说你的 pinpoint-batch 位于 172.24 .12:8079。

目前除 pinpoint-collector 之外的容器没有固定的 IP，因此重新启动时可以有不同的 IP。 您是否有使用 docker 命令以外的命令重新启动过某些容器docker-compose -f docker-compose.yml -f docker-compose-metric.yml restart？

I restarted all containers with docker-compose and still have this problem. I really don’t know where to start. /pinpoint-docker-pinot-server-0-1 - 172.24.0.16 /pinpoint-docker-pinot-broker-0-1 - 172.24.0.13 /pinpoint-docker-pinot-controller-1 - 172.24.0.9 /pinpoint-quickstart - 172.24.0.20 /pinpoint-docker-telegraf-1 - 172.24.0.18 /pinpoint-agent - 172.24.0.19 /pinpoint-web - 172.24.0.15 /pinpoint-collector - 172.24.0.30 /pinpoint-flink-taskmanager - 172.24.0.14 /pinpoint-batch - 172.24.0.12 /pinpoint-docker-pinpoint-kafka-1 - 172.24.0.8 /pinpoint-flink-jobmanager - 172.24.0.11 /pinpoint-hbase - 172.24.0.10 /pinpoint-docker-pinot-zoo-1 - 172.24.0.5 /pinpoint-mysql - 172.24.0.4 /pinpoint-docker-zoo3-1 - 172.24.0.2 /pinpoint-docker-zoo2-1 - 172.24.0.7 /pinpoint-docker-zoo1-1 - 172.24.0.6 /pinpoint-docker-redis-1 - 172.24.0.3

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 : 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'
      AND applicationName = 'HSAYMDM'
      AND "timestamp" BETWEEN 1709098193000 AND 1709099393000
    GROUP BY uri, version
    ORDER BY totalCount desc
    LIMIT 50

The error may exist in class path resource [mapper/uristat/UriStatMapper.xml]

The error may involve com.navercorp.pinpoint.uristat.web.dao.PinotUriStatDao.uriStatApplicationSummary-Inline

The error occurred while setting parameters

SQL: 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

        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'
      AND applicationName = 'HSAYMDM'
      AND "timestamp" BETWEEN 1709098193000 AND 1709099393000
    GROUP BY uri, version
    ORDER BY totalCount desc
    LIMIT 50

; uncategorized SQLException; SQL state [null]; error code [0]; Failed to execute 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' AND applicationName = 'HSAYMDM' AND "timestamp" BETWEEN 1709098193000 AND 1709099393000 GROUP BY uri, version ORDER BY totalCount desc LIMIT 50; nested exception is java.sql.SQLException: Failed to execute 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' AND applicationName = 'HSAYMDM' AND "timestamp" BETWEEN 1709098193000 AND 1709099393000 GROUP BY uri, version ORDER BY totalCount desc LIMIT 50] org.springframework.jdbc.UncategorizedSQLException:

Error querying database. Cause: java.sql.SQLException: Failed to execute 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'
      AND applicationName = 'HSAYMDM'
      AND "timestamp" BETWEEN 1709098193000 AND 1709099393000
    GROUP BY uri, version
    ORDER BY totalCount desc
    LIMIT 50

The error may exist in class path resource [mapper/uristat/UriStatMapper.xml]

The error may involve com.navercorp.pinpoint.uristat.web.dao.PinotUriStatDao.uriStatApplicationSummary-Inline

The error occurred while setting parameters

SQL: 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

        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'
      AND applicationName = 'HSAYMDM'
      AND "timestamp" BETWEEN 1709098193000 AND 1709099393000
    GROUP BY uri, version
    ORDER BY totalCount desc
    LIMIT 50

; uncategorized SQLException; SQL state [null]; error code [0]; Failed to execute 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' AND applicationName = 'HSAYMDM' AND "timestamp" BETWEEN 1709098193000 AND 1709099393000 GROUP BY uri, version ORDER BY totalCount desc LIMIT 50; nested exception is java.sql.SQLException: Failed to execute 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' AND applicationName = 'HSAYMDM' AND "timestamp" BETWEEN 1709098193000 AND 1709099393000 GROUP BY uri, version ORDER BY totalCount desc LIMIT 50 at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92) ~[mybatis-spring-2.0.7.jar!/:2.0.7] at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) ~[mybatis-spring-2.0.7.jar!/:2.0.7] at com.sun.proxy.$Proxy105.selectList(Unknown Source) ~[?:?] at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224) ~[mybatis-spring-2.0.7.jar!/:2.0.7] at com.navercorp.pinpoint.uristat.web.dao.PinotUriStatDao.getUriStatApplicationPagedSummary(PinotUriStatDao.java:65) ~[pinpoint-uristat-web-2.5.3.jar!/:2.5.3] at com.navercorp.pinpoint.uristat.web.dao.PinotUriStatDao$$FastClassBySpringCGLIB$$53083096.invoke() ~[pinpoint-uristat-web-2.5.3.jar!/:2.5.3] at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.3.24.jar!/:5.3.24] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793) ~[spring-aop-5.3.24.jar!/:5.3.24] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.3.24.jar!/:5.3.24] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.24.jar!/:5.3.24] at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137) ~[spring-tx-5.3.24.jar!/:5.3.24] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.24.jar!/:5.3.24] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.24.jar!/:5.3.24] at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708) ~[spring-aop-5.3.24.jar!/:5.3.24] at com.navercorp.pinpoint.uristat.web.dao.PinotUriStatDao$$EnhancerBySpringCGLIB$$34e850e4.getUriStatApplicationPagedSummary() ~[pinpoint-uristat-web-2.5.3.jar!/:2.5.3] at com.navercorp.pinpoint.uristat.web.service.UriStatServiceImpl.getUriStatApplicationPagedSummary(UriStatServiceImpl.java:71) ~[pinpoint-uristat-web-2.5.3.jar!/:2.5.3] at com.navercorp.pinpoint.uristat.web.controller.UriStatController.getUriStatPagedSummary(UriStatController.java:71) ~[pinpoint-uristat-web-2.5.3.jar!/:2.5.3] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:?] at java.lang.reflect.Method.invoke(Unknown Source) ~[?:?] at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205) ~[spring-web-5.3.24.jar!/:5.3.24] at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150) ~[spring-web-5.3.24.jar!/:5.3.24] at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117) ~[spring-webmvc-5.3.24.jar!/:5.3.24] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) ~[spring-webmvc-5.3.24.jar!/:5.3.24] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808) ~[spring-webmvc-5.3.24.jar!/:5.3.24] at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.3.24.jar!/:5.3.24] at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1071) ~[spring-webmvc-5.3.24.jar!/:5.3.24] at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:964) ~[spring-webmvc-5.3.24.jar!/:5.3.24] at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) ~[spring-webmvc-5.3.24.jar!/:5.3.24] at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898) ~[spring-webmvc-5.3.24.jar!/:5.3.24] at javax.servlet.http.HttpServlet.service(HttpServlet.java:670) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) ~[spring-webmvc-5.3.24.jar!/:5.3.24] at javax.servlet.http.HttpServlet.service(HttpServlet.java:779) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.70.jar!/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.70.jar!/:?] at com.navercorp.pinpoint.web.servlet.RewriteForV2Filter.doFilter(RewriteForV2Filter.java:94) ~[pinpoint-web-2.5.3.jar!/:2.5.3] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:106) ~[spring-web-5.3.24.jar!/:5.3.24] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) ~[spring-web-5.3.24.jar!/:5.3.24] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:126) ~[spring-boot-2.7.7.jar!/:2.7.7] at org.springframework.boot.web.servlet.support.ErrorPageFilter.access$000(ErrorPageFilter.java:64) ~[spring-boot-2.7.7.jar!/:2.7.7] at org.springframework.boot.web.servlet.support.ErrorPageFilter$1.doFilterInternal(ErrorPageFilter.java:101) ~[spring-boot-2.7.7.jar!/:2.7.7] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) ~[spring-web-5.3.24.jar!/:5.3.24] at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:119) ~[spring-boot-2.7.7.jar!/:2.7.7] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) ~[spring-web-5.3.24.jar!/:5.3.24] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) ~[spring-web-5.3.24.jar!/:5.3.24] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:177) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:891) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1784) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) ~[tomcat-embed-core-9.0.70.jar!/:?] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat-embed-core-9.0.70.jar!/:?] at java.lang.Thread.run(Unknown Source) ~[?:?] Caused by: java.sql.SQLException: Failed to execute 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' AND applicationName = 'HSAYMDM' AND "timestamp" BETWEEN 1709098193000 AND 1709099393000 GROUP BY uri, version ORDER BY totalCount desc LIMIT 50 at org.apache.pinot.client.PinotPreparedStatement.executeQuery(PinotPreparedStatement.java:188) ~[pinot-jdbc-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at com.navercorp.pinpoint.pinot.datasource.WrappedPinotPreparedStatement.execute(WrappedPinotPreparedStatement.java:66) ~[pinpoint-pinot-datasource-2.5.3.jar!/:2.5.3] at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:80) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:65) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:333) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142) ~[mybatis-3.5.12.jar!/:3.5.12] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:?] at java.lang.reflect.Method.invoke(Unknown Source) ~[?:?] at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ~[mybatis-spring-2.0.7.jar!/:2.0.7] ... 71 more Caused by: org.apache.pinot.client.PinotClientException: java.util.concurrent.ExecutionException: java.util.concurrent.ExecutionException: java.net.ConnectException: Connection refused: /172.24.0.16:8099 at org.apache.pinot.client.JsonAsyncHttpPinotClientTransport.executeQuery(JsonAsyncHttpPinotClientTransport.java:125) ~[pinot-java-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at org.apache.pinot.client.Connection.execute(Connection.java:122) ~[pinot-java-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at org.apache.pinot.client.Connection.execute(Connection.java:93) ~[pinot-java-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at org.apache.pinot.client.PinotPreparedStatement.executeQuery(PinotPreparedStatement.java:180) ~[pinot-jdbc-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at com.navercorp.pinpoint.pinot.datasource.WrappedPinotPreparedStatement.execute(WrappedPinotPreparedStatement.java:66) ~[pinpoint-pinot-datasource-2.5.3.jar!/:2.5.3] at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:80) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:65) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:333) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142) ~[mybatis-3.5.12.jar!/:3.5.12] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:?] at java.lang.reflect.Method.invoke(Unknown Source) ~[?:?] at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ~[mybatis-spring-2.0.7.jar!/:2.0.7] ... 71 more Caused by: java.util.concurrent.ExecutionException: java.util.concurrent.ExecutionException: java.net.ConnectException: Connection refused: /172.24.0.16:8099 at org.apache.pinot.client.JsonAsyncHttpPinotClientTransport$BrokerResponseFuture.get(JsonAsyncHttpPinotClientTransport.java:233) ~[pinot-java-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at org.apache.pinot.client.JsonAsyncHttpPinotClientTransport$BrokerResponseFuture.get(JsonAsyncHttpPinotClientTransport.java:181) ~[pinot-java-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at org.apache.pinot.client.JsonAsyncHttpPinotClientTransport.executeQuery(JsonAsyncHttpPinotClientTransport.java:123) ~[pinot-java-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at org.apache.pinot.client.Connection.execute(Connection.java:122) ~[pinot-java-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at org.apache.pinot.client.Connection.execute(Connection.java:93) ~[pinot-java-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at org.apache.pinot.client.PinotPreparedStatement.executeQuery(PinotPreparedStatement.java:180) ~[pinot-jdbc-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at com.navercorp.pinpoint.pinot.datasource.WrappedPinotPreparedStatement.execute(WrappedPinotPreparedStatement.java:66) ~[pinpoint-pinot-datasource-2.5.3.jar!/:2.5.3] at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:80) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:65) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:333) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142) ~[mybatis-3.5.12.jar!/:3.5.12] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:?] at java.lang.reflect.Method.invoke(Unknown Source) ~[?:?] at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ~[mybatis-spring-2.0.7.jar!/:2.0.7] ... 71 more Caused by: java.util.concurrent.ExecutionException: java.net.ConnectException: Connection refused: /172.24.0.16:8099 at java.util.concurrent.CompletableFuture.reportGet(Unknown Source) ~[?:?] at java.util.concurrent.CompletableFuture.get(Unknown Source) ~[?:?] at org.asynchttpclient.netty.NettyResponseFuture.get(NettyResponseFuture.java:206) ~[async-http-client-2.12.3.jar!/:?] at org.apache.pinot.client.JsonAsyncHttpPinotClientTransport$BrokerResponseFuture.get(JsonAsyncHttpPinotClientTransport.java:221) ~[pinot-java-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at org.apache.pinot.client.JsonAsyncHttpPinotClientTransport$BrokerResponseFuture.get(JsonAsyncHttpPinotClientTransport.java:181) ~[pinot-java-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at org.apache.pinot.client.JsonAsyncHttpPinotClientTransport.executeQuery(JsonAsyncHttpPinotClientTransport.java:123) ~[pinot-java-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at org.apache.pinot.client.Connection.execute(Connection.java:122) ~[pinot-java-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at org.apache.pinot.client.Connection.execute(Connection.java:93) ~[pinot-java-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at org.apache.pinot.client.PinotPreparedStatement.executeQuery(PinotPreparedStatement.java:180) ~[pinot-jdbc-client-0.11.0.jar!/:0.11.0-1b4d6b6b0a27422c1552ea1a936ad145056f7033] at com.navercorp.pinpoint.pinot.datasource.WrappedPinotPreparedStatement.execute(WrappedPinotPreparedStatement.java:66) ~[pinpoint-pinot-datasource-2.5.3.jar!/:2.5.3] at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:80) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:65) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:333) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ~[mybatis-3.5.12.jar!/:3.5.12] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142) ~[mybatis-3.5.12.jar!/:3.5.12] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:?] at java.lang.reflect.Method.invoke(Unknown Source) ~[?:?] at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ~[mybatis-spring-2.0.7.jar!/:2.0.7] ... 71 more Caused by: java.net.ConnectException: Connection refused: /172.24.0.16:8099 at org.asynchttpclient.netty.channel.NettyConnectListener.onFailure(NettyConnectListener.java:179) ~[async-http-client-2.12.3.jar!/:?] at org.asynchttpclient.netty.channel.NettyChannelConnector$1.onFailure(NettyChannelConnector.java:108) ~[async-http-client-2.12.3.jar!/:?] at org.asynchttpclient.netty.SimpleChannelFutureListener.operationComplete(SimpleChannelFutureListener.java:28) ~[async-http-client-2.12.3.jar!/:?] at org.asynchttpclient.netty.SimpleChannelFutureListener.operationComplete(SimpleChannelFutureListener.java:20) ~[async-http-client-2.12.3.jar!/:?] at io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:578) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.concurrent.DefaultPromise.notifyListeners0(DefaultPromise.java:571) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.concurrent.DefaultPromise.notifyListenersNow(DefaultPromise.java:550) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:491) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.concurrent.DefaultPromise.setValue0(DefaultPromise.java:616) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.concurrent.DefaultPromise.setFailure0(DefaultPromise.java:609) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.concurrent.DefaultPromise.tryFailure(DefaultPromise.java:117) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.fulfillConnectPromise(AbstractNioChannel.java:321) ~[netty-transport-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.finishConnect(AbstractNioChannel.java:337) ~[netty-transport-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:710) ~[netty-transport-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:658) ~[netty-transport-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:584) ~[netty-transport-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:496) ~[netty-transport-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:995) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] ... 1 more Caused by: io.netty.channel.AbstractChannel$AnnotatedConnectException: Connection refused: /172.24.0.16:8099 Caused by: java.net.ConnectException: Connection refused at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method) ~[?:?] at sun.nio.ch.SocketChannelImpl.finishConnect(Unknown Source) ~[?:?] at io.netty.channel.socket.nio.NioSocketChannel.doFinishConnect(NioSocketChannel.java:337) ~[netty-transport-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.finishConnect(AbstractNioChannel.java:334) ~[netty-transport-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:710) ~[netty-transport-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:658) ~[netty-transport-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:584) ~[netty-transport-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:496) ~[netty-transport-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:995) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) ~[netty-common-4.1.77.Final.jar!/:4.1.77.Final] ... 1 more

ga-ram commented 9 months ago

Does this error still occur when you clean up all the docker volume data and start all afresh?

(This removes all saved data in hbase and pinot)
docker-compose -f docker-compose.yml -f docker-compose-metric.yml down
docker volume prune
docker volume ls #check if all pinpoint-* volumes are removed
docker-compose -f docker-compose.yml -f docker-compose-metric.yml pull
docker-compose -f docker-compose.yml -f docker-compose-metric.yml up -d