130828 12:04:56 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.31' socket: '/var/lib/mysql/mysql.sock' port: 3306 Percona XtraDB Cluster (GPL), wsrep_2 3.7.5.r3880 130828 13:02:30 [ERROR] Slave SQL: Could not execute Write_rows event on table test.b; Cannot add or upda te a child row: a foreign key constraint fails (`test`.`b`, CONSTRAINT `aid_fk` FOREIGN KEY (`aid`) REFER ENCES `a` (`id`) ON DELETE CASCADE), Error_code: 1452; handler error HA_ERR_NO_REFERENCED_ROW; the event' s master log FIRST, end_log_pos 92, Error_code: 1452 130828 13:02:30 [ERROR] Slave SQL: Could not execute Write_rows event on table test.b; Cannot add or upda te a child row: a foreign key constraint fails (`test`.`b`, CONSTRAINT `aid_fk` FOREIGN KEY (`aid`) REFER ENCES `a` (`id`) ON DELETE CASCADE), Error_code: 1452; handler error HA_ERR_NO_REFERENCED_ROW; the event' s master log FIRST, end_log_pos 92, Error_code: 1452 130828 13:02:30 [Warning] WSREP: RBR event 2 Write_rows apply warning: 151, 2397802 130828 13:02:30 [Warning] WSREP: RBR event 2 Write_rows apply warning: 151, 2397804 130828 13:02:30 [ERROR] WSREP: Failed to apply trx: source: 5a26db1a-0fd9-11e3-93a3-57798c06b48f version: 2 local: 0 state: APPLYING flags: 1 conn_id: 11273 trx_id: 9566534 seqnos (l: 2405865, g: 2397804, s: 23 97803, d: 2397232, ts: 1377694950684317742) 130828 13:02:30 [ERROR] WSREP: Failed to apply app buffer: seqno: 2397804, status: WSREP_FATAL at galera/src/replicator_smm.cpp:apply_wscoll():52 at galera/src/replicator_smm.cpp:apply_trx_ws():118 130828 13:02:30 [ERROR] WSREP: Node consistency compromized, aborting...
130828 12:04:56 [Note] /usr/sbin/mysqld: ready for connections. mysql/mysql. sock' port: 3306 Percona XtraDB Cluster (GPL), wsrep_2 NO_REFERENCED_ ROW; the event' NO_REFERENCED_ ROW; the event' 0fd9-11e3- 93a3-57798c06b4 8f version: 7742) src/replicator_ smm.cpp: apply_wscoll( ):52 src/replicator_ smm.cpp: apply_trx_ ws():118
Version: '5.5.31' socket: '/var/lib/
3.7.5.r3880
130828 13:02:30 [ERROR] Slave SQL: Could not execute Write_rows event on table test.b; Cannot add or upda
te a child row: a foreign key constraint fails (`test`.`b`, CONSTRAINT `aid_fk` FOREIGN KEY (`aid`) REFER
ENCES `a` (`id`) ON DELETE CASCADE), Error_code: 1452; handler error HA_ERR_
s master log FIRST, end_log_pos 92, Error_code: 1452
130828 13:02:30 [ERROR] Slave SQL: Could not execute Write_rows event on table test.b; Cannot add or upda
te a child row: a foreign key constraint fails (`test`.`b`, CONSTRAINT `aid_fk` FOREIGN KEY (`aid`) REFER
ENCES `a` (`id`) ON DELETE CASCADE), Error_code: 1452; handler error HA_ERR_
s master log FIRST, end_log_pos 92, Error_code: 1452
130828 13:02:30 [Warning] WSREP: RBR event 2 Write_rows apply warning: 151, 2397802
130828 13:02:30 [Warning] WSREP: RBR event 2 Write_rows apply warning: 151, 2397804
130828 13:02:30 [ERROR] WSREP: Failed to apply trx: source: 5a26db1a-
2 local: 0 state: APPLYING flags: 1 conn_id: 11273 trx_id: 9566534 seqnos (l: 2405865, g: 2397804, s: 23
97803, d: 2397232, ts: 137769495068431
130828 13:02:30 [ERROR] WSREP: Failed to apply app buffer: seqno: 2397804, status: WSREP_FATAL
at galera/
at galera/
130828 13:02:30 [ERROR] WSREP: Node consistency compromized, aborting...