be节点column_aggregate_func报错挂掉

3fe3be的集群,其中一个be节点异常挂掉,
版本3.1.6
日志如下,帮忙分析一下,谢谢:
F0814 15:02:13.101240 32573 column_aggregate_func.cpp:379] Check failed: false unreachable path, unknown key column type: 22
*** Check failure stack trace: ***
3.1.6 RELEASE (build fcc0c6b)
query_id:00000000-0000-0000-0000-000000000000, fragment_instance:00000000-0000-0000-0000-000000000000
tracker:process consumption: 14746675056
tracker:query_pool consumption: 0
tracker:load consumption: 9648
tracker:metadata consumption: 12312649
tracker:tablet_metadata consumption: 2696696
tracker:rowset_metadata consumption: 132951
tracker:segment_metadata consumption: 109098
tracker:column_metadata consumption: 9373904
tracker:tablet_schema consumption: 135272
tracker:segment_zonemap consumption: 72180
tracker:short_key_index consumption: 684
tracker:column_zonemap_index consumption: 334928
tracker:ordinal_index consumption: 8633288
tracker:bitmap_index consumption: 0
tracker:bloom_filter_index consumption: 0
tracker:compaction consumption: 0
tracker:schema_change consumption: 0
tracker:column_pool consumption: 2102115830
tracker:page_cache consumption: 9946020208
tracker:update consumption: 383822
tracker:chunk_allocator consumption: 2147671120
tracker:clone consumption: 0
tracker:consistency consumption: 0
*** Aborted at 1723618933 (unix time) try “date -d @1723618933” if you are using GNU date ***
PC: @ 0x7fedbeafa387 __GI_raise
*** SIGABRT (@0x7e5a) received by PID 32346 (TID 0x7fed94ff0700) from PID 32346; stack trace: ***
@ 0x63bc462 google::(anonymous namespace)::FailureSignalHandler()
@ 0x7fedbf7c9630 (unknown)
@ 0x7fedbeafa387 __GI_raise
@ 0x7fedbeafba78 __GI_abort
@ 0x2a274de starrocks::failure_function()
@ 0x63afe3d google::LogMessage::Fail()
@ 0x63b22af google::LogMessage::SendToLog()
@ 0x63af98e google::LogMessage::Flush()
@ 0x63b28b9 google::LogMessageFatal::~LogMessageFatal()
@ 0x4cdf972 starrocks::create_value_aggregator()
@ 0x4ce01c1 starrocks::ColumnAggregatorFactory::create_value_column_aggregator()
@ 0x4763261 starrocks::ChunkAggregator::ChunkAggregator()
@ 0x4764765 starrocks::MemTable::_init_aggregator_if_needed()
@ 0x47649e5 starrocks::MemTable::MemTable()
@ 0x4cf0b3b starrocks::DeltaWriter::_reset_mem_table()
@ 0x4cf23e9 starrocks::DeltaWriter::write()
@ 0x59681e7 starrocks::AsyncDeltaWriter::_execute()
@ 0x6517eec bthread::ExecutionQueueBase::_execute()
@ 0x6518c68 bthread::ExecutionQueueBase::_execute_tasks()
@ 0x4fa7de2 starrocks::ThreadPool::dispatch_thread()
@ 0x4fa287a starrocks::thread::supervise_thread()
@ 0x7fedbf7c1ea5 start_thread
@ 0x7fedbebc2b0d __clone
@ 0x0 (unknown)

grep F0814 be.INFO

F0814 15:02:13.101240 32573 column_aggregate_func.cpp:379] Check failed: false unreachable path, unknown key column type: 22

就只有这一行

https://github.com/StarRocks/starrocks/pull/49528 应该是这个问题,刚修复

可能还不太是同一类问题,目前没用物化视图呢
且那个bug里提供的语句也不好复现呢

发下be.info这个错误附近的日志看看。

有用什么聚合表吗

