Comment 2 for bug 1308016

Revision history for this message
fabe (fabe-e) wrote : Re: Duplicate UK values can be replicated under concurrent wokload

Same thing happened to us today on production servers, two out of tree nodes crashed at the same time, while first node remained working!!!

installed versions:
Percona-Server-shared-51.x86_64 5.1.72-rel14.10.597.rhel6
Percona-XtraDB-Cluster-client.x86_64 1:5.5.34-23.7.6.565.rhel6
Percona-XtraDB-Cluster-galera.x86_64 2.8-1.162.rhel6
Percona-XtraDB-Cluster-server.x86_64 1:5.5.34-23.7.6.565.rhel6
Percona-XtraDB-Cluster-shared.x86_64 1:5.5.34-23.7.6.565.rhel6

140428 14:51:19 [ERROR] Slave SQL: Could not execute Write_rows event on table x.y; Duplicate entry ‘167176' for key 'subscriber_id_UNIQUE', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log FIRST, end_log_pos 311, Error_code: 1062
140428 14:51:19 [Warning] WSREP: RBR event 2 Write_rows apply warning: 121, 93581360
140428 14:51:19 [ERROR] WSREP: Failed to apply trx: source: d1d7af33-9e01-11e3-a5c8-0ef8a35689df version: 2 local: 0 state: APPLYING flags: 1 conn_id: 8418444 trx_id: 227697579 seqnos (l: 17217951, g: 93581360, s: 93581336, d: 93581359, ts: 1398685878256910366)
140428 14:51:19 [ERROR] WSREP: Failed to apply app buffer: seqno: 93581360, status: WSREP_FATAL
         at galera/src/replicator_smm.cpp:apply_wscoll():52
         at galera/src/replicator_smm.cpp:apply_trx_ws():118
140428 14:51:19 [ERROR] WSREP: Node consistency compromized, aborting...

Any info/help on this would be great.