集群信息:3fe+3be(混部)
DDL操作语句:
ALTER TABLE oc_order_main
MODIFY COLUMN `front_pay_amount` decimal(14, 2) NULL DEFAULT NULL COMMENT '定金金额',
MODIFY COLUMN `tail_pay_amount` decimal(14, 2) NULL DEFAULT NULL COMMENT '尾款金额',
MODIFY COLUMN `receivable_amount` decimal(14, 2) NULL DEFAULT NULL COMMENT '应收金额(含运费)',
MODIFY COLUMN `actual_pay_amount` decimal(14, 2) NULL DEFAULT NULL COMMENT '实付金额(货品实付总金额+运费)',
MODIFY COLUMN `prod_receivable_amount` decimal(14, 2) NULL DEFAULT NULL COMMENT '货品应收总金额(货品实付+平台承担优惠,不含运费)',
MODIFY COLUMN `prod_total_amount` decimal(14, 2) NULL DEFAULT NULL COMMENT '货品实付总金额(优惠后实付,不含运费)',
MODIFY COLUMN `total_discount_amount` decimal(14, 2) NULL DEFAULT NULL COMMENT '优惠总金额',
MODIFY COLUMN `postage_cost` decimal(14, 2) NULL DEFAULT NULL COMMENT '运费',
MODIFY COLUMN `active_pref_amount` decimal(14, 2) NULL DEFAULT NULL COMMENT '活动优惠总金额',
MODIFY COLUMN `globle_pref_amount` decimal(14, 2) NULL DEFAULT NULL COMMENT '全场活动优惠金额',
MODIFY COLUMN `member_pref_amount` decimal(14, 2) NULL DEFAULT NULL COMMENT '会员优惠总金额',
MODIFY COLUMN `platform_bear_amount` decimal(14, 2) NULL DEFAULT NULL COMMENT '平台承担优惠总金额',
MODIFY COLUMN `coupon_amount` decimal(14, 2) NULL DEFAULT NULL COMMENT '优惠券总金额',
MODIFY COLUMN `employee_card_pref_price_amount` decimal(14, 2) NULL DEFAULT NULL COMMENT '员购卡优惠总金额',
MODIFY COLUMN `score_amount` decimal(14, 2) NULL DEFAULT NULL COMMENT '积分兑换总金额',
MODIFY COLUMN `expand_price_used` decimal(14, 2) NULL DEFAULT NULL COMMENT '购物金',
MODIFY COLUMN `tag_price_total_amount` decimal(14, 2) NULL DEFAULT NULL COMMENT '牌价总金额(不含运费)',
MODIFY COLUMN `prod_unit_total_amount` decimal(14, 2) NULL DEFAULT NULL COMMENT '商品总金额(优惠前现价总金额不含运费)',
MODIFY COLUMN `reduce_total_amount` decimal(14, 2) NULL DEFAULT NULL COMMENT '减价总金额',
MODIFY COLUMN `foreign_card_discount_total_amount` decimal(14, 2) NULL DEFAULT NULL COMMENT '外卡折让总金额',
MODIFY COLUMN `platform_fee` decimal(14, 2) NULL DEFAULT NULL COMMENT '平台费用',
MODIFY COLUMN `platform_postage_cost` decimal(14, 2) NULL DEFAULT NULL COMMENT '平台运费';
使用SHOW ALTER TABLE COLUMN;查看报错:
errCode = 2, detailMessage = schema change tasks failed, error reason: task type: ALTER, status_code: INTERNAL_ERROR, status_message: [(10.250.90.8)[E-804]fail to find Rowset for version. tablet=31187144, version=[469860-469860]], backendId: Backend [id=10007, host=10.250.90.8, heartbeatPort=9050, alive=true, lastStartTime=2025-08-04 15:04:34, process epoch=1754291074074, tags: {location=default}], signature: 31187144
查看BE的be.WARNING日志有报错:
3# doris::alter_tablet_callback(doris::StorageEngine&, doris::TAgentTaskRequest const&) at /home/zcp/repo_center/doris_release/doris/be/src/common/status.h:380
4# std::_Function_handler<void (), doris::TaskWorkerPool::submit_task(doris::TAgentTaskRequest const&)::$_0::operator()<doris::TAgentTaskRequest const&>(doris::TAgentTaskRequest const&) const::{lambda()#1}>::_M_invoke(std::_Any_data const&) at /home/zcp/repo_center/doris_release/doris/be/src/agent/task_worker_pool.cpp:445
5# doris::ThreadPool::dispatch_thread() at /home/zcp/repo_center/doris_release/doris/be/src/util/threadpool.cpp:0
6# doris::Thread::supervise_thread(void*) at /var/local/ldb-toolchain/bin/../usr/include/pthread.h:562
7# ?
8# ?
W20250804 14:40:47.578933 2360686 schema_change.cpp:1041] failed to alter tablet. base_tablet=12419, drop new_tablet=31162108[E-804]fail to find Rowset for version. tablet=31162108, version=[469324-469324]
W20250804 14:40:47.579265 2360686 task_worker_pool.cpp:223] failed to alter tablet|signature=31162108|base_tablet_id=12419|new_tablet_id=31162108|error=[E-804]fail to find Rowset for version. tablet=31162108, version=[469324-469324]
W20250804 14:40:47.630568 2360685 schema_change.cpp:1041] failed to alter tablet. base_tablet=12410, drop new_tablet=31162099[E-804]fail to find Rowset for version. tablet=31162099, version=[469324-469324]
W20250804 14:40:47.630852 2360685 task_worker_pool.cpp:223] failed to alter tablet|signature=31162099|base_tablet_id=12410|new_tablet_id=31162099|error=[E-804]fail to find Rowset for version. tablet=31162099, version=[469324-469324]
W20250804 14:47:32.647603 219146 timezone_utils.cpp:98] Meet illegal tzdata file: Africa/Casablanca. skipped
W20250804 14:47:32.676450 219146 timezone_utils.cpp:98] Meet illegal tzdata file: Africa/El_Aaiun. skipped
W20250804 14:47:32.797245 219146 timezone_utils.cpp:98] Meet illegal tzdata file: iso3166.tab. skipped
W20250804 14:47:32.797452 219146 timezone_utils.cpp:98] Meet illegal tzdata file: leap-seconds.list. skipped
W20250804 14:47:32.797536 219146 timezone_utils.cpp:98] Meet illegal tzdata file: leapseconds. skipped
W20250804 14:47:32.797840 219146 timezone_utils.cpp:98] Meet illegal tzdata file: tzdata.zi. skipped
W20250804 14:47:32.798179 219146 timezone_utils.cpp:98] Meet illegal tzdata file: zone.tab. skipped
W20250804 14:47:32.798465 219146 timezone_utils.cpp:98] Meet illegal tzdata file: zone1970.tab. skipped
E20250804 14:47:33.179282 219146 variable.cpp:179] Already exposed `doris_cache_data_page_cache' whose value is `0'
E20250804 14:47:33.179318 219146 variable.cpp:179] Already exposed `doris_cache_data_page_cache_persecond' whose value is `0'
E20250804 14:47:33.179438 219146 variable.cpp:179] Already exposed `doris_cache_index_page_cache' whose value is `0'
E20250804 14:47:33.179446 219146 variable.cpp:179] Already exposed `doris_cache_index_page_cache_persecond' whose value is `0'
E20250804 14:47:33.179566 219146 variable.cpp:179] Already exposed `doris_cache_pkindex_page_cache' whose value is `0'
E20250804 14:47:33.179575 219146 variable.cpp:179] Already exposed `doris_cache_pkindex_page_cache_persecond' whose value is `0'
E20250804 14:47:33.179667 219146 variable.cpp:179] Already exposed `doris_cache_point_query_row_cache' whose value is `0'
E20250804 14:47:33.179677 219146 variable.cpp:179] Already exposed `doris_cache_point_query_row_cache_persecond' whose value is `0'
E20250804 14:47:33.179729 219146 variable.cpp:179] Already exposed `doris_cache_segment_cache' whose value is `0'
E20250804 14:47:33.179738 219146 variable.cpp:179] Already exposed `doris_cache_segment_cache_persecond' whose value is `0'
E20250804 14:47:33.179778 219146 variable.cpp:179] Already exposed `doris_cache_schema_cache' whose value is `0'
E20250804 14:47:33.179785 219146 variable.cpp:179] Already exposed `doris_cache_schema_cache_persecond' whose value is `0'
E20250804 14:47:33.179834 219146 variable.cpp:179] Already exposed `doris_cache_common_obj_lrucache' whose value is `0'
E20250804 14:47:33.179842 219146 variable.cpp:179] Already exposed `doris_cache_common_obj_lrucache_persecond' whose value is `0'
E20250804 14:47:33.179874 219146 variable.cpp:179] Already exposed `doris_cache_point_query_lookup_connection_cache' whose value is `0'
E20250804 14:47:33.179883 219146 variable.cpp:179] Already exposed `doris_cache_point_query_lookup_connection_cache_persecond' whose value is `0'
E20250804 14:47:33.180006 219146 variable.cpp:179] Already exposed `doris_cache_inverted_index_searcher_cache' whose value is `0'
E20250804 14:47:33.180024 219146 variable.cpp:179] Already exposed `doris_cache_inverted_index_searcher_cache_persecond' whose value is `0'
E20250804 14:47:33.180150 219146 variable.cpp:179] Already exposed `doris_cache_inverted_index_query_cache' whose value is `0'
E20250804 14:47:33.180157 219146 variable.cpp:179] Already exposed `doris_cache_inverted_index_query_cache_persecond' whose value is `0'
E20250804 14:47:33.180367 219146 variable.cpp:179] Already exposed `doris_cache_last_success_channel_cache' whose value is `0'
E20250804 14:47:33.180380 219146 variable.cpp:179] Already exposed `doris_cache_last_success_channel_cache_persecond' whose value is `0'
E20250804 14:47:33.180644 219146 variable.cpp:179] Already exposed `doris_cache_tablet_schema_cache' whose value is `0'
E20250804 14:47:33.180655 219146 variable.cpp:179] Already exposed `doris_cache_tablet_schema_cache_persecond' whose value is `0'
E20250804 14:47:33.180697 219146 variable.cpp:179] Already exposed `doris_cache_tablet_column_object_pool' whose value is `0'
E20250804 14:47:33.180706 219146 variable.cpp:179] Already exposed `doris_cache_tablet_column_object_pool_persecond' whose value is `0'
E20250804 14:47:33.181241 219146 variable.cpp:179] Already exposed `doris_cache_mow_tablet_version_cache' whose value is `0'
E20250804 14:47:33.181249 219146 variable.cpp:179] Already exposed `doris_cache_mow_tablet_version_cache_persecond' whose value is `0'
E20250804 14:47:33.181293 219146 variable.cpp:179] Already exposed `doris_cache_create_tablet_rridx_cache' whose value is `0'
E20250804 14:47:33.181299 219146 variable.cpp:179] Already exposed `doris_cache_create_tablet_rridx_cache_persecond' whose value is `0'
E20250804 14:47:34.249397 220021 variable.cpp:179] Already exposed `doris_cache_mow_delete_bitmap_agg_cache' whose value is `0'
E20250804 14:47:34.249425 220021 variable.cpp:179] Already exposed `doris_cache_mow_delete_bitmap_agg_cache_persecond' whose value is `0'
W20250804 14:47:35.724869 220064 olap_server.cpp:687] Have not get FE Master heartbeat yet
W20250804 14:47:44.541103 220063 cumulative_compaction.cpp:129] There are missed versions among rowsets. prev rowset verison=[1246-1246], next rowset version=[1248-1248], tablet=30143754
W20250804 14:47:45.445950 220063 cumulative_compaction.cpp:129] There are missed versions among rowsets. prev rowset verison=[1246-1246], next rowset version=[1248-1248], tablet=30143758
W20250804 14:49:55.443629 220063 cumulative_compaction.cpp:129] There are missed versions among rowsets. prev rowset verison=[1246-1246], next rowset version=[1248-1248], tablet=30143758
W20250804 14:50:02.243536 220063 cumulative_compaction.cpp:129] There are missed versions among rowsets. prev rowset verison=[1246-1246], next rowset version=[1248-1248], tablet=30143758
W20250804 14:50:23.331874 221863 ref_count_closure.h:119] RPC meet error status: [INVALID_ARGUMENT]PStatus: (10.250.90.9)[INVALID_ARGUMENT]query-id: 791590a4dfe8461d-bc18888918f1451a
W20250804 14:50:24.064359 220567 fragment_mgr.cpp:1316] Could not find the query id:c5f91e5fb6df4275-ba4cc46681007b17 fragment id:12 to cancel
W20250804 14:50:24.064741 220569 fragment_mgr.cpp:1316] Could not find the query id:c5f91e5fb6df4275-ba4cc46681007b17 fragment id:4 to cancel
W20250804 14:50:24.064779 220568 fragment_mgr.cpp:1316] Could not find the query id:c5f91e5fb6df4275-ba4cc46681007b17 fragment id:0 to cancel
W20250804 14:50:24.064814 220570 fragment_mgr.cpp:1316] Could not find the query id:c5f91e5fb6df4275-ba4cc46681007b17 fragment id:10 to cancel
W20250804 14:50:24.064818 220571 fragment_mgr.cpp:1316] Could not find the query id:c5f91e5fb6df4275-ba4cc46681007b17 fragment id:11 to cancel
W20250804 14:50:24.064888 220568 fragment_mgr.cpp:1316] Could not find the query id:c5f91e5fb6df4275-ba4cc46681007b17 fragment id:6 to cancel
W20250804 14:50:24.064973 220573 fragment_mgr.cpp:1316] Could not find the query id:c5f91e5fb6df4275-ba4cc46681007b17 fragment id:9 to cancel
W20250804 14:50:24.064996 220574 fragment_mgr.cpp:1316] Could not find the query id:c5f91e5fb6df4275-ba4cc46681007b17 fragment id:7 to cancel
W20250804 14:50:24.065518 220575 fragment_mgr.cpp:1316] Could not find the query id:c5f91e5fb6df4275-ba4cc46681007b17 fragment id:2 to cancel
W20250804 14:50:45.164870 220800 fragment_mgr.cpp:1316] Could not find the query id:bca08b33457e4984-85f6646165b196d5 fragment id:12 to cancel
W20250804 14:50:45.164860 220799 fragment_mgr.cpp:1316] Could not find the query id:bca08b33457e4984-85f6646165b196d5 fragment id:10 to cancel
W20250804 14:50:45.164933 220801 fragment_mgr.cpp:1316] Could not find the query id:bca08b33457e4984-85f6646165b196d5 fragment id:6 to cancel
W20250804 14:50:45.164996 220804 fragment_mgr.cpp:1316] Could not find the query id:bca08b33457e4984-85f6646165b196d5 fragment id:2 to cancel
W20250804 14:50:45.165030 220802 fragment_mgr.cpp:1316] Could not find the query id:bca08b33457e4984-85f6646165b196d5 fragment id:4 to cancel
W20250804 14:50:45.165059 220801 fragment_mgr.cpp:1316] Could not find the query id:bca08b33457e4984-85f6646165b196d5 fragment id:0 to cancel
W20250804 14:50:45.165066 220803 fragment_mgr.cpp:1316] Could not find the query id:bca08b33457e4984-85f6646165b196d5 fragment id:11 to cancel
W20250804 14:50:45.165143 220805 fragment_mgr.cpp:1316] Could not find the query id:bca08b33457e4984-85f6646165b196d5 fragment id:9 to cancel
W20250804 14:50:45.165208 220809 fragment_mgr.cpp:1316] Could not find the query id:bca08b33457e4984-85f6646165b196d5 fragment id:7 to cancel
W20250804 14:53:01.016185 220051 vertical_merge_iterator.cpp:225] end of row source buffer file
W20250804 14:53:04.282829 220054 status.h:415] meet error status: [E-504]try to delete not exist version [478390-478390] from 31164934
0# doris::Tablet::modify_rowsets(std::vector<std::shared_ptr<doris::Rowset>, std::allocator<std::shared_ptr<doris::Rowset> > >&, std::vector<std::shared_ptr<doris::Rowset>, std::allocator<std::shared_ptr<doris::Rowset> > >&, bool) at /home/zcp/repo_center/doris_release/doris/be/src/olap/tablet.cpp:0
1# doris::Compaction::modify_rowsets(doris::Merger::Statistics const*) at /home/zcp/repo_center/doris_release/doris/be/src/common/status.h:494
2# doris::Compaction::do_compaction_impl(long) at /home/zcp/repo_center/doris_release/doris/be/src/olap/compaction.cpp:0
3# doris::Compaction::do_compaction(long) at /var/local/ldb-toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/shared_ptr_base.h:1291
4# doris::CumulativeCompaction::execute_compact_impl() at /home/zcp/repo_center/doris_release/doris/be/src/common/status.h:494
5# doris::Compaction::execute_compact() at /home/zcp/repo_center/doris_release/doris/be/src/common/status.h:494
6# doris::Tablet::execute_compaction(doris::Compaction&) at /home/zcp/repo_center/doris_release/doris/be/src/olap/tablet.cpp:2089
7# std::_Function_handler<void (), doris::StorageEngine::_submit_compaction_task(std::shared_ptr<doris::Tablet>, doris::CompactionType, bool)::$_0>::_M_invoke(std::_Any_data const&) at /home/zcp/repo_center/doris_release/doris/be/src/olap/olap_server.cpp:0
8# doris::ThreadPool::dispatch_thread() at /home/zcp/repo_center/doris_release/doris/be/src/util/threadpool.cpp:0
9# doris::Thread::supervise_thread(void*) at /var/local/ldb-toolchain/bin/../usr/include/pthread.h:562
10# ?
11# ?
W20250804 14:53:04.282893 220054 tablet.cpp:2092] failed to do cumulative compaction, tablet=31164934 : [E-504]try to delete not exist version [478390-478390] from 31164934