mysql同步MySQL SQL_ERROR 跳过

1. 报错信息如下：

Slave_SQL_Running: NO

Last_SQL_Errno:1032Last_SQL_Error: Worker3 failed executing transaction '' at master log mysql-bin.000019, end_log_pos 550269899;

Could not execute Delete_rowsevent on table db_test.test01; Can't find record in'test01', Error_code: 1032;

handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.000003, end_log_pos 550269899

从上可以看出，是SQL_THREAD线程出错，错误号码1032。是在应用delete db_test.test01 表中一行数据的事件时，由于这条数据不存在而出错.

2. 跳过错误Event

stop slave;

set global sql_slave_skip_counter=1;

start slave;

执行上面命令会报错

mysql> set global sql_slave_skip_counter=1;

ERROR 1858 (HY000): sql_slave_skip_counter can not be set when the server is running with @@GLOBAL.GTID_MODE = ON. Instead, for each transaction that you want to skip, generate an empty transaction with the same GTID as the transaction

解决问题过程：

分析出现问题时候GTID值

通过分析法获取gtid值

通过查看mysql> show slave status \G;

查看一下信息并记录下来:

Retrieved_Gtid_Set: 89b77a15c-8379-11eb-8f78-005056a8acd4:20103126-20103628  -跳过此事务

Executed_Gtid_Set: 89b77a15c-8379-11eb-8f78-005056a8acd4:2010312601-2010362829

通过上面的信息可以知道已经执行的gtid是89b77a15c-8379-11eb-8f78-005056a8acd4:2010312601-2010362829
准备要执行89b77a15c-8379-11eb-8f78-005056a8acd4:20103126-20103628
所以条跳过此步骤

解决办法
mysql> STOP SLAVE;

mysql> RESET MASTER;

mysql> SET @@GLOBAL.GTID_PURGED ='89b77a15c-8379-11eb-8f78-005056a8acd4:20103126-20103628‘

mysql> START SLAVE;

mysql> show slave status\G;