170418 18:06:59 [Warning] WSREP: last inactive check more than PT1.5S ago (PT4.39887S), skipping check 170418 18:06:59 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') connection established to 5862b534 tcp://*.*.*.35:4567 170418 18:06:59 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: 170418 18:06:59 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') connection established to 578a8700 tcp://*.*.*.206:4567 170418 18:07:02 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') connection to peer 578a8700 with addr tcp://*.*.*.206:4567 timed out, no messages seen in PT3S 170418 18:07:03 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') reconnecting to 578a8700 (tcp://*.*.*.206:4567), attempt 0 170418 18:07:03 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') connection established to 578a8700 tcp://*.*.*.206:4567 170418 18:07:08 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') turning message relay requesting off 170418 18:07:08 [Warning] WSREP: last inactive check more than PT1.5S ago (PT2.63407S), skipping check 170418 18:07:22 [Warning] WSREP: last inactive check more than PT1.5S ago (PT1.75048S), skipping check 170418 18:07:33 [Warning] WSREP: last inactive check more than PT1.5S ago (PT2.05876S), skipping check 170418 18:07:37 [Warning] WSREP: last inactive check more than PT1.5S ago (PT1.83655S), skipping check 170418 18:07:52 [Warning] WSREP: last inactive check more than PT1.5S ago (PT2.00298S), skipping check 170418 18:07:58 [Warning] WSREP: Failed to report last committed 3472031148, -4 (Interrupted system call) 170418 18:07:58 [Warning] WSREP: last inactive check more than PT1.5S ago (PT1.51434S), skipping check 170418 18:08:09 [Warning] WSREP: last inactive check more than PT1.5S ago (PT1.90126S), skipping check 170418 18:08:19 [Warning] WSREP: last inactive check more than PT1.5S ago (PT1.98197S), skipping check 170418 18:08:22 [Warning] WSREP: last inactive check more than PT1.5S ago (PT1.80965S), skipping check 170418 18:08:39 [Warning] WSREP: last inactive check more than PT1.5S ago (PT1.53322S), skipping check 170418 18:09:07 [Warning] WSREP: last inactive check more than PT1.5S ago (PT2.4975S), skipping check 170418 18:09:12 [Warning] WSREP: last inactive check more than PT1.5S ago (PT3.28518S), skipping check 170418 18:09:17 [Warning] WSREP: Failed to report last committed 3472048691, -4 (Interrupted system call) 170418 18:09:19 [Warning] WSREP: Failed to report last committed 3472049051, -4 (Interrupted system call) 170418 18:09:22 [Warning] WSREP: last inactive check more than PT1.5S ago (PT8.31332S), skipping check 170418 18:09:23 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://*.*.*.35:4567 170418 18:09:23 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') reconnecting to 5862b534 (tcp://*.*.*.35:4567), attempt 0 170418 18:09:25 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') connection to peer 578a8700 with addr tcp://*.*.*.206:4567 timed out, no messages seen in PT3S 170418 18:09:26 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') connection to peer 5862b534 with addr tcp://*.*.*.35:4567 timed out, no messages seen in PT3S 170418 18:09:26 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') reconnecting to 578a8700 (tcp://*.*.*.206:4567), attempt 0 170418 18:09:26 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') connection established to 578a8700 tcp://*.*.*.206:4567 170418 18:09:27 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') connection established to 5862b534 tcp://*.*.*.35:4567 170418 18:09:27 [Note] WSREP: evs::proto(886f5e39, OPERATIONAL, view_id(REG,578a8700,539)) suspecting node: 578a8700 170418 18:09:27 [Note] WSREP: evs::proto(886f5e39, OPERATIONAL, view_id(REG,578a8700,539)) suspected node without join message, declaring inactive 170418 18:09:27 [Note] WSREP: evs::proto(886f5e39, OPERATIONAL, view_id(REG,578a8700,539)) suspecting node: 5862b534 170418 18:09:27 [Note] WSREP: evs::proto(886f5e39, OPERATIONAL, view_id(REG,578a8700,539)) suspected node without join message, declaring inactive 170418 18:09:35 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') turning message relay requesting off 170418 18:09:35 [Note] WSREP: view(view_id(NON_PRIM,578a8700,539) memb { 886f5e39,0 } joined { } left { } partitioned { 578a8700,0 5862b534,0 }) 170418 18:09:35 [Note] WSREP: view(view_id(NON_PRIM,886f5e39,540) memb { 886f5e39,0 } joined { } left { } partitioned { 578a8700,0 5862b534,0 }) 170418 18:09:35 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 170418 18:09:35 [Note] WSREP: Flow-control interval: [2500, 2500] 170418 18:09:35 [Note] WSREP: Received NON-PRIMARY. 170418 18:09:35 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 3472049381) 170418 18:09:35 [Note] WSREP: New cluster view: global state: dda62f30-e8ff-11e5-b5ce-3754b5ddaee3:3472049381, view# -1: non-Primary, number of nodes: 1, my index: 0, protocol version 3 170418 18:09:35 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 170418 18:09:35 [Warning] WSREP: Last Applied Action message in non-primary configuration from member 0 170418 18:09:35 [Warning] WSREP: Last Applied Action message in non-primary configuration from member 0 170418 18:09:35 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 170418 18:09:35 [Note] WSREP: Flow-control interval: [2500, 2500] 170418 18:09:35 [Note] WSREP: Received NON-PRIMARY. 170418 18:09:35 [Note] WSREP: New cluster view: global state: dda62f30-e8ff-11e5-b5ce-3754b5ddaee3:3472049381, view# -1: non-Primary, number of nodes: 1, my index: 0, protocol version 3 170418 18:09:35 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 170418 18:09:35 [Warning] WSREP: Send action {(nil), 314, TORDERED} returned -107 (Transport endpoint is not connected) 170418 18:09:35 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') connection established to 578a8700 tcp://*.*.*.206:4567 170418 18:09:35 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: 170418 18:09:35 [Warning] WSREP: last inactive check more than PT1.5S ago (PT7.25521S), skipping check 170418 18:09:36 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') connection established to 5862b534 tcp://*.*.*.35:4567 170418 18:09:36 [Note] WSREP: declaring 578a8700 at tcp://*.*.*.206:4567 stable 170418 18:09:36 [Note] WSREP: declaring 5862b534 at tcp://*.*.*.35:4567 stable 170418 18:09:37 [Note] WSREP: Node 578a8700 state prim 170418 18:09:37 [Note] WSREP: view(view_id(PRIM,578a8700,541) memb { 578a8700,0 5862b534,0 886f5e39,0 } joined { } left { } partitioned { }) 170418 18:09:37 [Note] WSREP: save pc into disk 170418 18:09:37 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 2, memb_num = 3 170418 18:09:37 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 170418 18:09:37 [Note] WSREP: STATE EXCHANGE: sent state msg: 7709ea16-243c-11e7-a613-cbf01960c8d2 170418 18:09:37 [Warning] WSREP: Action message in non-primary configuration from member 1 170418 18:09:37 [Note] WSREP: STATE EXCHANGE: got state msg: 7709ea16-243c-11e7-a613-cbf01960c8d2 from 0 (node3) 170418 18:09:37 [Note] WSREP: STATE EXCHANGE: got state msg: 7709ea16-243c-11e7-a613-cbf01960c8d2 from 1 (node1) 170418 18:09:37 [Note] WSREP: STATE EXCHANGE: got state msg: 7709ea16-243c-11e7-a613-cbf01960c8d2 from 2 (node2) 170418 18:09:37 [Note] WSREP: Quorum results: version = 4, component = PRIMARY, conf_id = 65, members = 2/3 (joined/total), act_id = 3472053927, last_appl. = 3472048572, protocols = 0/7/3 (gcs/repl/appl), group UUID = dda62f30-e8ff-11e5-b5ce-3754b5ddaee3 170418 18:09:37 [Note] WSREP: Flow-control interval: [4330, 4330] 170418 18:09:37 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 3472053927) 170418 18:09:37 [Note] WSREP: State transfer required: Group state: dda62f30-e8ff-11e5-b5ce-3754b5ddaee3:3472053927 Local state: dda62f30-e8ff-11e5-b5ce-3754b5ddaee3:3472049381 170418 18:09:37 [Note] WSREP: New cluster view: global state: dda62f30-e8ff-11e5-b5ce-3754b5ddaee3:3472053927, view# 66: Primary, number of nodes: 3, my index: 2, protocol version 3 170418 18:09:37 [Warning] WSREP: Gap in state sequence. Need state transfer. 170418 18:09:37 [Note] WSREP: You have configured 'xtrabackup-v2' state snapshot transfer method which cannot be performed on a running server. Wsrep provider won't be able to fall back to it if other means of state transfer are unavailable. In that case you will need to restart the server. 170418 18:09:37 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 170418 18:09:37 [Note] WSREP: REPL Protocols: 7 (3, 2) 170418 18:09:37 [Note] WSREP: Assign initial position for certification: 3472053927, protocol version: 3 170418 18:09:37 [Note] WSREP: Service thread queue flushed. 170418 18:09:37 [Note] WSREP: IST receiver addr using tcp://*.*.*.60:4568 170418 18:09:37 [Note] WSREP: Prepared IST receiver, listening at: tcp://*.*.*.60:4568 170418 18:09:37 [Note] WSREP: Member 2.0 (node2) requested state transfer from '*any*'. Selected 0.0 (node3)(SYNCED) as donor. 170418 18:09:37 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 3472054008) 170418 18:09:37 [Note] WSREP: Requesting state transfer: success, donor: 0 170418 18:09:37 [Note] WSREP: GCache history reset: old(dda62f30-e8ff-11e5-b5ce-3754b5ddaee3:3472049381) -> new(dda62f30-e8ff-11e5-b5ce-3754b5ddaee3:3472053927) 170418 18:09:38 [Note] WSREP: GCache DEBUG: RingBuffer::seqno_reset(): discarded 26843249838 bytes 170418 18:09:38 [Note] WSREP: GCache DEBUG: RingBuffer::seqno_reset(): found 1/82 locked buffers 170418 18:09:44 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') turning message relay requesting off 170418 18:09:44 [Warning] WSREP: last inactive check more than PT1.5S ago (PT5.80429S), skipping check 170418 18:09:44 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') connection established to 5862b534 tcp://*.*.*.35:4567 170418 18:09:44 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') connection established to 578a8700 tcp://*.*.*.206:4567 170418 18:09:44 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: 170418 18:09:44 [Note] WSREP: view(view_id(NON_PRIM,578a8700,541) memb { 886f5e39,0 } joined { } left { } partitioned { 578a8700,0 5862b534,0 }) 170418 18:09:44 [Note] WSREP: view(view_id(NON_PRIM,886f5e39,542) memb { 886f5e39,0 } joined { } left { } partitioned { 578a8700,0 5862b534,0 }) 170418 18:09:45 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') reconnecting to 5862b534 (tcp://*.*.*.35:4567), attempt 0 170418 18:09:47 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') connection to peer 578a8700 with addr tcp://*.*.*.206:4567 timed out, no messages seen in PT3S 170418 18:09:48 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') connection to peer 5862b534 with addr tcp://*.*.*.35:4567 timed out, no messages seen in PT3S 170418 18:09:48 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') reconnecting to 578a8700 (tcp://*.*.*.206:4567), attempt 0 170418 18:09:48 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') connection established to 578a8700 tcp://*.*.*.206:4567 170418 18:09:48 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') connection established to 5862b534 tcp://*.*.*.35:4567 170418 18:09:50 [Note] WSREP: view(view_id(NON_PRIM,886f5e39,543) memb { 886f5e39,0 } joined { } left { } partitioned { 578a8700,0 5862b534,0 }) 170418 18:09:51 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') reconnecting to 5862b534 (tcp://*.*.*.35:4567), attempt 0 170418 18:09:53 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') connection to peer 578a8700 with addr tcp://*.*.*.206:4567 timed out, no messages seen in PT3S 170418 18:09:54 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') reconnecting to 578a8700 (tcp://*.*.*.206:4567), attempt 0 170418 18:09:54 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') connection established to 578a8700 tcp://*.*.*.206:4567 170418 18:09:54 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') connection established to 5862b534 tcp://*.*.*.35:4567 170418 18:09:57 [Note] WSREP: declaring 578a8700 at tcp://*.*.*.206:4567 stable 170418 18:09:57 [Note] WSREP: declaring 5862b534 at tcp://*.*.*.35:4567 stable 170418 18:09:58 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') turning message relay requesting off 170418 18:09:58 [Note] WSREP: Node 578a8700 state prim 170418 18:09:58 [Note] WSREP: view(view_id(PRIM,578a8700,544) memb { 578a8700,0 5862b534,0 886f5e39,0 } joined { } left { } partitioned { }) 170418 18:09:58 [Note] WSREP: save pc into disk 170418 18:10:05 [Note] WSREP: 0.0 (node3): State transfer to 2.0 (node2) complete. 170418 18:10:05 [Note] WSREP: Member 0.0 (node3) synced with group. 170418 18:10:05 [Note] WSREP: Receiving IST: 4546 writesets, seqnos 3472049381-3472053927 170418 18:10:06 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 170418 18:10:06 [Note] WSREP: Flow-control interval: [2500, 2500] 170418 18:10:06 [Note] WSREP: Received NON-PRIMARY. 170418 18:10:06 [Note] WSREP: Shifting JOINER -> OPEN (TO: 3472054265) 170418 18:10:06 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 170418 18:10:06 [Note] WSREP: Flow-control interval: [2500, 2500] 170418 18:10:06 [Note] WSREP: Received NON-PRIMARY. 170418 18:10:06 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 170418 18:10:06 [Note] WSREP: Flow-control interval: [2500, 2500] 170418 18:10:06 [Note] WSREP: Received NON-PRIMARY. 170418 18:10:06 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 2, memb_num = 3 170418 18:10:06 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 170418 18:10:06 [Note] WSREP: STATE EXCHANGE: sent state msg: 83973001-243c-11e7-9732-030e5a2c2108 170418 18:10:06 [Note] WSREP: STATE EXCHANGE: got state msg: 83973001-243c-11e7-9732-030e5a2c2108 from 0 (node3) 170418 18:10:06 [Note] WSREP: STATE EXCHANGE: got state msg: 83973001-243c-11e7-9732-030e5a2c2108 from 1 (node1) 170418 18:10:06 [Note] WSREP: STATE EXCHANGE: got state msg: 83973001-243c-11e7-9732-030e5a2c2108 from 2 (node2) 170418 18:10:06 [Note] WSREP: Quorum results: version = 4, component = PRIMARY, conf_id = 66, members = 2/3 (joined/total), act_id = 3472054318, last_appl. = 3472054176, protocols = 0/7/3 (gcs/repl/appl), group UUID = dda62f30-e8ff-11e5-b5ce-3754b5ddaee3 170418 18:10:06 [Note] WSREP: Flow-control interval: [4330, 4330] 170418 18:10:06 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 3472054318) 170418 18:10:23 [Warning] WSREP: last inactive check more than PT1.5S ago (PT4.76466S), skipping check 170418 18:10:23 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') connection established to 5862b534 tcp://*.*.*.35:4567 170418 18:10:23 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://*.*.*.206:4567 170418 18:10:23 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') connection established to 578a8700 tcp://*.*.*.206:4567 170418 18:10:29 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') turning message relay requesting off 170418 18:10:29 [Warning] WSREP: last inactive check more than PT1.5S ago (PT5.9059S), skipping check 170418 18:10:29 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') connection established to 5862b534 tcp://*.*.*.35:4567 170418 18:10:29 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://*.*.*.206:4567 170418 18:10:29 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') connection established to 578a8700 tcp://*.*.*.206:4567 170418 18:10:30 [Note] WSREP: view(view_id(NON_PRIM,578a8700,544) memb { 886f5e39,0 } joined { } left { } partitioned { 578a8700,0 5862b534,0 }) 170418 18:10:30 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 170418 18:10:30 [Note] WSREP: view(view_id(NON_PRIM,886f5e39,545) memb { 886f5e39,0 } joined { } left { } partitioned { 578a8700,0 5862b534,0 }) 170418 18:10:30 [Note] WSREP: Flow-control interval: [2500, 2500] 170418 18:10:30 [Note] WSREP: Received NON-PRIMARY. 170418 18:10:30 [Note] WSREP: Shifting PRIMARY -> OPEN (TO: 3472057770) 170418 18:10:30 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 170418 18:10:30 [Note] WSREP: Flow-control interval: [2500, 2500] 170418 18:10:30 [Note] WSREP: Received NON-PRIMARY. 170418 18:10:30 [Note] WSREP: declaring 578a8700 at tcp://*.*.*.206:4567 stable 170418 18:10:30 [Note] WSREP: declaring 5862b534 at tcp://*.*.*.35:4567 stable 170418 18:10:30 [Note] WSREP: Node 578a8700 state prim 170418 18:10:30 [Note] WSREP: view(view_id(PRIM,578a8700,546) memb { 578a8700,0 5862b534,0 886f5e39,0 } joined { } left { } partitioned { }) 170418 18:10:30 [Note] WSREP: save pc into disk 170418 18:10:31 [Warning] WSREP: last inactive check more than PT1.5S ago (PT1.79252S), skipping check 170418 18:10:31 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 2, memb_num = 3 170418 18:10:31 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 170418 18:10:31 [Note] WSREP: STATE EXCHANGE: sent state msg: 96afc2dc-243c-11e7-8a03-3b06a6d1b1cf 170418 18:10:31 [Note] WSREP: STATE EXCHANGE: got state msg: 96afc2dc-243c-11e7-8a03-3b06a6d1b1cf from 0 (node3) 170418 18:10:31 [Note] WSREP: STATE EXCHANGE: got state msg: 96afc2dc-243c-11e7-8a03-3b06a6d1b1cf from 1 (node1) 170418 18:10:31 [Note] WSREP: STATE EXCHANGE: got state msg: 96afc2dc-243c-11e7-8a03-3b06a6d1b1cf from 2 (node2) 170418 18:10:31 [Note] WSREP: Quorum results: version = 4, component = PRIMARY, conf_id = 67, members = 2/3 (joined/total), act_id = 3472057835, last_appl. = 3472057667, protocols = 0/7/3 (gcs/repl/appl), group UUID = dda62f30-e8ff-11e5-b5ce-3754b5ddaee3 170418 18:10:31 [Note] WSREP: Flow-control interval: [4330, 4330] 170418 18:10:31 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 3472057835) 170418 18:10:33 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') turning message relay requesting off 170418 18:10:36 [Warning] WSREP: last inactive check more than PT1.5S ago (PT3.45767S), skipping check 170418 18:10:37 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://*.*.*.35:4567 170418 18:10:38 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') reconnecting to 5862b534 (tcp://*.*.*.35:4567), attempt 0 170418 18:10:38 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') connection established to 5862b534 tcp://*.*.*.35:4567 170418 18:10:38 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') connection established to 578a8700 tcp://*.*.*.206:4567 170418 18:10:38 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') connection established to 5862b534 tcp://*.*.*.35:4567 170418 18:10:41 [Warning] WSREP: last inactive check more than PT1.5S ago (PT2.6793S), skipping check 170418 18:10:41 [Note] WSREP: view(view_id(NON_PRIM,578a8700,546) memb { 886f5e39,0 } joined { } left { } partitioned { 578a8700,0 5862b534,0 }) 170418 18:10:41 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 170418 18:10:41 [Note] WSREP: Flow-control interval: [2500, 2500] 170418 18:10:41 [Note] WSREP: Received NON-PRIMARY. 170418 18:10:41 [Note] WSREP: Shifting PRIMARY -> OPEN (TO: 3472058460) 170418 18:10:41 [Note] WSREP: view(view_id(NON_PRIM,886f5e39,547) memb { 886f5e39,0 } joined { } left { } partitioned { 578a8700,0 5862b534,0 }) 170418 18:10:41 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 170418 18:10:41 [Note] WSREP: Flow-control interval: [2500, 2500] 170418 18:10:41 [Note] WSREP: Received NON-PRIMARY. 170418 18:10:42 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') connection to peer 578a8700 with addr tcp://*.*.*.206:4567 timed out, no messages seen in PT3S 170418 18:10:42 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') reconnecting to 5862b534 (tcp://*.*.*.35:4567), attempt 0 170418 18:10:42 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') connection established to 5862b534 tcp://*.*.*.35:4567 170418 18:10:42 [Note] WSREP: declaring 578a8700 at tcp://*.*.*.206:4567 stable 170418 18:10:42 [Note] WSREP: declaring 5862b534 at tcp://*.*.*.35:4567 stable 170418 18:10:42 [Note] WSREP: Node 578a8700 state prim 170418 18:10:42 [Note] WSREP: view(view_id(PRIM,578a8700,548) memb { 578a8700,0 5862b534,0 886f5e39,0 } joined { } left { } partitioned { }) 170418 18:10:42 [Note] WSREP: save pc into disk 170418 18:10:43 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 2, memb_num = 3 170418 18:10:43 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 170418 18:10:43 [Note] WSREP: STATE EXCHANGE: sent state msg: 9e2a8bf0-243c-11e7-96ad-ee03339856f1 170418 18:10:43 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') connection established to 578a8700 tcp://*.*.*.206:4567 170418 18:10:43 [Note] WSREP: STATE EXCHANGE: got state msg: 9e2a8bf0-243c-11e7-96ad-ee03339856f1 from 0 (node3) 170418 18:10:43 [Note] WSREP: STATE EXCHANGE: got state msg: 9e2a8bf0-243c-11e7-96ad-ee03339856f1 from 1 (node1) 170418 18:10:43 [Note] WSREP: STATE EXCHANGE: got state msg: 9e2a8bf0-243c-11e7-96ad-ee03339856f1 from 2 (node2) 170418 18:10:43 [Note] WSREP: Quorum results: version = 4, component = PRIMARY, conf_id = 69, members = 2/3 (joined/total), act_id = 3472060319, last_appl. = 3472058369, protocols = 0/7/3 (gcs/repl/appl), group UUID = dda62f30-e8ff-11e5-b5ce-3754b5ddaee3 170418 18:10:43 [Note] WSREP: Flow-control interval: [4330, 4330] 170418 18:10:43 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 3472060319) 170418 18:10:46 [Note] WSREP: (886f5e39, 'tcp://0.0.0.0:4567') turning message relay requesting off 170418 18:10:58 [Note] WSREP: IST received: dda62f30-e8ff-11e5-b5ce-3754b5ddaee3:3472053927 170418 18:10:58 [Warning] WSREP: Rejecting JOIN message from 2.0 (node2): new State Transfer required. 170418 18:10:59 [Note] WSREP: New cluster view: global state: dda62f30-e8ff-11e5-b5ce-3754b5ddaee3:3472054265, view# -1: non-Primary, number of nodes: 1, my index: 0, protocol version 3 170418 18:10:59 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 170418 18:10:59 [Note] WSREP: New cluster view: global state: dda62f30-e8ff-11e5-b5ce-3754b5ddaee3:3472054265, view# -1: non-Primary, number of nodes: 1, my index: 0, protocol version 3 170418 18:10:59 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 170418 18:10:59 [Note] WSREP: New cluster view: global state: dda62f30-e8ff-11e5-b5ce-3754b5ddaee3:3472054265, view# -1: non-Primary, number of nodes: 1, my index: 0, protocol version 3 170418 18:10:59 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 170418 18:10:59 [Note] WSREP: State transfer required: Group state: dda62f30-e8ff-11e5-b5ce-3754b5ddaee3:3472054318 Local state: dda62f30-e8ff-11e5-b5ce-3754b5ddaee3:3472054265 170418 18:10:59 [Note] WSREP: New cluster view: global state: dda62f30-e8ff-11e5-b5ce-3754b5ddaee3:3472054318, view# 67: Primary, number of nodes: 3, my index: 2, protocol version 3 170418 18:10:59 [Warning] WSREP: Gap in state sequence. Need state transfer. 170418 18:10:59 [Note] WSREP: You have configured 'xtrabackup-v2' state snapshot transfer method which cannot be performed on a running server. Wsrep provider won't be able to fall back to it if other means of state transfer are unavailable. In that case you will need to restart the server. 170418 18:10:59 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 170418 18:10:59 [Note] WSREP: REPL Protocols: 7 (3, 2) 170418 18:10:59 [Note] WSREP: Assign initial position for certification: 3472054318, protocol version: 3 170418 18:10:59 [Note] WSREP: Service thread queue flushed. 170418 18:10:59 [Note] WSREP: IST receiver addr using tcp://*.*.*.60:4568 170418 18:10:59 [Note] WSREP: Prepared IST receiver, listening at: tcp://*.*.*.60:4568 170418 18:10:59 [Note] WSREP: Member 2.0 (node2) requested state transfer from '*any*'. Selected 0.0 (node3)(SYNCED) as donor. 170418 18:10:59 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 3472062685) 170418 18:10:59 [Note] WSREP: Requesting state transfer: success, donor: 0 170418 18:10:59 [Note] WSREP: GCache history reset: old(dda62f30-e8ff-11e5-b5ce-3754b5ddaee3:3472054265) -> new(dda62f30-e8ff-11e5-b5ce-3754b5ddaee3:3472054318) 170418 18:10:59 [Note] WSREP: GCache DEBUG: RingBuffer::seqno_reset(): discarded 556284 bytes 170418 18:10:59 [Note] WSREP: GCache DEBUG: RingBuffer::seqno_reset(): found 1/6444 locked buffers 170418 18:10:59 [Note] WSREP: Receiving IST: 53 writesets, seqnos 3472054265-3472054318 170418 18:10:59 [Note] WSREP: 0.0 (node3): State transfer to 2.0 (node2) complete. 170418 18:10:59 [Note] WSREP: Member 0.0 (node3) synced with group. 170418 18:11:47 [Note] WSREP: IST received: dda62f30-e8ff-11e5-b5ce-3754b5ddaee3:3472060319 170418 18:11:47 [Note] WSREP: 2.0 (node2): State transfer from 0.0 (node3) complete. 170418 18:11:47 [Note] WSREP: Shifting JOINER -> JOINED (TO: 3472062685) 170418 18:11:47 [Note] WSREP: Member 2.0 (node2) synced with group. 170418 18:11:47 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 3472062685) 170418 18:11:48 [Note] WSREP: New cluster view: global state: dda62f30-e8ff-11e5-b5ce-3754b5ddaee3:3472057770, view# -1: non-Primary, number of nodes: 1, my index: 0, protocol version 3 170418 18:11:48 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 170418 18:11:48 [Note] WSREP: New cluster view: global state: dda62f30-e8ff-11e5-b5ce-3754b5ddaee3:3472057770, view# -1: non-Primary, number of nodes: 1, my index: 0, protocol version 3 Hamoon 170418 18:11:48 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 170418 18:11:48 [Note] WSREP: Closing send monitor... 170418 18:11:48 [Note] WSREP: Closed send monitor. 170418 18:11:48 [Note] WSREP: gcomm: terminating thread 170418 18:11:48 [Note] WSREP: gcomm: joining thread 170418 18:11:48 [Note] WSREP: gcomm: closing backend 170418 18:11:48 [Note] WSREP: view(view_id(NON_PRIM,578a8700,548) memb { 886f5e39,0 } joined { } left { } partitioned { 578a8700,0 5862b534,0 }) 170418 18:11:48 [Note] WSREP: view((empty)) 170418 18:11:48 [Note] WSREP: gcomm: closed 170418 18:11:48 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 170418 18:11:48 [Note] WSREP: Flow-control interval: [2500, 2500] 170418 18:11:48 [Note] WSREP: Received NON-PRIMARY. 170418 18:11:48 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 3472062685) 170418 18:11:48 [Note] WSREP: Received self-leave message. 170418 18:11:48 [Note] WSREP: Flow-control interval: [0, 0] 170418 18:11:48 [Note] WSREP: Received SELF-LEAVE. Closing connection. 170418 18:11:48 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 3472062685) 170418 18:11:48 [Note] WSREP: RECV thread exiting 0: Success 170418 18:11:48 [Note] WSREP: recv_thread() joined. 170418 18:11:48 [Note] WSREP: Closing replication queue. 170418 18:11:48 [Note] WSREP: Closing slave action queue. 170418 18:11:48 [ERROR] WSREP: Local state seqno (3472060319) is greater than group seqno (3472057835): states diverged. Aborting to avoid potential data loss. Remove '/home/mysql//grastate.dat' file and restart if you wish to continue. (FATAL) at galera/src/replicator_str.cpp:state_transfer_required():33 170418 18:11:48 [Note] WSREP: applier thread exiting (code:8) 170418 18:11:48 [Note] WSREP: starting shutdown 170418 18:11:48 [Note] /usr/sbin/mysqld: Normal shutdown 170418 18:11:48 [Note] WSREP: Stop replication 170418 18:11:50 [Note] WSREP: killing local connection: 3607058 170418 18:11:50 [Note] WSREP: killing local connection: 3607040 170418 18:11:50 [Note] WSREP: killing local connection: 3607039 170418 18:11:50 [Note] WSREP: killing local connection: 3607035 170418 18:11:50 [Note] WSREP: killing local connection: 3607032 170418 18:11:50 [Note] WSREP: killing local connection: 3606762 170418 18:11:50 [Note] WSREP: killing local connection: 3606603