start time: Wed Mar 25 03:54:53 PM CST 2026, server uptime: 15:54:53 up 134 days, 17:50, 2 users, load average: 3.31, 3.56, 3.94
3.3.20 RELEASE (build bc0523a distro ubuntu arch x86_64)
query_id:d0b216c6-2d58-11f1-a0a9-200522001340, fragment_instance:d0b216c6-2d58-11f1-a0a9-200522001352
tracker:process consumption: 38968898504
tracker:jemalloc_metadata consumption: 1401616704
tracker:query_pool consumption: 124003048
tracker:query_pool/connector_scan consumption: 0
tracker:load consumption: 0
tracker:metadata consumption: 5728931731
tracker:tablet_metadata consumption: 1312439180
tracker:rowset_metadata consumption: 509701804
tracker:segment_metadata consumption: 402267105
tracker:column_metadata consumption: 3504523642
tracker:tablet_schema consumption: 1667292
tracker:segment_zonemap consumption: 305598573
tracker:short_key_index consumption: 13558630
tracker:column_zonemap_index consumption: 530761538
tracker:ordinal_index consumption: 1040639552
tracker:bitmap_index consumption: 62127264
tracker:bloom_filter_index consumption: 27929272
tracker:compaction consumption: 0
tracker:schema_change consumption: 0
tracker:column_pool consumption: 0
tracker:page_cache consumption: 22064382512
tracker:jit_cache consumption: 0
tracker:update consumption: 4702467339
tracker:chunk_allocator consumption: 0
tracker:passthrough consumption: 0
tracker:clone consumption: 0
tracker:consistency consumption: 0
tracker:datacache consumption: 0
tracker:replication consumption: 0
*** Aborted at 1774999491 (unix time) try "date -d @1774999491" if you are using GNU date ***
PC: @ 0x6638f2e starrocks::ColumnReader::_parse_zone_map(starrocks::LogicalType, starrocks::ZoneMapPB const&, starrocks::ZoneMapDetail*) const
*** SIGSEGV (@0x7effa2dcea68) received by PID 149125 (TID 0x7fe3cc1c3640) from PID 18446744072146971240; stack trace: ***
@ 0x7fe57dc1eee8 (/usr/lib/x86_64-linux-gnu/libc.so.6+0x99ee7)
@ 0xa2eb389 google::(anonymous namespace)::FailureSignalHandler(int, siginfo_t*, void*)
@ 0x7fe57dbc7520 (/usr/lib/x86_64-linux-gnu/libc.so.6+0x4251f)
@ 0x6638f2e starrocks::ColumnReader::_parse_zone_map(starrocks::LogicalType, starrocks::ZoneMapPB const&, starrocks::ZoneMapDetail*) const
@ 0x66392bd starrocks::ColumnReader::segment_zone_map_filter(std::vector<starrocks::ColumnPredicate const*, std::allocator<starrocks::ColumnPredicate const*> > const&) const
@ 0x662c719 starrocks::Segment::_new_iterator(starrocks::Schema const&, starrocks::SegmentReadOptions const&)
@ 0x662cac3 starrocks::Segment::new_iterator(starrocks::Schema const&, starrocks::SegmentReadOptions const&)
@ 0x661b43c starrocks::Rowset::get_segment_iterators(starrocks::Schema const&, starrocks::RowsetReadOptions const&, std::vector<std::shared_ptr<starrocks::ChunkIterator>, std::allocator<std::shared_ptr<starrocks::ChunkIterator> > >*)
@ 0x6d4edf9 starrocks::TabletReader::get_segment_iterators(starrocks::TabletReaderParams const&, std::vector<std::shared_ptr<starrocks::ChunkIterator>, std::allocator<std::shared_ptr<starrocks::ChunkIterator> > >*)
@ 0x6d4f605 starrocks::TabletReader::_init_collector(starrocks::TabletReaderParams const&)
@ 0x6d50cda starrocks::TabletReader::open(starrocks::TabletReaderParams const&)
@ 0x78635f4 starrocks::pipeline::OlapChunkSource::_init_olap_reader(starrocks::RuntimeState*)
@ 0x7863abd starrocks::pipeline::OlapChunkSource::prepare(starrocks::RuntimeState*)
@ 0x54280a8 starrocks::pipeline::ScanOperator::_pickup_morsel(starrocks::RuntimeState*, int)
@ 0x542659c starrocks::pipeline::ScanOperator::_try_to_trigger_next_scan(starrocks::RuntimeState*)
@ 0x542682a starrocks::pipeline::ScanOperator::pull_chunk(starrocks::RuntimeState*)
@ 0x541d898 starrocks::pipeline::PipelineDriver::process(starrocks::RuntimeState*, int)
@ 0x7eb3f68 starrocks::pipeline::GlobalDriverExecutor::_worker_thread()
@ 0x8bfe683 starrocks::ThreadPool::dispatch_thread()
@ 0x8bf5489 starrocks::Thread::supervise_thread(void*)
@ 0x7fe57dc19ac3 (/usr/lib/x86_64-linux-gnu/libc.so.6+0x94ac2)
@ 0x7fe57dcab8d0 (/usr/lib/x86_64-linux-gnu/libc.so.6+0x1268cf)
start time: Wed Apr 15 03:31:41 PM CST 2026, server uptime: 15:31:41 up 155 days, 17:27, 3 users, load average: 1.65, 2.84, 3.44
F20260418 23:25:01.517191 140398051591744 logical_type_infra.h:170] Check failed: false Unknown type: 1835884903
3.3.20 RELEASE (build bc0523a distro ubuntu arch x86_64)
query_id:c38437c8-3b3a-11f1-a0a9-200522001340, fragment_instance:c38437c8-3b3a-11f1-a0a9-200522001356
tracker:process consumption: 43902338312
tracker:jemalloc_metadata consumption: 1313863760
tracker:query_pool consumption: 81320272
tracker:query_pool/connector_scan consumption: 0
tracker:load consumption: 0
tracker:metadata consumption: 10837384228
tracker:tablet_metadata consumption: 1330946036
tracker:rowset_metadata consumption: 1149131873
tracker:segment_metadata consumption: 1056656017
tracker:column_metadata consumption: 7300650302
tracker:tablet_schema consumption: 1664132
tracker:segment_zonemap consumption: 893524702
tracker:short_key_index consumption: 10447338
tracker:column_zonemap_index consumption: 1619585254
tracker:ordinal_index consumption: 1723358464
tracker:bitmap_index consumption: 228626816
tracker:bloom_filter_index consumption: 88235032
tracker:compaction consumption: 1655392
tracker:schema_change consumption: 0
tracker:column_pool consumption: 0
tracker:page_cache consumption: 22003944432
tracker:jit_cache consumption: 0
tracker:update consumption: 3437184430
tracker:chunk_allocator consumption: 0
tracker:passthrough consumption: 0
tracker:clone consumption: 0
tracker:consistency consumption: 0
tracker:datacache consumption: 0
tracker:replication consumption: 0
*** Aborted at 1776525901 (unix time) try "date -d @1776525901" if you are using GNU date ***
PC: @ 0x7fb2c55149fc pthread_kill
*** SIGABRT (@0x301f2) received by PID 197106 (TID 0x7fb0f7fe0640) from PID 197106; stack trace: ***
@ 0x7fb2c5517ee8 (/usr/lib/x86_64-linux-gnu/libc.so.6+0x99ee7)
@ 0xa2eb389 google::(anonymous namespace)::FailureSignalHandler(int, siginfo_t*, void*)
@ 0x7fb2c54c0520 (/usr/lib/x86_64-linux-gnu/libc.so.6+0x4251f)
@ 0x7fb2c55149fc pthread_kill
@ 0x7fb2c54c0476 raise
@ 0x7fb2c54a67f3 abort
@ 0x8a670c7 starrocks::failure_function()
@ 0xa2deb1e google::LogMessage::Fail()
@ 0xa2dfd99 google::LogMessageFatal::~LogMessageFatal()
@ 0x54db5de auto starrocks::type_dispatch_column<starrocks::ColumnBuilder, starrocks::TypeDescriptor, unsigned long>(starrocks::LogicalType, starrocks::ColumnBuilder, starrocks::TypeDescriptor, unsigned long)
@ 0x54d5d48 starrocks::ColumnHelper::create_column(starrocks::TypeDescriptor const&, bool, bool, unsigned long, bool)
@ 0x54d6d20 starrocks::ColumnHelper::create_column(starrocks::TypeDescriptor const&, bool)
@ 0x75934a8 starrocks::CastColumnIterator::CastColumnIterator(std::unique_ptr<starrocks::ColumnIterator, std::default_delete<starrocks::ColumnIterator> >, starrocks::TypeDescriptor const&, starrocks::TypeDescriptor const&, bool)
@ 0x662d462 starrocks::Segment::new_column_iterator_or_default(starrocks::TabletColumn const&, starrocks::ColumnAccessPath*)
@ 0x759ee88 starrocks::SegmentIterator::_init_column_iterator_by_cid(unsigned int, int, bool)
@ 0x75b6cf6 starrocks::Status starrocks::SegmentIterator::_init_column_iterators<true>(starrocks::Schema const&)
@ 0x75a84ab starrocks::SegmentIterator::_init()
@ 0x75a8d03 starrocks::SegmentIterator::do_get_next(starrocks::Chunk*)
@ 0x6620788 starrocks::SegmentIteratorWrapper::do_get_next(starrocks::Chunk*)
@ 0x706a943 starrocks::TimedChunkIterator::do_get_next(starrocks::Chunk*)
@ 0x706e35f starrocks::UnionIterator::do_get_next(starrocks::Chunk*)
@ 0x6d50d8f starrocks::TabletReader::do_get_next(starrocks::Chunk*)
@ 0x7863e18 starrocks::pipeline::OlapChunkSource::_read_chunk_from_storage(starrocks::RuntimeState*, starrocks::Chunk*)
@ 0x78645ff starrocks::pipeline::OlapChunkSource::_read_chunk(starrocks::RuntimeState*, std::shared_ptr<starrocks::Chunk>*)
@ 0x76de70f starrocks::pipeline::ChunkSource::buffer_next_batch_chunks_blocking(starrocks::RuntimeState*, unsigned long, starrocks::workgroup::WorkGroup const*)
@ 0x5428f6f auto starrocks::pipeline::ScanOperator::_trigger_next_scan(starrocks::RuntimeState*, int)::{lambda(auto:1&)#1}::operator()<starrocks::workgroup::YieldContext>(starrocks::workgroup::YieldContext&) const [clone .constprop.0]
@ 0x5406a7e starrocks::workgroup::ScanExecutor::worker_thread()
@ 0x8bfe683 starrocks::ThreadPool::dispatch_thread()
@ 0x8bf5489 starrocks::Thread::supervise_thread(void*)
@ 0x7fb2c5512ac3 (/usr/lib/x86_64-linux-gnu/libc.so.6+0x94ac2)
@ 0x7fb2c55a48d0 (/usr/lib/x86_64-linux-gnu/libc.so.6+0x1268cf)
64节点隔一段时间就会挂掉重启
grep -aRin “c38437c8-3b3a-11f1-a0a9-200522001340” /opt/datasophon/starrocks/fe/log/fe.audit.log*
/opt/datasophon/starrocks/fe/log/fe.audit.log.20260418-1:173158:2026-04-18 23:25:30.886+08:00 [slow_query] |Timestamp=1776525900477|Client=|User=zhangjie|AuthorizedUser=|ResourceGroup=default_wg|Catalog=default_catalog|Db=dws|State=ERR|ErrorCode=ANALYSIS_ERR|Time=30409|ScanBytes=2204343|ScanRows=3480|ReturnRows=0|CpuCostNs=891641171|MemCostBytes=214696928|StmtId=4944056|QueryId=c38437c8-3b3a-11f1-a0a9-200522001340|IsQuery=false|feIp=10.1.1.65|Stmt=INSERT INTO dws.dws_video_product_detail (platform, product_id, video_id, product_name, cover, product_url, shop_id, shop_name, desc, nickname, signature, avatar_larger, following_count, video_cover, content_url, digg_count, create_time, duration, comment_count, share_count, collect_count, is_delete, etl_date) SELECT ‘dy’ platform, t.product_id , t.video_id, t.title, cover , detail_url, coalesce(t2.shop_id, t.shop_id) shop_id, t2.shop_name, t1.desc, nickname, author_signature as signature, author_avatar_larger as avatar_larger, author_following_count as following_count, preview_pic, content_url, t1.digg_count, t1.create_time, t1.duration, coalesce(t.comment_count, t1.comment_count) comment_count, t1.share_count, t1.collect_count, coalesce(is_on_sales, 0) as is_delete, t.etl_date FROM tds.tds_dy_product_detail_v2 t left join dws.dws_video_basic_info_d t1 on t.video_id = t1.video_id join dws.dws_cps_product_base_info t2 on t.product_id = t2.product_id left join ods.ods_dy_video_details_info t3 on t.video_id =t3.aweme_id where t2.platform=‘dyc’ and date_format(t.etl_date, ‘%Y%m%d%H’) = ‘2026041822’|Digest=|PlanCpuCost=2.2234518529206808E11|PlanMemCost=2.050522482131239E7|Warehouse=default_warehouse|IsForwardToLeader=false|QueryFEAllocatedMemory=100715144
/opt/datasophon/starrocks/fe/log/fe.audit.log.20260418-1:173159:2026-04-18 23:25:30.886+08:00 [query] |Timestamp=1776525900477|Client=|User=zhangjie|AuthorizedUser=|ResourceGroup=default_wg|Catalog=default_catalog|Db=dws|State=ERR|ErrorCode=ANALYSIS_ERR|Time=30409|ScanBytes=2204343|ScanRows=3480|ReturnRows=0|CpuCostNs=891641171|MemCostBytes=214696928|StmtId=4944056|QueryId=c38437c8-3b3a-11f1-a0a9-200522001340|IsQuery=false|feIp=10.1.1.65|Stmt=INSERT INTO dws.dws_video_product_detail (platform, product_id, video_id, product_name, cover, product_url, shop_id, shop_name, desc, nickname, signature, avatar_larger, following_count, video_cover, content_url, digg_count, create_time, duration, comment_count, share_count, collect_count, is_delete, etl_date) SELECT ‘dy’ platform, t.product_id , t.video_id, t.title, cover , detail_url, coalesce(t2.shop_id, t.shop_id) shop_id, t2.shop_name, t1.desc, nickname, author_signature as signature, author_avatar_larger as avatar_larger, author_following_count as following_count, preview_pic, content_url, t1.digg_count, t1.create_time, t1.duration, coalesce(t.comment_count, t1.comment_count) comment_count, t1.share_count, t1.collect_count, coalesce(is_on_sales, 0) as is_delete, t.etl_date FROM tds.tds_dy_product_detail_v2 t left join dws.dws_video_basic_info_d t1 on t.video_id = t1.video_id join dws.dws_cps_product_base_info t2 on t.product_id = t2.product_id left join ods.ods_dy_video_details_info t3 on t.video_id =t3.aweme_id where t2.platform=‘dyc’ and date_format(t.etl_date, ‘%Y%m%d%H’) = ‘2026041822’|Digest=|PlanCpuCost=2.2234518529206808E11|PlanMemCost=2.050522482131239E7|Warehouse=default_warehouse|IsForwardToLeader=false|QueryFEAllocatedMemory=100715144
预格式化文本将缩进 4 格[be.out|attachment](upload://t4c4LPYbVgpJ5pA2iiYVClmBzcF.out) (9.1 KB)