2020-07-02 6:30:55 24 [Note] WSREP: ================================================ View: id: 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:830572398 status: primary protocol_version: 4 capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO final: no own_index: 0 members(3): 0: 929c349f-bb78-11ea-a696-fa2539cbb929, SRV3 1: 94b0f457-bc2d-11ea-8448-43f9df54c00f, SRV2 2: 9f03a2e3-bb78-11ea-8cfd-c6ef66345640, SRV1 ================================================= 2020-07-02 6:30:55 24 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-07-02 6:30:55 24 [Note] WSREP: Lowest cert indnex boundary for CC from group: 830570867 2020-07-02 6:30:55 24 [Note] WSREP: Min available from gcache for CC from group: 830570867 2020-07-02 6:30:55 0 [Note] WSREP: Member 1.0 (SRV2) requested state transfer from '*any*'. Selected 0.0 (SRV3)(SYNCED) as donor. 2020-07-02 6:30:55 0 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 830572505) 2020-07-02 6:30:55 15 [Note] WSREP: Detected STR version: 1, req_len: 142, req: STRv1 2020-07-02 6:30:55 15 [Note] WSREP: Cert index preload: 830570867 -> 830572398 2020-07-02 6:30:55 15 [Note] WSREP: Server status change synced -> donor 2020-07-02 6:30:55 0 [Note] WSREP: async IST sender starting to serve tcp://192.168.148.226:4568 sending 830570867-830572398, preload starts from 830570867 2020-07-02 6:30:55 15 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-07-02 6:30:55 15 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-07-02 6:30:55 0 [Note] WSREP: Donor monitor thread started to monitor 2020-07-02 6:30:55 0 [Note] WSREP: IST sender 830570867 -> 830572398 2020-07-02 6:30:55 0 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'donor' --address '192.168.148.226:4444/xtrabackup_sst//1' --socket '/var/lib/mysql/mysql.sock' --datadir '/var/lib/mysql/' --gtid '59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:830572505' --gtid-domain-id '0' --binlog '/var/lib/mysql/master-bin' --binlog-index '/var/lib/mysql/master-bin.index' --mysqld-args --wsrep_start_position=59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:821215429' 2020-07-02 6:30:55 15 [Note] WSREP: sst_donor_thread signaled with 0 WSREP_SST: [INFO] Logging all stderr of SST/Innobackupex to syslog (20200702 06:30:55.918) 2020-07-02 6:30:57 0 [Note] WSREP: (929c349f-a696, 'tcp://0.0.0.0:4567') turning message relay requesting off 2020-07-02 6:32:02 0 [Note] WSREP: SST sent: 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:830572505 2020-07-02 6:32:02 0 [Note] WSREP: Server status change donor -> joined 2020-07-02 6:32:02 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-07-02 6:32:02 0 [Note] WSREP: 0.0 (SRV3): State transfer to 1.0 (SRV2) complete. 2020-07-02 6:32:02 0 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 830581409) 2020-07-02 6:32:02 0 [Note] WSREP: Member 0.0 (SRV3) synced with group. 2020-07-02 6:32:02 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 830581409) 2020-07-02 6:32:02 16 [Note] WSREP: Server SRV3 synced with group 2020-07-02 6:32:02 16 [Note] WSREP: Server status change joined -> synced 2020-07-02 6:32:02 16 [Note] WSREP: Synchronized with group, ready for connections 2020-07-02 6:32:02 16 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-07-02 6:32:02 0 [Note] WSREP: Donor monitor thread ended with total time 67 sec 2020-07-02 6:32:08 0 [Note] WSREP: async IST sender served 2020-07-02 6:32:08 0 [Note] WSREP: 1.0 (SRV2): State transfer from 0.0 (SRV3) complete. 2020-07-02 6:32:08 0 [Note] WSREP: declaring 9f03a2e3-8cfd at tcp://192.168.198.58:4567 stable 2020-07-02 6:32:08 0 [Note] WSREP: forgetting 94b0f457-8448 (tcp://192.168.148.226:4567) 2020-07-02 6:32:08 0 [Note] WSREP: Node 929c349f-a696 state prim 2020-07-02 6:32:08 0 [Note] WSREP: view(view_id(PRIM,929c349f-a696,35) memb { 929c349f-a696,0 9f03a2e3-8cfd,0 } joined { } left { } partitioned { 94b0f457-8448,0 }) 2020-07-02 6:32:08 0 [Note] WSREP: save pc into disk 2020-07-02 6:32:08 0 [Note] WSREP: forgetting 94b0f457-8448 (tcp://192.168.148.226:4567) 2020-07-02 6:32:08 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2 2020-07-02 6:32:08 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: c11b8e25-bc2d-11ea-97a9-9bf7bf559d70 2020-07-02 6:32:08 0 [Note] WSREP: STATE EXCHANGE: sent state msg: c11b8e25-bc2d-11ea-97a9-9bf7bf559d70 2020-07-02 6:32:08 0 [Note] WSREP: STATE EXCHANGE: got state msg: c11b8e25-bc2d-11ea-97a9-9bf7bf559d70 from 0 (SRV3) 2020-07-02 6:32:08 0 [Note] WSREP: STATE EXCHANGE: got state msg: c11b8e25-bc2d-11ea-97a9-9bf7bf559d70 from 1 (SRV1) 2020-07-02 6:32:08 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 13, members = 2/2 (joined/total), act_id = 830582423, last_appl. = 830582345, protocols = 2/10/4 (gcs/repl/appl), vote policy= 0, group UUID = 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb 2020-07-02 6:32:08 0 [Note] WSREP: Flow-control interval: [23, 23] 2020-07-02 6:32:08 17 [Note] WSREP: ####### processing CC 830582424, local, ordered 2020-07-02 6:32:08 17 [Note] WSREP: ####### My UUID: 929c349f-bb78-11ea-a696-fa2539cbb929 2020-07-02 6:32:08 17 [Note] WSREP: Skipping cert index reset 2020-07-02 6:32:08 17 [Note] WSREP: REPL Protocols: 10 (5) 2020-07-02 6:32:08 17 [Note] WSREP: ####### Adjusting cert position: 830582423 -> 830582424 2020-07-02 6:32:08 0 [Note] WSREP: Service thread queue flushed. 2020-07-02 6:32:08 17 [Note] WSREP: ================================================ View: id: 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:830582424 status: primary protocol_version: 4 capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO final: no own_index: 0 members(2): 0: 929c349f-bb78-11ea-a696-fa2539cbb929, SRV3 1: 9f03a2e3-bb78-11ea-8cfd-c6ef66345640, SRV1 ================================================= 2020-07-02 6:32:08 17 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-07-02 6:32:08 17 [Note] WSREP: Lowest cert indnex boundary for CC from group: 830582346 2020-07-02 6:32:08 17 [Note] WSREP: Min available from gcache for CC from group: 830582346 2020-07-02 6:32:13 0 [Note] WSREP: cleaning up 94b0f457-8448 (tcp://192.168.148.226:4567) 2020-07-02 6:32:55 0 [Note] WSREP: (929c349f-a696, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://192.168.198.58:4567 2020-07-02 6:32:56 0 [Note] WSREP: (929c349f-a696, 'tcp://0.0.0.0:4567') reconnecting to 9f03a2e3-8cfd (tcp://192.168.198.58:4567), attempt 0 2020-07-02 6:32:59 0 [Note] WSREP: evs::proto(929c349f-a696, OPERATIONAL, view_id(REG,929c349f-a696,35)) suspecting node: 9f03a2e3-8cfd 2020-07-02 6:32:59 0 [Note] WSREP: evs::proto(929c349f-a696, OPERATIONAL, view_id(REG,929c349f-a696,35)) suspected node without join message, declaring inactive 2020-07-02 6:33:00 0 [Note] WSREP: view(view_id(NON_PRIM,929c349f-a696,35) memb { 929c349f-a696,0 } joined { } left { } partitioned { 9f03a2e3-8cfd,0 }) 2020-07-02 6:33:00 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2020-07-02 6:33:00 0 [Note] WSREP: view(view_id(NON_PRIM,929c349f-a696,36) memb { 929c349f-a696,0 } joined { } left { } partitioned { 9f03a2e3-8cfd,0 }) 2020-07-02 6:33:00 0 [Note] WSREP: Flow-control interval: [16, 16] 2020-07-02 6:33:00 0 [Note] WSREP: Received NON-PRIMARY. 2020-07-02 6:33:00 0 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 830589248) 2020-07-02 6:33:00 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2020-07-02 6:33:00 5015920 [Warning] WSREP: Send action {(nil), 752, WRITESET} returned -107 (Transport endpoint is not connected) 2020-07-02 6:33:00 0 [Note] WSREP: Flow-control interval: [16, 16] 2020-07-02 6:33:00 0 [Note] WSREP: Received NON-PRIMARY. 2020-07-02 6:33:00 22 [Note] WSREP: ================================================ View: id: 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:-1 status: non-primary protocol_version: 4 capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO final: no own_index: 0 members(1): 0: 929c349f-bb78-11ea-a696-fa2539cbb929, SRV3 ================================================= 2020-07-02 6:33:00 22 [Note] WSREP: Non-primary view 2020-07-02 6:33:00 22 [Note] WSREP: Server status change synced -> connected 2020-07-02 6:33:00 5015922 [Warning] WSREP: Send action {(nil), 832, WRITESET} returned -107 (Transport endpoint is not connected) 2020-07-02 6:33:00 5006472 [Warning] WSREP: Send action {(nil), 960, WRITESET} returned -107 (Transport endpoint is not connected) 2020-07-02 6:33:00 5015924 [Warning] WSREP: Send action {(nil), 744, WRITESET} returned -107 (Transport endpoint is not connected) 2020-07-02 6:33:00 5015925 [Warning] WSREP: Send action {(nil), 744, WRITESET} returned -107 (Transport endpoint is not connected) 2020-07-02 6:33:00 5015923 [Warning] WSREP: Send action {(nil), 832, WRITESET} returned -107 (Transport endpoint is not connected) 2020-07-02 6:33:00 4940986 [Warning] WSREP: Send action {(nil), 528, WRITESET} returned -107 (Transport endpoint is not connected) 2020-07-02 6:33:00 5015928 [Warning] WSREP: Send action {(nil), 744, WRITESET} returned -107 (Transport endpoint is not connected) 2020-07-02 6:33:00 5015929 [Warning] WSREP: Send action {(nil), 824, WRITESET} returned -107 (Transport endpoint is not connected) 2020-07-02 6:33:00 5015930 [Warning] WSREP: Send action {(nil), 752, WRITESET} returned -107 (Transport endpoint is not connected) 2020-07-02 6:33:00 22 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-07-02 6:33:00 22 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-07-02 6:33:00 22 [Note] WSREP: ================================================ View: id: 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:-1 status: non-primary protocol_version: 4 capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO final: no own_index: 0 members(1): 0: 929c349f-bb78-11ea-a696-fa2539cbb929, SRV3 ================================================= 2020-07-02 6:33:00 22 [Note] WSREP: Non-primary view 2020-07-02 6:33:00 22 [Note] WSREP: Server status change connected -> connected 2020-07-02 6:33:00 22 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-07-02 6:33:00 22 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-07-02 6:33:00 5015931 [Warning] WSREP: Send action {(nil), 752, WRITESET} returned -107 (Transport endpoint is not connected) 2020-07-02 6:33:00 5015933 [Warning] WSREP: Send action {(nil), 832, WRITESET} returned -107 (Transport endpoint is not connected) 2020-07-02 6:33:00 5015932 [Warning] WSREP: Send action {(nil), 752, WRITESET} returned -107 (Transport endpoint is not connected) 2020-07-02 6:33:00 5015927 [Warning] WSREP: Send action {(nil), 752, WRITESET} returned -107 (Transport endpoint is not connected) 2020-07-02 6:33:00 5015934 [Warning] WSREP: Send action {(nil), 832, WRITESET} returned -107 (Transport endpoint is not connected) 2020-07-02 6:33:00 5015935 [Warning] WSREP: Send action {(nil), 824, WRITESET} returned -107 (Transport endpoint is not connected) 2020-07-02 6:33:00 5015936 [Warning] WSREP: Send action {(nil), 832, WRITESET} returned -107 (Transport endpoint is not connected) 2020-07-02 6:33:00 5015938 [Warning] WSREP: Send action {(nil), 392, WRITESET} returned -107 (Transport endpoint is not connected) 2020-07-02 6:33:00 5015937 [Warning] WSREP: Send action {(nil), 824, WRITESET} returned -107 (Transport endpoint is not connected) 2020-07-02 6:33:00 5015939 [Warning] WSREP: Send action {(nil), 824, WRITESET} returned -107 (Transport endpoint is not connected) 2020-07-02 6:33:00 5015940 [Warning] WSREP: Send action {(nil), 832, WRITESET} returned -107 (Transport endpoint is not connected) 2020-07-02 6:33:00 5015942 [Warning] WSREP: Send action {(nil), 824, WRITESET} returned -107 (Transport endpoint is not connected) 2020-07-02 6:33:00 5015943 [Warning] WSREP: Send action {(nil), 832, WRITESET} returned -107 (Transport endpoint is not connected) 2020-07-02 6:33:00 5015945 [Warning] WSREP: Send action {(nil), 824, WRITESET} returned -107 (Transport endpoint is not connected) 2020-07-02 6:33:00 5015946 [Warning] WSREP: Send action {(nil), 832, WRITESET} returned -107 (Transport endpoint is not connected) 2020-07-02 6:33:00 5015950 [Warning] WSREP: Send action {(nil), 824, WRITESET} returned -107 (Transport endpoint is not connected) 2020-07-02 6:33:00 5015949 [Warning] WSREP: Send action {(nil), 832, WRITESET} returned -107 (Transport endpoint is not connected) 2020-07-02 6:33:05 0 [Note] WSREP: (929c349f-a696, 'tcp://0.0.0.0:4567') connection established to 9f03a2e3-8cfe tcp://192.168.198.58:4567 2020-07-02 6:33:05 0 [Note] WSREP: remote endpoint tcp://192.168.198.58:4567 changed identity 9f03a2e3-bb78-11ea-8cfd-c6ef66345640 -> 9f03a2e3-bb78-11ea-8cfe-c6ef66345640 2020-07-02 6:33:06 0 [Note] WSREP: declaring 9f03a2e3-8cfe at tcp://192.168.198.58:4567 stable 2020-07-02 6:33:06 0 [Note] WSREP: view(view_id(NON_PRIM,929c349f-a696,37) memb { 929c349f-a696,0 9f03a2e3-8cfe,0 } joined { } left { } partitioned { 9f03a2e3-8cfd,0 }) 2020-07-02 6:33:06 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 2 2020-07-02 6:33:06 0 [Note] WSREP: Flow-control interval: [23, 23] 2020-07-02 6:33:06 0 [Note] WSREP: Received NON-PRIMARY. 2020-07-02 6:33:06 22 [Note] WSREP: ================================================ View: id: 59f18ef6-11e2-11ea-bb4d-9f7d6a2a1ddb:-1 status: non-primary protocol_version: 4 capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO final: no own_index: 0 members(2): 0: 929c349f-bb78-11ea-a696-fa2539cbb929, SRV3 1: 9f03a2e3-bb78-11ea-8cfe-c6ef66345640, unspecified ================================================= 2020-07-02 6:33:06 22 [Note] WSREP: Non-primary view 2020-07-02 6:33:06 22 [Note] WSREP: Server status change connected -> connected 2020-07-02 6:33:06 22 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-07-02 6:33:06 22 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-07-02 6:33:08 0 [Note] WSREP: (929c349f-a696, 'tcp://0.0.0.0:4567') turning message relay requesting off