Comment 5 for bug 1308016

Revision history for this message
Przemek (pmalkowski) wrote : Re: Duplicate UK values can be replicated under concurrent wokload

I am able to reproduce on version: 5.6.19-67.0-56 Percona XtraDB Cluster (GPL), Release rel67.0, Revision 796, WSREP version 25.6, wsrep_25.6.r4096, Galera 3.6(r3a949e6), but so far only in READ-COMMITTED isolation level.

I am running 3 or 4 simultaneous sessions where called the p1 procedure with different value on first PXC node.
This is the error I am getting after a while on rest of the nodes:

2014-07-18 10:45:08 8036 [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 169, Error_code: 1062
2014-07-18 10:45:08 8036 [Warning] WSREP: RBR event 3 Write_rows apply warning: 121, 219790
2014-07-18 10:45:08 8036 [Warning] WSREP: Failed to apply app buffer: seqno: 219790, status: 1
         at galera/src/trx_handle.cpp:apply():340
Retrying 2th time
2014-07-18 10:45:08 8036 [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 169, Error_code: 1062
2014-07-18 10:45:08 8036 [Warning] WSREP: RBR event 3 Write_rows apply warning: 121, 219790
2014-07-18 10:45:08 8036 [Warning] WSREP: Failed to apply app buffer: seqno: 219790, status: 1
         at galera/src/trx_handle.cpp:apply():340
Retrying 3th time
2014-07-18 10:45:08 8036 [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 169, Error_code: 1062
2014-07-18 10:45:08 8036 [Warning] WSREP: RBR event 3 Write_rows apply warning: 121, 219790
2014-07-18 10:45:08 8036 [Warning] WSREP: Failed to apply app buffer: seqno: 219790, status: 1
         at galera/src/trx_handle.cpp:apply():340
Retrying 4th time
2014-07-18 10:45:08 8036 [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 169, Error_code: 1062
2014-07-18 10:45:08 8036 [Warning] WSREP: RBR event 3 Write_rows apply warning: 121, 219790
2014-07-18 10:45:08 8036 [ERROR] WSREP: Failed to apply trx: source: f4bac56f-0e51-11e4-af0f-2e6e7974831c version: 3 local: 0 state: APPLYING flags: 1 conn_id: 26 trx_id: 1197054 seqnos (l: 222107, g: 219790, s: 219789, d: 219789, ts: 2668662170318334)
2014-07-18 10:45:08 8036 [ERROR] WSREP: Failed to apply trx 219790 4 times
2014-07-18 10:45:08 8036 [ERROR] WSREP: Node consistency compromized, aborting...

For some reason, I cannot reproduce the same on PXC 5.5.34 and Galera 2.8.