10 December 2013

MySQL 5.6 - Slave: received end packet from server, apparent master shutdown

I received the following error on a replication setup with Percona MySQL 5.6:
[Note] Slave: received end packet from server, apparent master shutdown:
[Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000024' at position 37418593

The issue was the server_uuid which is read from data_dir/auto.cnf. Read more here.
To diagnose:
mysql> show global variables like "Server%"
+----------------+--------------------------------------+
| Variable_name | Value |
+----------------+--------------------------------------+
| server_id | 20 |
| server_id_bits | 32 |
| server_uuid | 6a16558f-3b42-11e3-8548-00163e3d05d3 |
+----------------+--------------------------------------+
You have to make sure that server_id and server_uuid are different between all nodes participating in the master/slave setup.

No comments:

Post a Comment