So, I got the error in my MySQL Slave something error code like 1594, Relay log read failure: Could not parse relay log event entry.
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.
MySQL Error 1594, is the mysql replication error not able to read relay log from the Master.
>show slave status\G;
mysql> SHOW SLAVE STATUS\G; *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 192.168.1.10 Master_User: tastethelinux Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin-changelog.001599 Read_Master_Log_Pos: 110977146 Relay_Log_File: mysql-rr-relay-bin.003183 Relay_Log_Pos: 123039468 Relay_Master_Log_File: mysql-bin-changelog.001595 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: 0 Exec_Master_Log_Pos: 123039295 Relay_Log_Space: 647842039 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: 1454754655 Master_UUID: c3b6cf4c-98f2-329e-86a8-25f5c3b0fc42 Master_Info_File: /var/lib/mysql/master.info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: 200604 09:42:52 Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: Executed_Gtid_Set: Auto_Position: 0 1 row in set (0.00 sec)
So, the highlighted part Relay_Master_Log_File and Exec_Master_Log_Pos, we have to copy it somewhere.
We will stop the Slave now with the following command.
>STOP SLAVE;
So, After Stopping the slave we will reset the slave by using reset slave command.
>RESET SLAVE;
Now we have reset slave so guys we will set the master log file and master log position.
>CHANGE MASTER TO master_log_file='mysql-bin-changelog.001595', master_log_pos=123039295;
So, now we will start the salve in the slave server.
>START SLAVE;
Again check the status of the Slave by using the below command and please check the Seconds_Behind_Master parameters.
>show slave status\G;
Once, the Seconds_Behind_Master will be Zero, then the Master and Slave Server will be in Sync.
Thanks for Reading the post on the ERROR 1594 in MySQL.
Refer the link for this error in MySQL, Error code 1298 Slave Unknown or incorrect time zone Error code 1062 Slave duplicate entry
My First YouTube Video in Linux Command, Share the Knowledge, and keep supporting us!
You can also practice a Linux refer to this link
