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.
Subject
Views
Written By
Posted
2475
February 21, 2012 06:43AM
1207
February 22, 2012 02:49AM
1263
February 22, 2012 10:23PM
Re: Slave has more data than Master?
1396
February 23, 2012 06:01AM
1057
February 24, 2012 04:27AM
1161
February 24, 2012 07:26AM
1123
March 05, 2012 04:38AM
855
March 22, 2012 05:26AM
790
March 23, 2012 08:03PM
960
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.