After master shutdown and restarted, the slave should
resume replication from when it was stopped. But this
time, I got message said, 'Client requested master to
start replication from impossible position'. (see the
log below). Anybody can explain?
070423 9:17:44 [Note] Slave: received end packet from
server, apparent master shutdown:
070423 9:17:44 [Note] Slave I/O thread: Failed
reading log event, reconnecting to retry, log
'binlog.000582' position 19787047
070423 9:17:44 [ERROR] Slave I/O thread: error
reconnecting to master 'acct:3306': Error: 'Lost
connection to MySQL server during query' errno: 2013
retry-time: 60 retries: 86400
070423 9:20:07 [ERROR] Slave I/O thread: error
reconnecting to master 'acct:3306': Error: 'Can't
connect to MySQL server on 'masterhost' (10060)'
errno: 2003 retry-time: 60 retries: 86400
070423 9:22:30 [Note] Slave: connected to master
'acct:3306',replication resumed in log 'binlog.000582'
at position 19787047
070423 11:21:01 [ERROR] Error reading packet from
server: Client requested master to start replication
from impossible position ( server_errno=1236)
070423 11:21:01 [ERROR] Got fatal error 1236: 'Client
requested master to start replication from impossible
position' from master when reading data from binary
070423 11:21:01 [Note] Slave I/O thread exiting, read
up to log 'binlog.000583', position 2432394
--end of message
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around