# Problem with RBR replication, HA\_ERR\_END\_OF\_FILE

**URL:** <https://forums.percona.com/t/problem-with-rbr-replication-ha-err-end-of-file/1784>\
**Category:** Other MySQL® Questions\
**Created:** [March 27, 2012, 7:46am UTC](https://forums.percona.com/t/problem-with-rbr-replication-ha-err-end-of-file/1784 "2012-03-27T07:46:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![achapela](https://avatars.discourse-cdn.com/v4/letter/a/35a633/32.png) [@achapela](https://forums.percona.com/u/achapela)\
**Post date:** [March 27, 2012, 7:46am UTC](https://forums.percona.com/t/problem-with-rbr-replication-ha-err-end-of-file/1784/1 "2012-03-27T07:46:58Z")

</div>

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 ?

---

<div class="post-metadata">

**Author:** ![xaprb](https://avatars.discourse-cdn.com/v4/letter/x/49beb7/32.png) [@xaprb](https://forums.percona.com/u/xaprb)\
**Post date:** [March 27, 2012, 11:41am UTC](https://forums.percona.com/t/problem-with-rbr-replication-ha-err-end-of-file/1784/2 "2012-03-27T11:41:06Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![achapela](https://avatars.discourse-cdn.com/v4/letter/a/35a633/32.png) [@achapela](https://forums.percona.com/u/achapela)\
**Post date:** [March 27, 2012, 1:36pm UTC](https://forums.percona.com/t/problem-with-rbr-replication-ha-err-end-of-file/1784/3 "2012-03-27T13:36:53Z")

</div>

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 …
