MySQL Forums
Forum List  »  Replication

Re: Slave has more data than Master?
Posted by: Irfan Ali
Date: February 23, 2012 06:01AM

>> There is another thing which I think may be relevant: the replication crashed twice for the same reason Fatal error 1236. the slave said" reading data from binary log from impossible position". According to this, I check the position on Master, I found"Most probably mysqld crashed writing it". Is it relevant?

How did you resolve it on slave ? This error means mysql slave thread forget it's replication position. It requires CHANGE MASTER TO command to point to correct position from master binary log after verification of data on master.

If you started slave from wrong position it yields errors and master slave data will be inconsistent.

Options: ReplyQuote


Subject
Views
Written By
Posted
2464
February 21, 2012 06:43AM
1201
February 22, 2012 02:49AM
1259
February 22, 2012 10:23PM
Re: Slave has more data than Master?
1387
February 23, 2012 06:01AM
1049
February 24, 2012 04:27AM
1156
February 24, 2012 07:26AM
1118
March 05, 2012 04:38AM
850
March 22, 2012 05:26AM
955
March 26, 2012 02:37AM


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.