SR集群所有查询和写入失败

SR版本:2.5.12
问题描述:用户执行过下面的SQL之后 所有的查询和写入都失败了
SQL:
SELECT datae_column_049df6b6da, cal_27b7219036d02d6f7396db2840ce234a, datae_column_33055a71ce
FROM
(
SELECT hour datae_column_049df6b6da ,
ifnull((sum(value_sum) / (CASE WHEN (sum(valid_cnt) = 0) THEN null ELSE sum(valid_cnt) END)), 0) cal_27b7219036d02d6f7396db2840ce234a ,
feature datae_column_33055a71ce
FROM d1.t1
WHERE ((value_type IN (‘float’))
AND (hour IN (‘2025-12-20 09:00:00’, ‘2025-12-21 04:00:00’)))
GROUP BY feature, hour
ORDER BY cal_27b7219036d02d6f7396db2840ce234a DESC NULLS LAST limit 2000
) tmp

BE报错日志:
*** Aborted at 1766481166 (unix time) try “date -d @1766481166” if you are using GNU date ***
PC: @ 0x2fa3933 _ZN14pdqsort_detail12pdqsort_loopIN9__gnu_cxx17__normal_iteratorIPN9starrocks10vectorized20VerticalColumnSorter16CompactChunkItemIdEESt6vectorIS7_SaIS7_EEEEZNS4_L19sort_and_tie_helperIZNS5_8do_visitIdEENS3_6StatusERKNS4_21FixedLengthColumnBaseIT_EEEUlRKS7_SM_E_SB_EESF_RKbPKNS4_6ColumnEbRT0_RS9_IhSaIhEESH_St4pairIiiEbmPmEUlSH_ST_E0_Lb0EEEvSP_SH_SH_ST_ib.isra.0
*** SIGSEGV (@0x7f4471b51008) received by PID 28 (TID 0x7f47c851d700) from PID 1907691528; stack trace: ***
@ 0x5b82542 google::(anonymous namespace)::FailureSignalHandler()
@ 0x7f4b90f0c630 (unknown)
@ 0x2fa3933 _ZN14pdqsort_detail12pdqsort_loopIN9__gnu_cxx17__normal_iteratorIPN9starrocks10vectorized20VerticalColumnSorter16CompactChunkItemIdEESt6vectorIS7_SaIS7_EEEEZNS4_L19sort_and_tie_helperIZNS5_8do_visitIdEENS3_6StatusERKNS4_21FixedLengthColumnBaseIT_EEEUlRKS7_SM_E_SB_EESF_RKbPKNS4_6ColumnEbRT0_RS9_IhSaIhEESH_St4pairIiiEbmPmEUlSH_ST_E0_Lb0EEEvSP_SH_SH_ST_ib.isra.0
@ 0x2fa3cc6 _ZN14pdqsort_detail12pdqsort_loopIN9__gnu_cxx17__normal_iteratorIPN9starrocks10vectorized20VerticalColumnSorter16CompactChunkItemIdEESt6vectorIS7_SaIS7_EEEEZNS4_L19sort_and_tie_helperIZNS5_8do_visitIdEENS3_6StatusERKNS4_21FixedLengthColumnBaseIT_EEEUlRKS7_SM_E_SB_EESF_RKbPKNS4_6ColumnEbRT0_RS9_IhSaIhEESH_St4pairIiiEbmPmEUlSH_ST_E0_Lb0EEEvSP_SH_SH_ST_ib.isra.0
@ 0x2fa3cc6 _ZN14pdqsort_detail12pdqsort_loopIN9__gnu_cxx17__normal_iteratorIPN9starrocks10vectorized20VerticalColumnSorter16CompactChunkItemIdEESt6vectorIS7_SaIS7_EEEEZNS4_L19sort_and_tie_helperIZNS5_8do_visitIdEENS3_6StatusERKNS4_21FixedLengthColumnBaseIT_EEEUlRKS7_SM_E_SB_EESF_RKbPKNS4_6ColumnEbRT0_RS9_IhSaIhEESH_St4pairIiiEbmPmEUlSH_ST_E0_Lb0EEEvSP_SH_SH_ST_ib.isra.0
@ 0x2fa3cc6 _ZN14pdqsort_detail12pdqsort_loopIN9__gnu_cxx17__normal_iteratorIPN9starrocks10vectorized20VerticalColumnSorter16CompactChunkItemIdEESt6vectorIS7_SaIS7_EEEEZNS4_L19sort_and_tie_helperIZNS5_8do_visitIdEENS3_6StatusERKNS4_21FixedLengthColumnBaseIT_EEEUlRKS7_SM_E_SB_EESF_RKbPKNS4_6ColumnEbRT0_RS9_IhSaIhEESH_St4pairIiiEbmPmEUlSH_ST_E0_Lb0EEEvSP_SH_SH_ST_ib.isra.0
@ 0x301c845 starrocks::vectorized::VerticalColumnSorter::do_visit<>()
@ 0x301d7d6 starrocks::ColumnVisitorAdapter<>::visit()
@ 0x3357cef starrocks::vectorized::ColumnFactory<>::accept()
@ 0x2f7e993 starrocks::vectorized::sort_vertical_columns()
@ 0x2ffe5c1 starrocks::vectorized::VerticalColumnSorter::do_visit()
$
@ 0x50aa87c starrocks::vectorized::ColumnFactory<>::accept()
@ 0x2f7e993 starrocks::vectorized::sort_vertical_columns()
@ 0x2f7f7cc starrocks::vectorized::sort_vertical_chunks()
@ 0x2f05604 starrocks::vectorized::ChunksSorterTopn::_partial_sort_col_wise()
@ 0x2f05a15 starrocks::vectorized::ChunksSorterTopn::_filter_and_sort_data()
Connection to xgrelay.sys.xiaojukeji.com closed by remote host.n::_sort_chunks()
Connection to xgrelay.sys.xiaojukeji.com closed.ChunksSorterTopn::do_done()
client_loop: send disconnect: Broken piperized::ChunksSorter::done()
$ @ 0x3075680 starrocks::pipeline::PartitionSortSinkOperator::set_finishing()
@ 0x2d9ed49 starrocks::pipeline::PipelineDriver::_mark_operator_finishing()
@ 0x2da0106 starrocks::pipeline::PipelineDriver::process()
@ 0x518f92a starrocks::pipeline::GlobalDriverExecutor::_worker_thread()
@ 0x4b59b92 starrocks::ThreadPool::dispatch_thread()
@ 0x4b5462a starrocks::thread::supervise_thread()
@ 0x7f4b90f04ea5 start_thread
@ 0x7f4b9051fb0d __clone
@ 0x0 (unknown)

