We also have had reports of similar nature on 5.5.29-23.7.2:
130220 19:29:14 [ERROR] Slave SQL: Could not execute Write_rows event on table db.tbl1; Cannot add or update a child row: a foreign key constraint fails (`db`.`tbl1`, CONSTRAINT `cm_email_customcm_activity_email` FOREIGN KEY (`custom_email_id`) REFERENCES `tbl1` (`custom_email_id`) ON DELETE CASCADE), Error_code: 1452; handler error HA_ERR_NO_REFERENCED_ROW; the event's master log FIRST, end_log_pos 115, Error_code: 1452 130220 19:29:14 [Warning] WSREP: RBR event 2 Write_rows apply warning: 151, 2726260 130220 19:29:14 [ERROR] WSREP: Failed to apply trx: source: bce7b305-7b8e-11e2-0800-6d35e4e6862e version: 2 local: 0 state: APPLYING flags: 1 conn_id: 7389 trx_id: 38835836 seqnos (l: 4436, g: 2726260, s: 2726259, d: 2726084, ts: 1361413754140954569) 130220 19:29:14 [ERROR] WSREP: Failed to apply app buffer: z%Q, seqno: 2726260, status: WSREP_FATAL at galera/src/replicator_smm.cpp:apply_wscoll():49 at galera/src/replicator_smm.cpp:apply_trx_ws():116 130220 19:29:14 [ERROR] WSREP: Node consistency compromized, aborting...
And 5.5.27 - Version: '5.5.27-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Percona XtraDB Cluster (GPL), wsrep_23.6.r356
130215 1:02:15 [ERROR] Slave SQL: Could not execute Write_rows event on table db.tbl2; Cannot add or update a child row: a foreign key constraint fails (`db`.`tbl2`, CONSTRAINT `lms_xxxxx_instance` FOREIGN KEY (`user_id`) REFERENCES `lms_user` (`user_id`) ON DELETE CASCADE), Error_code: 1452; handler error HA_ERR_NO_REFERENCED_ROW; the event's master log FIRST, end_log_pos 120, Error_code: 1452 130215 1:02:15 [Warning] WSREP: RBR event 2 Write_rows apply warning: 151, 10968 130215 1:02:15 [ERROR] WSREP: Failed to apply trx: source: 54b4a428-76e0-11e2-0800-907af715c84c version: 2 local: 0 state: APPLYING flags: 1 conn_id: 8649 trx_id: 400479 seqnos (l: 37, g: 10968, s: 10967, d: 10961, ts: 1360890117848877021) 130215 1:02:15 [ERROR] WSREP: Failed to apply app buffer: � Q, seqno: 10968, status: WSREP_FATAL at galera/src/replicator_smm.cpp:apply_wscoll():49 at galera/src/replicator_smm.cpp:apply_trx_ws():120 130215 1:02:15 [ERROR] WSREP: Node consistency compromized, aborting...
Full error log is available and can be sent privately.
We also have had reports of similar nature on 5.5.29-23.7.2:
130220 19:29:14 [ERROR] Slave SQL: Could not execute Write_rows event on table db.tbl1; Cannot add or update a child row: a foreign key constraint fails (`db`.`tbl1`, CONSTRAINT `cm_email_ customcm_ activity_ email` FOREIGN KEY (`custom_email_id`) REFERENCES `tbl1` (`custom_email_id`) ON DELETE CASCADE), Error_code: 1452; handler error HA_ERR_ NO_REFERENCED_ ROW; the event's master log FIRST, end_log_pos 115, Error_code: 1452 7b8e-11e2- 0800-6d35e4e686 2e version: 2 local: 0 state: APPLYING flags: 1 conn_id: 7389 trx_id: 38835836 seqnos (l: 4436, g: 2726260, s: 2726259, d: 2726084, ts: 136141375414095 4569) src/replicator_ smm.cpp: apply_wscoll( ):49 src/replicator_ smm.cpp: apply_trx_ ws():116
130220 19:29:14 [Warning] WSREP: RBR event 2 Write_rows apply warning: 151, 2726260
130220 19:29:14 [ERROR] WSREP: Failed to apply trx: source: bce7b305-
130220 19:29:14 [ERROR] WSREP: Failed to apply app buffer: z%Q, seqno: 2726260, status: WSREP_FATAL
at galera/
at galera/
130220 19:29:14 [ERROR] WSREP: Node consistency compromized, aborting...
And 5.5.27 - Version: '5.5.27-log' socket: '/var/lib/ mysql/mysql. sock' port: 3306 Percona XtraDB Cluster (GPL), wsrep_23.6.r356
130215 1:02:15 [ERROR] Slave SQL: Could not execute Write_rows event on table db.tbl2; Cannot add or update a child row: a foreign key constraint fails (`db`.`tbl2`, CONSTRAINT `lms_xxxxx_ instance` FOREIGN KEY (`user_id`) REFERENCES `lms_user` (`user_id`) ON DELETE CASCADE), Error_code: 1452; handler error HA_ERR_ NO_REFERENCED_ ROW; the event's master log FIRST, end_log_pos 120, Error_code: 1452 76e0-11e2- 0800-907af715c8 4c version: 2 local: 0 state: APPLYING flags: 1 conn_id: 8649 trx_id: 400479 seqnos (l: 37, g: 10968, s: 10967, d: 10961, ts: 136089011784887 7021) src/replicator_ smm.cpp: apply_wscoll( ):49 src/replicator_ smm.cpp: apply_trx_ ws():120
130215 1:02:15 [Warning] WSREP: RBR event 2 Write_rows apply warning: 151, 10968
130215 1:02:15 [ERROR] WSREP: Failed to apply trx: source: 54b4a428-
130215 1:02:15 [ERROR] WSREP: Failed to apply app buffer: �
Q, seqno: 10968, status: WSREP_FATAL
at galera/
at galera/
130215 1:02:15 [ERROR] WSREP: Node consistency compromized, aborting...
Full error log is available and can be sent privately.