Phantom Reads Occur When Reading Data Through TiFlash

Translated
1

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

Original topic: 通过tiflash读取数据出现幻读

| username: Running

The image is not available for translation. Please provide the text content that you need translated.

2
| username: WalterWj | Original post link

Did the user ID primary key get read out repeatedly?

3
| username: Running | Original post link

Yes, using the TiDB engine is no problem.

4
| username: tracy0984 | Original post link

Which version?

5
| username: WalterWj | Original post link

It feels like a bug? Try the new version to see if it gets better…
Or try recreating the replica for this table in TiFlash.

6
| username: WalterWj | Original post link

Also, perform an admin check on this table.

7
| username: Running | Original post link

The issue has been resolved. It was caused by the tiflash_fastscan parameter being enabled in the latest version, which led to data inaccuracies. After disabling it, everything returned to normal.

8
| username: Running | Original post link

The issue has been resolved; it was not a table corruption problem.

9
| username: Running | Original post link

For version 5.7.25-TiDB-v6.5.0, the tiflashfastscan parameter needs to be disabled.

10
| username: ohammer | Original post link

Thank you for sharing.

11
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.