MySQL5.7.x使用GTID主从同步show slave status时候报错信息如下

Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: '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 replica'

解决方法如下:
在Master上使用show master status查看 Executed_Gtid_Set的值,
在Slave上执行如下操作:

RESET MASTER;
set global gtid_purged = 'xxxx';                 -- 这里xxxx是Master的Executed_Gtid_Set
start slave;
show slave status\G;

问题解决,一般出现该问题主要是没正常操作binlog或主库宕机等引起gtid发生变化造成的。

 [ERROR] Slave I/O: Got fatal error 1236 from master when reading data from binary log: 'The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master has purged binary logs containing GTIDs that the slave requires.', Error_code: 1236

也可用同样的方法解决.

带符号 * 的表示必填项