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

  1. Bug #1308016
  2. Comment #7

Comment 7 for bug 1308016

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

Sure, upgraded all 3 nodes to:
percona30 mysql> select @@version,@@version_comment;
+----------------+---------------------------------------------------------------------------------------------------+
| @@version | @@version_comment |
 +----------------+---------------------------------------------------------------------------------------------------+
| 5.6.19-67.0-56 | Percona XtraDB Cluster (GPL), Release rel67.0, Revision 824, WSREP version 25.6, wsrep_25.6.r4111 |
 +----------------+---------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

And did the same test - called the procedure in 4 different sessions on node1, after a while nodes 2 and 3 shutdown with:

2014-07-23 17:23:02 4187 [ERROR] Slave SQL: Could not execute Write_rows event on table test.t1; Duplicate entry '1' for key 'a', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log FIRST, end_log_pos 219, Error_code: 1062
2014-07-23 17:23:02 4187 [Warning] WSREP: RBR event 4 Write_rows apply warning: 121, 371009
2014-07-23 17:23:02 4187 [Warning] WSREP: Failed to apply app buffer: seqno: 371009, status: 1
         at galera/src/trx_handle.cpp:apply():340
Retrying 2th time
2014-07-23 17:23:02 4187 [ERROR] Slave SQL: Could not execute Write_rows event on table test.t1; Duplicate entry '1' for key 'a', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log FIRST, end_log_pos 219, Error_code: 1062
2014-07-23 17:23:02 4187 [Warning] WSREP: RBR event 4 Write_rows apply warning: 121, 371009
2014-07-23 17:23:02 4187 [Warning] WSREP: Failed to apply app buffer: seqno: 371009, status: 1
         at galera/src/trx_handle.cpp:apply():340
Retrying 3th time
2014-07-23 17:23:02 4187 [ERROR] Slave SQL: Could not execute Write_rows event on table test.t1; Duplicate entry '1' for key 'a', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log FIRST, end_log_pos 219, Error_code: 1062
2014-07-23 17:23:02 4187 [Warning] WSREP: RBR event 4 Write_rows apply warning: 121, 371009
2014-07-23 17:23:02 4187 [Warning] WSREP: Failed to apply app buffer: seqno: 371009, status: 1
         at galera/src/trx_handle.cpp:apply():340
Retrying 4th time
2014-07-23 17:23:02 4187 [ERROR] Slave SQL: Could not execute Write_rows event on table test.t1; Duplicate entry '1' for key 'a', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log FIRST, end_log_pos 219, Error_code: 1062
2014-07-23 17:23:02 4187 [Warning] WSREP: RBR event 4 Write_rows apply warning: 121, 371009
2014-07-23 17:23:02 4187 [ERROR] WSREP: Failed to apply trx: source: 54df79b2-127b-11e4-b7f0-c3402efb9419 version: 3 local: 0 state: APPLYING flags: 1 conn_id: 13 trx_id: 1988541 seqnos (l: 73248, g: 371009, s: 371007, d: 371008, ts: 3124540080922232)
2014-07-23 17:23:02 4187 [ERROR] WSREP: Failed to apply trx 371009 4 times
2014-07-23 17:23:02 4187 [ERROR] WSREP: Node consistency compromized, aborting...