【详述】创建异步物化视图，运行了一段时间后，出现刷新停止问题。fe报错：failed for query tables。
【背景】重建。
【业务影响】
【StarRocks版本】2.5.4
【集群规模】例如：3fe（2follower）+3be（fe与be混部）
【机器信息】CPU虚拟核/内存/网卡，8C/24G/万兆
【联系方式】为了在解决问题过程中能及时联系到您获取一些日志信息，请补充下您的联系方式，例如：社区群4-小李或者邮箱，谢谢
【附件】
fe warn日志报错：
2023-05-11 09:14:35,980 WARN (starrocks-mysql-nio-pool-3370|98390) [MvRewritePreprocessor.prepareMvCandidatesForPlan():71] preprocess mv ads_zt_sass_public_staff_postion_data_r failed for query tables:[to_zt_platform_staff_info, to_zt_platform_user_info, to_zt_platform_
company_info, to_zt_platform_union_staff_department, to_zt_platform_department_info, to_zt_platform_union_staff_position, to_zt_platform_job_position, to_hrm_saas_employee_info, to_hrm_saas_department_information_extend, to_hrm_saas_position_information_extend, to_hrm_s
aas_employee_info_extend]
java.lang.NullPointerException: null
2023-05-11 09:15:46,208 WARN (starrocks-mysql-nio-pool-3370|98390) [ReadListener.lambda$handleEvent$0():63] Exception happened in one session(com.starrocks.mysql.nio.NConnectContext@70c6e22c).
java.io.IOException: Error happened when receiving packet.
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:689) ~[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:1149) [?:1.8.0_291]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_291]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_291]
2023-05-11 09:18:48,175 WARN (starrocks-mysql-nio-pool-3370|98390) [MvRewritePreprocessor.prepareMvCandidatesForPlan():71] preprocess mv ads_zt_sass_public_staff_postion_data_r failed for query tables:[to_zt_platform_staff_info, to_zt_platform_user_info, to_zt_platform_
company_info, to_zt_platform_union_staff_department, to_zt_platform_department_info, to_zt_platform_union_staff_position, to_zt_platform_job_position, to_hrm_saas_employee_info, to_hrm_saas_department_information_extend, to_hrm_saas_position_information_extend, to_hrm_s
aas_employee_info_extend]
java.lang.NullPointerException: null
2023-05-11 09:19:35,250 WARN (starrocks-mysql-nio-pool-3370|98390) [ReadListener.lambda$handleEvent$0():63] Exception happened in one session(com.starrocks.mysql.nio.NConnectContext@3056f647).
java.io.IOException: Error happened when receiving packet.
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:689) ~[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:1149) [?:1.8.0_291]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_291]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_291]
2023-05-11 09:20:38,491 WARN (starrocks-mysql-nio-pool-3370|98390) [ReadListener.lambda$handleEvent$0():63] Exception happened in one session(com.starrocks.mysql.nio.NConnectContext@3bef1ce9).
java.io.IOException: Error happened when receiving packet.
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:689) ~[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:1149) [?:1.8.0_291]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_291]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_291]
2023-05-11 09:21:38,856 WARN (replayer|70) [TaskManager.replayUpdateTaskRun():546] could not find query_id:2d275e62-ef9a-11ed-8d45-0242f1965298, taskId:1366450, when replay update pendingTaskRun
2023-05-11 09:23:16,030 WARN (starrocks-mysql-nio-pool-3370|98390) [MvRewritePreprocessor.prepareMvCandidatesForPlan():71] preprocess mv ads_zt_sass_public_staff_postion_data_r failed for query tables:[to_zt_platform_staff_info, to_zt_platform_user_info, to_zt_platform_
company_info, to_zt_platform_union_staff_department, to_zt_platform_department_info]
fe.out报错：
五月 11, 2023 2:09:25 下午 com.github.benmanes.caffeine.cache.LocalAsyncCache$AsyncBulkCompleter accept
警告: Exception thrown during asynchronous load
java.util.concurrent.CompletionException: java.lang.IllegalStateException
at java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:273)
at java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:280)
at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1606)
at java.util.concurrent.CompletableFuture$AsyncSupply.exec(CompletableFuture.java:1596)
at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:289)
at java.util.concurrent.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1067)
at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1703)
at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:172)
Caused by: java.lang.IllegalStateException
at com.google.common.base.Preconditions.checkState(Preconditions.java:494)
at com.starrocks.statistic.StatisticExecutor.queryStatisticSync(StatisticExecutor.java:74)
at com.starrocks.sql.optimizer.statistics.ColumnBasicStatsCacheLoader.queryStatisticsData(ColumnBasicStatsCacheLoader.java:111)
at com.starrocks.sql.optimizer.statistics.ColumnBasicStatsCacheLoader.lambda$asyncLoadAll$1(ColumnBasicStatsCacheLoader.java:77)
at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1604)
… 5 more
