Comment 5 for bug 1366997

Revision history for this message
Miguel Angel Nieto (miguelangelnieto) wrote :

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.