Bug #69094 Could not execute Delete_rows event on table, Error_code: 1032; handler error
Submitted: 29 Apr 2013 19:00 Modified: 30 Apr 2013 11:33
Reporter: Wei Shen Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Row Based Replication ( RBR ) Severity:S2 (Serious)
Version:5.5.30 OS:Linux
Assigned to: CPU Architecture:Any
Tags: 1032, hardler error

[29 Apr 2013 19:00] Wei Shen
Description:
I have a master/slave replication and sometimes replication stops with the following error:

Last_SQL_Error: Could not execute Delete_rows event on table optiweber2.sa_crawls; Can't find record in 'sa_crawls', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log bin-log.000027, end_log_pos 882646945

How to repeat:
rsync database from master to slave
setup replication by pointing slave to the master
after sometime it will break
[30 Apr 2013 11:33] MySQL Verification Team
Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

We really need more details to consider a bug. Such as table structure and some idea of queries to replay on the master so the slave hits an error.  Are @user variables involved?  Does anybody modify slave directly, etc.