ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND;?

Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND;?

原创 Linux操作系统 作者:mysqldbd 时间:2011-05-06 16:25:14 0 删除 编辑
我的主从配置一样,主的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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-01-19

  • 博文量
    35
  • 访问量
    78734