概述
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 statusG的时候Slave_IO_Running一时YES,一时NO。
问题的原因是:和某一台slave的server_id重复了
转载于:https://blog.51cto.com/ldhqy/1620116
最后
以上就是直率犀牛为你收集整理的Mysql slave error的全部内容,希望文章能够帮你解决Mysql slave error所遇到的程序开发问题。
如果觉得靠谱客网站的内容还不错,欢迎将靠谱客网站推荐给程序员好友。
发表评论 取消回复