Hi.
Thanks for all the info you provided, I've been able to reproduce it with the following test case:
1- Prepare a .sql file full of INSERT queries:
INSERT INTO test.t VALUES(NULL,"miguel");
that line million of times.
2- Start a 3 node clusters.
3- Load the data on node 1 (if you do several times in parallel you will get the error sooner):
cat data.sql | mysql
4- Restart node2 and wait until MySQL is running.
5- Restart node3 and wait until MySQL is running.
Repeat step 4 and 5 several times (sometimes lot of restarts are needed, sometimes just a few) and the node1 load will fail with duplicate key entry.
I used your my.cnf.
Hi.
Thanks for all the info you provided, I've been able to reproduce it with the following test case:
1- Prepare a .sql file full of INSERT queries:
INSERT INTO test.t VALUES( NULL,"miguel" );
that line million of times.
2- Start a 3 node clusters.
3- Load the data on node 1 (if you do several times in parallel you will get the error sooner):
cat data.sql | mysql
4- Restart node2 and wait until MySQL is running.
5- Restart node3 and wait until MySQL is running.
Repeat step 4 and 5 several times (sometimes lot of restarts are needed, sometimes just a few) and the node1 load will fail with duplicate key entry.
I used your my.cnf.