Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND;？

我的主从配置一样，主的binlog是mixed，从的binlog也是mixed。

在网上看了许多同类的问题，都是先stop slave，然后从新change  master到报错位置。然后start slave，下面是我的经历过程。

-- ===============================================
Could not execute Update_rows event on table csf.tmp_excel_data; Can't find record in 'tmp_excel_data', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.000521, end_log_pos 869528465

stop slave ;
CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000521', MASTER_LOG_POS=869528465;
start slave;
show slave status;

-- ================================
Could not execute Update_rows event on table csf.tmp_excel_data; Can't find record in 'tmp_excel_data', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.000521, end_log_pos 869528770

stop slave ;
CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000521', MASTER_LOG_POS=869528770;
start slave;
show slave status;

-- ======================
Could not execute Update_rows event on table csf.tmp_excel_data; Can't find record in 'tmp_excel_data', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.000521, end_log_pos 869529075
stop slave ;
CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000521', MASTER_LOG_POS=869529075;
start slave;
show slave status\G;

-- =======================
Could not execute Update_rows event on table csf.tmp_excel_data; Can't find record in 'tmp_excel_data', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.000521, end_log_pos 869529380
stop slave ;
CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000521', MASTER_LOG_POS=869529380;
start slave;
show slave status\G;

-- ==================
Last_SQL_Error: Could not execute Update_rows event on table csf.tmp_excel_data; Can't find record in 'tmp_excel_data', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.000521, end_log_pos 869529685

stop slave ;
CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000521', MASTER_LOG_POS=869529685;
start slave;
show slave status\G;
-- =============================
Last_SQL_Error: Could not execute Update_rows event on table csf.tmp_excel_data; Can't find record in 'tmp_excel_data', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.000521, end_log_pos 869529990
stop slave ;
CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000521', MASTER_LOG_POS=869529990;
start slave;
show slave status\G;

-- =============================
Last_SQL_Error: Could not execute Update_rows event on table csf.tmp_excel_data; Can't find record in 'tmp_excel_data', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.000521, end_log_pos 869530295

stop slave ;
CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000521', MASTER_LOG_POS=869530295;
start slave;
show slave status\G;

-- ============================
Last_SQL_Error: Could not execute Update_rows event on table csf.tmp_excel_data; Can't find record in 'tmp_excel_data', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.000521, end_log_pos 869530600

stop slave ;
CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000521', MASTER_LOG_POS=869530600;
start slave;
show slave status\G;

然后每次重新change master之后，继续报错10032，我郁闷了，不能人工这么每次change，也不知道需要change多少次，才能双yes，不报100032错误呢。
我不想暴力手段解决啊：在my.cnf里面，设置slave-skip-errors=1032  然后从新启动mysql数据库

大家对复制熟悉的，多提供一点意见吧！在今天下班之前，如果还没有搞定，只有最后用暴力手段了。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25267658/viewspace-694633/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25267658/viewspace-694633/