[8.5.3]tiflash报错： CHBlockChunkCodec schema mismatch at column 96, expected Nullable(Int64), actual Int64, e.what() = DB::Exception

foxchan · 2025 年11 月 13 日 06:34

【 TiDB 使用环境】生产环境
【遇到的问题：问题现象及影响】
delete 语句跑tiflash报错
尝试删除tiflash 副本数再添加，还是报错
另外报错提示的column 96, 没有这个这个字段

报错日志

[2025/11/13 14:14:47.559 +08:00] [INFO] [FlashService.cpp:601] [“Handling establish mpp connection request: sender_meta {\n start_ts: 462163669789442144\n task_id: 7\n address: "192.168.6.42:3930"\n gather_id: 1\n query_ts: 1763014487435399852\n local_query_id: 7797397\n server_id: 744\n mpp_version: 2\n connection_id: 1560918944\n}\nreceiver_meta {\n start_ts: 462163669789442144\n task_id: 10\n address: "192.168.6.52:3930"\n gather_id: 1\n query_ts: 1763014487435399852\n local_query_id: 7797397\n server_id: 744\n mpp_version: 2\n keyspace_id: 4294967295\n coordinator_address: "192.168.6.32:10080"\n resource_group_name: "default"\n connection_id: 1560918944\n}\n”] [source=FlashService] [thread_id=250]
[2025/11/13 14:14:47.559 +08:00] [INFO] [SegmentReadTaskScheduler.cpp:247] [“Erase pool_id=75622793”] [source=“Coprocessor, is_remote_read: true, start_ts: 462163669670690929, region_info: {20956324, 28033, 75634} table_id=179702”] [thread_id=201]
[2025/11/13 14:14:47.560 +08:00] [INFO] [SegmentReadTaskPool.h:150] [“Done. pool_id=75622793 pop=8 pop_empty=4 pop_empty_ratio=0.5 max_queue_size=1 blk_avg_bytes=369115 approx_max_pending_block_bytes=0.35MB total_count=3 total_bytes=1.06MB total_rows=528 avg_block_rows=176 avg_rows_bytes=2097B”] [source=“Coprocessor, is_remote_read: true, start_ts: 462163669670690929, region_info: {20956324, 28033, 75634} table_id=179702”] [thread_id=201]
[2025/11/13 14:14:47.575 +08:00] [INFO] [UnorderedSourceOp.h:48] [“All unordered input streams are finished, pool_id=75622792 last_stream_ref_no=3”] [source=“MPP<gather_id:2, query_ts:1763014367404393943, local_query_id:4650271, server_id:165, start_ts:462163669670690929,task_id:10> table_id=179702”] [thread_id=195]
[2025/11/13 14:14:47.575 +08:00] [INFO] [MPPTask.cpp:581] [“mpp task finish execute, is_success: false, status: RUNNING”] [source=“MPP<gather_id:2, query_ts:1763014367404393943, local_query_id:4650271, server_id:165, start_ts:462163669670690929,task_id:10>”] [thread_id=516]
[2025/11/13 14:14:47.592 +08:00] [INFO] [] [“cop task exit because has been cancelled”] [source=“MPP<gather_id:2, query_ts:1763014367404393943, local_query_id:4650271, server_id:165, start_ts:462163669670690929,task_id:10> pingcap/coprocessor”] [thread_id=85248]
[2025/11/13 14:14:47.592 +08:00] [ERROR] [MPPTask.cpp:653] [“task running meets error: Code: 49, e.displayText() = DB::Exception: CHBlockChunkCodec schema mismatch at column 96, expected Nullable(Int64), actual Int64, e.what() = DB::Exception, Stack trace:\n\n\n 0x55e5a629da03\tDB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator> const&, int) [tiflash+33667587]\n \tdbms/src/Common/StackTrace.cpp:23\n 0x55e5accc3394\tDB::CodecUtils::checkDataTypeName(std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator> const&, unsigned long, std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator> const&, std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator> const&) [tiflash+144970644]\n \tdbms/src/Flash/Coprocessor/CodecUtils.cpp:39\n 0x55e5accb4a91\tDB::CHBlockChunkCodec::readColumnMeta(unsigned long, DB::ReadBuffer&, DB::ColumnWithTypeAndName&) [tiflash+144910993]\n \tdbms/src/Flash/Coprocessor/CHBlockChunkCodec.cpp:229\n 0x55e5accb44d2\tDB::CHBlockChunkCodec::decodeImpl(DB::ReadBuffer&, unsigned long) [tiflash+144909522]\n \tdbms/src/Flash/Coprocessor/CHBlockChunkCodec.cpp:182\n 0x55e5accb4eaf\tDB::CHBlockChunkCodec::decode(std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator> const&, DB::Block const&) [tiflash+144912047]\n \tdbms/src/Flash/Coprocessor/CHBlockChunkCodec.cpp:247\n 0x55e5a6255b5d\tDB::CoprocessorReader::decodeChunks(std::__1::shared_ptrtipb::SelectResponse const&, std::__1::queue<DB::Block, std::__1::deque<DB::Block, std::__1::allocatorDB::Block>>&, DB::Block const&, std::__1::vector<std::__1::pair<std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator>, TiDB::ColumnInfo>, std::__1::allocator<std::__1::pair<std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator>, TiDB::ColumnInfo>>> const&) [tiflash+33373021]\n \tdbms/src/Flash/Coprocessor/CoprocessorReader.h:228\n 0x55e5ad0714ad\tDB::CoprocessorReader::toResult(std::__1::pair<pingcap::coprocessor::ResponseIter::Result, bool>&, std::__1::queue<DB::Block, std::__1::deque<DB::Block, std::__1::allocatorDB::Block>>&, DB::Block const&) [tiflash+148829357]\n \tdbms/src/Flash/Coprocessor/CoprocessorReader.h:293\n 0x55e5ad08118a\tDB::CoprocessorReaderSourceOp::readImpl(DB::Block&) [tiflash+148894090]\n \tdbms/src/Operators/CoprocessorReaderSourceOp.cpp:73\n 0x55e5ace0a853\tDB::SourceOp::read(DB::Block&) [tiflash+146311251]\n \tdbms/src/Operators/Operator.cpp:102\n 0x55e5ace06acb\tDB::PipelineExec::executeImpl() [tiflash+146295499]\n \tdbms/src/Flash/Pipeline/Exec/PipelineExec.cpp:167\n 0x55e5ace1ac06\tDB::PipelineTaskBase::runExecute() [tiflash+146377734]\n \tdbms/src/Flash/Pipeline/Exec/PipelineExec.cpp:114\n 0x55e5ace2f19e\tDB::Task::execute() [tiflash+146461086]\n \tdbms/src/Flash/Pipeline/Schedule/Tasks/Task.cpp:128\n 0x55e5a6258bd9\tDB::TaskThreadPoolDB::CPUImpl::loop(unsigned long) [tiflash+33385433]\n \tdbms/src/Flash/Pipeline/Schedule/ThreadPool/TaskThreadPoolImpl.h:32\n 0x55e5a6259436\tvoid* std::__1::__thread_proxy[abi:ue170006]<std::__1::tuple<std::__1::unique_ptr<std::__1::__thread_struct, std::__1::default_deletestd::__1::__thread_struct>, void (DB::TaskThreadPoolDB::CPUImpl::)(unsigned long), DB::TaskThreadPoolDB::CPUImpl, unsigned long>>(void*) [tiflash+33387574]\n \t/data/build_tiflash/sysroot/bin/…/include/c++/v1/__type_traits/invoke.h:308\n 0x7fc367a4dea5\tstart_thread [libpthread.so.0+32421]\n 0x7fc36729f96d\t__clone [libc.so.6+1042797]”] [source=“MPP<gather_id:2, query_ts:1763014367404393943, local_query_id:4650271, server_id:165, start_ts:462163669670690929,task_id:10>”] [thread_id=516]
[2025/11/13 14:14:47.593 +08:00] [WARN] [MPPTask.cpp:751] [“Begin abort task: MPP<gather_id:2, query_ts:1763014367404393943, local_query_id:4650271, server_id:165, start_ts:462163669670690929,task_id:10>, abort type: ONERROR”] [source=“MPP<gather_id:2, query_ts:1763014367404393943, local_query_id:4650271, server_id:165, start_ts:462163669670690929,task_id:10>”] [thread_id=516]
[2025/11/13 14:14:47.593 +08:00] [WARN] [MPPTask.cpp:780] [“Finish abort task from running”] [source=“MPP<gather_id:2, query_ts:1763014367404393943, local_query_id:4650271, server_id:165, start_ts:462163669670690929,task_id:10>”] [thread_id=516]
[2025/11/13 14:14:47.593 +08:00] [INFO] [MPPTaskStatistics.cpp:139] [“{"query_tso":462163669670690929,"task_id":10,"is_root":true,"sender_executor_id":"ExchangeSender_13","executors":[{"id":"ExchangeSender_13","type":"ExchangeSender","children":["Selection_12"],"outbound_rows":0,"outbound_blocks":0,"outbound_bytes":0,"outbound_allocated_bytes":0,"concurrency":0,"execution_time_ns":0,"partition_num":1,"sender_target_task_ids":[-1],"exchange_type":"PassThrough","connection_details":[{"tunnel_id":"tunnel10±1","sender_target_task_id":-1,"sender_target_host":"192.168.6.42:30009","is_local":false,"packets":0,"bytes":0}]},{"id":"Selection_12","type":"Selection","children":["TableFullScan_11"],"outbound_rows":0,"outbound_blocks":0,"outbound_bytes":0,"outbound_allocated_bytes":0,"concurrency":0,"execution_time_ns":0},{"id":"TableFullScan_11","type":"TableScan","children":,"outbound_rows":0,"outbound_blocks":0,"outbound_bytes":0,"outbound_allocated_bytes":0,"concurrency":0,"execution_time_ns":0,"connection_details":[{"is_local":true,"packets":0,"bytes":0,"max":0,"min":0},{"is_local":false,"packets":0,"bytes":0,"max":0,"min":0}],"scan_details":{"build_bitmap_time":"265.327ms","build_stream_time":"609.508ms","create_snapshot_time":"0.145ms","delta_bytes":85435307,"delta_rows":59081,"dmfile_data_scanned_rows":420597,"dmfile_data_skipped_rows":822653,"dmfile_lm_filter_scanned_rows":420597,"dmfile_lm_filter_skipped_rows":822653,"dmfile_mvcc_scanned_rows":1354278,"dmfile_mvcc_skipped_rows":2300239,"dmfile_read_time":"1946.696ms","late_materialization_skip_rows":0,"learner_read_time":"16.939ms","local_max_stream_cost_ms":"0.000ms","local_min_stream_cost_ms":"0.000ms","mvcc_input_bytes":20002557,"mvcc_input_rows":1176621,"mvcc_skip_rows":152856,"num_columns":97,"num_local_region":31,"num_read_tasks":8,"num_remote_region":29,"num_segments":8,"num_stale_read":0,"pushdown":{"rs_operator":{"children":[{"col":"create_time","op":"less","value":"1853022339453681664"},{"col":"tenant_id","op":"less","value":"4"},{"col":"relate_activity_product_status","op":"in","value":["2","3"]}],"op":"and"}},"read_bytes":605780474,"read_mode":"Bitmap","region_num_of_instance":[{"instance_id":"192.168.6.42:3930","region_num":31}],"remote_max_stream_cost_ms":"0.000ms","remote_min_stream_cost_ms":"0.000ms","rs_dmfile_read_with_all":0,"rs_pack_filter_all":0,"rs_pack_filter_all_null":0,"rs_pack_filter_check_time":"2.199ms","rs_pack_filter_none":149,"rs_pack_filter_some":157}}],"host":"192.168.6.42:3930","task_init_timestamp":1763014487001245000,"task_start_timestamp":1763014487049542000,"task_end_timestamp":1763014487593096000,"compile_start_timestamp":1763014487002320000,"compile_end_timestamp":1763014487049508000,"read_wait_index_start_timestamp":1763014487020512000,"read_wait_index_end_timestamp":1763014487020582000,"local_input_bytes":9283294,"remote_input_bytes":0,"output_bytes":0,"status":"FAILED","error_message":"Code: 49, e.displayText() = DB::Exception: CHBlockChunkCodec schema mismatch at column 96, expected Nullable(Int64), actual Int64, e.what() = DB::Exception,","cpu_ru":101,"read_ru":9243.476470947266,"memory_peak":0,"extra_info":{"cpu_execute_time_ns":302005652,"cpu_pending_time_ns":1030019279,"io_execute_time_ns":0,"io_pending_time_ns":0,"await_time_ns":5889110212,"wait_for_notify_time_ns":8229154009}}”] [source=“mpp_task_tracing MPP<gather_id:2, query_ts:1763014367404393943, local_query_id:4650271, server_id:165, start_ts:462163669670690929,task_id:10>”] [thread_id=516]
[2025/11/13 14:14:47.593 +08:00] [INFO] [MPPTask.cpp:155] [“finish MPPTask: MPP<gather_id:2, query_ts:1763014367404393943, local_query_id:4650271, server_id:165, start_ts:462163669670690929,task_id:10>”] [source=“MPP<gather_id:2, query_ts:1763014367404393943, local_query_id:4650271, server_id:165, start_ts:462163669670690929,task_id:10>”] [thread_id=516]
[2025/11/13 14:14:47.594 +08:00] [INFO] [UnorderedSourceOp.h:48] [“All unordered input streams are finished, pool_id=75622807 last_stream_ref_no=0”] [source=“Coprocessor, is_remote_read: true, start_ts: 462163669670690929, region_info: {19448914, 27829, 75623} table_id=179702”] [thread_id=150]

