【详述】问题详细描述
【背景】做过哪些操作？
【业务影响】
【StarRocks版本】例如：2.3.3
【集群规模】例如：3fe（1 follower+2observer）+5be（fe与be混部）
【机器信息】CPU虚拟核/内存/网卡，例如：48C/64G/万兆
【附件】
com.starrocks.common.DdlException: Cancelled 报错原因？
022-12-04 14:30:25,724 WARN (starrocks-mysql-nio-pool-5000|540006) [StmtExecutor.handleDMLStmt():1153] insert failed: Cancelled
2022-12-04 14:30:25,724 WARN (starrocks-mysql-nio-pool-5000|540006) [StmtExecutor.handleDMLStmt():1229] handle insert stmt fail: insert_70717743-739c-11ed-a9a8-525400fd0e8f
com.starrocks.common.DdlException: Cancelled
at com.starrocks.common.ErrorReport.reportDdlException(ErrorReport.java:80) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.handleDMLStmt(StmtExecutor.java:1154) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:430) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:322) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:440) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:676) ~[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_202]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_202]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202]
2022-12-04 14:30:25,757 INFO (starrocks-mysql-nio-pool-5000|540006) [QeProcessorImpl.unregisterQuery():79] deregister query id 70717743-739c-11ed-a9a8-525400fd0e8f
2022-12-04 14:30:25,779 INFO (starrocks-mysql-nio-pool-5000|540006) [StmtExecutor.analyze():587] begin to analyze stmt: 2574122, forwarded stmt id: 0
2022-12-04 14:30:25,787 INFO (starrocks-mysql-nio-pool-5000|540006) [StmtExecutor.analyze():587] begin to analyze stmt: 2574123, forwarded stmt id: 0
sql语句：
INSERT INTO pack_seq_id_bit_map (business_id, create_time, seq_id_bitmap) SELECT 'HWVjl3qmEfH-K7U4v99', '2022-12-04 14:25:25', ifnull((SELECT bitmap_union(to_bitmap(em.seq_id)) from push_50001_open_account AS pb JOIN entity_40_seq_id_mapping AS em ON pb.user_id=em.entity_id WHERE bitmap_contains(bitmap_and((SELECT ifnull(bitmap_union(seq_id_bitmap), bitmap_empty()) as seq_id_bitmap FROM entity_40_label_summary WHERE label_id = 405 AND update_time = '2022-11-27 23:57:39' AND label_value='H5'), (SELECT bitmap_union (seq_id_bitmap) seq_id_bitmap from (select to_bitmap(seq_id) seq_id_bitmap ,seq_id,dt from push_50001_open_account e join entity_40_seq_id_mapping s on e.user_id = s.entity_id where SUBSTR(event_time, 1, 10) IN ( '2022-11-27' ) and e.event_code= 'KH_qsxy' and e.user_id is not null and e.user_id!='null' GROUP BY seq_id,dt ) e)), em.seq_id) AND DATE_FORMAT(date_trunc('day', event_time),'%Y-%m-%d') = '2022-11-27'), bitmap_empty())
对应执行sql在fe.audit.log中超时。该情况只出过一次，后续同样的sql未出现超时问题。执行时间1s内。