I0814 15:02:00.662212 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1a65bdc0-5a0b-11ef-bd9e-02429b1504da
I0814 15:02:00.679508 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1a65bdc0-5a0b-11ef-bd9e-02429b1504dc
I0814 15:02:00.704337 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1a65bdc0-5a0b-11ef-bd9e-02429b1504de
I0814 15:02:00.840821 32740 fragment_executor.cpp:176] Prepare(): query_id=1a8309c4-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1a8309c4-5a0b-11ef-bd9e-02429b1504db is_stream_pipeline=0 backend_num=4
I0814 15:02:00.843655 33078 jdbc_driver_manager.cpp:162] driver[jdbc:postgresql:99.99.11.55:5432_dw] already exists
I0814 15:02:00.847697 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1a8309c4-5a0b-11ef-bd9e-02429b1504db
I0814 15:02:01.217464 32721 fragment_executor.cpp:176] Prepare(): query_id=1ac6c986-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1ac6c986-5a0b-11ef-bd9e-02429b1504da is_stream_pipeline=0 backend_num=0
I0814 15:02:01.218072 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1ac6c986-5a0b-11ef-bd9e-02429b1504da
I0814 15:02:01.225469 32713 fragment_executor.cpp:176] Prepare(): query_id=1ac7dafd-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1ac7dafd-5a0b-11ef-bd9e-02429b1504da is_stream_pipeline=0 backend_num=0
I0814 15:02:01.228117 32874 pipeline_driver_executor.cpp:318] [Driver] Fail to report exec state due to query not found: fragment_instance_id=1ac7dafd-5a0b-11ef-bd9e-02429b1504da
I0814 15:02:01.244123 32716 fragment_executor.cpp:176] Prepare(): query_id=1acae846-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1acae846-5a0b-11ef-bd9e-02429b1504da is_stream_pipeline=0 backend_num=0
I0814 15:02:01.245249 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1acae846-5a0b-11ef-bd9e-02429b1504da
I0814 15:02:01.267886 32741 fragment_executor.cpp:176] Prepare(): query_id=1ac765cc-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1ac765cc-5a0b-11ef-bd9e-02429b1504de is_stream_pipeline=0 backend_num=0
I0814 15:02:01.277676 32758 fragment_executor.cpp:176] Prepare(): query_id=1acfa340-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1acfa340-5a0b-11ef-bd9e-02429b1504da is_stream_pipeline=0 backend_num=0
I0814 15:02:01.277694 32751 fragment_executor.cpp:176] Prepare(): query_id=1acff161-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1acff161-5a0b-11ef-bd9e-02429b1504da is_stream_pipeline=0 backend_num=0
I0814 15:02:01.277789 32732 fragment_executor.cpp:176] Prepare(): query_id=1ac765cc-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1ac765cc-5a0b-11ef-bd9e-02429b1504dc is_stream_pipeline=0 backend_num=2
I0814 15:02:01.278560 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1acff161-5a0b-11ef-bd9e-02429b1504da
I0814 15:02:01.287324 32726 fragment_executor.cpp:176] Prepare(): query_id=1ac9d6d1-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1ac9d6d1-5a0b-11ef-bd9e-02429b1504de is_stream_pipeline=0 backend_num=0
I0814 15:02:01.292315 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1acfa340-5a0b-11ef-bd9e-02429b1504da
I0814 15:02:01.293375 32724 fragment_executor.cpp:176] Prepare(): query_id=1ac73eba-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1ac73eba-5a0b-11ef-bd9e-02429b1504db is_stream_pipeline=0 backend_num=4
I0814 15:02:01.293397 32742 fragment_executor.cpp:176] Prepare(): query_id=1ac765cc-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1ac765cc-5a0b-11ef-bd9e-02429b1504da is_stream_pipeline=0 backend_num=3
I0814 15:02:01.296139 32724 fragment_executor.cpp:176] Prepare(): query_id=1acb0f58-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1acb0f58-5a0b-11ef-bd9e-02429b1504de is_stream_pipeline=0 backend_num=0
I0814 15:02:01.296348 33074 jdbc_driver_manager.cpp:162] driver[jdbc:postgresql:99.99.11.55:5432_dw] already exists
I0814 15:02:01.296382 32974 jdbc_driver_manager.cpp:162] driver[oracle_ds] already exists
I0814 15:02:01.299026 32752 fragment_executor.cpp:176] Prepare(): query_id=1ac9d6d1-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1ac9d6d1-5a0b-11ef-bd9e-02429b1504dc is_stream_pipeline=0 backend_num=2
I0814 15:02:01.301700 32723 fragment_executor.cpp:176] Prepare(): query_id=1ac9d6d0-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1ac9d6d0-5a0b-11ef-bd9e-02429b1504db is_stream_pipeline=0 backend_num=4
I0814 15:02:01.302942 45868 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1ac765cc-5a0b-11ef-bd9e-02429b1504da
I0814 15:02:01.303563 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1ac73eba-5a0b-11ef-bd9e-02429b1504db
I0814 15:02:01.304428 33021 jdbc_driver_manager.cpp:162] driver[jdbc:postgresql:99.99.11.55:5432_dw] already exists
I0814 15:02:01.306751 32764 fragment_executor.cpp:176] Prepare(): query_id=1acb0f58-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1acb0f58-5a0b-11ef-bd9e-02429b1504dc is_stream_pipeline=0 backend_num=2
I0814 15:02:01.310406 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1ac9d6d0-5a0b-11ef-bd9e-02429b1504db
I0814 15:02:01.310712 32709 fragment_executor.cpp:176] Prepare(): query_id=1ac9d6d1-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1ac9d6d1-5a0b-11ef-bd9e-02429b1504da is_stream_pipeline=0 backend_num=3
I0814 15:02:01.311323 32745 fragment_executor.cpp:176] Prepare(): query_id=1aca7315-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1aca7315-5a0b-11ef-bd9e-02429b1504db is_stream_pipeline=0 backend_num=4
I0814 15:02:01.312008 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1ac765cc-5a0b-11ef-bd9e-02429b1504dc
I0814 15:02:01.313115 32969 jdbc_driver_manager.cpp:162] driver[oracle_ds] already exists
I0814 15:02:01.313887 33220 jdbc_driver_manager.cpp:162] driver[jdbc:postgresql:99.99.11.55:5432_dw] already exists
I0814 15:02:01.316386 32715 fragment_executor.cpp:176] Prepare(): query_id=1acb0f58-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1acb0f58-5a0b-11ef-bd9e-02429b1504da is_stream_pipeline=0 backend_num=3
I0814 15:02:01.316623 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1ac9d6d1-5a0b-11ef-bd9e-02429b1504da
I0814 15:02:01.317457 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1aca7315-5a0b-11ef-bd9e-02429b1504db
I0814 15:02:01.319160 33295 jdbc_driver_manager.cpp:162] driver[oracle_ds] already exists
I0814 15:02:01.321448 32733 fragment_executor.cpp:176] Prepare(): query_id=1ad6811c-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1ad6811c-5a0b-11ef-bd9e-02429b1504da is_stream_pipeline=0 backend_num=0
I0814 15:02:01.324280 32874 pipeline_driver_executor.cpp:318] [Driver] Fail to report exec state due to query not found: fragment_instance_id=1ad6811c-5a0b-11ef-bd9e-02429b1504da
I0814 15:02:01.324596 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1acb0f58-5a0b-11ef-bd9e-02429b1504da
I0814 15:02:01.328269 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1ac765cc-5a0b-11ef-bd9e-02429b1504de
I0814 15:02:01.373050 45868 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1ac9d6d1-5a0b-11ef-bd9e-02429b1504de
I0814 15:02:01.373224 45868 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1acb0f58-5a0b-11ef-bd9e-02429b1504dc
I0814 15:02:01.374228 45868 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1acb0f58-5a0b-11ef-bd9e-02429b1504de
I0814 15:02:01.374289 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1ac9d6d1-5a0b-11ef-bd9e-02429b1504dc
I0814 15:02:01.379467 32744 fragment_executor.cpp:176] Prepare(): query_id=1adfa8e7-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1adfa8e7-5a0b-11ef-bd9e-02429b1504da is_stream_pipeline=0 backend_num=0
I0814 15:02:01.379832 32744 fragment_executor.cpp:176] Prepare(): query_id=1adfa8ec-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1adfa8ec-5a0b-11ef-bd9e-02429b1504da is_stream_pipeline=0 backend_num=0
I0814 15:02:01.380018 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1adfa8e7-5a0b-11ef-bd9e-02429b1504da
I0814 15:02:01.380236 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1adfa8ec-5a0b-11ef-bd9e-02429b1504da
I0814 15:02:01.394269 32734 fragment_executor.cpp:176] Prepare(): query_id=1adff714-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1adff714-5a0b-11ef-bd9e-02429b1504dc is_stream_pipeline=0 backend_num=2
I0814 15:02:01.396751 33217 jdbc_driver_manager.cpp:162] driver[oracle_ds] already exists
I0814 15:02:01.400223 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1adff714-5a0b-11ef-bd9e-02429b1504dc
I0814 15:02:01.424711 32749 fragment_executor.cpp:176] Prepare(): query_id=1ad632fa-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1ad632fa-5a0b-11ef-bd9e-02429b1504de is_stream_pipeline=0 backend_num=0
I0814 15:02:01.428066 32755 fragment_executor.cpp:176] Prepare(): query_id=1ad6f64e-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1ad6f64e-5a0b-11ef-bd9e-02429b1504dd is_stream_pipeline=0 backend_num=1
I0814 15:02:01.429433 32761 fragment_executor.cpp:176] Prepare(): query_id=1ad807c5-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1ad807c5-5a0b-11ef-bd9e-02429b1504dd is_stream_pipeline=0 backend_num=1
I0814 15:02:01.440491 32731 fragment_executor.cpp:176] Prepare(): query_id=1ae04538-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1ae04538-5a0b-11ef-bd9e-02429b1504de is_stream_pipeline=0 backend_num=0
I0814 15:02:01.445255 32760 fragment_executor.cpp:176] Prepare(): query_id=1ae01e26-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1ae01e26-5a0b-11ef-bd9e-02429b1504dd is_stream_pipeline=0 backend_num=1
I0814 15:02:01.447190 32743 fragment_executor.cpp:176] Prepare(): query_id=1ad6f64e-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1ad6f64e-5a0b-11ef-bd9e-02429b1504db is_stream_pipeline=0 backend_num=4
I0814 15:02:01.450062 33248 jdbc_driver_manager.cpp:162] driver[jdbc:postgresql:99.99.11.55:5432_dw] already exists
I0814 15:02:01.452780 32756 fragment_executor.cpp:176] Prepare(): query_id=1ae04538-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1ae04538-5a0b-11ef-bd9e-02429b1504dc is_stream_pipeline=0 backend_num=2
I0814 15:02:01.452816 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1ad6f64e-5a0b-11ef-bd9e-02429b1504db
I0814 15:02:01.453002 32727 fragment_executor.cpp:176] Prepare(): query_id=1adff713-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1adff713-5a0b-11ef-bd9e-02429b1504db is_stream_pipeline=0 backend_num=4
I0814 15:02:01.456132 33221 jdbc_driver_manager.cpp:162] driver[jdbc:postgresql:99.99.11.55:5432_dw] already exists
I0814 15:02:01.460070 32730 fragment_executor.cpp:176] Prepare(): query_id=1ae04538-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1ae04538-5a0b-11ef-bd9e-02429b1504da is_stream_pipeline=0 backend_num=3
I0814 15:02:01.463131 33169 jdbc_driver_manager.cpp:162] driver[oracle_ds] already exists
I0814 15:02:01.463297 45868 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1adff713-5a0b-11ef-bd9e-02429b1504db
I0814 15:02:01.463397 45868 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1ad807c5-5a0b-11ef-bd9e-02429b1504dd
I0814 15:02:01.467864 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1ae04538-5a0b-11ef-bd9e-02429b1504da
I0814 15:02:01.469087 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1ad632fa-5a0b-11ef-bd9e-02429b1504de
I0814 15:02:01.478405 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1ad6f64e-5a0b-11ef-bd9e-02429b1504dd
I0814 15:02:01.483704 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1ae01e26-5a0b-11ef-bd9e-02429b1504dd
I0814 15:02:01.483937 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1ae04538-5a0b-11ef-bd9e-02429b1504dc
I0814 15:02:01.493834 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1ae04538-5a0b-11ef-bd9e-02429b1504de
I0814 15:02:02.732791 32735 fragment_executor.cpp:176] Prepare(): query_id=1ba59112-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1ba59112-5a0b-11ef-bd9e-02429b1504de is_stream_pipeline=0 backend_num=0
I0814 15:02:02.746457 32748 fragment_executor.cpp:176] Prepare(): query_id=1ba59112-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1ba59112-5a0b-11ef-bd9e-02429b1504dc is_stream_pipeline=0 backend_num=2
I0814 15:02:02.752909 32736 fragment_executor.cpp:176] Prepare(): query_id=1ba59112-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1ba59112-5a0b-11ef-bd9e-02429b1504da is_stream_pipeline=0 backend_num=3
I0814 15:02:02.755012 33224 jdbc_driver_manager.cpp:162] driver[oracle_ds] already exists
I0814 15:02:02.759038 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1ba59112-5a0b-11ef-bd9e-02429b1504da
I0814 15:02:02.764581 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1ba59112-5a0b-11ef-bd9e-02429b1504dc
I0814 15:02:02.776259 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1ba59112-5a0b-11ef-bd9e-02429b1504de
I0814 15:02:05.533922 32763 fragment_executor.cpp:176] Prepare(): query_id=1d47a856-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1d47a856-5a0b-11ef-bd9e-02429b1504e6 is_stream_pipeline=0 backend_num=6
I0814 15:02:05.536443 33079 jdbc_driver_manager.cpp:162] driver[oracle_ets] already exists
I0814 15:02:05.548096 32718 fragment_executor.cpp:176] Prepare(): query_id=1d47a856-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1d47a856-5a0b-11ef-bd9e-02429b1504e1 is_stream_pipeline=0 backend_num=11
I0814 15:02:05.551038 32980 jdbc_driver_manager.cpp:162] driver[oracle_rs] already exists
I0814 15:02:05.559614 32762 fragment_executor.cpp:176] Prepare(): query_id=1d47a856-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1d47a856-5a0b-11ef-bd9e-02429b1504db is_stream_pipeline=0 backend_num=15
I0814 15:02:05.562629 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1d47a856-5a0b-11ef-bd9e-02429b1504e6
I0814 15:02:05.562631 46689 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1d47a856-5a0b-11ef-bd9e-02429b1504e1
I0814 15:02:05.582460 33012 jdbc_driver_manager.cpp:162] driver[oracle_ets] already exists
I0814 15:02:05.663810 46689 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1d47a856-5a0b-11ef-bd9e-02429b1504db
I0814 15:02:08.578512 32720 fragment_executor.cpp:176] Prepare(): query_id=1f2a23f8-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1f2a23f8-5a0b-11ef-bd9e-02429b1504da is_stream_pipeline=0 backend_num=0
I0814 15:02:08.579828 32874 pipeline_driver_executor.cpp:318] [Driver] Fail to report exec state due to query not found: fragment_instance_id=1f2a23f8-5a0b-11ef-bd9e-02429b1504da
I0814 15:02:09.273859 32722 fragment_executor.cpp:176] Prepare(): query_id=1f2a992a-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1f2a992a-5a0b-11ef-bd9e-02429b1504e2 is_stream_pipeline=0 backend_num=1
I0814 15:02:09.284075 32714 fragment_executor.cpp:176] Prepare(): query_id=1f2a992a-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1f2a992a-5a0b-11ef-bd9e-02429b1504e0 is_stream_pipeline=0 backend_num=7
I0814 15:02:09.284125 32712 fragment_executor.cpp:176] Prepare(): query_id=1f2a992a-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1f2a992a-5a0b-11ef-bd9e-02429b1504f9 is_stream_pipeline=0 backend_num=4
I0814 15:02:09.286520 33148 jdbc_driver_manager.cpp:162] driver[oracle_ets] already exists
I0814 15:02:09.293820 32719 fragment_executor.cpp:176] Prepare(): query_id=1f2a992a-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1f2a992a-5a0b-11ef-bd9e-02429b1504f5 is_stream_pipeline=0 backend_num=9
I0814 15:02:09.300077 32725 fragment_executor.cpp:176] Prepare(): query_id=1f2a992a-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1f2a992a-5a0b-11ef-bd9e-02429b1504ef is_stream_pipeline=0 backend_num=14
I0814 15:02:09.300109 32708 fragment_executor.cpp:176] Prepare(): query_id=1f2a992a-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1f2a992a-5a0b-11ef-bd9e-02429b1504f4 is_stream_pipeline=0 backend_num=17
I0814 15:02:09.302253 33157 jdbc_driver_manager.cpp:162] driver[oracle_rs] already exists
I0814 15:02:09.309152 32739 fragment_executor.cpp:176] Prepare(): query_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504e8 is_stream_pipeline=0 backend_num=0
I0814 15:02:09.317225 32759 fragment_executor.cpp:176] Prepare(): query_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504e4 is_stream_pipeline=0 backend_num=3
I0814 15:02:09.318590 32753 fragment_executor.cpp:176] Prepare(): query_id=1f2a992a-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1f2a992a-5a0b-11ef-bd9e-02429b1504ee is_stream_pipeline=0 backend_num=21
I0814 15:02:09.318607 32717 fragment_executor.cpp:176] Prepare(): query_id=1f2a992a-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1f2a992a-5a0b-11ef-bd9e-02429b1504dd is_stream_pipeline=0 backend_num=20
I0814 15:02:09.321394 33095 jdbc_driver_manager.cpp:162] driver[oracle_rs] already exists
I0814 15:02:09.333299 32740 fragment_executor.cpp:176] Prepare(): query_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504f9 is_stream_pipeline=0 backend_num=4
I0814 15:02:09.333384 32721 fragment_executor.cpp:176] Prepare(): query_id=1f2a992a-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1f2a992a-5a0b-11ef-bd9e-02429b1504df is_stream_pipeline=0 backend_num=25
I0814 15:02:09.336756 33242 jdbc_driver_manager.cpp:162] driver[jdbc:postgresql:99.99.10.42:5432_open] already exists
I0814 15:02:09.349980 32716 fragment_executor.cpp:176] Prepare(): query_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504da is_stream_pipeline=0 backend_num=13
I0814 15:02:09.349980 32713 fragment_executor.cpp:176] Prepare(): query_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504f5 is_stream_pipeline=0 backend_num=9
I0814 15:02:09.351624 32741 fragment_executor.cpp:176] Prepare(): query_id=1f2a992a-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1f2a992a-5a0b-11ef-bd9e-02429b1504e9 is_stream_pipeline=0 backend_num=33
I0814 15:02:09.352488 33071 jdbc_driver_manager.cpp:162] driver[oracle_ets] already exists
I0814 15:02:09.354956 33009 jdbc_driver_manager.cpp:162] driver[jdbc:postgresql:99.99.10.42:5432_openapi] already exists
I0814 15:02:09.355324 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1f2a992a-5a0b-11ef-bd9e-02429b1504f4
I0814 15:02:09.357277 32751 fragment_executor.cpp:176] Prepare(): query_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504ef is_stream_pipeline=0 backend_num=14
I0814 15:02:09.369561 32758 fragment_executor.cpp:176] Prepare(): query_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504dc is_stream_pipeline=0 backend_num=19
I0814 15:02:09.369594 32732 fragment_executor.cpp:176] Prepare(): query_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504f3 is_stream_pipeline=0 backend_num=23
I0814 15:02:09.372193 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1f2a992a-5a0b-11ef-bd9e-02429b1504e0
I0814 15:02:09.372212 33252 jdbc_driver_manager.cpp:162] driver[oracle_rs] already exists
I0814 15:02:09.385257 32726 fragment_executor.cpp:176] Prepare(): query_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504de is_stream_pipeline=0 backend_num=24
I0814 15:02:09.387537 33116 jdbc_driver_manager.cpp:162] driver[oracle_gatewayo32] already exists
I0814 15:02:09.398286 32742 fragment_executor.cpp:176] Prepare(): query_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504ec is_stream_pipeline=0 backend_num=30
I0814 15:02:09.401468 33268 jdbc_driver_manager.cpp:162] driver[jdbc:postgresql:99.99.10.42:5432_open] already exists
I0814 15:02:09.415571 32724 fragment_executor.cpp:176] Prepare(): query_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504e5 is_stream_pipeline=0 backend_num=32
I0814 15:02:09.418601 32958 jdbc_driver_manager.cpp:162] driver[jdbc:postgresql:99.99.10.42:5432_openapi] already exists
I0814 15:02:09.418869 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504da
I0814 15:02:09.418923 46901 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504de
I0814 15:02:09.419028 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1f2a992a-5a0b-11ef-bd9e-02429b1504ee
I0814 15:02:09.447382 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1f2a992a-5a0b-11ef-bd9e-02429b1504df
I0814 15:02:09.486481 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504ec
I0814 15:02:09.518903 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1f2a992a-5a0b-11ef-bd9e-02429b1504e9
I0814 15:02:09.520344 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504f3
I0814 15:02:09.666622 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1f2a992a-5a0b-11ef-bd9e-02429b1504dd
I0814 15:02:09.667333 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1f2a992a-5a0b-11ef-bd9e-02429b1504ef
I0814 15:02:09.668449 46901 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1f2a992a-5a0b-11ef-bd9e-02429b1504f9
I0814 15:02:09.668967 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1f2a992a-5a0b-11ef-bd9e-02429b1504f5
I0814 15:02:09.669489 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1f2a992a-5a0b-11ef-bd9e-02429b1504e2
I0814 15:02:09.768740 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504e5
I0814 15:02:09.811363 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504dc
I0814 15:02:09.811866 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504ef
I0814 15:02:09.812623 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504f5
I0814 15:02:09.813763 46901 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504f9
I0814 15:02:09.813789 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504e4
I0814 15:02:09.813922 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1f2dcd7d-5a0b-11ef-bd9e-02429b1504e8
I0814 15:02:09.833020 32482 daemon.cpp:211] Current memory statistics: process(14757391088), query_pool(-35138704), load(0), metadata(12311229), compaction(0), schema_change(0), column_pool(2102115830), page_cache(9946020208), update(383822), chunk_all
ocator(2147671120), clone(0), consistency(0)
I0814 15:02:09.972447 32710 fragment_executor.cpp:176] Prepare(): query_id=1ffd5282-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=1ffd5282-5a0b-11ef-bd9e-02429b1504dc is_stream_pipeline=0 backend_num=2
I0814 15:02:09.974871 33052 jdbc_driver_manager.cpp:162] driver[oracle_ds] already exists
I0814 15:02:09.987206 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=1ffd5282-5a0b-11ef-bd9e-02429b1504dc
I0814 15:02:10.058571 32723 fragment_executor.cpp:176] Prepare(): query_id=2002d0c6-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=2002d0c6-5a0b-11ef-bd9e-02429b1504de is_stream_pipeline=0 backend_num=0
I0814 15:02:10.069782 32752 fragment_executor.cpp:176] Prepare(): query_id=2002d0c6-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=2002d0c6-5a0b-11ef-bd9e-02429b1504dc is_stream_pipeline=0 backend_num=2
I0814 15:02:10.077543 32709 fragment_executor.cpp:176] Prepare(): query_id=2002d0c6-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=2002d0c6-5a0b-11ef-bd9e-02429b1504da is_stream_pipeline=0 backend_num=3
I0814 15:02:10.080248 33259 jdbc_driver_manager.cpp:162] driver[oracle_ds] already exists
I0814 15:02:10.086177 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=2002d0c6-5a0b-11ef-bd9e-02429b1504da
I0814 15:02:10.092829 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=2002d0c6-5a0b-11ef-bd9e-02429b1504dc
I0814 15:02:10.097162 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=2002d0c6-5a0b-11ef-bd9e-02429b1504de
I0814 15:02:10.196424 32745 fragment_executor.cpp:176] Prepare(): query_id=2014f93a-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=2014f93a-5a0b-11ef-bd9e-02429b1504db is_stream_pipeline=0 backend_num=4
I0814 15:02:10.199573 33261 jdbc_driver_manager.cpp:162] driver[jdbc:postgresql:99.99.11.55:5432_dw] already exists
I0814 15:02:10.202457 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=2014f93a-5a0b-11ef-bd9e-02429b1504db
I0814 15:02:10.795934 32764 fragment_executor.cpp:176] Prepare(): query_id=207c6d9c-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=207c6d9c-5a0b-11ef-bd9e-02429b1504da is_stream_pipeline=0 backend_num=0
I0814 15:02:10.796584 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=207c6d9c-5a0b-11ef-bd9e-02429b1504da
I0814 15:02:10.893780 32715 fragment_executor.cpp:176] Prepare(): query_id=207fef11-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=207fef11-5a0b-11ef-bd9e-02429b1504db is_stream_pipeline=0 backend_num=4
I0814 15:02:10.896545 33097 jdbc_driver_manager.cpp:162] driver[jdbc:postgresql:99.99.11.55:5432_dw] already exists
I0814 15:02:10.899210 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=207fef11-5a0b-11ef-bd9e-02429b1504db
I0814 15:02:10.913185 32733 fragment_executor.cpp:176] Prepare(): query_id=208e46f2-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=208e46f2-5a0b-11ef-bd9e-02429b1504da is_stream_pipeline=0 backend_num=0
I0814 15:02:10.913861 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=208e46f2-5a0b-11ef-bd9e-02429b1504da
I0814 15:02:10.953868 32744 fragment_executor.cpp:176] Prepare(): query_id=207d09de-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=207d09de-5a0b-11ef-bd9e-02429b1504e7 is_stream_pipeline=0 backend_num=3
I0814 15:02:10.956676 33050 jdbc_driver_manager.cpp:162] driver[jdbc:postgresql:99.99.10.42:5432_mgt] already exists
I0814 15:02:10.968667 32750 fragment_executor.cpp:176] Prepare(): query_id=207d09de-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=207d09de-5a0b-11ef-bd9e-02429b1504e2 is_stream_pipeline=0 backend_num=8
I0814 15:02:10.971339 33211 jdbc_driver_manager.cpp:162] driver[oracle_ets] already exists
I0814 15:02:10.981341 32734 fragment_executor.cpp:176] Prepare(): query_id=207d09de-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=207d09de-5a0b-11ef-bd9e-02429b1504dd is_stream_pipeline=0 backend_num=13
I0814 15:02:10.983631 33276 jdbc_driver_manager.cpp:162] driver[oracle_ds] already exists
I0814 15:02:11.020720 32749 fragment_executor.cpp:176] Prepare(): query_id=208ee334-5a0b-11ef-bd9e-02429b1504d9 fragment_instance_id=208ee334-5a0b-11ef-bd9e-02429b1504db is_stream_pipeline=0 backend_num=4
I0814 15:02:11.024046 32971 jdbc_driver_manager.cpp:162] driver[jdbc:postgresql:99.99.11.55:5432_dw] already exists
I0814 15:02:11.028590 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=208ee334-5a0b-11ef-bd9e-02429b1504db
I0814 15:02:11.159404 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=207d09de-5a0b-11ef-bd9e-02429b1504dd
I0814 15:02:11.187729 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=207d09de-5a0b-11ef-bd9e-02429b1504e7
I0814 15:02:12.322314 32874 pipeline_driver_executor.cpp:325] [Driver] Succeed to report exec state: fragment_instance_id=207d09de-5a0b-11ef-bd9e-02429b1504e2
I0814 15:02:13.101123 33565 local_tablets_channel.cpp:444] LocalTabletsChannel txn_id: 431305 load_id: 0d4f366d-e0dc-dcb8-ef24-c71d6d4f8eb9 commit 3 tablets: 138268,138262,138256
I0814 15:02:13.101325 32574 txn_manager.cpp:298] Commit txn successfully. tablet: 138268, txn_id: 431305, rowsetid: 02000000000402084f424dae2ed5c73e07919adc468a699f #segment:0 #delfile:0 #uptfiles:0
I0814 15:02:13.101374 32575 txn_manager.cpp:298] Commit txn successfully. tablet: 138256, txn_id: 431305, rowsetid: 02000000000402064f424dae2ed5c73e07919adc468a699f #segment:0 #delfile:0 #uptfiles:0
F0814 15:02:13.101240 32573 column_aggregate_func.cpp:379] Check failed: false unreachable path, unknown key column type: 22

