系统重启后MySQL同步GTID错误: 1594

Last_SQL_Errno: 1594
Last_SQL_Error: Relay log read failure: Could not parse relay log event entry. The possible reasons are: the master’s binary log is corrupted (you can check this by running ‘mysqlbinlog’ on the binary log), the slave’s relay log is corrupted (you can check this by running ‘mysqlbinlog’ on the relay log), a network problem, or a bug in the master’s or slave’s MySQL code. If you want to check the master’s binary log or slave’s relay log, you will be able to know their names by issuing ‘SHOW SLAVE STATUS’ on this slave.

这个还比较好处理,停止同步,重新设置下主从同步信息。

stop slave;
change master to master_host = ’10.x.x.x’,master_port = 3306,master_user = ‘xxx’,master_password=’xxx’,master_auto_position = 1;
start slave;

此条目发表在服务器分类目录,贴了标签。将固定链接加入收藏夹。

发表回复