DM Synchronization Error:

Translated
1

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

Original topic: DM同步报错：

| username: TiDBer_nKzLOm2B

【TiDB Usage Environment】Production
【TiDB Version】v6.1.0
【Encountered Issue】

image
image1380×638 60.8 KB

【Reproduction Path】Currently, this issue occurs when synchronizing a single table. I would like to ask what the reason for this is. Full synchronization works, but incremental does not.
【Issue Phenomenon and Impact】

【Attachments】

  • Relevant logs, configuration files, Grafana monitoring (https://metricstool.pingcap.com/)
    The log content is only these
    image
    image1431×807 22.2 KB
  • TiUP Cluster Display information
  • TiUP Cluster Edit config information
  • TiDB-Overview monitoring
  • Corresponding module Grafana monitoring (such as BR, TiDB-binlog, TiCDC, etc.)
  • Corresponding module logs (including logs one hour before and after the issue)

If the question is related to performance optimization or troubleshooting, please download the script and run it. Please select all and copy-paste the terminal output results for upload.

2
| username: lance6716 | Original post link

Which company’s RDS are you using upstream? Can you show the output of SHOW SLAVE HOSTS?

3
| username: TiDBer_nKzLOm2B | Original post link

Tencent’s

image
image1102×117 5.52 KB

4
| username: TiDBer_nKzLOm2B | Original post link

I am currently using the replica, and the primary database is also reporting this error.

5
| username: lance6716 | Original post link

Compared to standard MySQL, there is an additional column called Role. DM does not support this behavior for now. We will optimize it later. improve the backward compatibility of “SHOW SLAVE HOSTS“ command · Issue #5017 · pingcap/tiflow · GitHub

6
| username: TiDBer_nKzLOm2B | Original post link

Okay, thank you for the reply.