搜索下日志文件,F0814 15:02:13.101240 32573 column_aggregate_func.cpp:379] Check failed: false unreachable path, unknown key column type: 22 这条日志前面的第一条有 32573 的日志

I0814 07:01:35.812101 32573 txn_manager.cpp:298] Commit txn successfully. tablet: 101957, txn_id: 431286, rowsetid: 02000000000401d04f424dae2ed5c73e07919adc468a699f #segment:1 #delfile:0 #uptfiles:0
I0814 07:01:36.116514 32573 txn_manager.cpp:298] Commit txn successfully. tablet: 101969, txn_id: 431287, rowsetid: 02000000000401d54f424dae2ed5c73e07919adc468a699f #segment:1 #delfile:0 #uptfiles:0
I0814 07:01:36.374233 32573 txn_manager.cpp:298] Commit txn successfully. tablet: 101969, txn_id: 431288, rowsetid: 02000000000401d84f424dae2ed5c73e07919adc468a699f #segment:1 #delfile:0 #uptfiles:0
I0814 07:01:36.694944 32573 txn_manager.cpp:298] Commit txn successfully. tablet: 101969, txn_id: 431289, rowsetid: 02000000000401db4f424dae2ed5c73e07919adc468a699f #segment:1 #delfile:0 #uptfiles:0
I0814 07:01:37.004503 32573 txn_manager.cpp:298] Commit txn successfully. tablet: 101963, txn_id: 431290, rowsetid: 02000000000401dd4f424dae2ed5c73e07919adc468a699f #segment:1 #delfile:0 #uptfiles:0
I0814 07:01:37.405968 32573 txn_manager.cpp:298] Commit txn successfully. tablet: 101957, txn_id: 431291, rowsetid: 02000000000401df4f424dae2ed5c73e07919adc468a699f #segment:1 #delfile:0 #uptfiles:0
I0814 07:01:37.766863 32573 txn_manager.cpp:298] Commit txn successfully. tablet: 101957, txn_id: 431292, rowsetid: 02000000000401e24f424dae2ed5c73e07919adc468a699f #segment:1 #delfile:0 #uptfiles:0
I0814 07:01:38.048353 32573 txn_manager.cpp:298] Commit txn successfully. tablet: 101957, txn_id: 431293, rowsetid: 02000000000401e54f424dae2ed5c73e07919adc468a699f #segment:1 #delfile:0 #uptfiles:0
I0814 07:01:38.304270 32573 txn_manager.cpp:298] Commit txn successfully. tablet: 101963, txn_id: 431294, rowsetid: 02000000000401e94f424dae2ed5c73e07919adc468a699f #segment:1 #delfile:0 #uptfiles:0
I0814 07:01:38.667258 32573 txn_manager.cpp:298] Commit txn successfully. tablet: 101957, txn_id: 431295, rowsetid: 02000000000401eb4f424dae2ed5c73e07919adc468a699f #segment:1 #delfile:0 #uptfiles:0
I0814 07:01:38.962859 32573 txn_manager.cpp:298] Commit txn successfully. tablet: 101957, txn_id: 431296, rowsetid: 02000000000401ee4f424dae2ed5c73e07919adc468a699f #segment:1 #delfile:0 #uptfiles:0
I0814 07:01:39.183631 32573 txn_manager.cpp:298] Commit txn successfully. tablet: 101957, txn_id: 431297, rowsetid: 02000000000401f14f424dae2ed5c73e07919adc468a699f #segment:1 #delfile:0 #uptfiles:0
I0814 07:02:30.940739 32573 primary_index.cpp:1138] load primary index finish table:10028 tablet:10034 version:81343 #rowset:1 #segment:1 data_size:622682 rowsets:84693 size:88 capacity:103 memory:4165 duration: 0ms
I0814 07:02:30.940783 32573 txn_manager.cpp:298] Commit txn successfully. tablet: 10034, txn_id: 431298, rowsetid: 02000000000401f74f424dae2ed5c73e07919adc468a699f #segment:1 #delfile:0 #uptfiles:0

