Last_IO_Errno: 1236

从库报错:
 Last_IO_Errno: 1236
                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'
 Last_IO_Errno: 1236
                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'

				
mysql> stop slave;

systemctl stop mysqld				
mv /home/mysql/data/auto.cnf /mnt/
/etc/init.d/mysql start

mysql> start slave;
mysql> show slave status\G;

 

上一篇:1236错误场景分析


下一篇:业务代码优化杂谈