FE报错日志:
2025-12-23 16:49:00,526 WARN (starrocks-mysql-nio-pool-120326|4673482) [Coordinator.deliverExecBatchFragmentsRequests():1256] catch a execute exception
java.util.concurrent.ExecutionException: A error occurred: errorCode=62 errorMessage:method request time out, please check ‘onceTalkTimeout’ property. current value is:60000(MILLISECONDS) correlationId:196906350 timeout with bound channel =>[id: 0xada2d68e, L:/10.15.39.30:17930 - R:/10.15.115.39:16008]
at com.baidu.jprotobuf.pbrpc.client.ProtobufRpcProxy$2.get(ProtobufRpcProxy.java:578) ~[jprotobuf-rpc-core-4.2.1.jar:?]
at com.starrocks.qe.Coordinator.deliverExecBatchFragmentsRequests(Coordinator.java:1250) ~[starrocks-fe.jar:?]
at com.starrocks.qe.Coordinator.deliverExecFragments(Coordinator.java:787) ~[starrocks-fe.jar:?]
at com.starrocks.qe.Coordinator.exec(Coordinator.java:690) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.handleQueryStmt(StmtExecutor.java:797) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:474) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:337) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:454) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:712) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:55) ~[starrocks-fe.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[?:?]
at java.lang.Thread.run(Thread.java:829) ~[?:?]
Caused by: com.baidu.jprotobuf.pbrpc.ErrorDataException: A error occurred: errorCode=62 errorMessage:method request time out, please check ‘onceTalkTimeout’ property. current value is:60000(MILLISECONDS) correlationId:196906350 timeout with bound channel =>[id: 0xada2d68e, L:/10.15.39.30:17930 - R:/10.15.115.39:16008]
at com.baidu.jprotobuf.pbrpc.client.ProtobufRpcProxy.doWaitCallback(ProtobufRpcProxy.java:651) ~[jprotobuf-rpc-core-4.2.1.jar:?]
at com.baidu.jprotobuf.pbrpc.client.ProtobufRpcProxy.access$0(ProtobufRpcProxy.java:611) ~[jprotobuf-rpc-core-4.2.1.jar:?]
at com.baidu.jprotobuf.pbrpc.client.ProtobufRpcProxy$2.get(ProtobufRpcProxy.java:576) ~[jprotobuf-rpc-core-4.2.1.jar:?]
… 12 more