使用insert overwrite 插入数据出现 SQL 错误 [5025] [HY000]: Internal error: vector::_M_range_insert: BE:10002 错误

💬 StarRocks 用户问答
#1

为了更快的定位您的问题，请提供以下信息，谢谢
【详述】问题详细描述
执行INSERT OVERWRITE xxxx SELECT XXX 出现错误如下，单独执行SELECT XXX 能够返回正确结果：
SQL 错误 [5025] [HY000]: Internal error: vector::_M_range_insert: BE:10002 错误

【背景】做过哪些操作？
执行了 INSERT OVERWRITE xxxx SELECT XXX
【业务影响】
报错，但是fe和be节点均没有崩溃。

【是否存算分离】
否
【StarRocks版本】3.4.1-2f78e09
【集群规模】1fe+1be（fe与be混部在同一台机器）
【机器信息】16C/64G/万兆
【联系方式】liutaoxwl@qq.com
【附件】

  • fe.log/beINFO/相应截图

引用
fe.log:

2025-03-30 00:55:04.034+08:00 INFO (starrocks-mysql-nio-pool-13|2550) [LocalMetastore.buildPartitions():1789] start to build 1 partitions sequentially for table bigdata.301_dwd_tb_insp_alltask_trans with 2 replicas
2025-03-30 00:55:04.034+08:00 INFO (starrocks-mysql-nio-pool-13|2550) [TabletTaskExecutor.buildCreateReplicaTasks():216] build create replica tasks for index index id: 41521; index state: NORMAL; shardGroupId: -1; row count: 0; tablets size: 2; visibleTxnId: 0; tablets: [tablet: id=42310, tablet: id=42312, ]; db 10173 table 41520 partition partitionId: 42309; partitionName: $shadow_automatic_partition_42307_42309; parentPartitionId: 42308; shardGroupId: -1; isImmutable: false; baseIndex: index id: 41521; index state: NORMAL; shardGroupId: -1; row count: 0; tablets size: 2; visibleTxnId: 0; tablets: [tablet: id=42310, tablet: id=42312, ]; ; rollupCount: 0; visibleVersion: 1; visibleVersionTime: 1743267304034; committedVersion: 1; dataVersion: 1; committedDataVersion: 1; versionEpoch: 346932912395911168; versionTxnType: TXN_NORMAL; storageDataSize: 0; storageRowCount: 0; storageReplicaCount: 2;
2025-03-30 00:55:04.034+08:00 INFO (starrocks-mysql-nio-pool-13|2550) [TabletTaskExecutor.buildPartitionsSequentially():104] build partitions sequentially, send task one by one, all tasks timeout 20s
2025-03-30 00:55:04.038+08:00 INFO (starrocks-mysql-nio-pool-13|2550) [TabletTaskExecutor.buildPartitionsSequentially():107] build partitions sequentially, all tasks finished, took 4ms
2025-03-30 00:55:04.053+08:00 INFO (starrocks-mysql-nio-pool-13|2550) [DatabaseTransactionMgr.beginTransaction():189] begin transaction: txn_id: 19418 with label insert_8df3a599-0cbe-11f0-9bd5-1ac9333e1291 from coordinator FE: 192.168.119.4, listner id: -1
2025-03-30 00:55:05.115+08:00 INFO (colocate group clone checker|123) [ColocateTableBalancer.matchGroups():939] finished to match colocate group. cost: 0 ms, in lock time: 0 ms
2025-03-30 00:55:06.123+08:00 INFO (starrocks-mysql-nio-pool-13|2550) [TxnStateCallbackFactory.addCallback():40] add callback of txn state : 42314. current callback size: 1
2025-03-30 00:55:06.143+08:00 INFO (starrocks-mysql-nio-pool-13|2550) [DefaultCoordinator.prepareProfile():620] dispatch load job: 8df3a599-0cbe-11f0-9bd5-1ac9333e1291 to [10002]
2025-03-30 00:55:07.186+08:00 WARN (thrift-server-pool-1798|2568) [DefaultCoordinator.lambda$updateFragmentExecStatus$9():1094] exec state report failed status=errorCode INTERNAL_ERROR Internal error: vector::_M_range_insert: BE:10002, query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1445, backend_id=10002
2025-03-30 00:55:07.186+08:00 WARN (thrift-server-pool-1798|2568) [DefaultCoordinator.updateStatus():873] one instance report fail throw updateStatus(), need cancel. job id: 42314, query id: 8df3a599-0cbe-11f0-9bd5-1ac9333e1291, instance id: 8df3a599-0cbe-11f0-9bd5-1ac9333e1445
2025-03-30 00:55:07.188+08:00 WARN (starrocks-mysql-nio-pool-13|2550) [StmtExecutor.handleDMLStmt():2463] insert failed: Internal error: vector::_M_range_insert: BE:10002
2025-03-30 00:55:07.188+08:00 INFO (tablet scheduler|44) [ClusterLoadStatistic.classifyBackendByLoad():163] classify backend by load. medium: HDD, avg load score: 1.0, low/mid/high: 0/1/0
2025-03-30 00:55:07.188+08:00 WARN (starrocks-mysql-nio-pool-13|2550) [StmtExecutor.handleDMLStmt():2645] failed to handle stmt [/* ApplicationName=DBeaver 24.3.5 - SQLEditor <Script-8.sql> */ /^M
*
/^M
INSERT OVERWRITE bigdata.301_dwd_tb_insp_alltask_trans ^M
SELECT^M
/+ SET_VAR^M
(^M
query_timeout = 3600, ^M
group_concat_max_len = 1048576^M
)^M
/^M
DWD.inspTaskGId,^M
…
FROM^M
bigdata.301_drl_v_insp_alltask_bu_rt_std DWD^M
WHERE DWD.dt<=DATE(‘2025-03-28’)^M
] label: insert_8df3a599-0cbe-11f0-9bd5-1ac9333e1291
com.starrocks.common.DdlException: Internal error: vector::_M_range_insert: BE:10002
at com.starrocks.common.ErrorReport.reportDdlException(ErrorReport.java:90) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.handleDMLStmt(StmtExecutor.java:2464) ~[starrocks-fe.jar:?]
at com.starrocks.load.InsertOverwriteJobRunner.executeInsert(InsertOverwriteJobRunner.java:360) ~[starrocks-fe.jar:?]
at com.starrocks.load.InsertOverwriteJobRunner.doLoad(InsertOverwriteJobRunner.java:169) ~[starrocks-fe.jar:?]
at com.starrocks.load.InsertOverwriteJobRunner.handle(InsertOverwriteJobRunner.java:149) ~[starrocks-fe.jar:?]
at com.starrocks.load.InsertOverwriteJobRunner.transferTo(InsertOverwriteJobRunner.java:212) ~[starrocks-fe.jar:?]
at com.starrocks.load.InsertOverwriteJobRunner.prepare(InsertOverwriteJobRunner.java:256) ~[starrocks-fe.jar:?]
at com.starrocks.load.InsertOverwriteJobRunner.handle(InsertOverwriteJobRunner.java:146) ~[starrocks-fe.jar:?]
at com.starrocks.load.InsertOverwriteJobRunner.run(InsertOverwriteJobRunner.java:134) ~[starrocks-fe.jar:?]
at com.starrocks.load.InsertOverwriteJobMgr.executeJob(InsertOverwriteJobMgr.java:91) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.handleInsertOverwrite(StmtExecutor.java:2214) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.handleDMLStmt(StmtExecutor.java:2309) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.handleDMLStmtWithProfile(StmtExecutor.java:2223) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:748) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:372) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:572) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:910) ~[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:1128) ~[?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[?:?]
at java.lang.Thread.run(Thread.java:834) ~[?:?]
2025-03-30 00:55:07.191+08:00 WARN (thrift-server-pool-1797|2567) [DefaultCoordinator.lambda$updateFragmentExecStatus$9():1094] exec state report failed status=errorCode INTERNAL_ERROR Internal error: vector::_M_range_insert: BE:10002, query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1441, backend_id=10002
2025-03-30 00:55:07.191+08:00 WARN (thrift-server-pool-1793|2563) [DefaultCoordinator.lambda$updateFragmentExecStatus$9():1094] exec state report failed status=errorCode INTERNAL_ERROR Internal error: vector::_M_range_insert: BE:10002, query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1444, backend_id=10002
2025-03-30 00:55:07.191+08:00 WARN (thrift-server-pool-1794|2564) [DefaultCoordinator.lambda$updateFragmentExecStatus$9():1094] exec state report failed status=errorCode INTERNAL_ERROR Internal error: vector::_M_range_insert: BE:10002, query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1447, backend_id=10002
2025-03-30 00:55:07.192+08:00 WARN (thrift-server-pool-1792|2562) [DefaultCoordinator.lambda$updateFragmentExecStatus$9():1094] exec state report failed status=errorCode INTERNAL_ERROR Internal error: vector::_M_range_insert: BE:10002, query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1442, backend_id=10002
2025-03-30 00:55:07.193+08:00 WARN (thrift-server-pool-1795|2565) [DefaultCoordinator.lambda$updateFragmentExecStatus$9():1094] exec state report failed status=errorCode INTERNAL_ERROR Internal error: vector::_M_range_insert: BE:10002, query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e143f, backend_id=10002
2025-03-30 00:55:07.193+08:00 WARN (thrift-server-pool-1796|2566) [DefaultCoordinator.lambda$updateFragmentExecStatus$9():1094] exec state report failed status=errorCode INTERNAL_ERROR Internal error: vector::_M_range_insert: BE:10002, query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e143b, backend_id=10002
2025-03-30 00:55:07.194+08:00 WARN (thrift-server-pool-1798|2568) [DefaultCoordinator.lambda$updateFragmentExecStatus$9():1094] exec state report failed status=errorCode INTERNAL_ERROR Internal error: vector::_M_range_insert: BE:10002, query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e143e, backend_id=10002
2025-03-30 00:55:07.194+08:00 WARN (thrift-server-pool-1799|2569) [DefaultCoordinator.lambda$updateFragmentExecStatus$9():1094] exec state report failed status=errorCode INTERNAL_ERROR Internal error: vector::_M_range_insert: BE:10002, query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e143a, backend_id=10002
2025-03-30 00:55:07.205+08:00 INFO (starrocks-mysql-nio-pool-13|2550) [DatabaseTransactionMgr.abortTransaction():572] transaction:[TransactionState. txn_id: 19418, label: insert_8df3a599-0cbe-11f0-9bd5-1ac9333e1291, db id: 10173, table id list: 41520, callback id: 42314, coordinator: FE: 192.168.119.4, transaction status: ABORTED, error replicas num: 0, replica ids: , prepare time: 1743267304054, write end time: -1, allow commit time: -1, commit time: -1, finish time: 1743267307189, total cost: 3135ms, reason: Internal error: vector::_M_range_insert: BE:10002, partition commit info:[]] successfully rollback
2025-03-30 00:55:07.206+08:00 INFO (starrocks-mysql-nio-pool-13|2550) [TxnStateCallbackFactory.removeCallback():47] remove callback of txn state : 42314. current callback size: 0
2025-03-30 00:55:07.207+08:00 WARN (thrift-server-pool-1797|2567) [DefaultCoordinator.lambda$updateFragmentExecStatus$9():1094] exec state report failed status=errorCode INTERNAL_ERROR Internal error: vector::_M_range_insert: BE:10002, query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1292, backend_id=10002
2025-03-30 00:55:07.221+08:00 INFO (starrocks-mysql-nio-pool-13|2550) [InsertOverwriteJobRunner.gc():394] insert overwrite job 42307 start to garbage collect
2025-03-30 00:55:07.221+08:00 INFO (starrocks-mysql-nio-pool-13|2550) [InsertOverwriteJobRunner.gc():415] drop temp partition:42308
2025-03-30 00:55:07.237+08:00 WARN (starrocks-mysql-nio-pool-13|2550) [InsertOverwriteJobRunner.handle():153] insert overwrite job:42307 failed. createPartitionElapse:20 ms, insertElapse:0 ms
2025-03-30 00:55:07.237+08:00 WARN (starrocks-mysql-nio-pool-13|2550) [StmtExecutor.handleDMLStmtWithProfile():2225] DML statement(/ ApplicationName=DBeaver 24.3.5 - SQLEditor <Script-8.sql> */ /^M
/^M
INSERT OVERWRITE bigdata.301_dwd_tb_insp_alltask_trans ^M
^M
SELECT^M
/+ SET_VAR^M
(^M
query_timeout = 3600, ^M
group_concat_max_len = 1048576^M
)^M
*/^M
…
FROM^M
bigdata.301_drl_v_insp_alltask_bu_rt_std DWD^M
WHERE DWD.dt<=DATE(‘2025-03-28’)^M
) process failed.
com.starrocks.common.UserException: Internal error: vector::_M_range_insert: BE:10002
at com.starrocks.qe.StmtExecutor.handleDMLStmt(StmtExecutor.java:2693) ~[starrocks-fe.jar:?]
at com.starrocks.load.InsertOverwriteJobRunner.executeInsert(InsertOverwriteJobRunner.java:360) ~[starrocks-fe.jar:?]
at com.starrocks.load.InsertOverwriteJobRunner.doLoad(InsertOverwriteJobRunner.java:169) ~[starrocks-fe.jar:?]
at com.starrocks.load.InsertOverwriteJobRunner.handle(InsertOverwriteJobRunner.java:149) ~[starrocks-fe.jar:?]
at com.starrocks.load.InsertOverwriteJobRunner.transferTo(InsertOverwriteJobRunner.java:212) ~[starrocks-fe.jar:?]
at com.starrocks.load.InsertOverwriteJobRunner.prepare(InsertOverwriteJobRunner.java:256) ~[starrocks-fe.jar:?]
at com.starrocks.load.InsertOverwriteJobRunner.handle(InsertOverwriteJobRunner.java:146) ~[starrocks-fe.jar:?]
at com.starrocks.load.InsertOverwriteJobRunner.run(InsertOverwriteJobRunner.java:134) ~[starrocks-fe.jar:?]
at com.starrocks.load.InsertOverwriteJobMgr.executeJob(InsertOverwriteJobMgr.java:91) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.handleInsertOverwrite(StmtExecutor.java:2214) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.handleDMLStmt(StmtExecutor.java:2309) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.handleDMLStmtWithProfile(StmtExecutor.java:2223) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:748) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:372) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:572) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:910) ~[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:1128) ~[?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[?:?]
at java.lang.Thread.run(Thread.java:834) ~[?:?]
Caused by: com.starrocks.common.DdlException: Internal error: vector::_M_range_insert: BE:10002
at com.starrocks.common.ErrorReport.reportDdlException(ErrorReport.java:90) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.handleDMLStmt(StmtExecutor.java:2464) ~[starrocks-fe.jar:?]
… 19 more
2025-03-30 00:55:07.238+08:00 INFO (starrocks-mysql-nio-pool-13|2550) [StmtExecutor.execute():806] execute Exception, sql:
…
FROM^M
bigdata.301_drl_v_insp_alltask_bu_rt_std DWD^M
WHERE DWD.dt<=DATE(‘2025-03-28’)^M
, error: Internal error: vector::_M_range_insert: BE:10002
2025-03-30 00:55:07.598+08:00 INFO (tablet checker|45) [TabletChecker.doCheck():384] finished to check tablets. isUrgent: true, unhealthy/total/added/in_sched/not_ready: 0/0/0/0/0, cost: 0 ms, in lock time: 0 ms, wait time: 0ms
2025-03-30 00:55:07.602+08:00 INFO (tablet checker|45) [TabletChecker.doCheck():384] finished to check tablets. isUrgent: false, unhealthy/total/added/in_sched/not_ready: 0/5281/0/0/0, cost: 4 ms, in lock time: 4 ms, wait time: 0ms
2025-03-30 00:55:07.602+08:00 INFO (tablet checker|45) [TabletChecker.runAfterCatalogReady():221] TStat :
TStat num of tablet check round: 420 (+1)
TStat cost of tablet check(ms): 2079 (+4)
TStat num of tablet checked in tablet checker: 1890768 (+5281)
TStat num of unhealthy tablet checked in tablet checker: 0 (+0)
TStat num of tablet being added to tablet scheduler: 0 (+0)
TStat num of tablet schedule round: 8381 (+20)
TStat cost of tablet schedule(ms): 303 (+0)
TStat num of tablet being scheduled: 0 (+0)
TStat num of tablet being scheduled succeeded: 0 (+0)
TStat num of tablet being scheduled failed: 0 (+0)
TStat num of tablet being scheduled discard: 0 (+0)
TStat num of tablet priority upgraded: 0 (+0)
TStat num of clone task: 0 (+0)
TStat num of clone task succeeded: 0 (+0)
TStat num of clone task failed: 0 (+0)
TStat num of clone task timeout: 0 (+0)
TStat num of replica missing error: 0 (+0)
TStat num of replica version missing error: 0 (+0)
TStat num of replica unavailable error: 0 (+0)
TStat num of replica location mismatch error: 0 (+0)
TStat num of replica redundant error: 0 (+0)
TStat num of replica missing in cluster error: 0 (+0)
TStat num of balance scheduled: 0 (+0)
TStat num of colocate replica mismatch: 0 (+0)
TStat num of colocate replica redundant: 0 (+0)
TStat num of colocate balancer running round: 0 (+0)
2025-03-30 00:55:12.816+08:00 INFO (Load history syncer|48) [DatabaseTransactionMgr.beginTransaction():189] begin transaction: txn_id: 19419 with label insert_94cb3423-0cbe-11f0-9bd5-1ac9333e1291 from coordinator FE: 192.168.119.4, listner id: -1
2025-03-30 00:55:12.830+08:00 INFO (Load history syncer|48) [TxnStateCallbackFactory.addCallback():40] add callback of txn state : 42315. current callback size: 1
2025-03-30 00:55:12.841+08:00 INFO (Load history syncer|48) [DefaultCoordinator.prepareProfile():620] dispatch load job: 94cb3423-0cbe-11f0-9bd5-1ac9333e1291 to [10002]
2025-03-30 00:55:14.155+08:00 INFO (Load history syncer|48) [DatabaseTransactionMgr.commitPreparedTransaction():482] transaction:[TransactionState. txn_id: 19419, label: insert_94cb3423-0cbe-11f0-9bd5-1ac9333e1291, db id: 10001, table id list: 10164, callback id: 42315, coordinator: FE: 192.168.119.4, transaction status: COMMITTED, error replicas num: 0, replica ids: , prepare time: 1743267312816, write end time: 1743267314147, allow commit time: -1, commit time: 1743267314148, finish time: -1, write cost: 1332ms, reason: , attachment: com.starrocks.transaction.InsertTxnCommitAttachment@2d4a94cd, tabletCommitInfos size: 3, partition commit info:[partitionId=40171, version=50, versionTime=1743267314148, isDoubleWrite=false,]] successfully committed

be.INFO如下：

I20250330 00:55:06.793288 139866425833216 compaction_task.cpp:147] compaction finish. status:OK, task info:[CompactionTaskInfo] task_id:474, tablet_id:10007, compaction score:24.9981, algorithm:VERTICAL_COMPACTION, state:COMPACTION_SUCCESS, compaction_type:base, output_version:[0-365], gtid:346932910873378816, start_time:2025-03-30 00:55:06.761, end_time:2025-03-30 00:55:06.793, elapsed_time:31484 us, input_rowsets_size:5307, input_segments_num:2, input_rowsets_num:6, input_rows_num:4, output_num_rows:3, merged_rows:1, filtered_rows:0, output_segments_num:1, output_rowset_size:2651, column_group_size:3, total_output_num_rows:9, total_merged_rows:3, total_del_filtered_rows:0, is_shortcut_compaction:0, is_manual_compaction:0, progress:100
I20250330 00:55:06.793717 139869492647680 compaction_task.cpp:147] compaction finish. status:OK, task info:[CompactionTaskInfo] task_id:473, tablet_id:10025, compaction score:37, algorithm:VERTICAL_COMPACTION, state:COMPACTION_SUCCESS, compaction_type:base, output_version:[0-365], gtid:346932910873378816, start_time:2025-03-30 00:55:06.755, end_time:2025-03-30 00:55:06.793, elapsed_time:37954 us, input_rowsets_size:15780, input_segments_num:7, input_rowsets_num:14, input_rows_num:12, output_num_rows:6, merged_rows:6, filtered_rows:0, output_segments_num:1, output_rowset_size:2445, column_group_size:3, total_output_num_rows:18, total_merged_rows:18, total_del_filtered_rows:0, is_shortcut_compaction:0, is_manual_compaction:0, progress:100
I20250330 00:55:06.798813 139866425833216 compaction_task.cpp:147] compaction finish. status:OK, task info:[CompactionTaskInfo] task_id:475, tablet_id:10009, compaction score:24.0023, algorithm:HORIZONTAL_COMPACTION, state:COMPACTION_SUCCESS, compaction_type:base, output_version:[0-365], gtid:346932910873378816, start_time:2025-03-30 00:55:06.793, end_time:2025-03-30 00:55:06.798, elapsed_time:5369 us, input_rowsets_size:2205, input_segments_num:1, input_rowsets_num:6, input_rows_num:1, output_num_rows:1, merged_rows:0, filtered_rows:0, output_segments_num:1, output_rowset_size:2205, column_group_size:0, total_output_num_rows:0, total_merged_rows:0, total_del_filtered_rows:0, is_shortcut_compaction:1, is_manual_compaction:0, progress:100
W20250330 00:55:07.183669 139871541942016 stack_util.cpp:347] 2025-03-30 00:55:07.183614, query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, fragment_instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1426 throws exception: std::length_error, trace:
@ 0x3e09237 __wrap___cxa_throw
@ 0x381edae std::__throw_length_error(char const*)
@ 0x326fa32 void std::vector<unsigned char, starrocks::raw::RawAllocator<unsigned char, 16ul, starrocks::ColumnAllocator > >::_M_range_insert<unsigned char const*>(__gnu_cxx::normal_iterator<unsigned char*, std::vector<unsigned char, starrocks::raw::R@
@ 0x45b3d12 starrocks::BinaryColumnBase::append(starrocks::Column const&, unsigned long, unsigned long)
@ 0x45a34de starrocks::NullableColumn::append(starrocks::Column const&, unsigned long, unsigned long)
@ 0x475e7c7 starrocks::JoinHashTable::append_chunk(std::shared_ptrstarrocks::Chunk const&, std::vector<std::shared_ptrstarrocks::Column, std::allocator<std::shared_ptrstarrocks::Column > > const&)
@ 0x4da4a82 starrocks::SingleHashJoinBuilder::do_append_chunk(std::shared_ptrstarrocks::Chunk const&)
@ 0x4d99434 starrocks::AdaptivePartitionHashJoinBuilder::append_chunk_to_partitions(std::shared_ptrstarrocks::Chunk const&)
@ 0x4da4d40 starrocks::AdaptivePartitionHashJoinBuilder::do_append_chunk(std::shared_ptrstarrocks::Chunk const&)
@ 0x4d900bc starrocks::HashJoiner::append_chunk_to_ht(std::shared_ptrstarrocks::Chunk const&)
@ 0x4b6565b starrocks::pipeline::HashJoinBuildOperator::push_chunk(starrocks::RuntimeState*, std::shared_ptrstarrocks::Chunk const&)
@ 0x4b1c454 starrocks::pipeline::PipelineDriver::process(starrocks::RuntimeState*, int)
@ 0x4e5508f starrocks::pipeline::GlobalDriverExecutor::worker_thread()
@ 0x3e2c0ff starrocks::ThreadPool::dispatch_thread()
@ 0x3e22780 starrocks::thread::supervise_thread(void*)
@ 0x7f36e5091fed (/usr/lib64/libpthread-2.28.so+0x8fec)
@ 0x7f36e3b9d18f clone
W20250330 00:55:07.183994 139871541942016 pipeline_driver_executor.cpp:177] [Driver] Process error, query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1426, status=Internal error: Internal error: vector::M_range_insert: BE:10002
W20250330 00:55:07.185937 139871634261760 pipeline_driver.cpp:571] cancel pipeline driver error [driver=query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291 fragment_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1292 driver=driver_148_76, status=PRECONDITION_BLOCK(dependencies,), operator-chain: [exchange_source_148_0x7f3592da8910(O) -> chunk_accumulate_148_0x7f3592db5c10(X) -> hash_join_probe_160_0x7f3592da8b90(X)(HashJoiner=0x7f3592d8e990) -> chunk_accumulate_160_0x7f3592db7110(X) -> project_161_0x7f3592db7d10(X) -> hash_join_probe_169_0x7f3592da8e10(X)(HashJoiner=0x7f3592d8b790) -> project_170_0x7f3592db9210(X) -> hash_join_probe_174_0x7f3592da9310(X)(HashJoiner=0x7f3592da9090) -> project_175_0x7f3592dba710(X) -> hash_join_probe_234_0x7f3592da9810(X)(HashJoiner=0x7f3592da9590) -> project_235_0x7f3592dbbc10(X) -> hash_join_probe_731_0x7f3592da9d10(X)(HashJoiner=0x7f3592da9a90) -> project_732_0x7f3592dbd110(X) -> hash_join_probe_756_0x7f3592daa210(X)(HashJoiner=0x7f3592da9f90) -> project_757_0x7f3592dbf610(X) -> hash_join_probe_1216_0x7f3592daa710(X)(HashJoiner=0x7f3592daa490) -> project_1217_0x7f3592dc0b10(X) -> hash_join_probe_1438_0x7f3592daac10(X)(HashJoiner=0x7f3592daa990) -> chunk_accumulate_1438_0x7f3592dc2010(X) -> project_1439_0x7f3592dc2c10(X) -> hash_join_probe_1446_0x7f3592dab110(X)(HashJoiner=0x7f3592daae90) -> project_1447_0x7f3592dc4110(X) -> hash_join_probe_1689_0x7f3592dab610(X)(HashJoiner=0x7f3592dab390) -> project_1690_0x7f3592dc5610(X) -> hash_join_probe_1760_0x7f3592dabb10(X)(HashJoiner=0x7f3592dab890) -> project_1761_0x7f3592dc6b10(X) -> hash_join_probe_1773_0x7f3592dc8010(X)(HashJoiner=0x7f3592dabd90) -> project_1774_0x7f3592dcd010(X) -> table_function_1775_0x7f35941b2510(X) -> select_1776_0x7f3592dce510(X) -> project_1777_0x7f3592dcf110(X) -> hash_join_probe_1855_0x7f3592dc8510(X)(HashJoiner=0x7f3592dc8290) -> chunk_accumulate_1855_0x7f3592dd0610(X) -> project_1856_0x7f3592dd1210(X) -> olap_table_sink-1_0x7f3592dd1e10(X)]]: Cancelled: Cancelled by pipeline engine
I20250330 00:55:07.186004 139869643716352 local_tablets_channel.cpp:769] cancel LocalTabletsChannel txn_id: 19418 load_id: 8df3a5990cbe11f0-9bd51ac9333e1291 index_id: 41521 #tablet:2 tablet_ids:42312,42310
W20250330 00:55:07.186365 139871634261760 tablet_sink_sender.cpp:250] close channel failed. channel_name=NodeChannel[10002], load_info=load_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, txn_id: 19418, parallel=1, compress_type=2, error_msg=Cancelled by pipeline engine
W20250330 00:55:07.186577 139871634261760 pipeline_driver.cpp:571] cancel pipeline driver error [driver=query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291 fragment_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1292 driver=driver_148_77, status=PRECONDITION_BLOCK(dependencies,), operator-chain: [exchange_source_148_0x7f3592dc8f10(O) -> chunk_accumulate_148_0x7f3592dd3610(X) -> hash_join_probe_160_0x7f3592dc9190(X)(HashJoiner=0x7f3592d8f390) -> chunk_accumulate_160_0x7f3592dd4b10(X) -> project_161_0x7f3592dd5710(X) -> hash_join_probe_169_0x7f3592dc9410(X)(HashJoiner=0x7f3592d8c190) -> project_170_0x7f3592dd6c10(X) -> hash_join_probe_174_0x7f3592dc9910(X)(HashJoiner=0x7f3592dc9690) -> project_175_0x7f3592dd8110(X) -> hash_join_probe_234_0x7f3592dc9e10(X)(HashJoiner=0x7f3592dc9b90) -> project_235_0x7f3592dd9610(X) -> hash_join_probe_731_0x7f3592dca310(X)(HashJoiner=0x7f3592dca090) -> project_732_0x7f3592ddab10(X) -> hash_join_probe_756_0x7f3592dca810(X)(HashJoiner=0x7f3592dca590) -> project_757_0x7f3592de1010(X) -> hash_join_probe_1216_0x7f3592dcad10(X)(HashJoiner=0x7f3592dcaa90) -> project_1217_0x7f3592de2510(X) -> hash_join_probe_1438_0x7f3592dcb210(X)(HashJoiner=0x7f3592dcaf90) -> chunk_accumulate_1438_0x7f3592de3a10(X) -> project_1439_0x7f3592de4610(X) -> hash_join_probe_1446_0x7f3592dcb710(X)(HashJoiner=0x7f3592dcb490) -> project_1447_0x7f3592de5b10(X) -> hash_join_probe_1689_0x7f3592dcbc10(X)(HashJoiner=0x7f3592dcb990) -> project_1690_0x7f3592de7010(X) -> hash_join_probe_1760_0x7f3592dcc110(X)(HashJoiner=0x7f3592dcbe90) -> project_1761_0x7f3592de8510(X) -> hash_join_probe_1773_0x7f3592dcc610(X)(HashJoiner=0x7f3592dcc390) -> project_1774_0x7f3592de9a10(X) -> table_function_1775_0x7f35941b2f90(X) -> select_1776_0x7f3592deaf10(X) -> project_1777_0x7f3592debb10(X) -> hash_join_probe_1855_0x7f3592dccb10(X)(HashJoiner=0x7f3592dcc890) -> chunk_accumulate_1855_0x7f3592df2010(X) -> project_1856_0x7f3592df2c10(X) -> olap_table_sink-1_0x7f3592df3810(X)]]: Cancelled: Cancelled by pipeline engine
W20250330 00:55:07.186641 139871634261760 tablet_sink_sender.cpp:250] close channel failed. channel_name=NodeChannel[10002], load_info=load_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, txn_id: 19418, parallel=1, compress_type=2, error_msg=Cancelled by pipeline engine
W20250330 00:55:07.186819 139871634261760 pipeline_driver.cpp:571] cancel pipeline driver error [driver=query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291 fragment_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1292 driver=driver_148_78, status=PRECONDITION_BLOCK(dependencies,), operator-chain: [exchange_source_148_0x7f3592ded510(O) -> chunk_accumulate_148_0x7f3592df5010(X) -> hash_join_probe_160_0x7f3592ded790(X)(HashJoiner=0x7f3592d8fd90) -> chunk_accumulate_160_0x7f3592df6510(X) -> project_161_0x7f3592df7110(X) -> hash_join_probe_169_0x7f3592deda10(X)(HashJoiner=0x7f3592d8cb90) -> project_170_0x7f3592df8610(X) -> hash_join_probe_174_0x7f3592dedf10(X)(HashJoiner=0x7f3592dedc90) -> project_175_0x7f3592df9b10(X) -> hash_join_probe_234_0x7f3592dee410(X)(HashJoiner=0x7f3592dee190) -> project_235_0x7f3592dfb010(X) -> hash_join_probe_731_0x7f3592dee910(X)(HashJoiner=0x7f3592dee690) -> project_732_0x7f3592dfc510(X) -> hash_join_probe_756_0x7f3592deee10(X)(HashJoiner=0x7f3592deeb90) -> project_757_0x7f3592dfda10(X) -> hash_join_probe_1216_0x7f3592def310(X)(HashJoiner=0x7f3592def090) -> project_1217_0x7f3592dfef10(X) -> hash_join_probe_1438_0x7f3592def810(X)(HashJoiner=0x7f3592def590) -> chunk_accumulate_1438_0x7f3592e00410(X) -> project_1439_0x7f3592e01010(X) -> hash_join_probe_1446_0x7f3592defd10(X)(HashJoiner=0x7f3592defa90) -> project_1447_0x7f3592e02510(X) -> hash_join_probe_1689_0x7f3592df0210(X)(HashJoiner=0x7f3592deff90) -> project_1690_0x7f3592e03a10(X) -> hash_join_probe_1760_0x7f3592df0710(X)(HashJoiner=0x7f3592df0490) -> project_1761_0x7f3592e04f10(X) -> hash_join_probe_1773_0x7f3592df0c10(X)(HashJoiner=0x7f3592df0990) -> project_1774_0x7f3592e06410(X) -> table_function_1775_0x7f35941b3310(X) -> select_1776_0x7f3592e07910(X) -> project_1777_0x7f3592e08510(X) -> hash_join_probe_1855_0x7f3592df1110(X)(HashJoiner=0x7f3592df0e90) -> chunk_accumulate_1855_0x7f3592e09a10(X) -> project_1856_0x7f3592e0a610(X) -> olap_table_sink-1_0x7f3592e0b210(X)]]: Cancelled: Cancelled by pipeline engine
W20250330 00:55:07.186883 139871634261760 tablet_sink_sender.cpp:250] close channel failed. channel_name=NodeChannel[10002], load_info=load_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, txn_id: 19418, parallel=1, compress_type=2, error_msg=Cancelled by pipeline engine
W20250330 00:55:07.187053 139871634261760 pipeline_driver.cpp:571] cancel pipeline driver error [driver=query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291 fragment_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1292 driver=driver_148_79, status=PRECONDITION_BLOCK(dependencies,), operator-chain: [exchange_source_148_0x7f3592df1b10(O) -> chunk_accumulate_148_0x7f3592e0ca10(X) -> hash_join_probe_160_0x7f3592df1d90(X)(HashJoiner=0x7f3592da7790) -> chunk_accumulate_160_0x7f3592e0df10(X) -> project_161_0x7f3592e0eb10(X) -> hash_join_probe_169_0x7f3592e10010(X)(HashJoiner=0x7f3592d8d590) -> project_170_0x7f3592e15010(X) -> hash_join_probe_174_0x7f3592e10510(X)(HashJoiner=0x7f3592e10290) -> project_175_0x7f3592e16510(X) -> hash_join_probe_234_0x7f3592e10a10(X)(HashJoiner=0x7f3592e10790) -> project_235_0x7f3592e17a10(X) -> hash_join_probe_731_0x7f3592e10f10(X)(HashJoiner=0x7f3592e10c90) -> project_732_0x7f3592e18f10(X) -> hash_join_probe_756_0x7f3592e11410(X)(HashJoiner=0x7f3592e11190) -> project_757_0x7f3592e1a410(X) -> hash_join_probe_1216_0x7f3592e11910(X)(HashJoiner=0x7f3592e11690) -> project_1217_0x7f3592e1b910(X) -> hash_join_probe_1438_0x7f3592e11e10(X)(HashJoiner=0x7f3592e11b90) -> chunk_accumulate_1438_0x7f3592e1ce10(X) -> project_1439_0x7f3592e1da10(X) -> hash_join_probe_1446_0x7f3592e12310(X)(HashJoiner=0x7f3592e12090) -> project_1447_0x7f3592e30f10(X) -> hash_join_probe_1689_0x7f3592e12810(X)(HashJoiner=0x7f3592e12590) -> project_1690_0x7f3592e32410(X) -> hash_join_probe_1760_0x7f3592e12d10(X)(HashJoiner=0x7f3592e12a90) -> project_1761_0x7f3592e33910(X) -> hash_join_probe_1773_0x7f3592e13210(X)(HashJoiner=0x7f3592e12f90) -> project_1774_0x7f3592e34e10(X) -> table_function_1775_0x7f35941b3690(X) -> select_1776_0x7f3592e36310(X) -> project_1777_0x7f3592e36f10(X) -> hash_join_probe_1855_0x7f3592e13710(X)(HashJoiner=0x7f3592e13490) -> chunk_accumulate_1855_0x7f3592e38410(X) -> project_1856_0x7f3592e39010(X) -> olap_table_sink-1_0x7f3592e39c10(X)]]: Cancelled: Cancelled by pipeline engine
W20250330 00:55:07.187118 139871634261760 tablet_sink_sender.cpp:250] close channel failed. channel_name=NodeChannel[10002], load_info=load_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, txn_id: 19418, parallel=1, compress_type=2, error_msg=Cancelled by pipeline engine
I20250330 00:55:07.187460 139871776937728 internal_service.cpp:530] cancel fragment, fragment_instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1292, reason: InternalError
I20250330 00:55:07.187473 139871886042880 internal_service.cpp:530] cancel fragment, fragment_instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e143a, reason: InternalError
I20250330 00:55:07.187606 139871802115840 internal_service.cpp:530] cancel fragment, fragment_instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e143b, reason: InternalError
I20250330 00:55:07.187480 139871852472064 internal_service.cpp:530] cancel fragment, fragment_instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1426, reason: InternalError
I20250330 00:55:07.187935 139871793723136 internal_service.cpp:530] cancel fragment, fragment_instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e143f, reason: InternalError
I20250330 00:55:07.187959 139871827293952 internal_service.cpp:530] cancel fragment, fragment_instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1441, reason: InternalError
I20250330 00:55:07.188067 139871793723136 internal_service.cpp:530] cancel fragment, fragment_instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1444, reason: InternalError
I20250330 00:55:07.188114 139871793723136 internal_service.cpp:530] cancel fragment, fragment_instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e143e, reason: InternalError
I20250330 00:55:07.188115 139871877650176 internal_service.cpp:530] cancel fragment, fragment_instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1442, reason: InternalError
I20250330 00:55:07.188168 139871793723136 internal_service.cpp:530] cancel fragment, fragment_instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1447, reason: InternalError
I20250330 00:55:07.188272 139871760152320 internal_service.cpp:530] cancel fragment, fragment_instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e145c, reason: InternalError
W20250330 00:55:07.190451 139871634261760 pipeline_driver.cpp:571] cancel pipeline driver error [driver=query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291 fragment_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1292 driver=driver_148_80, status=PRECONDITION_BLOCK(dependencies,), operator-chain: [exchange_source_148_0x7f3592e14110(X) -> chunk_accumulate_148_0x7f3592e3b410(X) -> hash_join_probe_160_0x7f3592e14390(X)(HashJoiner=0x7f3592da8190) -> chunk_accumulate_160_0x7f3592e3c910(X) -> project_161_0x7f3592e3d510(X) -> hash_join_probe_169_0x7f3592e14610(X)(HashJoiner=0x7f3592d8df90) -> project_170_0x7f3592e3ea10(X) -> hash_join_probe_174_0x7f3592e14b10(X)(HashJoiner=0x7f3592e14890) -> project_175_0x7f3592e49f10(X) -> hash_join_probe_234_0x7f3592e44010(X)(HashJoiner=0x7f3592e14d90) -> project_235_0x7f3592e4b410(X) -> hash_join_probe_731_0x7f3592e44510(X)(HashJoiner=0x7f3592e44290) -> project_732_0x7f3592e4c910(X) -> hash_join_probe_756_0x7f3592e44a10(X)(HashJoiner=0x7f3592e44790) -> project_757_0x7f3592e4de10(X) -> hash_join_probe_1216_0x7f3592e44f10(X)(HashJoiner=0x7f3592e44c90) -> project_1217_0x7f3592e4f310(X) -> hash_join_probe_1438_0x7f3592e45410(X)(HashJoiner=0x7f3592e45190) -> chunk_accumulate_1438_0x7f3592e50810(X) -> project_1439_0x7f3592e51410(X) -> hash_join_probe_1446_0x7f3592e45910(X)(HashJoiner=0x7f3592e45690) -> project_1447_0x7f3592e52910(X) -> hash_join_probe_1689_0x7f3592e45e10(X)(HashJoiner=0x7f3592e45b90) -> project_1690_0x7f3592e53e10(X) -> hash_join_probe_1760_0x7f3592e46310(X)(HashJoiner=0x7f3592e46090) -> project_1761_0x7f3592e55310(X) -> hash_join_probe_1773_0x7f3592e46810(X)(HashJoiner=0x7f3592e46590) -> project_1774_0x7f3592e56810(X) -> table_function_1775_0x7f35941b3a10(X) -> select_1776_0x7f3592e57d10(X) -> project_1777_0x7f3592e58910(X) -> hash_join_probe_1855_0x7f3592e46d10(X)(HashJoiner=0x7f3592e46a90) -> chunk_accumulate_1855_0x7f3592e59e10(X) -> project_1856_0x7f3592e5aa10(X) -> olap_table_sink-1_0x7f3592e5b610(X)]]: Cancelled: Cancelled by pipeline engine
W20250330 00:55:07.190552 139871634261760 tablet_sink_sender.cpp:250] close channel failed. channel_name=NodeChannel[10002], load_info=load_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, txn_id: 19418, parallel=1, compress_type=2, error_msg=Cancelled by pipeline engine
W20250330 00:55:07.191596 139871575512832 stack_util.cpp:347] 2025-03-30 00:55:07.191568, query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, fragment_instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1426 throws exception: std::length_error, trace:
@ 0x3e09237 __wrap___cxa_throw
@ 0x381edae std::__throw_length_error(char const*)
@ 0x326fa32 void std::vector<unsigned char, starrocks::raw::RawAllocator<unsigned char, 16ul, starrocks::ColumnAllocator > >::_M_range_insert<unsigned char const*>(__gnu_cxx::__normal_iterator<unsigned char*, std::vector<unsigned char, starrocks::raw::R@
@ 0x45b3d12 starrocks::BinaryColumnBase::append(starrocks::Column const&, unsigned long, unsigned long)
@ 0x45a34de starrocks::NullableColumn::append(starrocks::Column const&, unsigned long, unsigned long)
@ 0x475e7c7 starrocks::JoinHashTable::append_chunk(std::shared_ptrstarrocks::Chunk const&, std::vector<std::shared_ptrstarrocks::Column, std::allocator<std::shared_ptrstarrocks::Column > > const&)
@ 0x4da4a82 starrocks::SingleHashJoinBuilder::do_append_chunk(std::shared_ptrstarrocks::Chunk const&)
@ 0x4d99434 starrocks::AdaptivePartitionHashJoinBuilder::_append_chunk_to_partitions(std::shared_ptrstarrocks::Chunk const&)
@ 0x4da4d40 starrocks::AdaptivePartitionHashJoinBuilder::do_append_chunk(std::shared_ptrstarrocks::Chunk const&)
@ 0x4d900bc starrocks::HashJoiner::append_chunk_to_ht(std::shared_ptrstarrocks::Chunk const&)
@ 0x4b6565b starrocks::pipeline::HashJoinBuildOperator::push_chunk(starrocks::RuntimeState*, std::shared_ptrstarrocks::Chunk const&)
@ 0x4b1c454 starrocks::pipeline::PipelineDriver::process(starrocks::RuntimeState*, int)
@ 0x4e5508f starrocks::pipeline::GlobalDriverExecutor::_worker_thread()
@ 0x3e2c0ff starrocks::ThreadPool::dispatch_thread()
@ 0x3e22780 starrocks::thread::supervise_thread(void*)
@ 0x7f36e5091fed (/usr/lib64/libpthread-2.28.so+0x8fec)
@ 0x7f36e3b9d18f clone

W20250330 00:55:07.191803 139871575512832 pipeline_driver_executor.cpp:177] [Driver] Process error, query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1426, status=Internal error: Internal error: vector::_M_range_insert: BE:10002
W20250330 00:55:07.199497 139871575512832 tablet_sink_sender.cpp:299] close channel failed. channel_name=NodeChannel[10002], load_info=load_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, txn_id: 19418, parallel=1, compress_type=2, error_msg=Cancelled by pipeline engine
W20250330 00:55:07.199515 139871541942016 tablet_sink_sender.cpp:299] close channel failed. channel_name=NodeChannel[10002], load_info=load_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, txn_id: 19418, parallel=1, compress_type=2, error_msg=Cancelled by pipeline engine
W20250330 00:55:07.199585 139871558727424 tablet_sink_sender.cpp:299] close channel failed. channel_name=NodeChannel[10002], load_info=load_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, txn_id: 19418, parallel=1, compress_type=2, error_msg=Cancelled by pipeline engine
I20250330 00:55:07.199576 139871575512832 tablet_sink_sender.cpp:348] Olap table sink statistics. load_id: 8df3a599-0cbe-11f0-9bd5-1ac9333e1291, txn_id: 19418, add chunk time(ms)/wait lock time(ms)/num: {10002:(0)(0)(0)}
I20250330 00:55:07.199684 139871558727424 tablet_sink_sender.cpp:348] Olap table sink statistics. load_id: 8df3a599-0cbe-11f0-9bd5-1ac9333e1291, txn_id: 19418, add chunk time(ms)/wait lock time(ms)/num: {10002:(0)(0)(0)}
I20250330 00:55:07.199617 139871541942016 tablet_sink_sender.cpp:348] Olap table sink statistics. load_id: 8df3a599-0cbe-11f0-9bd5-1ac9333e1291, txn_id: 19418, add chunk time(ms)/wait lock time(ms)/num: {10002:(0)(0)(0)}
W20250330 00:55:07.199512 139871617476352 tablet_sink_sender.cpp:299] close channel failed. channel_name=NodeChannel[10002], load_info=load_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, txn_id: 19418, parallel=1, compress_type=2, error_msg=Cancelled by pipeline engine
I20250330 00:55:07.199824 139871617476352 tablet_sink_sender.cpp:348] Olap table sink statistics. load_id: 8df3a599-0cbe-11f0-9bd5-1ac9333e1291, txn_id: 19418, add chunk time(ms)/wait lock time(ms)/num: {10002:(0)(0)(0)}
W20250330 00:55:07.202184 139871525156608 stack_util.cpp:347] 2025-03-30 00:55:07.202138, query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, fragment_instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1426 throws exception: std::length_error, trace:
@ 0x3e09237 __wrap___cxa_throw
@ 0x381edae std::__throw_length_error(char const*)
@ 0x326fa32 void std::vector<unsigned char, starrocks::raw::RawAllocator<unsigned char, 16ul, starrocks::ColumnAllocator > >::_M_range_insert<unsigned char const*>(__gnu_cxx::__normal_iterator<unsigned char*, std::vector<unsigned char, starrocks::raw::R@
@ 0x45b3d12 starrocks::BinaryColumnBase::append(starrocks::Column const&, unsigned long, unsigned long)
@ 0x45a34de starrocks::NullableColumn::append(starrocks::Column const&, unsigned long, unsigned long)
@ 0x475e7c7 starrocks::JoinHashTable::append_chunk(std::shared_ptrstarrocks::Chunk const&, std::vector<std::shared_ptrstarrocks::Column, std::allocator<std::shared_ptrstarrocks::Column > > const&)
@ 0x4da4a82 starrocks::SingleHashJoinBuilder::do_append_chunk(std::shared_ptrstarrocks::Chunk const&)
@ 0x4d99434 starrocks::AdaptivePartitionHashJoinBuilder::_append_chunk_to_partitions(std::shared_ptrstarrocks::Chunk const&)
@ 0x4da4d40 starrocks::AdaptivePartitionHashJoinBuilder::do_append_chunk(std::shared_ptrstarrocks::Chunk const&)
@ 0x4d900bc starrocks::HashJoiner::append_chunk_to_ht(std::shared_ptrstarrocks::Chunk const&)
@ 0x4b6565b starrocks::pipeline::HashJoinBuildOperator::push_chunk(starrocks::RuntimeState*, std::shared_ptrstarrocks::Chunk const&)
@ 0x4b1c454 starrocks::pipeline::PipelineDriver::process(starrocks::RuntimeState*, int)
@ 0x4e5508f starrocks::pipeline::GlobalDriverExecutor::_worker_thread()
@ 0x3e2c0ff starrocks::ThreadPool::dispatch_thread()
@ 0x3e22780 starrocks::thread::supervise_thread(void*)
@ 0x7f36e5091fed (/usr/lib64/libpthread-2.28.so+0x8fec)
@ 0x7f36e3b9d18f clone

W20250330 00:55:07.202473 139871525156608 pipeline_driver_executor.cpp:177] [Driver] Process error, query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1426, status=Internal error: Internal error: vector::_M_range_insert: BE:10002
W20250330 00:55:07.205513 139871508371200 stack_util.cpp:347] 2025-03-30 00:55:07.205443, query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, fragment_instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1426 throws exception: std::length_error, trace:
@ 0x3e09237 __wrap___cxa_throw
@ 0x381edae std::__throw_length_error(char const*)
@ 0x326fa32 void std::vector<unsigned char, starrocks::raw::RawAllocator<unsigned char, 16ul, starrocks::ColumnAllocator > >::_M_range_insert<unsigned char const*>(__gnu_cxx::__normal_iterator<unsigned char*, std::vector<unsigned char, starrocks::raw::R@
@ 0x45b3d12 starrocks::BinaryColumnBase::append(starrocks::Column const&, unsigned long, unsigned long)
@ 0x45a34de starrocks::NullableColumn::append(starrocks::Column const&, unsigned long, unsigned long)
@ 0x475e7c7 starrocks::JoinHashTable::append_chunk(std::shared_ptrstarrocks::Chunk const&, std::vector<std::shared_ptrstarrocks::Column, std::allocator<std::shared_ptrstarrocks::Column > > const&)
@ 0x4da4a82 starrocks::SingleHashJoinBuilder::do_append_chunk(std::shared_ptrstarrocks::Chunk const&)
@ 0x4d99434 starrocks::AdaptivePartitionHashJoinBuilder::_append_chunk_to_partitions(std::shared_ptrstarrocks::Chunk const&)
@ 0x4da4d40 starrocks::AdaptivePartitionHashJoinBuilder::do_append_chunk(std::shared_ptrstarrocks::Chunk const&)
@ 0x4d900bc starrocks::HashJoiner::append_chunk_to_ht(std::shared_ptrstarrocks::Chunk const&)
@ 0x4b6565b starrocks::pipeline::HashJoinBuildOperator::push_chunk(starrocks::RuntimeState*, std::shared_ptrstarrocks::Chunk const&)
@ 0x4b1c454 starrocks::pipeline::PipelineDriver::process(starrocks::RuntimeState*, int)
@ 0x4e5508f starrocks::pipeline::GlobalDriverExecutor::_worker_thread()
@ 0x3e2c0ff starrocks::ThreadPool::dispatch_thread()
@ 0x3e22780 starrocks::thread::supervise_thread(void*)
@ 0x7f36e5091fed (/usr/lib64/libpthread-2.28.so+0x8fec)
@ 0x7f36e3b9d18f clone
W20250330 00:55:07.205551 139871575512832 tablet_sink_sender.cpp:299] close channel failed. channel_name=NodeChannel[10002], load_info=load_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, txn_id: 19418, parallel=1, compress_type=2, error_msg=Cancelled by pipeline engine
I20250330 00:55:07.205677 139871575512832 tablet_sink_sender.cpp:348] Olap table sink statistics. load_id: 8df3a599-0cbe-11f0-9bd5-1ac9333e1291, txn_id: 19418, add chunk time(ms)/wait lock time(ms)/num: {10002:(0)(0)(0)}
W20250330 00:55:07.205889 139871508371200 pipeline_driver_executor.cpp:177] [Driver] Process error, query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1426, status=Internal error: Internal error: vector::_M_range_insert: BE:10002
W20250330 00:55:07.216307 139871625869056 stack_util.cpp:347] 2025-03-30 00:55:07.216276, query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, fragment_instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1426 throws exception: std::length_error, trace:
@ 0x3e09237 __wrap___cxa_throw
@ 0x381edae std::__throw_length_error(char const*)
@ 0x326fa32 void std::vector<unsigned char, starrocks::raw::RawAllocator<unsigned char, 16ul, starrocks::ColumnAllocator > >::_M_range_insert<unsigned char const*>(__gnu_cxx::__normal_iterator<unsigned char*, std::vector<unsigned char, starrocks::raw::R@
@ 0x45b3d12 starrocks::BinaryColumnBase::append(starrocks::Column const&, unsigned long, unsigned long)
@ 0x45a34de starrocks::NullableColumn::append(starrocks::Column const&, unsigned long, unsigned long)
@ 0x475e7c7 starrocks::JoinHashTable::append_chunk(std::shared_ptrstarrocks::Chunk const&, std::vector<std::shared_ptrstarrocks::Column, std::allocator<std::shared_ptrstarrocks::Column > > const&)
@ 0x4da4a82 starrocks::SingleHashJoinBuilder::do_append_chunk(std::shared_ptrstarrocks::Chunk const&)
@ 0x4d99434 starrocks::AdaptivePartitionHashJoinBuilder::_append_chunk_to_partitions(std::shared_ptrstarrocks::Chunk const&)
@ 0x4da4d40 starrocks::AdaptivePartitionHashJoinBuilder::do_append_chunk(std::shared_ptrstarrocks::Chunk const&)
@ 0x4d900bc starrocks::HashJoiner::append_chunk_to_ht(std::shared_ptrstarrocks::Chunk const&)
@ 0x4b6565b starrocks::pipeline::HashJoinBuildOperator::push_chunk(starrocks::RuntimeState*, std::shared_ptrstarrocks::Chunk const&)
@ 0x4b1c454 starrocks::pipeline::PipelineDriver::process(starrocks::RuntimeState*, int)
@ 0x4e5508f starrocks::pipeline::GlobalDriverExecutor::_worker_thread()
@ 0x3e2c0ff starrocks::ThreadPool::dispatch_thread()
@ 0x3e22780 starrocks::thread::supervise_thread(void*)
@ 0x7f36e5091fed (/usr/lib64/libpthread-2.28.so+0x8fec)
@ 0x7f36e3b9d18f clone

W20250330 00:55:07.216528 139871625869056 pipeline_driver_executor.cpp:177] [Driver] Process error, query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1426, status=Internal error: Internal error: vector::_M_range_insert: BE:10002
W20250330 00:55:07.239461 139871550334720 stack_util.cpp:347] 2025-03-30 00:55:07.239436, query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, fragment_instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1426 throws exception: std::length_error, trace:
@ 0x3e09237 __wrap___cxa_throw
@ 0x381edae std::__throw_length_error(char const*)
@ 0x326fa32 void std::vector<unsigned char, starrocks::raw::RawAllocator<unsigned char, 16ul, starrocks::ColumnAllocator > >::_M_range_insert<unsigned char const*>(__gnu_cxx::__normal_iterator<unsigned char*, std::vector<unsigned char, starrocks::raw::R@
@ 0x45b3d12 starrocks::BinaryColumnBase::append(starrocks::Column const&, unsigned long, unsigned long)
@ 0x45a34de starrocks::NullableColumn::append(starrocks::Column const&, unsigned long, unsigned long)
@ 0x475e7c7 starrocks::JoinHashTable::append_chunk(std::shared_ptrstarrocks::Chunk const&, std::vector<std::shared_ptrstarrocks::Column, std::allocator<std::shared_ptrstarrocks::Column > > const&)
@ 0x4da4a82 starrocks::SingleHashJoinBuilder::do_append_chunk(std::shared_ptrstarrocks::Chunk const&)
@ 0x4d99434 starrocks::AdaptivePartitionHashJoinBuilder::_append_chunk_to_partitions(std::shared_ptrstarrocks::Chunk const&)
@ 0x4da4d40 starrocks::AdaptivePartitionHashJoinBuilder::do_append_chunk(std::shared_ptrstarrocks::Chunk const&)
@ 0x4d900bc starrocks::HashJoiner::append_chunk_to_ht(std::shared_ptrstarrocks::Chunk const&)
@ 0x4b6565b starrocks::pipeline::HashJoinBuildOperator::push_chunk(starrocks::RuntimeState*, std::shared_ptrstarrocks::Chunk const&)
@ 0x4b1c454 starrocks::pipeline::PipelineDriver::process(starrocks::RuntimeState*, int)
@ 0x4e5508f starrocks::pipeline::GlobalDriverExecutor::_worker_thread()
@ 0x3e2c0ff starrocks::ThreadPool::dispatch_thread()
@ 0x3e22780 starrocks::thread::supervise_thread(void*)
@ 0x7f36e5091fed (/usr/lib64/libpthread-2.28.so+0x8fec)
@ 0x7f36e3b9d18f clone

W20250330 00:55:07.239633 139871550334720 pipeline_driver_executor.cpp:177] [Driver] Process error, query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1426, status=Internal error: Internal error: vector::_M_range_insert: BE:10002
I20250330 00:55:07.247088 139871609083648 query_context.cpp:57] finished query_id:8df3a599-0cbe-11f0-9bd5-1ac9333e1291 context life time:1045269804 cpu costs:9763598496 peak memusage:633610144 scan_bytes:169923674 spilled bytes:0
I20250330 00:55:10.031919 139869313779456 heartbeat_server.cpp:104] Updating master info: TMasterInfo(network_address=TNetworkAddress(hostname=192.168.119.4, port=9120), cluster_id=2123610514, epoch=1, token=, backend_ip=192.168.119.4, http_port=8130, heartbeat_flags=0, backend_id=10002, min_active_txn_id=19419, run_mode=SHARED_NOTHING, disabled_disks=[], decommissioned_disks=[], encrypted=0)
I20250330 00:55:11.481254 139869234050816 starlet.cc:140] Empty starmanager address, skip reporting!
W20250330 00:55:12.443924 139869710857984 thrift_rpc_helper.cpp:118] Rpc error: FE RPC failure, address=TNetworkAddress(hostname=192.168.119.4, port=9120), reason=No more data to read.
W20250330 00:55:12.823444 139869702465280 thrift_rpc_helper.cpp:118] Rpc error: FE RPC failure, address=TNetworkAddress(hostname=192.168.119.4, port=9120), reason=No more data to read.
I20250330 00:55:12.846503 139869660501760 local_tablets_channel.cpp:745] LocalTabletsChannel txn_id: 19419 load_id: 94cb3423-0cbe-11f0-9bd5-1ac9333e1291 sink_id: 0 open 9 delta writer: [40174:1][40172:1][11736:1][11734:1][40176:1][11732:1][10171:1][10169:1][10167:1]0 failed_tablets: _num_remaining_senders: 5
W20250330 00:55:12.847386 139870380078848 thrift_rpc_helper.cpp:118] Rpc error: FE RPC failure, address=TNetworkAddress(hostname=192.168.119.4, port=9120), reason=No more data to read.
I20250330 00:55:13.259959 139873507866368 daemon.cpp:158] Current memory statistics: process(708262368), query_pool(1239488), load(39952), metadata(78241692), compaction(0), schema_change(0), page_cache(154870464), update(17480034), chunk_allocator(0), passthrough(0), clone(0), consistency(0), datacache(0), jit(5920)
I20250330 00:55:14.081366 139869668894464 local_tablets_channel.cpp:603] LocalTabletsChannel txn_id: 19419 load_id: 94cb3423-0cbe-11f0-9bd5-1ac9333e1291 sink_id: 0 commit 3 tablets: 40174,40172,40176
I20250330 00:55:14.084387 139871634261760 tablet_sink_sender.cpp:348] Olap table sink statistics. load_id: 94cb3423-0cbe-11f0-9bd5-1ac9333e1291, txn_id: 19419, add chunk time(ms)/wait lock time(ms)/num: {10002:(0)(0)(1)}
I20250330 00:55:14.089510 139871634261760 tablet_sink_sender.cpp:348] Olap table sink statistics. load_id: 94cb3423-0cbe-11f0-9bd5-1ac9333e1291, txn_id: 19419, add chunk time(ms)/wait lock time(ms)/num: {10002:(0)(0)(1)}
I20250330 00:55:14.094623 139871634261760 tablet_sink_sender.cpp:348] Olap table sink statistics. load_id: 94cb3423-0cbe-11f0-9bd5-1ac9333e1291, txn_id: 19419, add chunk time(ms)/wait lock time(ms)/num: {10002:(0)(0)(1)}
I20250330 00:55:14.099731 139871634261760 tablet_sink_sender.cpp:348] Olap table sink statistics. load_id: 94cb3423-0cbe-11f0-9bd5-1ac9333e1291, txn_id: 19419, add chunk time(ms)/wait lock time(ms)/num: {10002:(0)(0)(1)}
I20250330 00:55:14.147414 139871634261760 tablet_sink_index_channel.cpp:836] OlapTableSink txn_id: 19419 load_id: 94cb3423-0cbe-11f0-9bd5-1ac9333e1291 commit 3 tablets: 40172,40174,40176
I20250330 00:55:14.147435 139871634261760 tablet_sink_sender.cpp:348] Olap table sink statistics. load_id: 94cb3423-0cbe-11f0-9bd5-1ac9333e1291, txn_id: 19419, add chunk time(ms)/wait lock time(ms)/num: {10002:(60)(0)(1)}I20250330 00:55:14.159077 139869828355840 publish_version.cpp:287] publish_version success. txn_id: 19419 gtid: 346932933606506496 #partition:1 #tablet:3 time:1ms #already_finished:0
I20250330 00:55:15.032043 139869313779456 heartbeat_server.cpp:104] Updating master info: TMasterInfo(network_address=TNetworkAddress(hostname=192.168.119.4, port=9120), cluster_id=2123610514, epoch=1, token=, backend_ip=192.168.119.4, http_port=8130, heartbeat_flags=0, backend_id=10002, min_active_txn_id=19420, run_mode=SHARED_NOTHING, disabled_disks=[], decommissioned_disks=[], encrypted=0)
W20250330 00:55:19.929120 139869702465280 thrift_rpc_helper.cpp:118] Rpc error: FE RPC failure, address=TNetworkAddress(hostname=192.168.119.4, port=9120), reason=No more data to read.

  • 慢查询：

  • 查询报错：

  • be crash

    • be.out
      start time: Sat Mar 29 22:41:03 CST 2025, server uptime: 22:41:03 up 18 days, 22:16, 1 user, load average: 0.05, 0.08, 0.15
      ~

  • 外表查询报错

    • be.out和fe.warn.log
      fe.warn.log:

    DWD.orgDivisionName^M
    FROM^M
    bigdata.301_drl_v_insp_alltask_bu_rt_std DWD^M
    WHERE DWD.dt<=DATE(‘2025-03-28’)^M
    ] label: insert_8df3a599-0cbe-11f0-9bd5-1ac9333e1291
    com.starrocks.common.DdlException: Internal error: vector::_M_range_insert: BE:10002
    at com.starrocks.common.ErrorReport.reportDdlException(ErrorReport.java:90)
    at com.starrocks.qe.StmtExecutor.handleDMLStmt(StmtExecutor.java:2464)
    at com.starrocks.load.InsertOverwriteJobRunner.executeInsert(InsertOverwriteJobRunner.java:360)
    at com.starrocks.load.InsertOverwriteJobRunner.doLoad(InsertOverwriteJobRunner.java:169)
    at com.starrocks.load.InsertOverwriteJobRunner.handle(InsertOverwriteJobRunner.java:149)
    at com.starrocks.load.InsertOverwriteJobRunner.transferTo(InsertOverwriteJobRunner.java:212)
    at com.starrocks.load.InsertOverwriteJobRunner.prepare(InsertOverwriteJobRunner.java:256)
    at com.starrocks.load.InsertOverwriteJobRunner.handle(InsertOverwriteJobRunner.java:146)
    at com.starrocks.load.InsertOverwriteJobRunner.run(InsertOverwriteJobRunner.java:134)
    at com.starrocks.load.InsertOverwriteJobMgr.executeJob(InsertOverwriteJobMgr.java:91)
    at com.starrocks.qe.StmtExecutor.handleInsertOverwrite(StmtExecutor.java:2214)
    at com.starrocks.qe.StmtExecutor.handleDMLStmt(StmtExecutor.java:2309)
    at com.starrocks.qe.StmtExecutor.handleDMLStmtWithProfile(StmtExecutor.java:2223)
    at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:748)
    at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:372)
    at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:572)
    at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:910)
    at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:69)
    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-03-30 00:55:07.191+08:00 WARN (thrift-server-pool-1797|2567) [DefaultCoordinator.lambda$updateFragmentExecStatus$9():1094] exec state report failed status=errorCode INTERNAL_ERROR Internal error: vector::_M_range_insert: BE:10002, query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1441, backend_id=10002
    2025-03-30 00:55:07.191+08:00 WARN (thrift-server-pool-1793|2563) [DefaultCoordinator.lambda$updateFragmentExecStatus$9():1094] exec state report failed status=errorCode INTERNAL_ERROR Internal error: vector::_M_range_insert: BE:10002, query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1444, backend_id=10002
    2025-03-30 00:55:07.191+08:00 WARN (thrift-server-pool-1794|2564) [DefaultCoordinator.lambda$updateFragmentExecStatus$9():1094] exec state report failed status=errorCode INTERNAL_ERROR Internal error: vector::_M_range_insert: BE:10002, query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1447, backend_id=10002
    2025-03-30 00:55:07.192+08:00 WARN (thrift-server-pool-1792|2562) [DefaultCoordinator.lambda$updateFragmentExecStatus$9():1094] exec state report failed status=errorCode INTERNAL_ERROR Internal error: vector::_M_range_insert: BE:10002, query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1442, backend_id=10002
    2025-03-30 00:55:07.193+08:00 WARN (thrift-server-pool-1795|2565) [DefaultCoordinator.lambda$updateFragmentExecStatus$9():1094] exec state report failed status=errorCode INTERNAL_ERROR Internal error: vector::_M_range_insert: BE:10002, query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e143f, backend_id=10002
    2025-03-30 00:55:07.193+08:00 WARN (thrift-server-pool-1796|2566) [DefaultCoordinator.lambda$updateFragmentExecStatus$9():1094] exec state report failed status=errorCode INTERNAL_ERROR Internal error: vector::_M_range_insert: BE:10002, query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e143b, backend_id=10002
    2025-03-30 00:55:07.194+08:00 WARN (thrift-server-pool-1798|2568) [DefaultCoordinator.lambda$updateFragmentExecStatus$9():1094] exec state report failed status=errorCode INTERNAL_ERROR Internal error: vector::_M_range_insert: BE:10002, query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e143e, backend_id=10002
    2025-03-30 00:55:07.194+08:00 WARN (thrift-server-pool-1799|2569) [DefaultCoordinator.lambda$updateFragmentExecStatus$9():1094] exec state report failed status=errorCode INTERNAL_ERROR Internal error: vector::_M_range_insert: BE:10002, query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e143a, backend_id=10002
    2025-03-30 00:55:07.207+08:00 WARN (thrift-server-pool-1797|2567) [DefaultCoordinator.lambda$updateFragmentExecStatus$9():1094] exec state report failed status=errorCode INTERNAL_ERROR Internal error: vector::_M_range_insert: BE:10002, query_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1291, instance_id=8df3a599-0cbe-11f0-9bd5-1ac9333e1292, backend_id=10002
    2025-03-30 00:55:07.237+08:00 WARN (starrocks-mysql-nio-pool-13|2550) [InsertOverwriteJobRunner.handle():153] insert overwrite job:42307 failed. createPartitionElapse:20 ms, insertElapse:0 ms
    2025-03-30 00:55:07.237+08:00 WARN (starrocks-mysql-nio-pool-13|2550) [StmtExecutor.handleDMLStmtWithProfile():2225] DML statement(/* ApplicationName=DBeaver 24.3.5 - SQLEditor <Script-8.sql> */ /**^M
    /^M
    INSERT OVERWRITE bigdata.301_dwd_tb_insp_alltask_trans ^M
    ^M
    SELECT^M
    /    + SET_VAR^M
    (^M
    query_timeout = 3600, ^M
    group_concat_max_len = 1048576^M
    )^M
    */^M
    DWD.inspTaskGId,^M
    DWD.orgDivisionName^M
    FROM^M
    bigdata.301_drl_v_insp_alltask_bu_rt_std DWD^M
    WHERE DWD.dt<=DATE(‘2025-03-28’)^M
    ) process failed.
    com.starrocks.common.UserException: Internal error: vector::_M_range_insert: BE:10002
    at com.starrocks.qe.StmtExecutor.handleDMLStmt(StmtExecutor.java:2693)
    at com.starrocks.load.InsertOverwriteJobRunner.executeInsert(InsertOverwriteJobRunner.java:360)
    at com.starrocks.load.InsertOverwriteJobRunner.doLoad(InsertOverwriteJobRunner.java:169)
    at com.starrocks.load.InsertOverwriteJobRunner.handle(InsertOverwriteJobRunner.java:149)
    at com.starrocks.load.InsertOverwriteJobRunner.transferTo(InsertOverwriteJobRunner.java:212)
    at com.starrocks.load.InsertOverwriteJobRunner.prepare(InsertOverwriteJobRunner.java:256)
    at com.starrocks.load.InsertOverwriteJobRunner.handle(InsertOverwriteJobRunner.java:146)
    at com.starrocks.load.InsertOverwriteJobRunner.run(InsertOverwriteJobRunner.java:134)
    at com.starrocks.load.InsertOverwriteJobMgr.executeJob(InsertOverwriteJobMgr.java:91)
    at com.starrocks.qe.StmtExecutor.handleInsertOverwrite(StmtExecutor.java:2214)
    at com.starrocks.qe.StmtExecutor.handleDMLStmt(StmtExecutor.java:2309)
    at com.starrocks.qe.StmtExecutor.handleDMLStmtWithProfile(StmtExecutor.java:2223)
    at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:748)
    at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:372)
    at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:572)
    at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:910)
    at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:69)
    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)
    Caused by: com.starrocks.common.DdlException: Internal error: vector::_M_range_insert: BE:10002
    at com.starrocks.common.ErrorReport.reportDdlException(ErrorReport.java:90)
    at com.starrocks.qe.StmtExecutor.handleDMLStmt(StmtExecutor.java:2464)
    … 19 more
    2025-03-30 00:55:25.105+08:00 WARN (DynamicPartitionScheduler|55) [DynamicPartitionScheduler.executeDynamicPartitionForTable():369] Automatically removes the schedule because table[ods_dca_user_job_relation] does not have dynamic partition

京ICP备2022026421号-1