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
报错信息:
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。
注意:因为要重启数据库,不推荐,除非错误事件太多。