Comment 2 for bug 1217653

Revision history for this message
Jay Janssen (jay-janssen) wrote :

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...