Comment 17 for bug 1019473

Revision history for this message
Jervin R (revin) wrote :

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.