Could not execute Delete_rows event on table mysql.__firewall_rules__; Can’t find record in ‘__firewall_rules__’, Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event’s master log mysql-bin.000228, end_log_pos 30423413

  sre

5fd8bba6ae5662013.jpg_fo742.jpg
报错信息:

Could not execute Delete_rows event on table mysql.__firewall_rules__; Can't find record in '__firewall_rules__', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.000228, end_log_pos 30423413

1032错误,master要删除一条记录,而slave上找不到报错。
临时解决:

stop slave;
set global sql_slave_skip_counter=1;
start slave;

永久解决:

更改my.cnf文件,在Replication settings下添加:

slave-skip-errors=1032

并重启数据库,然后start salve。
注意:因为要重启数据库,不推荐,除非错误事件太多。

LEAVE A COMMENT

Captcha Code