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.
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: Server- shared- 51.x86_ 64 5.1.72- rel14.10. 597.rhel6 XtraDB- Cluster- client. x86_64 1:5.5.34- 23.7.6. 565.rhel6 XtraDB- Cluster- galera. x86_64 2.8-1.162.rhel6 XtraDB- Cluster- server. x86_64 1:5.5.34- 23.7.6. 565.rhel6 XtraDB- Cluster- shared. x86_64 1:5.5.34- 23.7.6. 565.rhel6
Percona-
Percona-
Percona-
Percona-
Percona-
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 9e01-11e3- a5c8-0ef8a35689 df version: 2 local: 0 state: APPLYING flags: 1 conn_id: 8418444 trx_id: 227697579 seqnos (l: 17217951, g: 93581360, s: 93581336, d: 93581359, ts: 139868587825691 0366) src/replicator_ smm.cpp: apply_wscoll( ):52 src/replicator_ smm.cpp: apply_trx_ ws():118
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-
140428 14:51:19 [ERROR] WSREP: Failed to apply app buffer: seqno: 93581360, status: WSREP_FATAL
at galera/
at galera/
140428 14:51:19 [ERROR] WSREP: Node consistency compromized, aborting...
Any info/help on this would be great.