After seeing the following in the error log on the second node:
121003 7:16:06 [Note] WSREP: Member 0 (joiner) synced with group.121003 7:16:06 [Note] WSREP: Shifting JOINED → SYNCED (TO: 0)121003 7:16:06 [Note] WSREP: Synchronized with group, ready for connections121003 7:16:06 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.121003 7:17:08 [Note] WSREP: Skipping empty log_xid: COMMIT121003 7:17:08 [Note] WSREP: ignoring DDL failure: 0 ALTER TABLE bigdata_queue_campaigns DISABLE KEYS121003 7:17:08 [Note] WSREP: Skipping empty log_xid: COMMIT121003 7:17:08 [Note] WSREP: ignoring DDL failure: 0 ALTER TABLE bigdata_queue_campaigns ENABLE KEYS … 121003 7:31:33 [ERROR] Slave SQL: Error ‘Table ‘reportingdb.norep_zonebannertmp_bk’ doesn’t exist’ on query. Default database: ‘reportingdb’. Query: ‘TRUNCATE TABLE norep_zonebannertmp_bk’, Error_code: 1146121003 7:31:33 [Warning] WSREP: RBR event 1 Query apply warning: 1, 1141121003 7:31:33 [Warning] WSREP: Ignoring error for TO isolated action: source: 84dcb35c-0ce4-11e2-0800-4568aec9a7f3 version: 2 local: 0 state: APPLYING flags: 65 conn_id: 1106 trx_id: -1 seqnos (l: 1196, g: 1141, s: 1140, d: 1140, ts: 1349224295344525000)
I cannot login to the first node mysql -u root -p hangs. I don’t see any interesting in the error on this node.
I’m using Percona-XtraDB-Cluster-server-5.5.27-23.6.356.rhel5.
Let me know if you need further information.