Jump to content

Resolution for 1032 Replication error on mysql with GTID

From TetraWiki


RCA

fix 1032 error of replication Referance: https://lalitvc.wordpress.com/2018/03/01/replication-handler-error-ha_err_key_not_found-and-memory-tables-in-replication/

   Set global slave_exec_mode = IDEMPOTENT;
   stop slave;
   start slave;
   show slave status\G
   Should be fine now
   check if the seconds behind master is 0 , then
   Set global slave_exec_mode = STRICT;

Observe the replication for some time .