Sync_diff_inspector runtime error

Translated
1

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

Original topic: sync_diff_inspector运行报错

| username: 像风一样的男子

【TiDB Usage Environment】Production
【TiDB Version】4.0.9
【Encountered Problem】
I encountered an error when running sync_diff_inspector to verify synchronization between the primary and secondary databases.
Only one table is being verified.
image
Below is the error log

image
image1562×157 10.6 KB

How should I resolve this issue?

2
| username: okenJiang | Original post link

It looks like a checksum failure. According to the error log, 58052 + 58052 does not equal 116103. You can manually check if the count between upstream and downstream is truly synchronized (consistent).

3
| username: TiDBer_CEVsub | Original post link

I see that the names of the two tables are inconsistent.

4
| username: 像风一样的男子 | Original post link

The diff comparison is used precisely because of the inconsistency. The data volume of this table is a bit large, and sync_diff_inspector probably doesn’t support comparison of such large data volumes.

5
| username: system | Original post link

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