Slave: received end packet from server, apparent master shutdown

下午搭建了mysql一主多从,晚上查看slave日志的时候,发现slave服务器上错误日志不停的输出

130530 20:50:37 [Note] Slave: received end packet from server, apparent master shutdown:
130530 20:50:37 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000009' at position 752065283
130530 20:50:37 [Note] Slave: received end packet from server, apparent master shutdown:
130530 20:50:37 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000009' at position 752065283
130530 20:50:37 [Note] Slave: received end packet from server, apparent master shutdown:
130530 20:50:37 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000009' at position 752065283
130530 20:50:37 [Note] Slave: received end packet from server, apparent master shutdown:
130530 20:50:37 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000009' at position 752065283
130530 20:50:37 [Note] Slave: received end packet from server, apparent master shutdown:
130530 20:50:37 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000009' at position 752065283
130530 20:50:37 [Note] Slave: received end packet from server, apparent master shutdown:
130530 20:50:37 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000009' at position 752065283
130530 20:50:38 [Note] Slave: received end packet from server, apparent master shutdown:
130530 20:50:38 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000009' at position 752065283
130530 20:50:38 [Note] Slave: received end packet from server, apparent master shutdown:
130530 20:50:38 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000009' at position 752065283
130530 20:50:38 [Note] Slave: received end packet from server, apparent master shutdown:
130530 20:50:38 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000009' at position 752065283
130530 20:50:38 [Note] Slave: received end packet from server, apparent master shutdown:
130530 20:50:38 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000009' at position 752065283

原来slave上的my.cnf 配置文件是一台台拷贝的,忘记修改server-id值,导致server-id值相同,切记,切记,server-id值一定保持唯一。

修改server-id,重启mysql server,ok。

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值