starrocks部署，服务端连接一开始正常，跑着跑着就会超时

💬 StarRocks 用户问答 功能使用相关
#1

为了更快的定位您的问题，请提供以下信息，谢谢
【详述】starrocks3.2.0版本，存算一体部署，4FE，4BE部署；微服务使用Druid连接池连接Starrocks；一开始运行正常，跑着跑着会报错连接超时
【背景】
【业务影响】
【是否存算分离】
【StarRocks版本】3.2.0
【集群规模】例如：4fe（1 Leader+3follower）+4be（fe与be混部）

【附件】
FE warn日志
2024-06-13 12:12:23,582 WARN (starrocks-mysql-nio-pool-299|5120) [ReadListener.lambda$handleEvent$0():81] Exception happened in one session(com.starrocks.mysql.nio.NConnectContext@76900bf1).
java.io.IOException: Broken pipe
at sun.nio.ch.FileDispatcherImpl.write0(Native Method) ~[?:1.8.0_392]
at sun.nio.ch.SocketDispatcher.write(SocketDispatcher.java:47) ~[?:1.8.0_392]
at sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:93) ~[?:1.8.0_392]
at sun.nio.ch.IOUtil.write(IOUtil.java:65) ~[?:1.8.0_392]
at sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:470) ~[?:1.8.0_392]
at org.xnio.nio.NioSocketConduit.write(NioSocketConduit.java:153) ~[xnio-nio-3.8.10.Final.jar:3.8.10.Final]
at org.xnio.conduits.ConduitStreamSinkChannel.write(ConduitStreamSinkChannel.java:150) ~[xnio-api-3.8.10.Final.jar:3.8.10.Final]
at org.xnio.channels.Channels.writeBlocking(Channels.java:147) ~[xnio-api-3.8.10.Final.jar:3.8.10.Final]
at com.starrocks.mysql.nio.NMysqlChannel.realNetSend(NMysqlChannel.java:69) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.MysqlChannel.send(MysqlChannel.java:354) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.MysqlChannel.flush(MysqlChannel.java:377) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.MysqlChannel.sendAndFlush(MysqlChannel.java:454) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.finalizeCommand(ConnectProcessor.java:660) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:850) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:69) ~[starrocks-fe.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_392]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_392]
at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_392]
2024-06-13 12:16:26,993 WARN (starrocks-mysql-nio-pool-299|5120) [ConnectProcessor.handleQuery():396] Process one query failed because IOException:
java.io.IOException: Broken pipe
at sun.nio.ch.FileDispatcherImpl.write0(Native Method) ~[?:1.8.0_392]
at sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:470) ~[?:1.8.0_392]
at org.xnio.nio.NioSocketConduit.write(NioSocketConduit.java:153) ~[xnio-nio-3.8.10.Final.jar:3.8.10.Final]
at org.xnio.conduits.ConduitStreamSinkChannel.write(ConduitStreamSinkChannel.java:150) ~[xnio-api-3.8.10.Final.jar:3.8.10.Final]
at org.xnio.channels.Channels.writeBlocking(Channels.java:147) ~[xnio-api-3.8.10.Final.jar:3.8.10.Final]
at com.starrocks.mysql.nio.NMysqlChannel.realNetSend(NMysqlChannel.java:69) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.MysqlChannel.send(MysqlChannel.java:354) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.MysqlChannel.flush(MysqlChannel.java:377) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.MysqlChannel.sendAndFlush(MysqlChannel.java:454) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.finalizeCommand(ConnectProcessor.java:660) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:850) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:69) ~[starrocks-fe.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_392]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_392]
at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_392]
2024-06-13 12:16:26,993 WARN (starrocks-mysql-nio-pool-299|5120) [ConnectProcessor.handleQuery():396] Process one query failed because IOException:
java.io.IOException: Broken pipe
at sun.nio.ch.FileDispatcherImpl.write0(Native Method) ~[?:1.8.0_392]
at sun.nio.ch.SocketDispatcher.write(SocketDispatcher.java:47) ~[?:1.8.0_392]
at sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:93) ~[?:1.8.0_392]
at sun.nio.ch.IOUtil.write(IOUtil.java:65) ~[?:1.8.0_392]
at sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:470) ~[?:1.8.0_392]
at org.xnio.nio.NioSocketConduit.write(NioSocketConduit.java:153) ~[xnio-nio-3.8.10.Final.jar:3.8.10.Final]
at org.xnio.conduits.ConduitStreamSinkChannel.write(ConduitStreamSinkChannel.java:150) ~[xnio-api-3.8.10.Final.jar:3.8.10.Final]
at org.xnio.channels.Channels.writeBlocking(Channels.java:147) ~[xnio-api-3.8.10.Final.jar:3.8.10.Final]
at com.starrocks.mysql.nio.NMysqlChannel.realNetSend(NMysqlChannel.java:69) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.MysqlChannel.send(MysqlChannel.java:354) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.MysqlChannel.flush(MysqlChannel.java:377) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.MysqlChannel.sendAndFlush(MysqlChannel.java:454) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.finalizeCommand(ConnectProcessor.java:660) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:390) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:570) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:848) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:69) ~[starrocks-fe.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_392]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_392]
at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_392]
2024-06-13 12:16:26,994 WARN (starrocks-mysql-nio-pool-299|5120) [ReadListener.lambda$handleEvent$0():81] Exception happened in one session(com.starrocks.mysql.nio.NConnectContext@2ad251b0).
java.io.IOException: Broken pipe
at sun.nio.ch.FileDispatcherImpl.write0(Native Method) ~[?:1.8.0_392]
at sun.nio.ch.SocketDispatcher.write(SocketDispatcher.java:47) ~[?:1.8.0_392]
at sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:93) ~[?:1.8.0_392]
at sun.nio.ch.IOUtil.write(IOUtil.java:65) ~[?:1.8.0_392]
at sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:470) ~[?:1.8.0_392]
at org.xnio.nio.NioSocketConduit.write(NioSocketConduit.java:153) ~[xnio-nio-3.8.10.Final.jar:3.8.10.Final]
at org.xnio.conduits.ConduitStreamSinkChannel.write(ConduitStreamSinkChannel.java:150) ~[xnio-api-3.8.10.Final.jar:3.8.10.Final]
at org.xnio.channels.Channels.writeBlocking(Channels.java:147) ~[xnio-api-3.8.10.Final.jar:3.8.10.Final]
at com.starrocks.mysql.nio.NMysqlChannel.realNetSend(NMysqlChannel.java:69) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.MysqlChannel.send(MysqlChannel.java:354) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.MysqlChannel.flush(MysqlChannel.java:377) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.MysqlChannel.sendAndFlush(MysqlChannel.java:454) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.finalizeCommand(ConnectProcessor.java:660) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:850) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:69) ~[starrocks-fe.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_392]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_392]

