物化视图偶尔failed

【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

请问这个要怎么解决阿

你好 麻烦SHOW MATERIALIZED VIEW看下详情

id         database_name     name                          refresh_type  is_active  inactive_reason  partition_type  task_id    task_name     last_refresh_start_time  last_refresh_finished_time  last_refresh_duration  last_refresh_state  last_refresh_force_refresh  last_refresh_start_partition  last_refresh_end_partition  last_refresh_base_refresh_partitions  last_refresh_mv_refresh_partitions  last_refresh_error_code  last_refresh_error_message  rows    text                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
---------  ----------------  ----------------------------  ------------  ---------  ---------------  --------------  ---------  ------------  -----------------------  --------------------------  ---------------------  ------------------  --------------------------  ----------------------------  --------------------------  ------------------------------------  ----------------------------------  -----------------------  --------------------------  ------  ----------------------------
419653882  隐藏库名           mv_cc_order_basic_extend_inc  ASYNC         true                        UNPARTITIONED   419653933  mv-419653882  2024-07-05 11:01:34      \N                          0.000                  RUNNING             false                                                                                 {}                                    mv_cc_order_basic_extend_inc        0                                                    0       隐藏创建语句

这个

这个有结论了吗?我在3.1.11版本也有同样的问题