show tablet 10034 看看是哪个Table,然后再show create table 这个表

你发的这个不是最近一个含 32573 的日志吧

离F0814 15:02:13.101240 32573最近的

发的就是最近的了,没有更近的了

表名 column_statistics

先确认下有没有使用同步物化视图吧

排查了一下,整个实例下就这么一个物化视图,每天刷新一遍,且看起来应该已经跑有段时间了

CREATE MATERIALIZED VIEW irr_flow (id, trade_acc, acc_name, fund_code, fund_name, confirm_date, confirm_share, confirm_amount, fee)
DISTRIBUTED BY HASH(trade_acc) BUCKETS 6
REFRESH ASYNC START(“2024-03-20 02:00:00”) EVERY(INTERVAL 1 DAY)
PROPERTIES (
“replication_num” = “1”,
“storage_medium” = “HDD”
)
AS SELECT concat(f.trade_acc, f.fund_code) AS id, f.trade_acc, f.acc_name, f.fund_code, f.pro_name AS fund_name, f.confirm_date, sum(f.confirm_share) AS confirm_share, (sum(CASE WHEN (f.confirm_amount = 0) THEN (f.confirm_share * n.wind_nav) ELSE f.confirm_amount END)) * -1 AS confirm_amount, sum(f.fee) AS fee
FROM hive2.ads.表1 AS f LEFT OUTER JOIN hive2.ads.表2 AS n ON ((f.fund_code = n.fund_code) AND (f.apply_date = n.nav_date)) AND (n.dt = (date_format(date_sub(now(), INTERVAL 1 DAY), ‘yyyy-MM-dd’)))
WHERE ((f.dt = (date_format(date_sub(now(), INTERVAL 1 DAY), ‘yyyy-MM-dd’))) AND (f.confirm_sign != ‘确认失败’)) AND (f.busi_type_name != ‘认购行为确认’)
GROUP BY concat(f.trade_acc, f.fund_code), trade_acc, confirm_date, f.pro_name, acc_name, f.fund_code;

那就是这个问题,打外补丁升级下吧

每次Crash都是一样的堆栈吗?