客户端日志
Communications link failure with primary host ..14.191:9030. Connection timed out; nested exception is java.sql.SQLInvalidAuthorizationSpecException: (conn=9) Communications link failure with primary host ..14.191:9030. Connection timed out
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:90)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82)
at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1575)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:398)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:434)
at com.huawei.winscloud.ai.api.datawarehouse.service.StarRocksService.execute(StarRocksService.java:54)
at com.huawei.winscloud.ai.api.datawarehouse.service.StarRocksService.setInitData(StarRocksService.java:155)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:389)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:333)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:157)
… 55 common frames omitted
Caused by: java.sql.SQLInvalidAuthorizationSpecException: (conn=9) Communications link failure with primary host ..14.191:9030. Connection timed out
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:66)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:158)
at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:262)
at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:362)
at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:500)
at com.alibaba.druid.pool.DruidPooledStatement.execute(DruidPooledStatement.java:635)
at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:425)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:383)
… 65 common frames omitted
Caused by: java.sql.SQLException: Communications link failure with primary host ..14.191:9030. Connection timed out
on HostAddress{host=‘..14.191’, port=9030, type=‘master’},master=true. Driver has reconnect connection
at org.mariadb.jdbc.internal.failover.AbstractMastersListener.throwFailoverMessage(AbstractMastersListener.java:563)
at org.mariadb.jdbc.internal.failover.FailoverProxy.handleFailOver(FailoverProxy.java:391)
at org.mariadb.jdbc.internal.failover.FailoverProxy.executeInvocation(FailoverProxy.java:324)
at org.mariadb.jdbc.internal.failover.FailoverProxy.invoke(FailoverProxy.java:294)
at com.sun.proxy.$Proxy171.executeQuery(Unknown Source)
at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:356)
… 69 common frames omitted
Caused by: java.sql.SQLNonTransientConnectionException: Read timed out
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.handleIoException(AbstractQueryProtocol.java:2091)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1541)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1520)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:256)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.mariadb.jdbc.internal.failover.AbstractMastersListener.invoke(AbstractMastersListener.java:408)
at org.mariadb.jdbc.internal.failover.FailoverProxy.executeInvocation(FailoverProxy.java:301)
… 72 common frames omitted
Caused by: java.net.SocketTimeoutException: Read timed out
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
at java.net.SocketInputStream.read(SocketInputStream.java:171)
at java.net.SocketInputStream.read(SocketInputStream.java:141)
at java.io.FilterInputStream.read(FilterInputStream.java:133)
at org.mariadb.jdbc.internal.io.input.ReadAheadBufferedStream.fillBuffer(ReadAheadBufferedStream.java:131)
at org.mariadb.jdbc.internal.io.input.ReadAheadBufferedStream.read(ReadAheadBufferedStream.java:104)
at org.mariadb.jdbc.internal.io.input.StandardPacketInputStream.getPacketArray(StandardPacketInputStream.java:247)
at org.mariadb.jdbc.internal.io.input.StandardPacketInputStream.getPacket(StandardPacketInputStream.java:218)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1539)

