MySQL 5.7.17 GTID Replication always breaking

[Christian Huck]

Hi,

as mentioned in the topic we have the following issue:

In short:

After transfering the Dump Export from the Master to the Slave, importing it and renabling the replication we get PK Errors after some time.


In long:
We are using MySQL 5.1.17 with GTID enabled.


We have a Master-Master scenario; but we make sure that all the traffic goes only to the first node.

What we do on both nodes:
stop slave;
reset slave;
reset master;

Then We do a full export on node A transfering the data directy to node B like this:
mysqldump --defaults-extra-file=/etc/my.live.cnf --user="root" --all-databases --single-transaction --add-drop-database --triggers --routines --events | mysql --host=nodeB --port=3305 --user=root

This takes a while(~1 hour). All db's sum up to about 25GB.

After completing the import we start the slave on node B.

It starts appy all changes on but after some time (seconds) the replication stops with this kind of errors:

Last_SQL_Error: Error 'Duplicate entry '4' for key 'PRIMARY'' on query. Default database: 'survey'. Query: 'INSERT INTO `survey_survey_49945`
(`49945XF836X27154`, `49943X8C36X27157`,`lastpage`,`startlanguage`) VALUES ('1', '',2, 'de-informal')'

Game Over.

We've tried this procedure many time with differnt settings but always end up with the same issue.

Help is very much appreciated !