【详述】这是be宕机后be.out报错日志
start time: Mon Sep 5 10:52:02 CST 2022
tcmalloc: large alloc 1677721600 bytes == 0x55898e000 @ 0x5493aef 0x572535c 0x1ecee38 0x56755d5 0x2a25fe3 0x2a2c731 0x26df88e 0x233f08a 0x1e948f4 0x1e955f7 0x1e294bb 0x1e2db9c 0x1e2e401 0x1f723d9 0x1f6df8a
0x7fa5c4f70e25
tcmalloc: large alloc 1677721600 bytes == 0x52698e000 @ 0x5493aef 0x572535c 0x1ecee38 0x56755d5 0x2a25fe3 0x2a2c731 0x26df88e 0x233f08a 0x1e948f4 0x1e955f7 0x1e294bb 0x1e2db9c 0x1e2e401 0x1f723d9 0x1f6df8a
0x7fa5c4f70e25
*** Aborted at 1663586314 (unix time) try “date -d @1663586314” if you are using GNU date ***
PC: @ 0x0 (unknown)
*** SIGSEGV (@0x0) received by PID 252310 (TID 0x7fa5b01d9700) from PID 0; stack trace: ***
@ 0x3cb75d2 google::(anonymous namespace)::FailureSignalHandler()
@ 0x7fa5c4f786d0 (unknown)
@ 0x0 (unknown)
start time: Mon Sep 19 19:37:15 CST 2022
*** Aborted at 1663645370 (unix time) try “date -d @1663645370” if you are using GNU date ***
PC: @ 0x4086310 google::protobuf::Message::SpaceUsedLong()
*** SIGSEGV (@0xcb) received by PID 75889 (TID 0x7efff21ae700) from PID 203; stack trace: ***
@ 0x3cb75d2 google::(anonymous namespace)::FailureSignalHandler()
@ 0x7f001c8586d0 (unknown)
@ 0x4086310 google::protobuf::Message::SpaceUsedLong()
@ 0x1c26814 starrocks::ZoneMapIndexReader::mem_usage()
@ 0x1ba5e80 starrocks::ColumnReader::_load_zonemap_index()
@ 0x1ba5fad starrocks::ColumnReader::zone_map_filter()
@ 0x1bf4959 starrocks::ScalarColumnIterator::get_row_ranges_by_zone_map()
@ 0x1a33c72 starrocks::vectorized::SegmentIterator::_get_row_ranges_by_zone_map()
@ 0x1a3493f starrocks::vectorized::SegmentIterator::_init()
@ 0x1a35029 starrocks::vectorized::SegmentIterator::do_get_next()
@ 0x1a927f2 starrocks::vectorized::ProjectionIterator::do_get_next()
@ 0x1def65a starrocks::SegmentIteratorWrapper::do_get_next()
@ 0x1aca8ab starrocks::vectorized::TimedChunkIterator::do_get_next()
@ 0x1ad0554 starrocks::vectorized::UnionIterator::do_get_next()
@ 0x1ac330e starrocks::vectorized::TabletReader::do_get_next()
@ 0x27089a4 starrocks::vectorized::TabletScanner::get_chunk()
@ 0x242bc15 starrocks::vectorized::OlapScanNode::_scanner_thread()
@ 0x1e16820 starrocks::PriorityThreadPool::work_thread()
@ 0x3c52c07 thread_proxy
@ 0x7f001c850e25 start_thread
@ 0x7f001be6cbad __clone
@ 0x0 (unknown)
【背景】
执行查询语句
insert into dmp_dev.t_bitmap
(
project_version,
tag_version,
tag_name,
tag_value,
ids,
tag_wight,
tag_time
)
select
1639612800000,
tag_version,
tag_name,
if(
cast(tag_value as string) is null
or cast(tag_value as string) = ‘’,
‘默认值’,
cast(tag_value as string)
) as tag_value,
bitmap_union(to_bitmap(id)) as id,
tag_wight,
max(tag_time)
from
dmp_dev_mid.t_base_narrow_20220920114136
where
project_version = 1639612800000
and (
(
tag_name = ‘first_login_media’
and tag_version = 3121663553451
)
)
group by
tag_version,
tag_name,
tag_value,
tag_wight
;
就报错，有时候会报错，有时不报错；已经出现过两次了，导致多个节点挂掉
并行度：
show variables like ‘%parallel_fragment_exec_instance_num%’;
±------------------------------------±------+
| Variable_name | Value |
±------------------------------------±------+
| parallel_fragment_exec_instance_num | 8 |
±------------------------------------±------+
cbo是否开启：
show variables like ‘%cbo%’;
±------------------------------------±------+
| Variable_name | Value |
±------------------------------------±------+
| cbo_cte_reuse | false |
| cbo_enable_dp_join_reorder | true |
| cbo_enable_greedy_join_reorder | true |
| cbo_enable_low_cardinality_optimize | true |
| cbo_enable_replicated_join | true |
| cbo_max_reorder_node_use_dp | 10 |
| cbo_max_reorder_node_use_exhaustive | 4 |
| cbo_use_correlated_join_estimate | true |
±------------------------------------±------+
【StarRocks版本】2.2.5