为了更快的定位您的问题，请提供以下信息，谢谢
【详述】Starrock集群突遇只能读不能写
【背景】正常业务
【业务影响】业务数据写入失败
【是否存算分离】
【StarRocks版本】例如：3.1.15
【集群规模】例如：3fe+3 be（fe与be混部三台虚拟机）
【机器信息】CPU虚拟核/内存/网卡，例如：32C/256G/万兆
【联系方式】为了在解决问题过程中能及时联系到您获取一些日志信息，请补充下您的联系方式，例如：社区群4-小李或者邮箱，谢谢
【附件】
- fe.log
2026-03-23 11:30:33.883+08:00 WARN (ForkJoinPool.commonPool-worker-46|6303863) [TIOStreamTransport.close():110] Error closing output stream.
java.net.SocketException: Socket closed
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:118) ~[?:1.8.0_381]
at java.net.SocketOutputStream.write(SocketOutputStream.java:155) ~[?:1.8.0_381]
at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82) ~[?:1.8.0_381]
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140) ~[?:1.8.0_381]
at java.io.FilterOutputStream.close(FilterOutputStream.java:158) ~[?:1.8.0_381]
at org.apache.thrift.transport.TIOStreamTransport.close(TIOStreamTransport.java:108) ~[libthrift-0.13.0.jar:0.13.0]
at org.apache.thrift.transport.TSocket.close(TSocket.java:235) ~[libthrift-0.13.0.jar:0.13.0]
at com.starrocks.common.GenericPool.reopen(GenericPool.java:68) ~[starrocks-fe.jar:?]
at com.starrocks.rpc.FrontendServiceProxy.call(FrontendServiceProxy.java:47) ~[starrocks-fe.jar:?]
at com.starrocks.qe.scheduler.slot.SlotProvider.requireSlotFromSlotManager(SlotProvider.java:135) ~[starrocks-fe.jar:?]
at com.starrocks.qe.scheduler.slot.SlotProvider.requireSlot(SlotProvider.java:68) ~[starrocks-fe.jar:?]
at com.starrocks.qe.QueryQueueManager.maybeWait(QueryQueueManager.java:90) ~[starrocks-fe.jar:?]
at com.starrocks.qe.Coordinator.exec(Coordinator.java:638) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.executeStmtWithExecPlan(StmtExecutor.java:2123) ~[starrocks-fe.jar:?]
at com.starrocks.statistic.StatisticExecutor.queryDictSync(StatisticExecutor.java:187) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.statistics.CacheDictManager$1.lambda$asyncLoad$0(CacheDictManager.java:74) ~[starrocks-fe.jar:?]
at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1604) ~[?:1.8.0_381]
at java.util.concurrent.CompletableFuture$AsyncSupply.exec(CompletableFuture.java:1596) ~[?:1.8.0_381]
at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:289) ~[?:1.8.0_381]
at java.util.concurrent.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1067) ~[?:1.8.0_381]
at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1703) ~[?:1.8.0_381]
at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:172) ~[?:1.8.0_381]
-fe.warn.log
2026-03-23 11:09:40.079+08:00 WARN (starrocks-mysql-nio-pool-419230|6303255) [MysqlChannel.fetchOnePacket():194] receive packet sequence id[32] want to get[1]
2026-03-23 11:09:40.080+08:00 WARN (starrocks-mysql-nio-pool-419230|6303255) [AcceptListener.lambda$handleEvent$1():120] connect processor exception because
java.io.IOException: Bad packet sequence.
at com.starrocks.mysql.MysqlChannel.fetchOnePacket(MysqlChannel.java:195)
at com.starrocks.mysql.MysqlProto.readAuthPacket(MysqlProto.java:241)
at com.starrocks.mysql.MysqlProto.negotiate(MysqlProto.java:136)
at com.starrocks.mysql.nio.AcceptListener.lambda$handleEvent$1(AcceptListener.java:93)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)
2026-03-23 11:09:41.259+08:00 WARN (starrocks-mysql-nio-pool-419230|6303255) [MysqlChannel.fetchOnePacket():194] receive packet sequence id[32] want to get[1]
2026-03-23 11:09:41.259+08:00 WARN (starrocks-mysql-nio-pool-419230|6303255) [AcceptListener.lambda$handleEvent$1():120] connect processor exception because
java.io.IOException: Bad packet sequence.
at com.starrocks.mysql.MysqlChannel.fetchOnePacket(MysqlChannel.java:195)
at com.starrocks.mysql.MysqlProto.readAuthPacket(MysqlProto.java:241)
at com.starrocks.mysql.MysqlProto.negotiate(MysqlProto.java:136)
at com.starrocks.mysql.nio.AcceptListener.lambda$handleEvent$1(AcceptListener.java:93)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)
2026-03-23 11:09:42.305+08:00 WARN (starrocks-mysql-nio-pool-419231|6303256) [MysqlChannel.fetchOnePacket():194] receive packet sequence id[32] want to get[1]
2026-03-23 11:09:42.305+08:00 WARN (starrocks-mysql-nio-pool-419231|6303256) [AcceptListener.lambda$handleEvent$1():120] connect processor exception because
java.io.IOException: Bad packet sequence.
at com.starrocks.mysql.MysqlChannel.fetchOnePacket(MysqlChannel.java:195)
at com.starrocks.mysql.MysqlProto.readAuthPacket(MysqlProto.java:241)
at com.starrocks.mysql.MysqlProto.negotiate(MysqlProto.java:136)
at com.starrocks.mysql.nio.AcceptListener.lambda$handleEvent$1(AcceptListener.java:93)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)
2026-03-23 11:09:47.332+08:00 WARN (starrocks-mysql-nio-pool-419231|6303256) [MysqlChannel.fetchOnePacket():194] receive packet sequence id[32] want to get[1]
2026-03-23 11:09:47.332+08:00 WARN (starrocks-mysql-nio-pool-419231|6303256) [AcceptListener.lambda$handleEvent$1():120] connect processor exception because
java.io.IOException: Bad packet sequence.
at com.starrocks.mysql.MysqlChannel.fetchOnePacket(MysqlChannel.java:195)
at com.starrocks.mysql.MysqlProto.readAuthPacket(MysqlProto.java:241)
at com.starrocks.mysql.MysqlProto.negotiate(MysqlProto.java:136)
at com.starrocks.mysql.nio.AcceptListener.lambda$handleEvent$1(AcceptListener.java:93)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)
2026-03-23 11:09:57.749+08:00 WARN (starrocks-mysql-nio-pool-419231|6303256) [ConnectProcessor.handleQuery():408] Failed to parse SQL: insert into m values(’’‘2026-03-23T11:02:20.189117436’’’);, because:
com.starrocks.common.AnalysisException: Getting syntax error at line 1, column 25. Detail message: Unexpected input ‘2026’, the most similar input is {’,’, ‘)’}.
at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:360)
at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:497)
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:798)
at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:69)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)
2026-03-23 11:09:57.751+08:00 WARN (starrocks-mysql-nio-pool-419231|6303256) [ConnectProcessor.handleQuery():408] Failed to parse SQL: select v from m where v=’’‘2026-03-23T11:02:20.189117436’’’, because:
com.starrocks.common.AnalysisException: Getting syntax error at line 1, column 28. Detail message: Unexpected input ‘2026’, the most similar input is {, ‘;’}.
at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:360)
at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:497)
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:798)
at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:69)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)
2026-03-23 11:11:59.518+08:00 WARN (starrocks-mysql-nio-pool-419232|6303259) [ConnectProcessor.handleQuery():408] Failed to parse SQL: insert into m values(’’‘2026-03-23T11:02:20.189117436’’’), because:
com.starrocks.common.AnalysisException: Getting syntax error at line 1, column 25. Detail message: Unexpected input ‘2026’, the most similar input is {’,’, ‘)’}.
at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:360)
at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:497)
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:798)
at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:69)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)
2026-03-23 11:12:00.531+08:00 WARN (starrocks-mysql-nio-pool-419232|6303259) [PruneComplexTypeUtil$Context.checkCanPrune():172] Complex type columnRefOperator[VARCHAR] and scalarOperator[struct<col1 array, col2 array, c
ol3 array, col4 array, col5 array, col6 array>] should has the same type
2026-03-23 11:12:00.531+08:00 WARN (starrocks-mysql-nio-pool-419232|6303259) [PruneComplexTypeUtil$Context.checkCanPrune():172] Complex type columnRefOperator[VARCHAR] and scalarOperator[struct<col1 array, col2 array,
col3 array, col4 array>] should has the same type
2026-03-23 11:12:00.532+08:00 WARN (starrocks-mysql-nio-pool-419232|6303259) [PruneComplexTypeUtil$Context.checkCanPrune():172] Complex type columnRefOperator[VARCHAR] and scalarOperator[struct<col1 array, col2 array>]
should has the same type
2026-03-23 11:12:00.532+08:00 WARN (starrocks-mysql-nio-pool-419232|6303259) [PruneComplexTypeUtil$Context.checkCanPrune():172] Complex type columnRefOperator[VARCHAR] and scalarOperator[struct<col1 array, col2 array,
col3 array, col4 array, col5 array, col6 array>] should has the same type
2026-03-23 11:12:00.532+08:00 WARN (starrocks-mysql-nio-pool-419232|6303259) [PruneComplexTypeUtil$Context.checkCanPrune():172] Complex type columnRefOperator[VARCHAR] and scalarOperator[struct<col1 array, col2 array,
col3 array, col4 array>] should has the same type
2026-03-23 11:12:00.532+08:00 WARN (starrocks-mysql-nio-pool-419232|6303259) [PruneComplexTypeUtil$Context.checkCanPrune():172] Complex type columnRefOperator[VARCHAR] and scalarOperator[struct<col1 array, col2 array>]
should has the same type
2026-03-23 11:12:11.336+08:00 WARN (starrocks-mysql-nio-pool-419250|6303346) [ConnectContext.kill():747] kill query, 10.237.9.43:59951, kill connection: false
2026-03-23 11:15:38.486+08:00 WARN (starrocks-mysql-nio-pool-419270|6303454) [PruneComplexTypeUtil$Context.checkCanPrune():172] Complex type columnRefOperator[VARCHAR] and scalarOperator[struct<col1 array, col2 array,
col3 array, col4 array, col5 array, col6 array>] should has the same type
2026-03-23 11:15:38.487+08:00 WARN (starrocks-mysql-nio-pool-419270|6303454) [PruneComplexTypeUtil$Context.checkCanPrune():172] Complex type columnRefOperator[VARCHAR] and scalarOperator[struct<col1 array, col2 array,
col3 array, col4 array>] should has the same type
2026-03-23 11:15:38.487+08:00 WARN (starrocks-mysql-nio-pool-419270|6303454) [PruneComplexTypeUtil$Context.checkCanPrune():172] Complex type columnRefOperator[VARCHAR] and scalarOperator[struct<col1 array, col2 array>]
should has the same type
2026-03-23 11:15:38.487+08:00 WARN (starrocks-mysql-nio-pool-419270|6303454) [PruneComplexTypeUtil$Context.checkCanPrune():172] Complex type columnRefOperator[VARCHAR] and scalarOperator[struct<col1 array, col2 array,
col3 array, col4 array, col5 array, col6 array>] should has the same type
2026-03-23 11:15:38.487+08:00 WARN (starrocks-mysql-nio-pool-419270|6303454) [PruneComplexTypeUtil$Context.checkCanPrune():172] Complex type columnRefOperator[VARCHAR] and scalarOperator[struct<col1 array, col2 array,
col3 array, col4 array>] should has the same type
2026-03-23 11:15:38.487+08:00 WARN (starrocks-mysql-nio-pool-419270|6303454) [PruneComplexTypeUtil$Context.checkCanPrune():172] Complex type columnRefOperator[VARCHAR] and scalarOperator[struct<col1 array, col2 array>]
should has the same type
2026-03-23 11:16:10.807+08:00 WARN (starrocks-mysql-nio-pool-419270|6303454) [PruneComplexTypeUtil$Context.checkCanPrune():172] Complex type columnRefOperator[VARCHAR] and scalarOperator[struct<col1 array, col2 array,
col3 array, col4 array, col5 array, col6 array>] should has the same type
2026-03-23 11:16:10.807+08:00 WARN (starrocks-mysql-nio-pool-419270|6303454) [PruneComplexTypeUtil$Context.checkCanPrune():172] Complex type columnRefOperator[VARCHAR] and scalarOperator[struct<col1 array, col2 array,
col3 array, col4 array>] should has the same type
2026-03-23 11:16:10.808+08:00 WARN (starrocks-mysql-nio-pool-419270|6303454) [PruneComplexTypeUtil$Context.checkCanPrune():172] Complex type columnRefOperator[VARCHAR] and scalarOperator[struct<col1 array, col2 array>]
should has the same type
2026-03-23 11:16:10.808+08:00 WARN (starrocks-mysql-nio-pool-419270|6303454) [PruneComplexTypeUtil$Context.checkCanPrune():172] Complex type columnRefOperator[VARCHAR] and scalarOperator[struct<col1 array, col2 array,
col3 array, col4 array, col5 array, col6 array>] should has the same type
2026-03-23 11:16:10.808+08:00 WARN (starrocks-mysql-nio-pool-419270|6303454) [PruneComplexTypeUtil$Context.checkCanPrune():172] Complex type columnRefOperator[VARCHAR] and scalarOperator[struct<col1 array, col2 array,
col3 array, col4 array>] should has the same type
2026-03-23 11:16:10.808+08:00 WARN (starrocks-mysql-nio-pool-419270|6303454) [PruneComplexTypeUtil$Context.checkCanPrune():172] Complex type columnRefOperator[VARCHAR] and scalarOperator[struct<col1 array, col2 array>]
should has the same type
2026-03-23 11:20:55.979+08:00 WARN (ForkJoinPool.commonPool-worker-0|6303575) [TIOStreamTransport.close():110] Error closing output stream.
java.net.SocketException: Socket closed
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:118)
at java.net.SocketOutputStream.write(SocketOutputStream.java:155)
at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
at java.io.FilterOutputStream.close(FilterOutputStream.java:158)
at org.apache.thrift.transport.TIOStreamTransport.close(TIOStreamTransport.java:108)
at org.apache.thrift.transport.TSocket.close(TSocket.java:235)
at com.starrocks.common.GenericPool.reopen(GenericPool.java:68)
at com.starrocks.rpc.FrontendServiceProxy.call(FrontendServiceProxy.java:47)
at com.starrocks.qe.scheduler.slot.SlotProvider.requireSlotFromSlotManager(SlotProvider.java:135)
at com.starrocks.qe.scheduler.slot.SlotProvider.requireSlot(SlotProvider.java:68)
at com.starrocks.qe.QueryQueueManager.maybeWait(QueryQueueManager.java:90)
at com.starrocks.qe.Coordinator.exec(Coordinator.java:638)
at com.starrocks.qe.StmtExecutor.executeStmtWithExecPlan(StmtExecutor.java:2123)
at com.starrocks.statistic.StatisticExecutor.queryDictSync(StatisticExecutor.java:187)
at com.starrocks.sql.optimizer.statistics.CacheDictManager$1.lambda$asyncLoad$0(CacheDictManager.java:74)
at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1604)
at java.util.concurrent.CompletableFuture$AsyncSupply.exec(CompletableFuture.java:1596)
at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:289)
at java.util.concurrent.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1067)
at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1703)
at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:172)
be-warn-log
W0323 11:16:26.162369 13174 segment_replicate_executor.cpp:301] Failed to sync segment SyncChannnel [host: 10.3.7.44, port: 8060, load_id: 03136815-2662-11f1-8777-0242d9dce56e, tablet_id: 2022257, txn_id: 25994721] err Internal error: no
associated load channel 03136815-2662-11f1-8777-0242d9dce56e
/build/starrocks/be/src/storage/segment_replicate_executor.cpp:111 _wait_response(replicate_tablet_infos, failed_tablet_infos)
W0323 11:16:26.162312 1458163 async_delta_writer.cpp:61] Fail to write or commit. txn_id: 25994719 tablet_id: 10094: Internal error: no associated load channel a3bc8418-2661-11f1-b452-fa163e1c3ad1
/build/starrocks/be/src/storage/segment_replicate_executor.cpp:111 _wait_response(replicate_tablet_infos, failed_tablet_infos)
W0323 11:16:26.162379 1458160 async_delta_writer.cpp:61] Fail to write or commit. txn_id: 25994718 tablet_id: 42979170: Internal error: no associated load channel 1748b4e4-dacf-5d8f-bdef-93c17410ec96
/build/starrocks/be/src/storage/segment_replicate_executor.cpp:111 _wait_response(replicate_tablet_infos, failed_tablet_infos)
W0323 11:16:26.162389 13171 segment_replicate_executor.cpp:301] Failed to sync segment SyncChannnel [host: 10.3.7.44, port: 8060, load_id: 03136815-2662-11f1-8777-0242d9dce56e, tablet_id: 2022261, txn_id: 25994721] err Internal error: no
associated load channel 03136815-2662-11f1-8777-0242d9dce56e
/build/starrocks/be/src/storage/segment_replicate_executor.cpp:111 _wait_response(replicate_tablet_infos, failed_tablet_infos)
W0323 11:16:26.162408 1458155 async_delta_writer.cpp:61] Fail to write or commit. txn_id: 25994718 tablet_id: 42979146: Internal error: no associated load channel 1748b4e4-dacf-5d8f-bdef-93c17410ec96
/build/starrocks/be/src/storage/segment_replicate_executor.cpp:111 _wait_response(replicate_tablet_infos, failed_tablet_infos)
W0323 11:16:26.162223 1458148 async_delta_writer.cpp:61] Fail to write or commit. txn_id: 25994718 tablet_id: 42979158: Internal error: no associated load channel 1748b4e4-dacf-5d8f-bdef-93c17410ec96
/build/starrocks/be/src/storage/segment_replicate_executor.cpp:111 _wait_response(replicate_tablet_infos, failed_tablet_infos)
W0323 11:16:26.162412 13172 segment_replicate_executor.cpp:162] Failed to send rpc to SyncChannnel [host: 10.3.7.44, port: 8060, load_id: 03136815-2662-11f1-8777-0242d9dce56e, tablet_id: 2022265, txn_id: 25994721] err=Internal error: no
associated load channel 03136815-2662-11f1-8777-0242d9dce56e
W0323 11:16:26.162325 13167 segment_replicate_executor.cpp:301] Failed to sync segment SyncChannnel [host: 10.3.7.44, port: 8060, load_id: 03136815-2662-11f1-8777-0242d9dce56e, tablet_id: 2022309, txn_id: 25994721] err Internal error: no
associated load channel 03136815-2662-11f1-8777-0242d9dce56e
/build/starrocks/be/src/storage/segment_replicate_executor.cpp:111 _wait_response(replicate_tablet_infos, failed_tablet_infos)
W0323 11:16:26.162446 13170 segment_replicate_executor.cpp:301] Failed to sync segment SyncChannnel [host: 10.3.7.44, port: 8060, load_id: 03136815-2662-11f1-8777-0242d9dce56e, tablet_id: 2022253, txn_id: 25994721] err Internal error: no
associated load channel 03136815-2662-11f1-8777-0242d9dce56e
/build/starrocks/be/src/storage/segment_replicate_executor.cpp:111 _wait_response(replicate_tablet_infos, failed_tablet_infos)
W0323 11:16:26.162457 13169 segment_replicate_executor.cpp:301] Failed to sync segment SyncChannnel [host: 10.3.7.44, port: 8060, load_id: 03136815-2662-11f1-8777-0242d9dce56e, tablet_id: 2022305, txn_id: 25994721] err Internal error: no
associated load channel 03136815-2662-11f1-8777-0242d9dce56e
show variables like ‘%parallel_fragment_exec_instance_num%’;---------------1
show variables like ‘%pipeline%’;
| enable_pipeline_engine | true |
|---|---|
| enable_pipeline_query_statistic | true |
| max_pipeline_dop | 64 |
| pipeline_dop | 0 |
| pipeline_profile_level | 1 |
| pipeline_sink_dop | 0 |
SHOW FRONTENDS;
SHOW BACKENDS;
故障时状态均正常