#2

使用其他客户端工具连接，对元数据的操作，很慢

image

image
image955×67 9.26 KB

#3

客户端日志
2024-06-14 11:43:18.777 [https-jsse-nio-9888-exec-95] ERROR c.h.w.a.a.d.s.Service - current task has exception org.springframework.dao.DataAccessResourceFailureException: StatementCallback; SQL [DROP TABLE IF EXISTS Quarterly_027425_027848_VCN810001076]; (conn=3522) Connection timed out; nested exception is java.sql.SQLNonTransientConnectionException: (conn=3522) Connection timed out
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:81)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82)
at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1575)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:398)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:434)
at 。。。。
at 。。。。
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:792)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)
at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:123)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:707)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:903)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:809)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1072)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:965)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:523)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:590)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at com.huawei.wins.innerhttps.CorsFilter.doFilter(CorsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at com.huawei.wins.innerhttps.HttpFilter.doFilter(HttpFilter.java:75)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at com.huawei.wins.auditlog.RequestInfoFilter.doFilter(RequestInfoFilter.java:31)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at com.huawei.wins.apicenter.filter.RequestStatisticsFilter.doFilter(RequestStatisticsFilter.java:41)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:765)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:750)
Caused by: java.sql.SQLNonTransientConnectionException: (conn=3522) Connection timed out
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:73)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:158)
at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:262)
at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:362)
at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:500)
at com.alibaba.druid.pool.DruidPooledStatement.execute(DruidPooledStatement.java:635)
at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:425)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:383)
… 86 common frames omitted
Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Connection timed out
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:192)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:262)
at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:356)
… 90 common frames omitted
Caused by: java.sql.SQLNonTransientConnectionException: Read timed out
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.handleIoException(AbstractQueryProtocol.java:2091)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1541)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1520)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:256)
… 91 common frames omitted
Caused by: java.net.SocketTimeoutException: Read timed out
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
at java.net.SocketInputStream.read(SocketInputStream.java:171)
at java.net.SocketInputStream.read(SocketInputStream.java:141)
at java.io.FilterInputStream.read(FilterInputStream.java:133)
at org.mariadb.jdbc.internal.io.input.ReadAheadBufferedStream.fillBuffer(ReadAheadBufferedStream.java:131)
at org.mariadb.jdbc.internal.io.input.ReadAheadBufferedStream.read(ReadAheadBufferedStream.java:104)
at org.mariadb.jdbc.internal.io.input.StandardPacketInputStream.getPacketArray(StandardPacketInputStream.java:247)
at org.mariadb.jdbc.internal.io.input.StandardPacketInputStream.getPacket(StandardPacketInputStream.java:218)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1539)
… 93 common frames omitted

