Jump to content

Resolution for 1032 Replication error on mysql with GTID

From TetraWiki
Revision as of 13:23, 5 April 2021 by Admin (talk | contribs) (Created page with "category:Radico 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-i...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)


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 .