为了更快的定位您的问题，请提供以下信息，谢谢
【详述】be crash
【背景】原先3.3.7也有crash看了下社区有fix相关的spill算子 升级到3.3.10依旧是报错
【业务影响】
【是否存算分离】存算一体
【StarRocks版本】3.3.10
【集群规模】例如：3fe（1 follower+2observer）+5be（fe与be混部）
【机器信息】CPU虚拟核/内存/网卡，例如：48C/64G/万兆
【联系方式】社区群22 hpp
【附件】
通过queryId找到的sql
2025-03-12 16:33:16.581+08:00 [query] |Timestamp=1741768346163|Client=172.18.247.132:26786|User=fabric|AuthorizedUser=‘fabric’@’%’|ResourceGroup=load_resource_group|Catalog=default_catalog|Db=|State=ERR|ErrorCode=ANALYSIS_ERR|Time=50418|ScanBytes=0|ScanRows=0|ReturnRows=0|StmtId=17469|QueryId=870ba910-ff1c-11ef-8599-0242b2853acc|IsQuery=false|feIp=gaofan-node00|Stmt=/“set_var.spill_mode” = ‘force’,“sqlid” = ‘1741768346007-qk98’,“instanceid” = ‘OHcBRubbGW-3RCHYL’,“tasktype” = ‘persistTableTask’,“logid” = ‘J3wNaLjJAX’,“tag” = ‘OHcBRubbGW-3RCHYL’,“fabric-jobId” = ‘182eb965-3a08-acd8-9ffe-1ea1071d3300’,“set_var.pipeline_dop” = ‘2’/ INSERT /*+ SET_VAR(“spill_mode”= ‘force’, “pipeline_dop”= ‘2’) / INTO cubeappdata._tmp_1741768345644__persist_TABLE_OHcBRubbGW (Code, jls, orderid) (SELECT Code, CAST(CAST(SUM($f2) AS SIGNED INTEGER) AS DOUBLE) AS jls, CAST(COUNT(OrderId) AS DOUBLE) AS orderid FROM (SELECT _persist_TABLE_BugVuyhVOU.Code, _persist_TABLE_BugVuyhVOU.OrderId, COUNT() AS $f2 FROM cubeappdata._persist_TABLE_BugVuyhVOU GROUP BY _persist_TABLE_BugVuyhVOU.Code, _persist_TABLE_BugVuyhVOU.OrderId) AS _persist_TABLE_BugVuyhVOU GROUP BY Code)
- be crash
3.3.7_be.out (5.2 KB)
3.3.10_be.out (5.0 KB) - 外表查询报错
- be.out和fe.warn.log