为了更快的定位您的问题,请提供以下信息,谢谢
【详述】查询返回大数据量(200w行)结果集的时候,FE报错之后会cacel掉查询,mysql客户端直接卡死,接收不到查询错误的返回,并且会一直阻塞直到配置的socket_timeout时间
【背景】做过哪些操作?
【业务影响】
【是否存算分离】
【StarRocks版本】例如:3.3.2
【集群规模】例如:3fe(1 follower+2observer)+ 3be(fe与be混部)
【机器信息】64C/128G
【联系方式】社区联系
【附件】
2025-11-26 10:57:37.967+08:00 WARN (connect-scheduler-pool-405|84681) [QueryStatisticsInfo.getExecProgress():506] failed to get query progress, query_id: 57ef3744-ca73-11f0-b430-0242b520cf21, status code: 404, msg: query id 57ef3744-ca73-11f0-b430-0242b520cf21 not found.
2025-11-26 10:57:38.000+08:00 WARN (connect-scheduler-pool-405|84681) [QueryStatisticsInfo.getExecProgress():506] failed to get query progress, query_id: 57ef3744-ca73-11f0-b430-0242b520cf21, status code: 404, msg: query id 57ef3744-ca73-11f0-b430-0242b520cf21 not found.
2025-11-26 10:57:54.136+08:00 WARN (connect-scheduler-pool-448|91306) [StmtExecutor.execute():750] execute IOException
java.io.IOException: Write mysql packet failed.[write=124671, needToWrite=261782]
at com.starrocks.mysql.MysqlChannel.realNetSend(MysqlChannel.java:245)
at com.starrocks.mysql.MysqlChannel.send(MysqlChannel.java:236)
at com.starrocks.mysql.MysqlChannel.flush(MysqlChannel.java:259)
at com.starrocks.mysql.MysqlChannel.writeBuffer(MysqlChannel.java:297)
at com.starrocks.mysql.MysqlChannel.sendOnePacket(MysqlChannel.java:321)
at com.starrocks.qe.StmtExecutor.handleQueryStmt(StmtExecutor.java:1248)
at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:631)
at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:374)
at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:579)
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:914)
at com.starrocks.qe.ConnectProcessor.loop(ConnectProcessor.java:924)
at com.starrocks.qe.ConnectScheduler$LoopHandler.run(ConnectScheduler.java:302)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)
2025-11-26 10:57:54.137+08:00 WARN (connect-scheduler-pool-448|91306) [DefaultCoordinator.cancel():872] cancel execState of query, this is outside invoke
2025-11-26 10:58:02.547+08:00 WARN (thrift-server-accept|160) [SRTThreadPoolServer.execute():228] Transport error occurred during acceptance of message.
org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Accept timed out
at org.apache.thrift.transport.TServerSocket.accept(TServerSocket.java:119)
at org.apache.thrift.transport.TServerSocket.accept(TServerSocket.java:31)
at com.starrocks.common.SRTThreadPoolServer.execute(SRTThreadPoolServer.java:184)
at com.starrocks.common.SRTThreadPoolServer.serve(SRTThreadPoolServer.java:175)
at com.starrocks.common.ThriftServer$1.run(ThriftServer.java:95)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.net.SocketTimeoutException: Accept timed out
at java.base/java.net.PlainSocketImpl.socketAccept(Native Method)
at java.base/java.net.AbstractPlainSocketImpl.accept(AbstractPlainSocketImpl.java:458)
at java.base/java.net.ServerSocket.implAccept(ServerSocket.java:565)
at java.base/java.net.ServerSocket.accept(ServerSocket.java:533)
at org.apache.thrift.transport.TServerSocket.accept(TServerSocket.java:117)
… 5 more