Re: Slave_IO_Running = NO
Posted by:
James Day
Date: March 30, 2005 12:32AM
When I've seen the "Error reading packet from server: Client requested master to start replication from impossible position (server_errno=1236)" it has usually been because someone was restarting replication and gave the position in the relay log on the slave, not the position in the master binary log. Have a look at the error log file on the slave and check the sequence of starts and stops there to find out the right start position to use.
If this is not the cause and fix, posting a reply with the sequence of stop and start positions from the error log may give another clue to help find the cause.
If you can't find the problem quickly it may sometimes be easier and faster for you to clone the master to the slave again and restart replication as if it was a new slave.
Subject
Views
Written By
Posted
31079
March 29, 2005 07:27AM
Re: Slave_IO_Running = NO
14743
March 30, 2005 12:32AM
92711
March 30, 2005 06:38AM
30676
April 01, 2005 01:35AM
20181
April 01, 2005 03:21AM
16817
April 01, 2005 09:31PM
26209
April 18, 2006 12:07AM
19436
April 21, 2006 07:18PM
13667
June 14, 2006 03:04PM
11827
January 08, 2008 03:50PM
11435
January 08, 2008 04:47PM
11820
March 08, 2008 07:40PM
10558
March 09, 2008 07:59AM
11122
December 15, 2008 11:43AM
6474
December 18, 2008 01:58AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.