Help Center/ Data Replication Service/ Troubleshooting/ Failure Cases/ Real-Time Migration and Synchronization from MySQL to MySQL/ Incremental Phase Error: Slave has more GTIDs than the master has, using the master's SERVER_UUID.
Updated on 2023-09-06 GMT+08:00
View PDF
Share

Incremental Phase Error: Slave has more GTIDs than the master has, using the master's SERVER_UUID.

Scenarios

During an incremental migration or synchronization, an error is reported, and the log information is as follows: service LOGMANAGER failed, cause by: Received error packet: errno = 1236, sqlstate = HY000 errmsg = Slave has more GTIDs than the master has, using the master's SERVER_UUID. This may indicate that the end of the binary log was truncated or that the last binary log file was lost, e.g., after a power or disk failure when sync_binlog != 1. The master may or may not have rolled back transactions that were already replicated to the slave. Suggest to replicate any transactions that master has rolled back from slave to master, and/or commit empty transactions on master to account for transactions that have been.

Possible Causes

The source database position is rolled back, or the source database position is reset by running the reset master command.

Solution

In the task list, locate the target task and click Reset in the Operation column to reset the task. Alternatively, create a DRS task again.