#4

fe.log
2024-06-14 11:43:06,114 INFO (nioEventLoopGroup-4-8|576) [BaseAction.handleRequest():104] receive http request. url=/static?res=starrocks.js
2024-06-14 11:43:06,114 ERROR (nioEventLoopGroup-4-8|576) [StaticResourceAction.executeGet():173] Request with wrong path. url: /static?res=starrocks.js
2024-06-14 11:43:06,115 INFO (nioEventLoopGroup-4-9|577) [BaseAction.handleRequest():104] receive http request. url=/static/images?res=starrocks-logo.png
2024-06-14 11:43:06,115 ERROR (nioEventLoopGroup-4-9|577) [StaticResourceAction.executeGet():173] Request with wrong path. url: /static/images?res=starrocks-logo.png
2024-06-14 11:43:06,245 INFO (starrocks-mysql-nio I/O-3|124) [AcceptListener.handleEvent():79] Connection established. remote=/10.244.160.94:40761, connectionId=3535
2024-06-14 11:43:06,246 INFO (starrocks-mysql-nio-pool-127|468) [AcceptListener.lambda$handleEvent$1():87] Connection scheduled to worker thread 468. remote=/10.244.160.94:40761, connectionId=3535
2024-06-14 11:43:06,834 INFO (starrocks-mysql-nio I/O-1|122) [AcceptListener.handleEvent():79] Connection established. remote=/10.244.160.94:17191, connectionId=3536
2024-06-14 11:43:06,835 INFO (starrocks-mysql-nio-pool-127|468) [AcceptListener.lambda$handleEvent$1():87] Connection scheduled to worker thread 468. remote=/10.244.160.94:17191, connectionId=3536
2024-06-14 11:43:07,430 INFO (starrocks-mysql-nio I/O-4|125) [AcceptListener.handleEvent():79] Connection established. remote=/10.244.160.94:52066, connectionId=3537
2024-06-14 11:43:07,430 INFO (starrocks-mysql-nio-pool-127|468) [AcceptListener.lambda$handleEvent$1():87] Connection scheduled to worker thread 468. remote=/10.244.160.94:52066, connectionId=3537
2024-06-14 11:43:08,025 INFO (starrocks-mysql-nio I/O-4|125) [AcceptListener.handleEvent():79] Connection established. remote=/10.244.160.94:23163, connectionId=3538
2024-06-14 11:43:08,025 INFO (starrocks-mysql-nio-pool-127|468) [AcceptListener.lambda$handleEvent$1():87] Connection scheduled to worker thread 468. remote=/10.244.160.94:23163, connectionId=3538
2024-06-14 11:43:08,621 INFO (starrocks-mysql-nio I/O-2|123) [AcceptListener.handleEvent():79] Connection established. remote=/10.244.160.94:7811, connectionId=3539
2024-06-14 11:43:08,621 INFO (starrocks-mysql-nio-pool-127|468) [AcceptListener.lambda$handleEvent$1():87] Connection scheduled to worker thread 468. remote=/10.244.160.94:7811, connectionId=3539
2024-06-14 11:43:08,787 INFO (starrocks-mysql-nio-pool-127|468) [CatalogRecycleBin.eraseTableWithSameName():438] erase table[10037-027425_027848_VCN810001076], because table with the same name is recycled
2024-06-14 11:43:08,787 INFO (starrocks-mysql-nio-pool-127|468) [CatalogRecycleBin.recycleTable():172] recycle table[10315-027425_027848_VCN810001076]
2024-06-14 11:43:08,787 INFO (starrocks-mysql-nio-pool-127|468) [Database.unprotectDropTable():539] finished dropping table[027425_027848_VCN810001076] in db[wins_aggregate_db], tableId: 10315
2024-06-14 11:43:08,789 INFO (starrocks-mysql-nio-pool-127|468) [Database.dropTable():509] finished dropping table: 027425_027848_VCN810001076, type:FILE from db: wins_aggregate_db, is force: false
2024-06-14 11:43:08,795 INFO (starrocks-mysql-nio I/O-3|124) [AcceptListener.handleEvent():79] Connection established. remote=/10.243.118.64:38428, connectionId=3540
2024-06-14 11:43:08,795 INFO (starrocks-mysql-nio-pool-123|464) [AcceptListener.lambda$handleEvent$1():87] Connection scheduled to worker thread 464. remote=/10.243.118.64:38428, connectionId=3540
2024-06-14 11:43:08,876 INFO (starrocks-mysql-nio-pool-123|464) [QeProcessorImpl.registerQuery():101] register query id = 3759721d-2a00-11ef-8e8e-fa163e490775
2024-06-14 11:43:08,878 INFO (starrocks-mysql-nio-pool-123|464) [QeProcessorImpl.unregisterQuery():140] deregister query id = 3759721d-2a00-11ef-8e8e-fa163e490775

#5

使用工具删除表
image

FE 日志
2024-06-14 13:42:00,482 INFO (starrocks-mysql-nio-pool-218|793) [QeProcessorImpl.unregisterQuery():140] deregister query id = d21e0235-2a10-11ef-8e8e-fa163e490775
2024-06-14 13:42:00,486 WARN (starrocks-mysql-nio-pool-218|793) [ConnectProcessor.handleQuery():399] Process one query failed. SQL: SAVEPOINT 329cc9fb-9069-4b3c-9980-259b91c185cf, because.
com.starrocks.common.AnalysisException: Getting syntax error at line 1, column 0. Detail message: Unexpected input ‘SAVEPOINT’, the most similar input is {‘EXPORT’, ‘EXPLAIN’, ‘ADMIN’, ‘BEGIN’, ‘GRANT’, ‘(’, ‘;’}.
at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:349) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:570) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:848) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:69) ~[starrocks-fe.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_392]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_392]
at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_392]
2024-06-14 13:42:00,491 INFO (starrocks-mysql-nio-pool-218|793) [CatalogRecycleBin.eraseTableWithSameName():438] erase table[10370-getSecondary], because table with the same name is recycled
2024-06-14 13:42:00,491 INFO (starrocks-mysql-nio-pool-218|793) [CatalogRecycleBin.recycleTable():172] recycle table[10853-getSecondary]
2024-06-14 13:42:00,492 INFO (starrocks-mysql-nio-pool-218|793) [Database.unprotectDropTable():539] finished dropping table[getSecondary] in db[wins_aggregate_db], tableId: 10853
2024-06-14 13:42:00,493 INFO (starrocks-mysql-nio-pool-218|793) [Database.dropTable():509] finished dropping table: getSecondary, type:OLAP from db: wins_aggregate_db, is force: false
2024-06-14 13:42:01,014 INFO (starrocks-mysql-nio I/O-1|122) [AcceptListener.handleEvent():79] Connection established. remote=/10.244.160.94:16212, connectionId=15151
2024-06-14 13:42:01,014 INFO (starrocks-mysql-nio-pool-240|944) [AcceptListener.lambda$handleEvent$1():87] Connection scheduled to worker thread 944. remote=/10.244.160.94:16212, connectionId=15151
2024-06-14 13:42:01,607 INFO (starrocks-mysql-nio I/O-3|124) [AcceptListener.handleEvent():79] Connection established. remote=/10.244.160.94:59473, connectionId=15152
2024-06-14 13:42:01,607 INFO (starrocks-mysql-nio-pool-240|944) [AcceptListener.lambda$handleEvent$1():87] Connection scheduled to worker thread 944. remote=/10.244.160.94:59473, connectionId=15152

京ICP备2022026421号-1