tablet副本不一致

为了更快的定位您的问题,请提供以下信息,谢谢
【详述】问题详细描述:
SELECT * FROM statistics.column_statistics;
执行报错: [42000][1064] Build Exec OlapScanNode fail, scan info is invalid
【背景】做过哪些操作?
执行select 报错
【业务影响】
影响未知
【是否存算分离】
【StarRocks版本】例如:3.2.13
【集群规模】例如:3fe(1 follower+2observer)+6be(fe与be混部)
【机器信息】CPU虚拟核/内存/网卡,例如:32C/128G/万兆
【联系方式】为了在解决问题过程中能及时联系到您获取一些日志信息,请补充下您的联系方式,例如:18612270201,谢谢

ADMIN SHOW REPLICA STATUS FROM statistics.column_statistics ;

version,lastsucessversion,committedversion
11043,116723998,11001,2824302,-1,2824302,2823302,0,5,false,false,NORMAL,OK
11043,150831740,11076,2824302,-1,2824302,2823302,0,5,false,false,NORMAL,OK
11043,150832156,21645363,2824302,-1,2824302,2823302,0,5,false,false,NORMAL,OK
11043,150832567,37896925,2824302,-1,2824302,2823302,0,5,false,false,NORMAL,OK

committedversion 和version 不一致。

SHOW PROC ‘/cluster_balance/pending_tablets’;
11043,REPAIR,HDD,REDUNDANT,PENDING,VERY_HIGH,VERY_HIGH,-1,-1,-1,-1,0,2025-09-25 16:18:39,2025-09-26 08:51:29,2025-09-26 08:51:29,47765,0,2025-09-26 08:46:38,2823301,0,2824302,0,wait txn before 917524646 to be finished
11045,REPAIR,HDD,REDUNDANT,PENDING,VERY_HIGH,VERY_HIGH,-1,-1,-1,-1,0,2025-09-25 16:14:37,2025-09-26 08:51:29,2025-09-26 08:51:29,47765,0,2025-09-26 08:51:08,2823301,0,2824302,0,wait txn before 917519322 to be finished
11049,REPAIR,HDD,REDUNDANT,PENDING,VERY_HIGH,VERY_HIGH,-1,-1,-1,-1,0,2025-09-25 16:14:37,2025-09-26 08:51:29,2025-09-26 08:51:29,47765,0,2025-09-26 08:46:38,2823301,0,2824302,0,wait txn before 917519324 to be finished
11033,REPAIR,HDD,REDUNDANT,PENDING,VERY_HIGH,VERY_HIGH,-1,-1,-1,-1,0,2025-09-25 16:18:39,2025-09-26 08:51:29,2025-09-26 08:51:29,47765,0,2025-09-26 08:46:38,2823301,0,2824302,0,wait txn before 917524645 to be finished
11039,REPAIR,HDD,REDUNDANT,PENDING,VERY_HIGH,VERY_HIGH,-1,-1,-1,-1,0,2025-09-25 16:14:37,2025-09-26 08:51:29,2025-09-26 08:51:29,47765,0,2025-09-26 08:37:56,2823301,0,2824302,0,wait txn before 917519320 to be finished
11041,REPAIR,HDD,REDUNDANT,PENDING,VERY_HIGH,VERY_HIGH,-1,-1,-1,-1,0,2025-09-25 16:14:37,2025-09-26 08:51:29,2025-09-26 08:51:29,47765,0,2025-09-26 08:33:21,2823301,0,2824302,0,wait txn before 917519321 to be finished
11047,REPAIR,HDD,REDUNDANT,PENDING,VERY_HIGH,VERY_HIGH,-1,-1,-1,-1,0,2025-09-25 16:14:37,2025-09-26 08:51:29,2025-09-26 08:51:29,47765,0,2025-09-26 08:35:48,2823301,0,2824302,0,wait txn before 917519323 to be finished
11037,REPAIR,HDD,REDUNDANT,PENDING,VERY_HIGH,VERY_HIGH,-1,-1,-1,-1,0,2025-09-25 16:14:37,2025-09-26 08:51:29,2025-09-26 08:51:29,47765,0,2025-09-26 08:46:38,2823301,0,2824302,0,wait txn before 917519319 to be finished
11035,REPAIR,HDD,REDUNDANT,PENDING,VERY_HIGH,VERY_HIGH,-1,-1,-1,-1,0,2025-09-25 16:14:37,2025-09-26 08:51:29,2025-09-26 08:51:29,47765,0,2025-09-26 08:35:27,2823301,0,2824302,0,wait txn before 917519318 to be finished
11031,REPAIR,HDD,REDUNDANT,PENDING,NORMAL,NORMAL,-1,-1,-1,-1,0,2025-09-25 17:58:16,2025-09-26 08:51:29,2025-09-26 08:51:29,47754,0,2823301,0,2824302,0,wait txn before 917663197 to be finished

fe.log

fe.log (19.2 KB)

Failed to get scan range, no queryable replica found in tablet=11031,

单副本吗?单副本得话,建议你重建一下这个表,副本数改成3
多副本得话,ADMIN SET REPLICA STATUS PROPERTIES(“tablet_id” = “11031”, “backend_id” = “<backend_id>”, “status” = “bad”);设置一下,让其重新克隆即可。

系统cbo统计信息的表,不知道为啥是1副本 。。没有可用副本了。
想着要删表重建了。