查询sql 报错 Failed to get scan range, no queryable replica found in tablet: xxxxxxx

Viewed 19

查询的sql : SELECT
domain,
businessUnit,
cityCompany,
project,
area,
format,
paidLiquidatedDamages,
paidInAmount
FROM table fee
WHERE fee.id IN (......)

查询的表是单副本,并且通过Flink 实时更新的,查询时会出现报错,
java.lang.RuntimeException: errCode = 2, detailMessage = Failed to get scan range, no queryable replica found in tablet: 51006077. Reason: Visible Replicas:Visible version: 2654043, Replicas: [replicaId=60759746, backendId=49901824, backendAlive=true, version=2649168, lastFailedVersion=2654042, lastSuccessVersion=2649168, lastFailedTimestamp=1745755815419, state=NORMAL].

报错时排查了 show tablet 51006077
SHOW PROC '/dbs/12729387/36809862/partitions/36809861/51006036/51006077';
并没有发现 "missing_rowsets": []

1 Answers

报错: Failed to get scan range, no queryable replica found in tablet: 51006077.

单副本,报这个错是丢version了,可能是你们导入未中断,然后BE出现了非正常停止导致。

目前这个情况需要手动补充rowset了,参考文章:副本修复排查指南