[Bug] Doris BE 宕机后数据无法导入和查询 #55754
Description
Search before asking
- I had searched in the issues 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
- I agree to follow this project's Code of Conduct