【StarRocks版本】3.1.9
【集群规模】3fe + 8be(fe与be混部)
SELECT * FROM `information_schema`.`task_runs` where query_id='385e06cc-39d8-11ef-b2d9-0242e753711b'
QUERY_ID TASK_NAME CREATE_TIME FINISH_TIME STATE DATABASE DEFINITION EXPIRE_TIME ERROR_CODE ERROR_MESSAGE PROGRESS EXTRA_MESSAGE PROPERTIES
------------------------------------ ------------ ------------------- ------------------- ------ -------- ---------- ------------------- ---------- ------------- -------- -------------------------------------------------------------------------------------------------------------------------------------------------- ------------
385e06cc-39d8-11ef-b2d9-0242e753711b mv-419653882 2024-07-04 15:37:09 2024-07-04 15:37:13 FAILED ****** ****** 2024-07-05 15:37:09 -1 100% {"forceRefresh":false,"mvPartitionsToRefresh":["mv_cc_order_basic_extend_inc"],"refBasePartitionsToRefreshMap":{},"basePartitionsToRefreshMap":{}}
FE日志:
2024-07-04 15:37:13,601 INFO (starrocks-taskrun-pool-3|444) [QeProcessorImpl.registerQuery():103] register query id = 385e06cc-39d8-11ef-b2d9-0242e753711b
2024-07-04 15:37:13,607 INFO (starrocks-taskrun-pool-3|444) [DatabaseTransactionMgr.abortTransaction():1254] transaction:[TransactionState. txn_id: 66882752, label: insert_385e06cc-39d8-11ef-b2d9-0242e753711b, db id: 10151, table id list: 419653882, callback id: -1, coordinator: FE: ****** , transaction status: ABORTED, error replicas num: 0, replica ids: , prepare time: 1720078633598, commit time: -1, finish time: 1720078633602, total cost: 4ms, reason: A problem occurred while executing the [ insert overwrite ****** ] statement with label:insert_385e06cc-39d8-11ef-b2d9-0242e753711b] successfully rollback
2024-07-04 15:37:13,611 INFO (starrocks-taskrun-pool-3|444) [QeProcessorImpl.unregisterQuery():142] deregister query id = 385e06cc-39d8-11ef-b2d9-0242e753711b
2024-07-04 15:37:13,611 INFO (starrocks-taskrun-pool-3|444) [InsertOverwriteJobRunner.gc():346] start to garbage collect
2024-07-04 15:37:13,611 INFO (starrocks-taskrun-pool-3|444) [InsertOverwriteJobRunner.gc():358] drop temp partition:436284873
2024-07-04 15:37:13,613 WARN (starrocks-taskrun-pool-3|444) [InsertOverwriteJobRunner.handle():145] insert overwrite job:436284872 failed. createPartitionElapse:71 ms, insertElapse:0 ms
2024-07-04 15:37:13,613 WARN (starrocks-taskrun-pool-3|444) [StmtExecutor.handleDMLStmtWithProfile():1547] DML statement(insert overwrite ******) process failed.
com.starrocks.common.UserException:
at com.starrocks.qe.StmtExecutor.handleDMLStmt(StmtExecutor.java:1972) ~[starrocks-fe.jar:?]
at com.starrocks.load.InsertOverwriteJobRunner.executeInsert(InsertOverwriteJobRunner.java:322) ~[starrocks-fe.jar:?]
at com.starrocks.load.InsertOverwriteJobRunner.doLoad(InsertOverwriteJobRunner.java:161) ~[starrocks-fe.jar:?]
at com.starrocks.load.InsertOverwriteJobRunner.handle(InsertOverwriteJobRunner.java:141) ~[starrocks-fe.jar:?]
at com.starrocks.load.InsertOverwriteJobRunner.transferTo(InsertOverwriteJobRunner.java:201) ~[starrocks-fe.jar:?]
at com.starrocks.load.InsertOverwriteJobRunner.prepare(InsertOverwriteJobRunner.java:223) ~[starrocks-fe.jar:?]
at com.starrocks.load.InsertOverwriteJobRunner.handle(InsertOverwriteJobRunner.java:138) ~[starrocks-fe.jar:?]
at com.starrocks.load.InsertOverwriteJobRunner.run(InsertOverwriteJobRunner.java:126) ~[starrocks-fe.jar:?]
at com.starrocks.load.InsertOverwriteJobMgr.executeJob(InsertOverwriteJobMgr.java:86) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.handleInsertOverwrite(StmtExecutor.java:1536) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.handleDMLStmt(StmtExecutor.java:1615) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.handleDMLStmtWithProfile(StmtExecutor.java:1545) ~[starrocks-fe.jar:?]
at com.starrocks.scheduler.PartitionBasedMvRefreshProcessor.refreshMaterializedView(PartitionBasedMvRefreshProcessor.java:1342) ~[starrocks-fe.jar:?]
at com.starrocks.scheduler.PartitionBasedMvRefreshProcessor.doMvRefresh(PartitionBasedMvRefreshProcessor.java:272) ~[starrocks-fe.jar:?]
at com.starrocks.scheduler.PartitionBasedMvRefreshProcessor.processTaskRun(PartitionBasedMvRefreshProcessor.java:187) ~[starrocks-fe.jar:?]
at com.starrocks.scheduler.TaskRun.executeTaskRun(TaskRun.java:213) ~[starrocks-fe.jar:?]
at com.starrocks.scheduler.TaskRunExecutor.lambda$executeTaskRun$0(TaskRunExecutor.java:53) ~[starrocks-fe.jar:?]
at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1590) ~[?:1.8.0_181]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_181]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_181]
at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_181]
Caused by: java.lang.NullPointerException
2024-07-04 15:37:13,614 WARN (ForkJoinPool.commonPool-worker-91|945974) [Coordinator.getNext():1503] get next fail, need cancel. status errorCode GLOBAL_DICT_ERROR no global dict, query id: 3aea0941-39d8-11ef-b2d9-0242e753711b
2024-07-04 15:37:13,614 WARN (ForkJoinPool.commonPool-worker-91|945974) [Coordinator.updateStatus():1483] one instance report fail throw updateStatus(), need cancel. job id: -1, query id: 3aea0941-39d8-11ef-b2d9-0242e753711b, instance id: NaN
2024-07-04 15:37:13,614 WARN (starrocks-taskrun-pool-3|444) [PartitionBasedMvRefreshProcessor.refreshMaterializedView():1344] refresh materialized view ****** failed: com.starrocks.common.UserException:
2024-07-04 15:37:13,614 INFO (ForkJoinPool.commonPool-worker-91|945974) [Coordinator.cancelInternal():1604] unfinished instance: 3aea0941-39d8-11ef-b2d9-0242e753711e
2024-07-04 15:37:13,614 WARN (ForkJoinPool.commonPool-worker-91|945974) [Coordinator.getNext():1529] query failed: no global dict
2024-07-04 15:37:13,614 WARN (starrocks-taskrun-pool-3|444) [TaskRunExecutor.lambda$executeTaskRun$0():60] failed to execute TaskRun.
com.starrocks.common.UserException:
2024-07-04 15:37:13,614 WARN (ForkJoinPool.commonPool-worker-91|945974) [StmtExecutor.executeStmtWithExecPlan():2048] com.starrocks.common.UserException: no global dict
请问这个要怎么解决阿