MySQL slave synchronization error, skip gtid

From the slave (slave node), get the binlog file being read and the pos position

mysql>show slave status\G

binlog and pos

The master (master node) confirms the position of the standby transaction relative to the master

show binlog events in ‘mysql-bin.000022’ from 1814 limit 2\G

Locate the position of the standby transaction relative to the master

Stop the slave

mysql>stop slave;

Set gtid_next in session to skip this GTID

mysql>SET @@SESSION.GTID_NEXT= ‘a47892ad-e207-11e9-bd0d-5254003519fe:185

Set an empty transaction

mysql>BEGIN;
mysql>COMMIT;

Restore transaction number

mysql>SET SESSION GTID_NEXT = AUTOMATIC;

Start slave process

mysql>start slave;