Percona Server moved to https://jira.percona.com/projects/PS

  1. Series 5.5
  2. Bug #1308016
  3. Comment #10

Comment 10 for bug 1308016

Revision history for this message
Przemek (pmalkowski) wrote : Re: Duplicate UK values can be replicated under concurrent workload with READ-COMMITTED

I was able to reproduce on:
percona1 mysql> select @@version,@@version_comment\G
*************************** 1. row ***************************
        @@version: 5.6.21-69.0-56
@@version_comment: Percona XtraDB Cluster (GPL), Release rel69.0, Revision 910, WSREP version 25.8, wsrep_25.8.r4126
1 row in set (0.00 sec)

by running 3 parallel sessions on writer node. Replicated nodes failed with:

2014-11-10 12:37:34 19254 [ERROR] Slave SQL: Could not execute Write_rows event on table test.t1; Duplicate entry '0' for key 'a', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log FIRST, end_log_pos 169, Error_code: 1062
2014-11-10 12:37:34 19254 [Warning] WSREP: RBR event 3 Write_rows apply warning: 121, 299546
2014-11-10 12:37:34 19254 [ERROR] WSREP: Failed to apply trx: source: 8b37e730-68cb-11e4-8de0-333e4b88f012 version: 3 local: 0 state: APPLYING flags: 1 conn_id: 7 trx_id: 1138584 seqnos (l: 259350, g: 299546, s: 299544, d: 299545, ts: 7858353781585)
2014-11-10 12:37:34 19254 [ERROR] WSREP: Failed to apply trx 299546 4 times
2014-11-10 12:37:34 19254 [ERROR] WSREP: Node consistency compromized, aborting...