Problem with RBR replication, HA_ERR_END_OF_FILE

MySQL & MariaDB Other MySQL® Questions
1

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.

How to debug it ?

2

Your replica has different data than the master does. pt-table-checksum and pt-table-sync are your friends.

3

Yes, but why I have different data ? Someone is modifying data on slave server ? Is strange because is only for read, and replication is configurated with RBR mode fron scratch…

I will configure slave server with read only mode to know if some of my developers is using it to modifying data …