Problem with RBR replication, HA_ERR_END_OF_FILE

03-27-2012, 08:16 AM

After preparing a slave server I have an error after a while running:
Could not execute Update_rows event on table tbl; Can't find record in 'tbl', Error_code: 1032; handler error HA_ERR_END_OF_FILE; the event's master log mysql-bin.72142, end_log_pos 6387298

I don't know what could be the problem. This master-slave configuration have been running for years without any problem in SBR mode and now is getting trouble changing to RBR.

Comment

Are you absolutely sure that you got your master and slave in sync when you started the replication?
Since if they aren't completely in sync then everything will look like it works for a while and data will be replicated to the slave. Until one day an UPDATE comes along and wants to update one of the records that went missing on the slave in the "gap" of the replication.