初识TiDB · 2025 年11 月 13 日 23:50

这里出错了：
[ERROR] CHBlockChunkCodec schema mismatch at column 96, expected Nullable(Int64)
遇到空表了

lllzd · 2025 年11 月 14 日 01:57

[ERROR] … DB::Exception: CHBlockChunkCodec schema mismatch at column 96,
2expected Nullable(Int64), actual Int64
格式要求是Nullable(Int64)，发的是Int64(非空整数)，主要问题就是数据不匹配，感觉像是BUG，建议提交至TiDB专家团队。

异乡的大人 · 2025 年11 月 14 日 01:58

应该是产品bug，反馈一下吧

程序猿_DBA · 2025 年11 月 14 日 01:59

可以跟官方反馈下确认下是否是产品缺陷

waeng · 2025 年11 月 14 日 02:24

感觉像是Bug

tidb菜鸟一只 · 2025 年11 月 18 日 01:03

报错表的表结构可以发下吗，重点是第96个列吧，可能是tiflash同步的表结构有问题，不包含这个列或者列格式不支持，然后报错了

北极星DB · 2025 年11 月 18 日 02:20

这个报错算是比较明显的了，关注下第96列差不多就能定位到问题了吧

北极星DB · 2025 年11 月 18 日 02:23

不是空表吧，是第96列期望可空值，但是实际为int64，是这么翻译吧，英语懂的不多

