Bug #37211 Unclear error in MySQL Replication
Submitted: 5 Jun 2008 2:55 Modified: 17 Jun 2008 20:04
Reporter: Peter Zaitsev (Basic Quality Contributor) Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:5.0, 5.1 OS:Any
Assigned to: CPU Architecture:Any
Tags: qc

[5 Jun 2008 2:55] Peter Zaitsev
Description:
Replication may start logging the following error message on the slave with little clue about what is happening.

080603 20:53:10 [Note] Slave: connected to master 'repl@host.com:3306',replication resumed in log 'master-bin.003676' at position 444286437
080603 20:53:10 [Note] Slave: received end packet from server, apparent master shutdown:
080603 20:53:10 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'master-bin.003676' position 444292333
080603 20:53:10 [Note] Slave: connected to master 'repl@host.com:3306',replication resumed in log 'master-bin.003676' at position 444292333
080603 20:53:10 [Note] Slave: received end packet from server, apparent master shutdown:
080603 20:53:10 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'master-bin.003676' position 444294573
080603 20:53:10 [Note] Slave: connected to master 'repl@host.com:3306',replication resumed in log 'master-bin.003676' at position 444294573
080603 20:53:10 [Note] Slave: received end packet from server, apparent master shutdown:
080603 20:53:10 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'master-bin.003676' position 444298239
080603 20:53:10 [Note] Slave: connected to master 'repl@host.com:3306',replication resumed in log 'master-bin.003676' at position 444298239

How to repeat:
Set two slave to have same server-id and start replication..

Suggested fix:
Add more descriptive error message.
[5 Jun 2008 18:59] Sveta Smirnova
Thank you for the report.

Verified as described.
[17 Jun 2008 20:04] James Day
Duplicate of bug #33815, please make any additional comments to that bug instead of this one.