升级回滚之后查询缓慢

StarRocks版本】例如:2.1.2
【集群规模】例如:3fe(3follower)+3be(fe与be混部)
【机器信息】CPU虚拟核/内存/网卡,例如:62C/512G/万兆
【联系方式】为了在解决问题过程中能及时联系到您获取一些日志信息,请补充下您的联系方式,例如:社区群4-李志鹏,谢谢
现象:由于集群最近连续两天be挂掉,从报错日志中
start time: Tue Oct 17 03:59:39 CST 2023
*** Aborted at 1697486390 (unix time) try “date -d @1697486390” if you are using GNU date ***
PC: @ 0x0 (unknown)
*** SIGSEGV (@0x0) received by PID 202206 (TID 0x7f612ca69700) from PID 0; stack trace: ***
@ 0x35002c2 google::(anonymous namespace)::FailureSignalHandler()
@ 0x7f62e323a630 (unknown)
@ 0x0 (unknown)
start time: Tue Oct 17 04:01:50 CST 2023
*** Aborted at 1697560675 (unix time) try “date -d @1697560675” if you are using GNU date ***
PC: @ 0x0 (unknown)
*** SIGSEGV (@0x0) received by PID 206534 (TID 0x7f0ade602700) from PID 0; stack trace: ***
@ 0x35002c2 google::(anonymous namespace)::FailureSignalHandler()
@ 0x7f0c40d2c630 (unknown)
@ 0x0 (unknown)
需要升级版本,而后升级版本从2.1.2升级到2.2.13,升级成功后,发现整体查询性能降低,
而后回滚到2.1.2,然而回滚之后查询也变慢了点,小表小数据量还好,当数据量大了之后发现查询时间较久,测试sql
select * from ods.ods_halm_curr order by event_day,此表是按event_day分区,保留15天,每天300w多的数据量,没升级之前是5s之内,升级之后是25s左右,具体执行计划如下,
查询耗时都在数据扫描阶段,磁盘io无什么影响
profile.sql (240.8 KB)

set global enable_pipeline_engine = false; 后试试

设置的就是false,设置为true更慢