执行 ANALYZE TABLE 收集表统计信息报错, [HY000][1105] errCode = 2, detailMessage = Stats table not available, please make sure your cluster status is normal

Viewed 13

show backends;
显示集群BE节点存活无异常
image.png

SHOW TABLETS FROM internal.__internal_schema.column_statistics;

State 为 NORMAL ,Version 为 1
image.png
ADMIN DIAGNOSE TABLET 10065;
所有tableId返回的异常信息都一致
image.png

已尝试以下命令进行修复异常无任何变化

ADMIN REPAIR TABLE internal.__internal_schema.column_statistics;

ADMIN SET REPLICA STATUS
PROPERTIES(
  "tablet_id" = "10065",
  "backend_id" = "10004",
  "status" = "bad"
);

ADMIN SET REPLICA STATUS
PROPERTIES(
  "tablet_id" = "10065",
  "backend_id" = "10004",
  "status" = "drop"
);
1 Answers