【详述】执行特定sql，be crash
select
a.brand_id,
count(distinct c.skc) skc_cnt,
count(distinct if(c.flag = 1, c.skc, null)) skc_1
from
table1 a
left join (
select
id,
skc,
max(flag) flag
from
table2 a
group by
1,2
) c on cast(a.id as varchar) = c.id
group by
a.brand_id
【业务影响】
【是否存算分离】
【StarRocks版本】3.3.11
异常栈：
query_id:3f8af1b4-f8a4-11ef-af8f-3e2ee1c76286, fragment_instance:3f8af1b4-f8a4-11ef-af8f-3e2ee1c7629c
tracker:process consumption: 59334822952
tracker:query_pool consumption: 49744564160
tracker:query_pool/connector_scan consumption: 0
tracker:load consumption: 0
tracker:metadata consumption: 0
tracker:tablet_metadata consumption: 0
tracker:rowset_metadata consumption: 0
tracker:segment_metadata consumption: 0
tracker:column_metadata consumption: 0
tracker:tablet_schema consumption: 0
tracker:segment_zonemap consumption: 0
tracker:short_key_index consumption: 0
tracker:column_zonemap_index consumption: 0
tracker:ordinal_index consumption: 0
tracker:bitmap_index consumption: 0
tracker:bloom_filter_index consumption: 0
tracker:compaction consumption: 0
tracker:schema_change consumption: 0
tracker:column_pool consumption: 0
tracker:page_cache consumption: 0
tracker:jit_cache consumption: 1264
tracker:update consumption: 0
tracker:chunk_allocator consumption: 20166584
tracker:clone consumption: 0
tracker:consistency consumption: 0
tracker:datacache consumption: 9157365339
tracker:replication consumption: 0
*** Aborted at 1741057275 (unix time) try “date -d @1741057275” if you are using GNU date ***
PC: @ 0x6548f10 starrocks::DistinctAggregateState<(starrocks::LogicalType)13, (starrocks::LogicalType)13, int>::deserialize_and_merge(starrocks::MemPool*, unsigned char const*, unsigned long)
*** SIGSEGV (@0xffe4f4e00000) received by PID 40 (TID 0xfffe6faf0040) from PID 18446744073522905088; stack trace: ***
@ 0xffff8b0b25d4 (/usr/lib/aarch64-linux-gnu/libc.so.6+0x825d3)
@ 0x9541468 google::(anonymous namespace)::FailureSignalHandler(int, siginfo_t*, void*)
@ 0xffff8bd356dc os::Linux::chained_handler(int, siginfo_t*, void*)
@ 0xffff8bd3b7cc JVM_handle_linux_signal
@ 0xffff8bd2dd5c signalHandler(int, siginfo_t*, void*)
@ 0xffff8c408850 ([vdso]+0x84f)
@ 0x6548f10 starrocks::DistinctAggregateState<(starrocks::LogicalType)13, (starrocks::LogicalType)13, int>::deserialize_and_merge(starrocks::MemPool*, unsigned char const*, unsigned long)
@ 0x6549148 starrocks::TDistinctAggregateFunction<(starrocks::LogicalType)13, (starrocks::LogicalType)13, starrocks::DistinctAggregateStateV2, (starrocks::AggDistinctType)0, starrocks::Slice>::merge(starrocks::FunctionContext*, starrocks::Column const*, unsigned char*
@ 0x6492c80 starrocks::NullableAggregateFunctionUnary<std::shared_ptrstarrocks::AggregateFunction, starrocks::NullableAggregateFunctionState<starrocks::DistinctAggregateStateV2<(starrocks::LogicalType)13, (starrocks::LogicalType)13, int>, false>, false, true, starro
@ 0x6fc2f8c starrocks::Aggregator::compute_batch_agg_states(starrocks::Chunk*, unsigned long)
@ 0x70e39bc starrocks::pipeline::AggregateBlockingSinkOperator::push_chunk(starrocks::RuntimeState*, std::shared_ptrstarrocks::Chunk const&)
@ 0x5573b24 starrocks::pipeline::PipelineDriver::process(starrocks::RuntimeState*, int)
@ 0x55edd30 starrocks::pipeline::GlobalDriverExecutor::_worker_thread()
@ 0x82162a4 starrocks::ThreadPool::dispatch_thread()
@ 0x820e14c starrocks:
:supervise_thread(void*)
@ 0xffff8b0ad5c8 (/usr/lib/aarch64-linux-gnu/libc.so.6+0x7d5c7)
@ 0xffff8b115edc (/usr/lib/aarch64-linux-gnu/libc.so.6+0xe5edb)