Inconsistency in TiFlash Data

This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: TiFlash数据不一致

| username: wakaka

[TiDB Usage Environment] Production Environment
[TiDB Version] 5.2.2
[Reproduction Path] Not sure why it happened
[Encountered Problem: Problem Phenomenon and Impact] TiFlash data is not synchronized, and the result of querying count(*) is inconsistent each time
[Resource Configuration]
[Attachments: Screenshots/Logs/Monitoring]

| username: xfworld | Original post link

Is the count inconsistent because the data is still changing?

Is there any anomaly with TiFlash?

| username: wakaka | Original post link

This is the same SQL query. It should be consistent. When I query individually, it is also inconsistent, and the query result with the specified TiKV hint is inconsistent.

| username: wakaka | Original post link

I didn’t see any related errors when searching the recent ERROR logs. Which keyword should I search for?

| username: Billmay表妹 | Original post link

The known issue is related to a critical error in TiFlash that may cause data inconsistency when deleting large amounts of data. This error affects versions v6.0.0, v5.4.0 ~ v5.4.1, v5.3.0 ~ v5.3.1, v5.2.0 ~ v5.2.4, v5.1.0 ~ v5.1.4, v5.0.0 ~ v5.0.6, and v4.0.0 ~ v4.0.16. To resolve this issue, you can upgrade to a newer version of TiFlash. The error has been fixed in versions v6.1.0, v5.4.2, v5.3.2, v5.2.5, v5.1.5, v5.0.7, and v4.0.17.

| username: wakaka | Original post link

Oh, can you send the error link? Thanks.

| username: Kongdom | Original post link

Has anyone done BR restoration?

| username: wakaka | Original post link


| username: Kongdom | Original post link

That should not be caused by BR restoration.