Rootop 服务器运维与web架构

Could not parse relay log event entry. The possible reasons are: the master’s binary log is corrupted

| 暂无评论

mysql主从做复制,从库报错:
130116 18:23:09 [ERROR] Slave: 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. Error_code: 0

在show slave status\G;中记录下Relay_Master_Log_File、Exec_Master_Log_Pos参数。

Master_Log_File: mysql-bin.000123
Read_Master_Log_Pos: 1059298549
Relay_Log_File: mysqld-relay-bin.000002
Relay_Log_Pos: 405876091
Relay_Master_Log_File: mysql-bin.000123
Exec_Master_Log_Pos: 675697758

shell>stop slave;

重新配置同步,把Exec_Master_Log_Pos的偏移量+1 、Relay_Master_Log_File值不变,以此来作为同步日志名称及偏移量。

同步参考:https://www.rootop.org/pages/1503.html

至于为什么出现这个错误,大多数资料都显示为mysql版本太低,我这里是5.0,同步功能或许真不咋地,而且从库version比主库低!

原创文章,转载请注明。本文链接地址: https://www.rootop.org/pages/1527.html

作者:Venus

服务器运维与性能优化

发表回复