Sync-diff-inspector execution progress stuck at a specific value for a long time

Translated
1

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

Original topic: sync-diff-inspector执行进度在某一特定值卡住很久

| username: 刘亚欣1

【TiDB Usage Environment】Production Environment
【TiDB Version】
【Reproduction Path】Using sync-diff-inspector for data validation
【Encountered Problem: Phenomenon and Impact】
When using sync-diff-inspector for validation, the progress stalls at a certain value, possibly 97%, 99%, etc. Checking the logs, there are no updates for 12 hours, and no new tables are being validated (each table has a small amount of data, so it shouldn’t take several hours to validate one table).
【Resource Configuration】All monitoring indicators are normal
【Attachments: Screenshots/Logs/Monitoring】

image
image1321×279 23.8 KB

2
| username: Billmay表妹 | Original post link

Verify MySQL and TiDB?

You can refer to this post:

3
| username: Billmay表妹 | Original post link

Here are some related questions you can check out: TiDB 社区搜索

4
| username: 刘亚欣1 | Original post link

Yes, verify MySQL->TiDB, not MySQL->MySQL~

5
| username: yilong | Original post link

Is the data volume relatively fixed?

6
| username: 刘亚欣1 | Original post link

Yes, there is basically no writing. It always gets stuck in one place for a long time. This happens right at the beginning of the verification process, where it gets stuck, and the progress remains at 0%. The logs also do not update for a long time.

7
| username: yilong | Original post link

These two are the same issue, just look at one of them.

8
| username: system | Original post link

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