Announcement

Announcement Module
Collapse
No announcement yet.

Does this make my XtraDB Cluster hang?

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Does this make my XtraDB Cluster hang?

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