# replication error

**URL:** <https://forums.percona.com/t/replication-error/3956>\
**Category:** Other MySQL® Questions\
**Created:** [December 18, 2014, 1:44am UTC](https://forums.percona.com/t/replication-error/3956 "2014-12-18T01:44:09Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![das-ich](https://avatars.discourse-cdn.com/v4/letter/d/f04885/32.png) [@das-ich](https://forums.percona.com/u/das-ich)\
**Post date:** [December 18, 2014, 1:44am UTC](https://forums.percona.com/t/replication-error/3956/1 "2014-12-18T01:44:09Z")

</div>

Hi all.

My replication stopped with error Last\_SQL\_Errno: 1032 or Last\_SQL\_Errno: 1062  
example error:  
Last\_SQL\_Error: Could not execute Delete\_rows event on table cportal.b\_search\_content\_stem; Can’t find record in ‘b\_search\_content\_stem’, Error\_code: 1032; handler error HA\_ERR\_KEY\_NOT\_FOUND; the event’s master log mk-db1-master-bin.000488, end\_log\_pos 74862564

I am found this issue [url][http://www.percona.com/blog/2013/09/13/enabling-crash-safe-slaves-with-mysql-5-6/[/url]](http://www.percona.com/blog/2013/09/13/enabling-crash-safe-slaves-with-mysql-5-6/%5B/url%5D)  
but it not working for me.  
my version is Percona-Server-server-56-5.6.21-rel69.0.el6.x86\_64.

my slave cnf [url][http://pastebin.com/wTdcbTwU[/url]](http://pastebin.com/wTdcbTwU%5B/url%5D)  
my master cnf [url][http://pastebin.com/q2uJAynU[/url]](http://pastebin.com/q2uJAynU%5B/url%5D)

thanks for help

---

<div class="post-metadata">

**Author:** ![psong](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/psong/32/16894_2.png) [@psong](https://forums.percona.com/u/psong)\
**Post date:** [December 23, 2014, 2:16am UTC](https://forums.percona.com/t/replication-error/3956/2 "2014-12-23T02:16:00Z")

</div>

das-ich,  
The error message you posted said that one row to be deleted from cportal.b\_search\_content\_stem could not be found in the slave. This suggested that slave’s data is not consistent with the master. You can use STOP SLAVE; SET GLOBAL sql\_slave\_skip\_counter = 1; START SLAVE to skip this statement and resume replication. Then use pt-table-checksum/pt-table-sync to check and fix the data discrepancy between master and slave.  
For the use of pt-table-checksum/pt-table-sync, you can refer to the documentation at:  
[URL][http://www.percona.com/doc/percona-toolkit/2.2/pt-table-checksum.html[/URL]](http://www.percona.com/doc/percona-toolkit/2.2/pt-table-checksum.html%5B/URL%5D)  
[URL][http://www.percona.com/doc/percona-toolkit/2.2/pt-table-sync.html[/URL]](http://www.percona.com/doc/percona-toolkit/2.2/pt-table-sync.html%5B/URL%5D)