foxchan · 2025 年11 月 18 日 08:14

描述写了，通过SET tiflash REPLICA 0，SET tiflash REPLICA 2，重新添加tiflash副本，仍然报错
这个表在set期间没有表结构的变更
表结构也没有96字段

Columns (95)


Create Table

CREATE TABLE `leader_relate_link` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '物理ID',
  `tenant_id` int NOT NULL COMMENT ' 团长id',
  `person_user_id` int NOT NULL DEFAULT '0' COMMENT '负责人ID',
  `link_url` varchar(1000) NOT NULL COMMENT '第三方链接地址',
  `platform` int NOT NULL COMMENT '第三方店铺类型 1抖店,3快手',
  `relate_shop_id` varchar(50) DEFAULT NULL COMMENT '第三方店铺ID',
  `relate_shop_name` varchar(50) DEFAULT NULL COMMENT '第三方店铺名称',
  `relate_shop_phone` varchar(20) DEFAULT NULL COMMENT '第三方店铺电话',
  `relate_shop_logo` varchar(255) DEFAULT NULL COMMENT '第三方店铺LOGO',
  `relate_product_id` varchar(50) NOT NULL COMMENT '第三方商品ID',
  `relate_product_name` varchar(100) NOT NULL COMMENT '第三方商品名称',
  `relate_product_img` varchar(500) NOT NULL COMMENT '第三方商品主图',
  `relate_product_img_list` text DEFAULT NULL COMMENT '第三方商品轮播图集合',
  `relate_product_img_detail_list` text DEFAULT NULL COMMENT '第三方商品详情图集合',
  `relate_first_cid` varchar(50) NOT NULL DEFAULT '0' COMMENT '第三方：一级类目ID',
  `relate_first_cname` varchar(50) DEFAULT NULL COMMENT '第三方：一级类目名称',
  `relate_second_cid` varchar(50) DEFAULT NULL COMMENT '第三方：二级类目ID',
  `relate_second_cname` varchar(50) DEFAULT NULL COMMENT '第三方：二级类目名称',
  `relate_third_cid` varchar(50) DEFAULT NULL COMMENT '第三方：三级类目ID',
  `relate_third_cname` varchar(50) DEFAULT NULL COMMENT '第三方：三级类目ID',
  `relate_fourth_cid` varchar(50) DEFAULT NULL COMMENT '第三方：四级类目ID',
  `relate_fourth_cname` varchar(50) DEFAULT NULL COMMENT '第三方：四级类目ID',
  `relate_brand_id` varchar(50) DEFAULT NULL COMMENT '第三方品牌ID',
  `relate_brand_name` varchar(50) DEFAULT NULL COMMENT '第三方品牌名称',
  `relate_spec_live_price` bigint DEFAULT NULL COMMENT '第三方直播价/售卖价',
  `relate_goods_stock` bigint DEFAULT NULL COMMENT '第三方商品库存',
  `relate_spec_sell_num` int DEFAULT NULL COMMENT '第三方销量',
  `relate_product_score` decimal(8,4) DEFAULT NULL COMMENT '第三方商品体验',
  `relate_shop_score` decimal(8,4) DEFAULT NULL COMMENT '第三方商家服务',
  `relate_logistics_score` decimal(8,4) DEFAULT NULL COMMENT '第三方物流体验',
  `relate_activity_id` varchar(50) DEFAULT NULL COMMENT '第三方活动id',
  `relate_activity_name` varchar(100) DEFAULT NULL COMMENT '第三方活动名称，托管商品存托管活动',
  `relate_promises` varchar(100) DEFAULT NULL COMMENT '第三方服务承诺',
  `relate_product_status` int NOT NULL COMMENT '第三方商品状态，1上架，2下架。',
  `relate_activity_product_status` int DEFAULT '1' COMMENT '活动商品状态 0：待审核；1：推广中；2：申请未通过；3：合作已终止；6：合作已到期',
  `relate_apply_id` bigint DEFAULT '0' COMMENT '第三方-申请ID（活动审核使用）',
  `relate_logistics_info` varchar(100) DEFAULT NULL COMMENT '第三方-商品物流说明',
  `relate_view_num` bigint DEFAULT '0' COMMENT '第三方-近30天浏览量',
  `relate_kol_num` bigint DEFAULT '0' COMMENT '第三方-近30天推广总达人数',
  `relate_yesterday_order_num` bigint DEFAULT '0' COMMENT '第三方-昨天订单数',
  `relate_order_num` bigint DEFAULT NULL COMMENT '第三方-近30天订单数',
  `relate_has_sxt` int DEFAULT '0' COMMENT '第三方-是否具有短视频随心推资质:0否1是',
  `goods_sample_flag` int NOT NULL DEFAULT '0' COMMENT '是否支持寄样，0不支持，1支持',
  `service_margin` decimal(6,4) NOT NULL COMMENT '第三方平台团长服务费率',
  `commission_margin` decimal(6,4) DEFAULT '0.0000' COMMENT '第三方平台达人公开佣金率--普通佣金',
  `activity_commission_margin` decimal(6,4) DEFAULT '0.0000' COMMENT '第三方平台活动佣金率----活动佣金',
  `has_leader_sec` int NOT NULL DEFAULT '0' COMMENT '是否支持二级团申报 0都不支持，1都支持，2不支持采集，支持提报',
  `divide_service_margin_sec` decimal(6,4) DEFAULT NULL COMMENT '给二级团服务费的分成比例',
  `divide_service_margin_sec_type` int NOT NULL DEFAULT '1' COMMENT '给二级团服务费的分成比例的方式：1填写分成比例动态计算，2填写固定分成比例',
  `link_start_time` datetime NOT NULL COMMENT '链接起始时间',
  `link_end_time` datetime NOT NULL COMMENT '链接终止时间',
  `sample_fans` int DEFAULT '0' COMMENT '寄样最低粉丝数',
  `sample_sales` int DEFAULT '0' COMMENT '寄样最低30天销量',
  `sample_sales_money` int DEFAULT '0' COMMENT '免费寄样要求：近30天销售额，0无限制',
  `sample_level` int DEFAULT '0' COMMENT '寄样要求达人等级',
  `sample_threshold_flag` int NOT NULL DEFAULT '0' COMMENT '是否有寄样门槛，0没有，1有',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '系统字段,创建时间,不再变化',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '系统字段,修改时间,每次变更自动更新',
  `operator` varchar(30) DEFAULT 'sys' COMMENT '操作人,用户名',
  `review_status` int DEFAULT '0' COMMENT '本地状态，0未上架，1上架，2下架',
  `last_reviewer` varchar(30) DEFAULT NULL COMMENT '最后审核人',
  `review_time` timestamp NULL DEFAULT NULL COMMENT '审核时间',
  `institution_id` varchar(20) NOT NULL COMMENT '团长的机构id',
  `origin_buyin_id` varchar(20) COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '原始团长百应ID',
  `origin_institution_id` varchar(20) DEFAULT '0' COMMENT '原始团长的机构id',
  `origin_institution_name` varchar(50) DEFAULT NULL COMMENT '原始团长名称',
  `origin_institution_phone` varchar(15) DEFAULT NULL COMMENT '原始团长联系方式',
  `origin_activity_id` bigint DEFAULT NULL COMMENT '原始第三方活动id。',
  `partner_type` int NOT NULL COMMENT '合作类型：1商家(一级团商品，商家自建活动商品)，2团长（二级团商品，一级团长报名二级团商品），3托管',
  `partner_shop_id` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '合作的店铺ID（商家合作存店铺ID，团长合作存原始团长机构ID）',
  `partner_shop_name` varchar(50) DEFAULT NULL COMMENT '合作方店铺名称',
  `partner_shop_phone` varchar(13) DEFAULT NULL COMMENT '合作方联系方式',
  `local_first_cid` int DEFAULT NULL COMMENT '映射表的一级类目id',
  `local_first_cname` varchar(50) DEFAULT NULL COMMENT '映射表一级类目名称',
  `goods_sell_point` varchar(1000) DEFAULT NULL COMMENT '商品卖点',
  `goods_slogan` varchar(1000) DEFAULT NULL COMMENT '推广话术',
  `goods_card_img` varchar(255) DEFAULT NULL COMMENT '手卡',
  `relate_sharable` int DEFAULT '0' COMMENT '第三方是否支持分销：0否1是',
  `promote_flg` int DEFAULT '0' COMMENT '是否支持投流：0否1是',
  `promote_start_time` datetime DEFAULT NULL COMMENT '投流开始时间',
  `promote_end_time` datetime DEFAULT NULL COMMENT '投流结束时间',
  `promote_ask` varchar(300) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '投流要求',
  `promote_reward` varchar(600) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '投流奖励',
  `sort_weight` int DEFAULT '0' COMMENT '排序权重',
  `material_flag` int DEFAULT '0' COMMENT '是否支持素材库 0否1是',
  `open_show_flag` int DEFAULT '0' COMMENT '开放显示标志位：0都显示，1只媒介，2只达人',
  `salesman_goods_price` bigint NOT NULL DEFAULT '-1' COMMENT '达人专属价（-1未设置。单位分）',
  `salesman_goods_price_info` varchar(100) DEFAULT NULL COMMENT '达人专属价说明',
  `sample_custom_info` varchar(255) DEFAULT NULL COMMENT '寄样自定义信息',
  `sort_weight_sec` int DEFAULT '0' COMMENT '选品池排序权重：使用二级团分成服务费计算',
  `to_top` int DEFAULT '0' COMMENT '是否置顶：0否1是',
  `to_top_time` datetime DEFAULT NULL COMMENT '置顶时间',
  `relate_category_id` varchar(50) DEFAULT NULL COMMENT '第三方：行业类目ID',
  `relate_category_name` varchar(50) DEFAULT NULL COMMENT '第三方：行业类目name',
  `link_status` int DEFAULT '0' COMMENT '链接状态：0正常。1已提报活动达到最大数',
  PRIMARY KEY (`id`,`tenant_id`) /*T![clustered_index] NONCLUSTERED */,
  UNIQUE KEY `relate_product_id_racid_pl_tid` (`relate_product_id`,`relate_activity_id`,`tenant_id`,`platform`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=1685670990 /*T! SHARD_ROW_ID_BITS=4 PRE_SPLIT_REGIONS=2 */ COMMENT='推广链接表或商品表'
PARTITION BY RANGE (`tenant_id`)
(PARTITION `p3` VALUES LESS THAN (4),
 PARTITION `p16` VALUES LESS THAN (24),
 PARTITION `p50` VALUES LESS THAN (57),
 PARTITION `p58` VALUES LESS THAN (73),
PARTITION ..............

WalterWj · 2025 年11 月 19 日 10:26

内部分析了下，试试重启下 tiflash

foxchan · 2025 年11 月 20 日 09:36

好的，反正通过tikv 慢慢删完数据了。
等到8.5.4 升级的时候重启下

system · 2025 年12 月 4 日 08:26

此话题已在最后回复的 7 天后被自动关闭。不再允许新回复。