Tidb-dm Synchronous error: binlog checksum mismatch, data may be corrupted

1. Cause of problem:

Binlog checked 4G

2. Processing relay

1. When an upstream confirmation error occurs, the size of the corresponding binlog file exceeds 4GB

2. Stop DM worker

Note that instead of stop task, stop the corresponding DM worker process

3. Copy the upstream binlog file to the relay log directory as the relay log file.

4. Modify the relay .meta file

Update the corresponding relay.meta file in the relay log directory to pull from the next binlog. If DM worker is enabled_gtid, when modifying the relay.meta file, you also need to modify the gtid corresponding to the next binlog. If enable is not enabled_gtid, there is no need to modify the gtid.


Read More: