Resolved : mysql replica : Relay log read failure: Could not parse relay log event entry.

I’m not sure what the root cause may be. But to recover from this situation, you’d want to instruct MySQL to clear out all the relay-bin-logs beyond the following point

  • Relay_Master_Log_File: mysql-bin.000xxx
  • Exec_Master_Log_Pos: 143983426

by doing the following:

mysql> STOP SLAVE;

mysql> CHANGE MASTER TO MASTER_LOG_FILE = 'mysql-bin.000xxx', MASTER_LOG_POS = 143983426;

mysql> START SLAVE;

 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: