文档首页/ 数据复制服务 DRS/ 故障排除/ 失败案例/ MySQL->MySQL实时迁移和同步/ 增量阶段失败报错，关键词“Slave has more GTIDs than the master has, using the master's SERVER_UUID.”
更新时间：2024-11-29 GMT+08:00
查看PDF
分享

增量阶段失败报错，关键词“Slave has more GTIDs than the master has, using the master's SERVER_UUID.”

场景描述

增量迁移或同步期间DRS任务报错，日志提示信息：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.

可能原因

源库位点回退，或者源库执行了reset master重置了位点。

解决方案

在任务列表中，单击任务对应操作列的“重置”，重新开始任务；或重新创建DRS任务进行迁移。