version=3, lastFailedVersion=4, lastSuccessVersion=3导致查询失败，如何处理？

Viewed 74
2.1 
Execution failed: Error Failed to execute sql: java.sql.SQLException: (conn=440550) errCode = 2, detailMessage = Failed to get scan range, no queryable replica found in tablet: 89273. Reason: Visible Replicas:Visible version: 2, Replicas: [replicaId=89274, backendId=10452, backendAlive=true, version=3, lastFailedVersion=4, lastSuccessVersion=3, lastFailedTimestamp=1723617079544, state=NORMAL].

这种如何删除错误的version，恢复正确的version？
谢谢各位老师。

solaris45
2 Answers
ADMIN SET REPLICA VERSION PROPERTIES("tablet_id" = "89273", "backend_id" = "10452", "last_failed_version" = "-1");


ADMIN SET REPLICA VERSION PROPERTIES("tablet_id" = "89273", "backend_id" = "10452", "last_failed_version" = "-1", "version" = "2");

执行了上面的两个命令，错误如下了：
Execution failed: Error Failed to execute sql: java.sql.SQLException: (conn=441200) errCode = 2, detailMessage = Failed to get scan range, no queryable replica found in tablet: 89273. Reason: Visible Replicas:Visible version: 2, Replicas: [replicaId=89274, backendId=10452, backendAlive=true, version=2, isBad=true, state=NORMAL].

solaris45

参考这个实践文档：https://ask.selectdb.com/questions/D1Pw1/zui-jia-shi-jian-shu-ju-fu-ben-wen-ti-pai-cha-zhi-nan

黄海军@SelectDB4528