nosilence 发表于 2018-9-28 08:21:03

mysql同步server-id故障

  100531 10:31:14 Slave: received end packet from server, apparent master shutdown:
  100531 10:31:14 Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysqld-bin.000003' at postion 241297498
  100531 10:31:14 Slave: received end packet from server, apparent master shutdown:
  100531 10:31:14 Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysqld-bin.000003' at postion 241297498
  100531 10:31:15 Slave: received end packet from server, apparent master shutdown:
  100531 10:31:15 Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysqld-bin.000003' at postion 241297498
  100531 10:31:15 Slave: received end packet from server, apparent master shutdown:
  100531 10:31:15 Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysqld-bin.000003' at postion 241297498
  100531 10:31:15 Slave: received end packet from server, apparent master shutdown:
  100531 10:31:15 Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysqld-bin.000003' at postion 241297498
  100531 10:31:16 Slave: received end packet from server, apparent master shutdown:
  100531 10:31:16 Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysqld-bin.000003' at postion 241297498
  100531 10:31:16 Slave: received end packet from server, apparent master shutdown:
  100531 10:31:16 Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysqld-bin.000003' at postion 241297498
  100531 10:31:16 Slave: received end packet from server, apparent master shutdown:
  100531 10:31:16 Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysqld-bin.000003' at postion 241297498
  100531 10:31:20 Slave: received end packet from server, apparent master shutdown:
  100531 10:31:20 Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysqld-bin.000003' at postion 241297498
  mysqlslave一直有以上报错,经查实是因为得my.cnf中配置了两个server-id导致。

页: [1]
查看完整版本: mysql同步server-id故障