XinSuiNian opened a new issue, #55754: URL: https://github.com/apache/doris/issues/55754
### Search before asking - [x] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version Doris 版本 2.1.9 ### What's Wrong? Doris 2.1.9版本。 当前副本数量是单副本 在Doris BE 突然宕机后。 BE 再次启动后，Doris某些表无法正常Doris数据， 也无法正常查询 导入时报错： `[ANALYSIS_ERROR]TStatus: errCode = 2, detailMessage = Failed to commit txn 459678240, cause tablet 740453653 succ replica num 0 < load required replica num 1. table 73862495, partition: [ id=73862494, commit version 625473, visible version 625460 ], this tablet detail: 1 replicas write data succ but miss previous version: { [replicaId=740453654, backendId=10236, backendAlive=true, version=625460, lastFailedVersion=625461, lastSuccessVersion=625460, lastFailedTimestamp=0, state=NORMAL] }, please check output of SHOW TABLET for details. Please try again later. ` 查询时报错： `ERROR 1105 (HY000): errCode = 2, detailMessage = Failed to get scan range, no queryable replica found in tablet: 520050185. Reason: Visible Replicas:Visible version: 386708, Replicas: [replicaId=520050186, backendId=10236, backendAlive=true, version=386708, lastFailedVersion=386709, lastSuccessVersion=386708, lastFailedTimestamp=0, state=NORMAL].` ### What You Expected? 1、期望Doris 可以修复此bug 2、可以给出紧急的修复数据的方案。（当前是truncate 表重新导入的，数据量小还好，一旦数据量大，就影响很大） ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
