我的博客已迁移到xdoujiang.com请去那边和我交流 1、mysql版本 5.5.24 2、ip 10.1.1.1 3、查看下slave状态 mysql> show slave status\G; *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 10.1.1.1 Master_User: repl Master_Port: 1111 Connect_Retry: 60 Master_Log_File: 29.001312 Read_Master_Log_Pos: 6783188 Relay_Log_File: 10-relay-bin.006100 Relay_Log_Pos: 93356016 Relay_Master_Log_File: 29.001309 Slave_IO_Running: Yes Slave_SQL_Running: No Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 1594 Last_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. Skip_Counter: 1 Exec_Master_Log_Pos: 365359563 Relay_Log_Space: 372590271 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: NULL Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: 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. Replicate_Ignore_Server_Ids: Master_Server_Id: 2229 1 row in set (0.00 sec) ERROR: No query specified 4、解决办法 stop slave; change master to master_host='10.1.1.1',master_port=3306,master_log_file='29.001310',master_log_pos=1; start slave; show slave status\G;
Relay log read failure错误解决
原创文章标签 mysql 1594 relay log 文章分类 MySQL 数据库
©著作权归作者所有:来自51CTO博客作者xdoujiang的原创作品,请联系作者获取转载授权,否则将追究法律责任
![](https://ucenter.51cto.com/images/noavatar_middle.gif)
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章