1, MySQL version 5.5.242, ip10.1.1.13, view the slave status 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: nullmaster_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: 22291 row in set (0.00 sec) error: no query specified4, Solution 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;
This article is from the "7928217" blog, please be sure to keep this source http://7938217.blog.51cto.com/7928217/1662067
Relay Log read failure error resolution