mysql同步server-id故障

100531 10:31:14 [Note] Slave: received end packet from server, apparent master shutdown:

100531 10:31:14 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysqld-bin.000003' at postion 241297498

100531 10:31:14 [Note] Slave: received end packet from server, apparent master shutdown:

100531 10:31:14 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysqld-bin.000003' at postion 241297498

100531 10:31:15 [Note] Slave: received end packet from server, apparent master shutdown:

100531 10:31:15 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysqld-bin.000003' at postion 241297498

100531 10:31:15 [Note] Slave: received end packet from server, apparent master shutdown:

100531 10:31:15 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysqld-bin.000003' at postion 241297498

100531 10:31:15 [Note] Slave: received end packet from server, apparent master shutdown:

100531 10:31:15 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysqld-bin.000003' at postion 241297498

100531 10:31:16 [Note] Slave: received end packet from server, apparent master shutdown:

100531 10:31:16 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysqld-bin.000003' at postion 241297498

100531 10:31:16 [Note] Slave: received end packet from server, apparent master shutdown:

100531 10:31:16 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysqld-bin.000003' at postion 241297498

100531 10:31:16 [Note] Slave: received end packet from server, apparent master shutdown:

100531 10:31:16 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysqld-bin.000003' at postion 241297498

100531 10:31:20 [Note] Slave: received end packet from server, apparent master shutdown:

100531 10:31:20 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysqld-bin.000003' at postion 241297498

mysql  slave一直有以上報錯，經查實是因為得my.cnf中配置了兩個server-id導緻。

轉載于:https://blog.51cto.com/gaizaoren/324133