140109 15:13:13 [Note] Slave: received end packet from server, apparent master shutdown:
140109 15:13:13 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-binlog.000899‘ at position 301029473
140109 15:13:14 [Note] Slave: received end packet from server, apparent master shutdown:
140109 15:13:14 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-binlog.000899‘ at position 301029473
140109 15:13:14 [Note] Slave: received end packet from server, apparent master shutdown:
140109 15:13:14 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-binlog.000899‘ at position 301031427
140109 15:13:14 [Note] Slave: received end packet from server, apparent master shutdown:
140109 15:13:14 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-binlog.000899‘ at position 301035259
140109 15:13:14 [Note] Slave: received end packet from server, apparent master shutdown:
140109 15:13:14 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-binlog.000899‘ at position 301037299
140109 15:13:14 [Note] Slave: received end packet from server, apparent master shutdown:
140109 15:13:14 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-binlog.000899‘ at position 301038319
140109 15:13:15 [Note] Slave: received end packet from server, apparent master shutdown:
140109 15:13:15 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-binlog.000899‘ at position 301038319
140109 15:13:15 [Note] Slave: received end packet from server, apparent master shutdown:
140109 15:13:15 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-binlog.000899‘ at position 301050289
140109 15:13:15 [Note] Slave: received end packet from server, apparent master shutdown:
140109 15:13:15 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-binlog.000899‘ at position 301053956
140109 15:13:15 [Note] Slave: received end packet from server, apparent master shutdown:
140109 15:13:15 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-binlog.000899‘ at position 301053956
140109 15:13:16 [Note] Slave: received end packet from server, apparent master shutdown:
140109 15:13:16 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-binlog.000899‘ at position 301054211
140109 15:13:16 [Note] Slave: received end packet from server, apparent master shutdown:
140109 15:13:16 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-binlog.000899‘ at position 301054466
140109 15:13:16 [Note] Slave: received end packet from server, apparent master shutdown:
140109 15:13:16 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-binlog.000899‘ at position 301057629
SLAVE的错误日志里面不停的刷上面的问题,而且show slave status\G的时候Slave_IO_Running一时YES,一时NO。
问题的原因是:和某一台slave的server_id重复了
原文:http://ldhqy.blog.51cto.com/2788106/1620116