I already wrote about some MySQL Error Messages which are confusing, here is one more:
PLAIN TEXT
SQL:

1. [FONT='Courier New', Courier, monospace]080603 20:53:10 [Note] Slave: connected TO master 'repl@host.com:3306',replication resumed IN log 'master-bin.003676' at position 444286437[/font]
2. [FONT='Courier New', Courier, monospace]080603 20:53:10 [Note] Slave: received end packet FROM server, apparent master shutdown:[/font]
3. [FONT='Courier New', Courier, monospace]080603 20:53:10 [Note] Slave I/O thread: Failed reading log event, reconnecting TO retry, log 'master-bin.003676' position 444292333[/font]
4. [FONT='Courier New', Courier, monospace]080603 20:53:10 [Note] Slave: connected TO master 'repl@host.com:3306',replication resumed IN log 'master-bin.003676' at position 444292333[/font]
5. [FONT='Courier New', Courier, monospace]080603 20:53:10 [Note] Slave: received end packet FROM server, apparent master shutdown:[/font]
6. [FONT='Courier New', Courier, monospace]080603 20:53:10 [Note] Slave I/O thread: Failed reading log event, reconnecting TO retry, log 'master-bin.003676' position 444294573[/font]
7. [FONT='Courier New', Courier, monospace]080603 20:53:10 [Note] Slave: connected TO master 'repl@host.com:3306',replication resumed IN log 'master-bin.003676' at position 444294573[/font]
8. [FONT='Courier New', Courier, monospace]080603 20:53:10 [Note] Slave: received end packet FROM server, apparent master shutdown:[/font]
9. [FONT='Courier New', Courier, monospace]080603 20:53:10 [Note] Slave I/O thread: Failed reading log event, reconnecting TO retry, log 'master-bin.003676' position 444298239[/font]
10. [FONT='Courier New', Courier, monospace]080603 20:53:10 [Note] Slave: connected TO master 'repl@host.com:3306',replication resumed IN log 'master-bin.003676' at position 444298239 [/font]

After setting up new slave Server I'm getting error log file flooded with messages like this and there is no hint in the message what would explain what is wrong.
In fact the issue in this case is (because of configuration error) two slave servers got the same server-id.
Seriously in this case Master clearly sees the problem in this case as there are 2 servers with same server-id connected and replicating so it should report it to the slave instead of sending end packet.
At very least it would be nice to include possible reason for this error message which MySQL already does in many other cases.
I've now filed it as a bug.
Entry posted by peter | No comment
Add to: | | | |


Confusing MySQL Replication Error Message - Read More...