Monday, June 24, 2013

MySql replication error: "Could not parse relay log event entry"

I was able to solve this problem by executing the following steps.


  1. I checked replication on the other slave. The replication thread on the other slave was running fine and slave was upto date with the master, implying that the relay logs on the first slave were the problem.
  2. On my first slave (the one with the replication error) I ran the following commands:
    • stop slave;
    • show slave status\G;
    • Note the Relay_Master_Log_File and Exec_Master_Log_Pos variables.
    • run command:- change master to MASTER_LOG_FILE='mysql-bin.010530, MASTER_LOG_POS=40783167;
    • start slave
This fixed my replication problem.

No comments:

Post a Comment