admin管理员组

文章数量:1550528

机房掉电，数据库非正常关机。MySQL拉起后，从库报如下错误。

  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 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'

Executed_Gtid_Set: 78baf053-b460-11ea-9b26-b82a72d58ac1:1-3,
f738f1f9-b466-11ea-a7b4-b82a72d58ac1:1-169102298

原因： 没有设置sync_binlog = 1

解决方法：

1.主库设置比从库大的GTID.

mysql> SET SESSION GTID_NEXT='f738f1f9-b466-11ea-a7b4-b82a72d58ac1:169102299';    
Query OK, 0 rows affected (0.00 sec)

mysql> begin ; commit; set gtid_next='automatic';

 

2.从库

stop slave;start slave; show slave status; 

 

 

 

 

 

 

 

本文标签： GTIDsSlaveSERVERUUIDMaster

版权声明：本文标题：Slave has more GTIDs than the master has, using the master‘s SERVER_UUID 内容由热心网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：https://m.elefans.com/dongtai/1727249006a1104998.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。