【已解决】异步物化视图 task 卡住应该怎么处理

Viewed 59
mysql>     select * from tasks("type"="mv") where MvName='gen_mv1' order by  StartTime desc limit 1\G
*************************** 1. row ***************************
               TaskId: 5769208113609482
                JobId: 1246261
              JobName: inner_mtmv_1246239
                 MvId: 1246239
               MvName: gen_mv1
         MvDatabaseId: 10117
       MvDatabaseName: test
               Status: RUNNING
             ErrorMsg: 
           CreateTime: 2024-03-29 09:32:54
            StartTime: 2024-03-29 09:32:54
           FinishTime: \N
           DurationMs: \N
          TaskContext: {"triggerMode":"SYSTEM","isComplete":false}
          RefreshMode: COMPLETE
NeedRefreshPartitions: ["gen_mv1"]
  CompletedPartitions: []
             Progress: 0.00% (0/1)
          LastQueryId: 27617a1ed07140be-96c56345e04b814b
1 row in set (0.04 sec)

1 Answers

是定时刷新还是强制refresh了呢?如果数据量比较大的话,可能刷新的时间晖比较长一些,也可以将异步物化视图创建成分区级别的