Last_IO_Error: Got fatal error 1236 from master when reading data from binary log报错解决
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的值，
RESET MASTER; set global gtid_purged = 'xxxx'; -- 这里xxxx是Master的Executed_Gtid_Set start slave; show slave status\G;
[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