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]