Sunday, December 26, 2010

Replication resumed, Apparent master shutdown, Failed reading log event

The slave server is getting this error in error log.

081102 0:30:18 [Note] Slave: connected to master ‘replicate@10.0.1.5:3310′,replication resumed in log ‘central3310.000142′ at position 789529654
081102 0:30:18 [Note] Slave: received end packet from server, apparent master shutdown:
081102 0:30:18 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘central3310.000142′ position 789529654

Solution :

The problem has started when a new slave has been configured for the existing setup. The slave server-id is matching exactly with another slave server-id, so the replication is happening for some time and then stopping. Finally one server is getting crashed. Then stop one of the slaves, change the server-id and start the slave to rectify the same.

1 comment:

  1. http://www.mysqlperformanceblog.com/2008/06/04/confusing-mysql-replication-error-message/

    ReplyDelete