错误 Failed to get scan range, no queryable replica found in tablet

错误信息

SQL 错误 [1105] [HY000]: errCode = 2, detailMessage = Failed to get scan range, no queryable replica found in tablet: 54193343. Reason: Visible Replicas:Visible version: 78987, Replicas: [replicaId=54193344, backendId=10023, backendAlive=true, version=78987, lastFailedVersion=78988, lastSuccessVersion=78987, lastFailedTimestamp=1746901777408, state=NORMAL], [replicaId=54193345, backendId=10021, backendAlive=true, version=78915, lastFailedVersion=78986, lastSuccessVersion=78915, lastFailedTimestamp=1746901777285, state=NORMAL], [replicaId=54193346, backendId=10022, backendAlive=true, version=78987, lastFailedVersion=78988, lastSuccessVersion=78987, lastFailedTimestamp=1746901778248, state=NORMAL].

解决方案

# 查看tablet信息
SHOW TABLET 54193343

# 从上一步获取detailCMD，并执行
SHOW PROC '/dbs/3790257/54193314/partitions/54193342/54193315/54193343';


# 从上一步获取 CompactionStatus，通过浏览器查看
http://10.3.5.14:8040/api/compaction/show?tablet_id=54193343
http://10.3.5.15:8040/api/compaction/show?tablet_id=54193343
http://10.3.5.13:8040/api/compaction/show?tablet_id=54193343

丢失了部分数据

由于我的是日志，丢失了就不要了。

通过以下命令填充

curl -X POST "http://10.3.5.13:8040/api/pad_rowset?tablet_id=54193343&start_version=78912&end_version=78915"
curl -X POST "http://10.3.5.15:8040/api/pad_rowset?tablet_id=54193343&start_version=78914&end_version=78919"
curl -X POST "http://10.3.5.14:8040/api/pad_rowset?tablet_id=54193343&start_version=78897&end_version=78915"

• tablet_id要改为报错的id
• start_version和end_version为上图中红框的部分