为了更快的定位您的问题，请提供以下信息，谢谢
【详述】问题详细描述
【背景】做过哪些操作？
【业务影响】
【StarRocks版本】3.1.1
【集群规模】3FE+5BE
【机器信息】CPU虚拟核/内存/网卡，例如：48C/64G/万兆
【联系方式】lianweijunlee@126.com
【附件】
- fe.log/beINFO/相应截图
2023-10-24 00:00:00,213 WARN (starrocks-mysql-nio-pool-2585|7802266) [MvRewritePreprocessor.prepareRelatedMVs():196] preprocess mv mjy_jiamian_user_list_mv failed for query tables:[dwd_cdp
_crm_mem_open_real_p_group, dm_cdp_user_portrait_single_group]
java.lang.NullPointerException: null
at com.starrocks.sql.optimizer.MvRewritePreprocessor.preprocessMv(MvRewritePreprocessor.java:238) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.MvRewritePreprocessor.prepareRelatedMVs(MvRewritePreprocessor.java:193) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.MvRewritePreprocessor.prepareMvCandidatesForPlan(MvRewritePreprocessor.java:88) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.Optimizer.prepare(Optimizer.java:246) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.Optimizer.optimize(Optimizer.java:121) ~[starrocks-fe.jar:?]
at com.starrocks.sql.InsertPlanner.plan(InsertPlanner.java:174) ~[starrocks-fe.jar:?]
at com.starrocks.sql.StatementPlanner.plan(StatementPlanner.java:92) ~[starrocks-fe.jar:?]
at com.starrocks.sql.StatementPlanner.plan(StatementPlanner.java:55) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:434) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:360) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:474) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:740) ~[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) ~[?:?] - 慢查询：
- Profile信息
- 并行度：show variables like ‘%parallel_fragment_exec_instance_num%’;
- pipeline是否开启：show variables like ‘%pipeline%’;
- be节点cpu和内存使用率截图
- 查询报错：
- query_dump，怎么获取query_dump文件
- be crash
- be.out
- 外表查询报错
- be.out和fe.warn.log