List:Replication« Previous MessageNext Message »
From:Database System Date:April 24 2007 8:54pm
Subject:Client asks master to start rep from impossible position
View as plain text  
Hi group,

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?
Thanks, Lisa

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
log
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 
http://mail.yahoo.com 
Thread
Client asks master to start rep from impossible positionDatabase System24 Apr
  • RE: Client asks master to start rep from impossible positionRick James25 Apr
  • Re: Client asks master to start rep from impossible positionJoe25 Apr
  • Re: Client asks master to start rep from impossible positionWayne Gemmell25 Apr
    • Re: Client asks master to start rep from impossible positionDing Deng25 Apr