140807 14:33:32 [ERROR] Slave SQL: Error 'Table 'trk_data.tab_test' doesn't exist' on query. Default database: 'trk_data'. Query: 'CREATE TABLE tab_test_tmp LIKE tab_test', Error_code: 1146 140807 14:33:32 [Warning] WSREP: RBR event 1 Query apply warning: 1, 53462743 140807 14:33:32 [Warning] WSREP: Ignoring error for TO isolated action: source: dc1ddd6f-1635-11e4-8a9e-0f322d258131 version: 3 local: 0 state: APPLYING flags: 65 conn_id: 3988540 trx_id: -1 seqnos (l: 17711458, g: 53462743, s: 53462741, d: 53462742, ts: 876714939208726) 140807 14:34:41 [ERROR] Slave SQL: Error 'Table 'trk_data.tab_test' doesn't exist' on query. Default database: 'trk_data'. Query: 'CREATE TABLE tab_test_tmp LIKE tab_test', Error_code: 1146 140807 14:34:41 [Warning] WSREP: RBR event 1 Query apply warning: 1, 53465043 140807 14:34:41 [Warning] WSREP: Ignoring error for TO isolated action: source: dc1ddd6f-1635-11e4-8a9e-0f322d258131 version: 3 local: 0 state: APPLYING flags: 65 conn_id: 3988883 trx_id: -1 seqnos (l: 17713780, g: 53465043, s: 53465037, d: 53465042, ts: 876783388505095) 140807 14:34:41 [ERROR] Slave SQL: Error 'Table 'tab_test_2014_08' already exists' on query. Default database: 'trk_data'. Query: 'RENAME TABLE tab_test TO tab_test_2014_08', Error_code: 1050 140807 14:34:41 [Warning] WSREP: RBR event 1 Query apply warning: 1, 53465052 140807 14:34:41 [Warning] WSREP: Ignoring error for TO isolated action: source: dc1ddd6f-1635-11e4-8a9e-0f322d258131 version: 3 local: 0 state: APPLYING flags: 65 conn_id: 3988883 trx_id: -1 seqnos (l: 17713789, g: 53465052, s: 53465043, d: 53465051, ts: 876783561714509) 140807 14:34:41 [ERROR] Slave SQL: Error 'Can't find file: './trk_data/tab_test_tmp.frm' (errno: 2)' on query. Default database: 'trk_data'. Query: 'RENAME TABLE tab_test_tmp TO tab_test', Error_code: 1017 140807 14:34:41 [Warning] WSREP: RBR event 1 Query apply warning: 1, 53465059 140807 14:34:41 [Warning] WSREP: Ignoring error for TO isolated action: source: dc1ddd6f-1635-11e4-8a9e-0f322d258131 version: 3 local: 0 state: APPLYING flags: 65 conn_id: 3988883 trx_id: -1 seqnos (l: 17713796, g: 53465059, s: 53465052, d: 53465058, ts: 876783702433320) 140807 14:35:20 [Warning] WSREP: BF applier failed to open_and_lock_tables: 1146, fatal: 0 wsrep = (exec_mode: 1 conflict_state: 0 seqno: 53466624) 140807 14:35:20 [ERROR] Slave SQL: Error executing row event: 'Table 'trk_data.tab_test' doesn't exist', Error_code: 1146 140807 14:35:20 [Warning] WSREP: RBR event 2 Write_rows apply warning: 1146, 53466624 140807 14:35:20 [Warning] WSREP: Failed to apply app buffer: seqno: 53466624, status: 1 140807 14:35:20 [Warning] WSREP: BF applier failed to open_and_lock_tables: 1146, fatal: 0 wsrep = (exec_mode: 1 conflict_state: 0 seqno: 53466624) 140807 14:35:20 [ERROR] Slave SQL: Error executing row event: 'Table 'trk_data.tab_test' doesn't exist', Error_code: 1146 140807 14:35:20 [Warning] WSREP: RBR event 2 Write_rows apply warning: 1146, 53466624 140807 14:35:20 [Warning] WSREP: Failed to apply app buffer: seqno: 53466624, status: 1 140807 14:35:20 [Warning] WSREP: BF applier failed to open_and_lock_tables: 1146, fatal: 0 wsrep = (exec_mode: 1 conflict_state: 0 seqno: 53466624) 140807 14:35:20 [ERROR] Slave SQL: Error executing row event: 'Table 'trk_data.tab_test' doesn't exist', Error_code: 1146 140807 14:35:20 [Warning] WSREP: RBR event 2 Write_rows apply warning: 1146, 53466624 140807 14:35:20 [Note] WSREP: declaring dc1ddd6f-1635-11e4-8a9e-0f322d258131 stable 140807 14:35:20 [Note] WSREP: (528f1947-1629-11e4-95bb-db54ace6d30c, 'tcp://0.0.0.0:4567') address 'tcp://10.0.2.9:4567' pointing to uuid 528f1947-1629-11e4-95bb-db54ace6d30c is blacklisted, skipping 140807 14:35:20 [Note] WSREP: (528f1947-1629-11e4-95bb-db54ace6d30c, 'tcp://0.0.0.0:4567') address 'tcp://10.0.2.9:4567' pointing to uuid 528f1947-1629-11e4-95bb-db54ace6d30c is blacklisted, skipping 140807 14:35:20 [Note] WSREP: (528f1947-1629-11e4-95bb-db54ace6d30c, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://10.0.2.10:4567 140807 14:35:20 [Note] WSREP: Node 528f1947-1629-11e4-95bb-db54ace6d30c state prim 140807 14:35:20 [Note] WSREP: view(view_id(PRIM,528f1947-1629-11e4-95bb-db54ace6d30c,18) memb { 140807 14:35:20 [Note] WSREP: forgetting 40f18a25-162e-11e4-803b-8f7b9c21a768 (tcp://10.0.2.10:4567) 140807 14:35:20 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2 140807 14:35:20 [Note] WSREP: (528f1947-1629-11e4-95bb-db54ace6d30c, 'tcp://0.0.0.0:4567') address 'tcp://10.0.2.9:4567' pointing to uuid 528f1947-1629-11e4-95bb-db54ace6d30c is blacklisted, skipping 140807 14:35:20 [Note] WSREP: (528f1947-1629-11e4-95bb-db54ace6d30c, 'tcp://0.0.0.0:4567') turning message relay requesting off 140807 14:35:20 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 4b5383dd-1e2f-11e4-a023-272f6b564ca6 140807 14:35:20 [Note] WSREP: STATE EXCHANGE: sent state msg: 4b5383dd-1e2f-11e4-a023-272f6b564ca6 140807 14:35:20 [Note] WSREP: STATE EXCHANGE: got state msg: 4b5383dd-1e2f-11e4-a023-272f6b564ca6 from 0 (hp9) 140807 14:35:20 [Note] WSREP: STATE EXCHANGE: got state msg: 4b5383dd-1e2f-11e4-a023-272f6b564ca6 from 1 (hp8) 140807 14:35:20 [Note] WSREP: Quorum results: 140807 14:35:20 [Note] WSREP: Flow-control interval: [23, 23] 140807 14:35:20 [Warning] WSREP: Failed to apply app buffer: seqno: 53466624, status: 1 140807 14:35:20 [Warning] WSREP: BF applier failed to open_and_lock_tables: 1146, fatal: 0 wsrep = (exec_mode: 1 conflict_state: 0 seqno: 53466624) 140807 14:35:20 [ERROR] Slave SQL: Error executing row event: 'Table 'trk_data.tab_test' doesn't exist', Error_code: 1146 140807 14:35:20 [Warning] WSREP: RBR event 2 Write_rows apply warning: 1146, 53466624 140807 14:35:20 [ERROR] WSREP: Failed to apply trx: source: dc1ddd6f-1635-11e4-8a9e-0f322d258131 version: 3 local: 0 state: APPLYING flags: 1 conn_id: 3918248 trx_id: 620225485 seqnos (l: 17715375, g: 53466624, s: 53466622, d: 53466563, ts: 876822927992452) 140807 14:35:20 [ERROR] WSREP: Failed to apply trx 53466624 4 times 140807 14:35:20 [ERROR] WSREP: Node consistency compromized, aborting... 140807 14:35:20 [Note] WSREP: Closing send monitor... 140807 14:35:20 [Note] WSREP: Closed send monitor. 140807 14:35:20 [Note] WSREP: gcomm: terminating thread 140807 14:35:20 [Note] WSREP: gcomm: joining thread 140807 14:35:20 [Note] WSREP: gcomm: closing backend 140807 14:35:21 [Note] WSREP: view(view_id(NON_PRIM,528f1947-1629-11e4-95bb-db54ace6d30c,18) memb { 140807 14:35:21 [Note] WSREP: view((empty)) 140807 14:35:21 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 140807 14:35:21 [Note] WSREP: gcomm: closed 140807 14:35:21 [Note] WSREP: Flow-control interval: [16, 16] 140807 14:35:21 [Note] WSREP: Received NON-PRIMARY. 140807 14:35:21 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 53466629) 140807 14:35:21 [Note] WSREP: Received self-leave message. 140807 14:35:21 [Note] WSREP: Flow-control interval: [0, 0] 140807 14:35:21 [Note] WSREP: Received SELF-LEAVE. Closing connection. 140807 14:35:21 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 53466629) 140807 14:35:21 [Note] WSREP: RECV thread exiting 0: Success 140807 14:35:21 [Note] WSREP: recv_thread() joined. 140807 14:35:21 [Note] WSREP: Closing replication queue. 140807 14:35:21 [Note] WSREP: Closing slave action queue. 140807 14:35:21 [Note] WSREP: /usr/sbin/mysqld: Terminated. 140807 14:35:21 mysqld_safe Number of processes running now: 0 140807 14:35:21 mysqld_safe WSREP: not restarting wsrep node automatically 140807 14:35:21 mysqld_safe mysqld from pid file /var/lib/mysql/hp9.pid ended