I have just upgraded to version 1.2.9 and instantly got a broken replication error message from my monitoring system. There was a Duplicate entry for one of the records in vb_dbtech_dbseo_resolvedurl that stopped the slave server. I thought this could be just an installation issue, but standard
didn't help. I got thousands of duplicate inserts errors in the next few minutes...
I have reverted to 1.2.8.
Code:
SET GLOBAL sql_slave_skip_counter = 1; start slave; SHOW SLAVE STATUS\G
didn't help. I got thousands of duplicate inserts errors in the next few minutes...
I have reverted to 1.2.8.