Slave: received end packet from server, apparent master shutdown

[Todd Troxell]

Hello,

I am seeing this message continuously in my 5.0.51a-24+lenny1 logs.
It is a master-master setup in which one node had inconsistent tables.
I tried to patch this by running a dump on the known-good server
and importing that to the broken server + starting slave thread.
This was the result:

091103  0:39:41 [Note] Slave I/O thread: Failed reading log event,
reconnecting to retry, log 'mysql-bin.000663' position 164513659
091103  0:39:41 [Note] Slave: connected to master
'root@stripped:3306',replication resumed in log
'mysql-bin.000663' at position 164513659
091103  0:39:41 [Note] Slave: received end packet from server, apparent
master shutdown: 
091103  0:39:41 [Note] Slave I/O thread: Failed reading log event,
reconnecting to retry, log 'mysql-bin.000663' position 164513835
091103  0:39:41 [Note] Slave: connected to master
'root@stripped:3306',replication resumed in log
'mysql-bin.000663' at position 164513835
091103  0:39:42 [Note] Slave: received end packet from server, apparent
master shutdown: 
091103  0:39:42 [Note] Slave I/O thread: Failed reading log event,
reconnecting to retry, log 'mysql-bin.000663' position 164514011
091103  0:39:42 [Note] Slave: connected to master
'root@stripped:3306',replication resumed in log
'mysql-bin.000663' at position 164514011
091103  0:39:42 [Note] Slave: received end packet from server, apparent
master shutdown: 
091103  0:39:42 [Note] Slave I/O thread: Failed reading log event,
reconnecting to retry, log 'mysql-bin.000663' position 164514011

Main master does not seem to log anything about these disconnects,
unless maybe I can turn up logging verbosity?

I've been searching for answers to this for a while and it seems like 99% of
cases are the result of a duplicate server_id  I have verified that both
servers are different in config and in memory:

Server 1:
mysql> show variables where variable_name ='server_id';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| server_id     | 2     | 
+---------------+-------+
1 row in set (0.00 sec)

Server 2:
mysql> show variables where variable_name ='server_id';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| server_id     | 1     | 
+---------------+-------+
1 row in set (0.00 sec)
 
Any clues are greatly appreciated!

-- 
Todd Troxell
http://rapidpacket.com/~xtat