Insert into 超级慢卡住不动

为了更快的定位您的问题,请提供以下信息,谢谢
【详述】问题详细描述
【背景】做过哪些操作?
【业务影响】
【是否存算分离】
【StarRocks版本】例如:3.2.9
【集群规模】例如:3fe(1 follower+2observer)+16be(fe与be不混部)
【机器信息】CPU虚拟核/内存/网卡,例如:16core
【表模型】例如:明细模型
【导入或者导出方式】例如:INSERT INTO ods_lake.ods_mysql_spider_fwd_eventcode_detail_inc_cdc_20241021
SELECT * FROM ods_lake.ods_mysql_spider_fwd_eventcode_detail_inc_cdc WHERE update_time >= ‘2024-01-01 00:00:00’ ; 数据量66538286
【联系方式】为了在解决问题过程中能及时联系到您获取一些日志信息,请补充下您的联系方式,例如:社区群4-小李或者邮箱,谢谢
【附件】

  • fe.log/be.INFO/相应截图
  • 完整的报错异常栈

2024-10-21 14:06:42.293+08:00 INFO (starrocks-mysql-nio-pool-8004|46401) [QeProcessorImpl.registerQuery():108] register query id = a4a1de91-8f72-11ef-875a-0242828a381b
2024-10-21 14:06:42.293+08:00 INFO (starrocks-mysql-nio-pool-8004|46401) [DefaultCoordinator.prepareProfile():539] dispatch load job: a4a1de91-8f72-11ef-875a-0242828a381b to [45090352, 18120309, 45090322, 18120211, 18120253, 45090298, 18120378, 45090272, 18120358, 243339606, 1842059, 173109, 243339608, 45090063]
2024-10-21 14:06:42.295+08:00 INFO (thrift-server-pool-21468|45952) [QeProcessorImpl.reportExecStatus():193] ReportExecStatus() failed, query does not exist, fragment_instance_id=ffe07c44-8f67-11ef-875a-0242828a3821, query_id=ffe07c44-8f67-11ef-875a-0242828a381b,
2024-10-21 14:06:42.311+08:00 INFO (thrift-server-pool-20796|43818) [QeProcessorImpl.reportExecStatus():193] ReportExecStatus() failed, query does not exist, fragment_instance_id=67a7cf45-8f6e-11ef-875a-0242828a381f, query_id=67a7cf45-8f6e-11ef-875a-0242828a381b,
2024-10-21 14:06:42.311+08:00 INFO (thrift-server-pool-21609|46140) [QeProcessorImpl.reportExecStatus():193] ReportExecStatus() failed, query does not exist, fragment_instance_id=b4f1461e-8f6e-11ef-875a-0242828a3827, query_id=b4f1461e-8f6e-11ef-875a-0242828a381b,
2024-10-21 14:06:42.311+08:00 INFO (thrift-server-pool-19962|42706) [QeProcessorImpl.reportExecStatus():193] ReportExecStatus() failed, query does not exist, fragment_instance_id=b4f564cf-8f6e-11ef-875a-0242828a3827, query_id=b4f564cf-8f6e-11ef-875a-0242828a381b,
2024-10-21 14:06:42.311+08:00 INFO (thrift-server-pool-20920|44109) [QeProcessorImpl.reportExecStatus():193] ReportExecStatus() failed, query does not exist, fragment_instance_id=67a5ac63-8f6e-11ef-875a-0242828a381e, query_id=67a5ac63-8f6e-11ef-875a-0242828a381b,

但是重启后可以很快写入成功 过几个小时重新写入又卡住 百分之xx% 不动