-- Logs begin at Sun 2020-11-15 22:12:59 CET, end at Tue 2021-03-23 11:44:27 CET. -- Mar 23 09:02:09 srv1 mysqld[18623]: 2021-03-23 9:02:09 0 [Note] WSREP: (7d447799-915b, 'ssl://0.0.0.0:4567') turning message relay requesting on, nonlive peers: ssl://10.0.1.3:4567 Mar 23 09:02:10 srv1 mysqld[18623]: 2021-03-23 9:02:10 0 [Note] WSREP: (7d447799-915b, 'ssl://0.0.0.0:4567') reconnecting to 6552b06c-a6b1 (ssl://10.0.1.3:4567), attempt 0 Mar 23 09:02:13 srv1 mysqld[18623]: 2021-03-23 9:02:13 0 [Note] WSREP: evs::proto(7d447799-915b, OPERATIONAL, view_id(REG,6552b06c-a6b1,158)) suspecting node: 6552b06c-a6b1 Mar 23 09:02:13 srv1 mysqld[18623]: 2021-03-23 9:02:13 0 [Note] WSREP: evs::proto(7d447799-915b, OPERATIONAL, view_id(REG,6552b06c-a6b1,158)) suspected node without join message, declaring inactive Mar 23 09:02:14 srv1 mysqld[18623]: 2021-03-23 9:02:14 0 [Note] WSREP: declaring fa61149d-9ae2 at ssl://10.0.1.4:4567 stable Mar 23 09:02:14 srv1 mysqld[18623]: 2021-03-23 9:02:14 0 [Note] WSREP: Node 7d447799-915b state prim Mar 23 09:02:14 srv1 mysqld[18623]: 2021-03-23 9:02:14 0 [Note] WSREP: view(view_id(PRIM,7d447799-915b,159) memb { Mar 23 09:02:14 srv1 mysqld[18623]: 7d447799-915b,0 Mar 23 09:02:14 srv1 mysqld[18623]: fa61149d-9ae2,0 Mar 23 09:02:14 srv1 mysqld[18623]: } joined { Mar 23 09:02:14 srv1 mysqld[18623]: } left { Mar 23 09:02:14 srv1 mysqld[18623]: } partitioned { Mar 23 09:02:14 srv1 mysqld[18623]: 6552b06c-a6b1,0 Mar 23 09:02:14 srv1 mysqld[18623]: }) Mar 23 09:02:14 srv1 mysqld[18623]: 2021-03-23 9:02:14 0 [Note] WSREP: save pc into disk Mar 23 09:02:14 srv1 mysqld[18623]: 2021-03-23 9:02:14 0 [Note] WSREP: forgetting 6552b06c-a6b1 (ssl://10.0.1.3:4567) Mar 23 09:02:14 srv1 mysqld[18623]: 2021-03-23 9:02:14 0 [Note] WSREP: (7d447799-915b, 'ssl://0.0.0.0:4567') turning message relay requesting off Mar 23 09:02:14 srv1 mysqld[18623]: 2021-03-23 9:02:14 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2 Mar 23 09:02:14 srv1 mysqld[18623]: 2021-03-23 9:02:14 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 145f9ae8-8bae-11eb-acb7-3f1beaea1490 Mar 23 09:02:14 srv1 mysqld[18623]: 2021-03-23 9:02:14 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 145f9ae8-8bae-11eb-acb7-3f1beaea1490 Mar 23 09:02:14 srv1 mysqld[18623]: 2021-03-23 9:02:14 0 [Note] WSREP: STATE EXCHANGE: got state msg: 145f9ae8-8bae-11eb-acb7-3f1beaea1490 from 0 (srv1) Mar 23 09:02:14 srv1 mysqld[18623]: 2021-03-23 9:02:14 0 [Note] WSREP: STATE EXCHANGE: got state msg: 145f9ae8-8bae-11eb-acb7-3f1beaea1490 from 1 (srv3) Mar 23 09:02:14 srv1 mysqld[18623]: 2021-03-23 9:02:14 0 [Note] WSREP: Quorum results: Mar 23 09:02:14 srv1 mysqld[18623]: version = 6, Mar 23 09:02:14 srv1 mysqld[18623]: component = PRIMARY, Mar 23 09:02:14 srv1 mysqld[18623]: conf_id = 3, Mar 23 09:02:14 srv1 mysqld[18623]: members = 2/2 (joined/total), Mar 23 09:02:14 srv1 mysqld[18623]: act_id = 1647665871, Mar 23 09:02:14 srv1 mysqld[18623]: last_appl. = 1647665736, Mar 23 09:02:14 srv1 mysqld[18623]: protocols = 2/10/4 (gcs/repl/appl), Mar 23 09:02:14 srv1 mysqld[18623]: vote policy= 0, Mar 23 09:02:14 srv1 mysqld[18623]: group UUID = bd401d28-f285-11ea-9c06-4e99d1c864f6 Mar 23 09:02:14 srv1 mysqld[18623]: 2021-03-23 9:02:14 0 [Note] WSREP: Flow-control interval: [23, 23] Mar 23 09:02:14 srv1 mysqld[18623]: 2021-03-23 9:02:14 17 [Note] WSREP: ####### processing CC 1647665872, local, ordered Mar 23 09:02:14 srv1 mysqld[18623]: 2021-03-23 9:02:14 17 [Note] WSREP: ####### My UUID: 7d447799-8b22-11eb-915b-468cb230a09e Mar 23 09:02:14 srv1 mysqld[18623]: 2021-03-23 9:02:14 17 [Note] WSREP: Skipping cert index reset Mar 23 09:02:14 srv1 mysqld[18623]: 2021-03-23 9:02:14 17 [Note] WSREP: REPL Protocols: 10 (5) Mar 23 09:02:14 srv1 mysqld[18623]: 2021-03-23 9:02:14 17 [Note] WSREP: ####### Adjusting cert position: 1647665871 -> 1647665872 Mar 23 09:02:14 srv1 mysqld[18623]: 2021-03-23 9:02:14 0 [Note] WSREP: Service thread queue flushed. Mar 23 09:02:14 srv1 mysqld[18623]: 2021-03-23 9:02:14 17 [Note] WSREP: ================================================ Mar 23 09:02:14 srv1 mysqld[18623]: View: Mar 23 09:02:14 srv1 mysqld[18623]: id: bd401d28-f285-11ea-9c06-4e99d1c864f6:1647665872 Mar 23 09:02:14 srv1 mysqld[18623]: status: primary Mar 23 09:02:14 srv1 mysqld[18623]: protocol_version: 4 Mar 23 09:02:14 srv1 mysqld[18623]: capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO Mar 23 09:02:14 srv1 mysqld[18623]: final: no Mar 23 09:02:14 srv1 mysqld[18623]: own_index: 0 Mar 23 09:02:14 srv1 mysqld[18623]: members(2): Mar 23 09:02:14 srv1 mysqld[18623]: 0: 7d447799-8b22-11eb-915b-468cb230a09e, srv1 Mar 23 09:02:14 srv1 mysqld[18623]: 1: fa61149d-87ed-11eb-9ae2-be4d05c83bf4, srv3 Mar 23 09:02:14 srv1 mysqld[18623]: ================================================= Mar 23 09:02:14 srv1 mysqld[18623]: 2021-03-23 9:02:14 17 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Mar 23 09:02:14 srv1 mysqld[18623]: 2021-03-23 9:02:14 17 [Note] WSREP: Lowest cert index boundary for CC from group: 1647665737 Mar 23 09:02:14 srv1 mysqld[18623]: 2021-03-23 9:02:14 17 [Note] WSREP: Min available from gcache for CC from group: 1644973750 Mar 23 09:02:17 srv1 mysqld[18623]: 2021-03-23 9:02:17 0 [Note] WSREP: cleaning up 6552b06c-a6b1 (ssl://10.0.1.3:4567) Mar 23 09:02:33 srv1 mysqld[18623]: 2021-03-23 9:02:33 0 [Note] WSREP: (7d447799-915b, 'ssl://0.0.0.0:4567') connection established to 6552b06c-a6b2 ssl://10.0.1.3:4567 Mar 23 09:02:33 srv1 mysqld[18623]: 2021-03-23 9:02:33 0 [Note] WSREP: (7d447799-915b, 'ssl://0.0.0.0:4567') turning message relay requesting on, nonlive peers: Mar 23 09:02:33 srv1 mysqld[18623]: 2021-03-23 9:02:33 0 [Note] WSREP: declaring 6552b06c-a6b2 at ssl://10.0.1.3:4567 stable Mar 23 09:02:33 srv1 mysqld[18623]: 2021-03-23 9:02:33 0 [Note] WSREP: declaring fa61149d-9ae2 at ssl://10.0.1.4:4567 stable Mar 23 09:02:33 srv1 mysqld[18623]: 2021-03-23 9:02:33 0 [Note] WSREP: Node 7d447799-915b state prim Mar 23 09:02:33 srv1 mysqld[18623]: 2021-03-23 9:02:33 0 [Note] WSREP: view(view_id(PRIM,6552b06c-a6b2,160) memb { Mar 23 09:02:33 srv1 mysqld[18623]: 6552b06c-a6b2,0 Mar 23 09:02:33 srv1 mysqld[18623]: 7d447799-915b,0 Mar 23 09:02:33 srv1 mysqld[18623]: fa61149d-9ae2,0 Mar 23 09:02:33 srv1 mysqld[18623]: } joined { Mar 23 09:02:33 srv1 mysqld[18623]: } left { Mar 23 09:02:33 srv1 mysqld[18623]: } partitioned { Mar 23 09:02:33 srv1 mysqld[18623]: }) Mar 23 09:02:33 srv1 mysqld[18623]: 2021-03-23 9:02:33 0 [Note] WSREP: save pc into disk Mar 23 09:02:33 srv1 mysqld[18623]: 2021-03-23 9:02:33 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 3 Mar 23 09:02:33 srv1 mysqld[18623]: 2021-03-23 9:02:33 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. Mar 23 09:02:34 srv1 mysqld[18623]: 2021-03-23 9:02:34 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 20039b70-8bae-11eb-936b-5abdaa1c6f49 Mar 23 09:02:34 srv1 mysqld[18623]: 2021-03-23 9:02:34 0 [Note] WSREP: STATE EXCHANGE: got state msg: 20039b70-8bae-11eb-936b-5abdaa1c6f49 from 0 (srv2) Mar 23 09:02:34 srv1 mysqld[18623]: 2021-03-23 9:02:34 0 [Note] WSREP: STATE EXCHANGE: got state msg: 20039b70-8bae-11eb-936b-5abdaa1c6f49 from 1 (srv1) Mar 23 09:02:34 srv1 mysqld[18623]: 2021-03-23 9:02:34 0 [Note] WSREP: STATE EXCHANGE: got state msg: 20039b70-8bae-11eb-936b-5abdaa1c6f49 from 2 (srv3) Mar 23 09:02:34 srv1 mysqld[18623]: 2021-03-23 9:02:34 0 [Note] WSREP: Quorum results: Mar 23 09:02:34 srv1 mysqld[18623]: version = 6, Mar 23 09:02:34 srv1 mysqld[18623]: component = PRIMARY, Mar 23 09:02:34 srv1 mysqld[18623]: conf_id = 4, Mar 23 09:02:34 srv1 mysqld[18623]: members = 2/3 (joined/total), Mar 23 09:02:34 srv1 mysqld[18623]: act_id = 1647668374, Mar 23 09:02:34 srv1 mysqld[18623]: last_appl. = 1647665736, Mar 23 09:02:34 srv1 mysqld[18623]: protocols = 2/10/4 (gcs/repl/appl), Mar 23 09:02:34 srv1 mysqld[18623]: vote policy= 0, Mar 23 09:02:34 srv1 mysqld[18623]: group UUID = bd401d28-f285-11ea-9c06-4e99d1c864f6 Mar 23 09:02:34 srv1 mysqld[18623]: 2021-03-23 9:02:34 0 [Note] WSREP: Flow-control interval: [28, 28] Mar 23 09:02:34 srv1 mysqld[18623]: 2021-03-23 9:02:34 17 [Note] WSREP: ####### processing CC 1647668375, local, ordered Mar 23 09:02:34 srv1 mysqld[18623]: 2021-03-23 9:02:34 17 [Note] WSREP: ####### My UUID: 7d447799-8b22-11eb-915b-468cb230a09e Mar 23 09:02:34 srv1 mysqld[18623]: 2021-03-23 9:02:34 17 [Note] WSREP: Skipping cert index reset Mar 23 09:02:34 srv1 mysqld[18623]: 2021-03-23 9:02:34 17 [Note] WSREP: REPL Protocols: 10 (5) Mar 23 09:02:34 srv1 mysqld[18623]: 2021-03-23 9:02:34 17 [Note] WSREP: ####### Adjusting cert position: 1647668374 -> 1647668375 Mar 23 09:02:34 srv1 mysqld[18623]: 2021-03-23 9:02:34 0 [Note] WSREP: Service thread queue flushed. Mar 23 09:02:34 srv1 mysqld[18623]: 2021-03-23 9:02:34 17 [Note] WSREP: ================================================ Mar 23 09:02:34 srv1 mysqld[18623]: View: Mar 23 09:02:34 srv1 mysqld[18623]: id: bd401d28-f285-11ea-9c06-4e99d1c864f6:1647668375 Mar 23 09:02:34 srv1 mysqld[18623]: status: primary Mar 23 09:02:34 srv1 mysqld[18623]: protocol_version: 4 Mar 23 09:02:34 srv1 mysqld[18623]: capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO Mar 23 09:02:34 srv1 mysqld[18623]: final: no Mar 23 09:02:34 srv1 mysqld[18623]: own_index: 1 Mar 23 09:02:34 srv1 mysqld[18623]: members(3): Mar 23 09:02:34 srv1 mysqld[18623]: 0: 6552b06c-87fd-11eb-a6b2-670c0c1acbe7, srv2 Mar 23 09:02:34 srv1 mysqld[18623]: 1: 7d447799-8b22-11eb-915b-468cb230a09e, srv1 Mar 23 09:02:34 srv1 mysqld[18623]: 2: fa61149d-87ed-11eb-9ae2-be4d05c83bf4, srv3 Mar 23 09:02:34 srv1 mysqld[18623]: ================================================= Mar 23 09:02:34 srv1 mysqld[18623]: 2021-03-23 9:02:34 17 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Mar 23 09:02:34 srv1 mysqld[18623]: 2021-03-23 9:02:34 17 [Note] WSREP: Lowest cert index boundary for CC from group: 1647665737 Mar 23 09:02:34 srv1 mysqld[18623]: 2021-03-23 9:02:34 17 [Note] WSREP: Min available from gcache for CC from group: 1644976254 Mar 23 09:02:34 srv1 mysqld[18623]: 2021-03-23 9:02:34 0 [Note] WSREP: Member 0.0 (srv2) requested state transfer from '*any*'. Selected 1.0 (srv1)(SYNCED) as donor. Mar 23 09:02:34 srv1 mysqld[18623]: 2021-03-23 9:02:34 0 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 1647668380) Mar 23 09:02:34 srv1 mysqld[18623]: 2021-03-23 9:02:34 17 [Note] WSREP: Detected STR version: 1, req_len: 145, req: STRv1 Mar 23 09:02:34 srv1 mysqld[18623]: 2021-03-23 9:02:34 17 [Note] WSREP: IST request: bd401d28-f285-11ea-9c06-4e99d1c864f6:1647665857-1647668375|ssl://10.0.1.3:4568 Mar 23 09:02:34 srv1 mysqld[18623]: 2021-03-23 9:02:34 17 [Note] WSREP: Server status change synced -> donor Mar 23 09:02:34 srv1 mysqld[18623]: 2021-03-23 9:02:34 17 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Mar 23 09:02:34 srv1 mysqld[18623]: 2021-03-23 9:02:34 0 [Note] WSREP: Donor monitor thread started to monitor Mar 23 09:02:34 srv1 mysqld[18623]: 2021-03-23 9:02:34 0 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'donor' --address '10.0.1.3:4444/xtrabackup_sst//1' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --gtid 'bd401d28-f285-11ea-9c06-4e99d1c864f6:1647665857' --gtid-domain-id '0' --binlog '/var/log/mysql/mariadb-bin' --binlog-index '/var/log/mysql/mariadb-bin.index' --bypass --mysqld-args --wsrep_start_position=bd401d28-f285-11ea-9c06-4e99d1c864f6:1644287162' Mar 23 09:02:34 srv1 mysqld[18623]: 2021-03-23 9:02:34 17 [Note] WSREP: sst_donor_thread signaled with 0 Mar 23 09:02:34 srv1 mysqld[18623]: 2021-03-23 9:02:34 0 [Note] WSREP: async IST sender starting to serve ssl://10.0.1.3:4568 sending 1647665737-1647668375, preload starts from 1647665737 Mar 23 09:02:34 srv1 mysqld[18623]: 2021-03-23 9:02:34 0 [Note] WSREP: IST sender 1647665737 -> 1647668375 Mar 23 09:02:35 srv1 mysqld[18623]: WSREP_SST: [INFO] Logging all stderr of SST/Innobackupex to syslog (20210323 09:02:35.064) Mar 23 09:02:35 srv1 mysqld[18623]: 2021-03-23 9:02:35 0 [Note] WSREP: SST sent: bd401d28-f285-11ea-9c06-4e99d1c864f6:1647665857 Mar 23 09:02:35 srv1 mysqld[18623]: 2021-03-23 9:02:35 0 [Note] WSREP: Server status change donor -> joined Mar 23 09:02:35 srv1 mysqld[18623]: 2021-03-23 9:02:35 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Mar 23 09:02:35 srv1 mysqld[18623]: 2021-03-23 9:02:35 0 [Note] WSREP: Donor monitor thread ended with total time 1 sec Mar 23 09:02:35 srv1 mysqld[18623]: 2021-03-23 9:02:35 0 [Note] WSREP: 1.0 (srv1): State transfer to 0.0 (srv2) complete. Mar 23 09:02:35 srv1 mysqld[18623]: 2021-03-23 9:02:35 0 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 1647668380) Mar 23 09:02:36 srv1 mysqld[18623]: 2021-03-23 9:02:36 0 [Note] WSREP: (7d447799-915b, 'ssl://0.0.0.0:4567') reconnecting to fa61149d-9ae2 (ssl://10.0.1.4:4567), attempt 0 Mar 23 09:02:36 srv1 mysqld[18623]: 2021-03-23 9:02:36 0 [Note] WSREP: async IST sender served Mar 23 09:02:38 srv1 mysqld[18623]: 2021-03-23 9:02:38 0 [Note] WSREP: (7d447799-915b, 'ssl://0.0.0.0:4567') reconnecting to 6552b06c-a6b2 (ssl://10.0.1.3:4567), attempt 0 Mar 23 09:02:40 srv1 mysqld[18623]: 2021-03-23 9:02:40 0 [Note] WSREP: evs::proto(7d447799-915b, OPERATIONAL, view_id(REG,6552b06c-a6b2,160)) suspecting node: fa61149d-9ae2 Mar 23 09:02:40 srv1 mysqld[18623]: 2021-03-23 9:02:40 0 [Note] WSREP: evs::proto(7d447799-915b, OPERATIONAL, view_id(REG,6552b06c-a6b2,160)) suspected node without join message, declaring inactive Mar 23 09:02:41 srv1 mysqld[18623]: 2021-03-23 9:02:41 0 [Note] WSREP: evs::proto(7d447799-915b, GATHER, view_id(REG,6552b06c-a6b2,160)) suspecting node: 6552b06c-a6b2 Mar 23 09:02:41 srv1 mysqld[18623]: 2021-03-23 9:02:41 0 [Note] WSREP: evs::proto(7d447799-915b, GATHER, view_id(REG,6552b06c-a6b2,160)) suspected node without join message, declaring inactive Mar 23 09:02:42 srv1 mysqld[18623]: 2021-03-23 9:02:42 0 [Note] WSREP: view(view_id(NON_PRIM,6552b06c-a6b2,160) memb { Mar 23 09:02:42 srv1 mysqld[18623]: 7d447799-915b,0 Mar 23 09:02:42 srv1 mysqld[18623]: } joined { Mar 23 09:02:42 srv1 mysqld[18623]: } left { Mar 23 09:02:42 srv1 mysqld[18623]: } partitioned { Mar 23 09:02:42 srv1 mysqld[18623]: 6552b06c-a6b2,0 Mar 23 09:02:42 srv1 mysqld[18623]: fa61149d-9ae2,0 Mar 23 09:02:42 srv1 mysqld[18623]: }) Mar 23 09:02:42 srv1 mysqld[18623]: 2021-03-23 9:02:42 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 Mar 23 09:02:42 srv1 mysqld[18623]: 2021-03-23 9:02:42 0 [Note] WSREP: Flow-control interval: [16, 16] Mar 23 09:02:42 srv1 mysqld[18623]: 2021-03-23 9:02:42 0 [Note] WSREP: view(view_id(NON_PRIM,7d447799-915b,161) memb { Mar 23 09:02:42 srv1 mysqld[18623]: 7d447799-915b,0 Mar 23 09:02:42 srv1 mysqld[18623]: } joined { Mar 23 09:02:42 srv1 mysqld[18623]: } left { Mar 23 09:02:42 srv1 mysqld[18623]: } partitioned { Mar 23 09:02:42 srv1 mysqld[18623]: 6552b06c-a6b2,0 Mar 23 09:02:42 srv1 mysqld[18623]: fa61149d-9ae2,0 Mar 23 09:02:42 srv1 mysqld[18623]: }) Mar 23 09:02:42 srv1 mysqld[18623]: 2021-03-23 9:02:42 0 [Note] WSREP: Received NON-PRIMARY. Mar 23 09:02:42 srv1 mysqld[18623]: 2021-03-23 9:02:42 0 [Note] WSREP: Shifting JOINED -> OPEN (TO: 1647668380) Mar 23 09:02:42 srv1 mysqld[18623]: 2021-03-23 9:02:42 0 [Warning] WSREP: SYNC message from member 0 in non-primary configuration. Ignored. Mar 23 09:02:42 srv1 mysqld[18623]: 2021-03-23 9:02:42 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 Mar 23 09:02:42 srv1 mysqld[18623]: 2021-03-23 9:02:42 11 [Note] WSREP: ================================================ Mar 23 09:02:42 srv1 mysqld[18623]: View: Mar 23 09:02:42 srv1 mysqld[18623]: id: bd401d28-f285-11ea-9c06-4e99d1c864f6:1647668380 Mar 23 09:02:42 srv1 mysqld[18623]: status: non-primary Mar 23 09:02:42 srv1 mysqld[18623]: protocol_version: 4 Mar 23 09:02:42 srv1 mysqld[18623]: capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO Mar 23 09:02:42 srv1 mysqld[18623]: final: no Mar 23 09:02:42 srv1 mysqld[18623]: own_index: 0 Mar 23 09:02:42 srv1 mysqld[18623]: members(1): Mar 23 09:02:42 srv1 mysqld[18623]: 0: 7d447799-8b22-11eb-915b-468cb230a09e, srv1 Mar 23 09:02:42 srv1 mysqld[18623]: ================================================= Mar 23 09:02:42 srv1 mysqld[18623]: 2021-03-23 9:02:42 11 [Note] WSREP: Non-primary view Mar 23 09:02:42 srv1 mysqld[18623]: 2021-03-23 9:02:42 11 [Note] WSREP: Server status change joined -> connected Mar 23 09:02:42 srv1 mysqld[18623]: 2021-03-23 9:02:42 11 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Mar 23 09:02:42 srv1 mysqld[18623]: 2021-03-23 9:02:42 0 [Note] WSREP: Flow-control interval: [16, 16] Mar 23 09:02:42 srv1 mysqld[18623]: 2021-03-23 9:02:42 0 [Note] WSREP: Received NON-PRIMARY. Mar 23 09:02:42 srv1 mysqld[18623]: 2021-03-23 9:02:42 11 [Note] WSREP: ================================================ Mar 23 09:02:42 srv1 mysqld[18623]: View: Mar 23 09:02:42 srv1 mysqld[18623]: id: bd401d28-f285-11ea-9c06-4e99d1c864f6:1647668380 Mar 23 09:02:42 srv1 mysqld[18623]: status: non-primary Mar 23 09:02:42 srv1 mysqld[18623]: protocol_version: 4 Mar 23 09:02:42 srv1 mysqld[18623]: capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO Mar 23 09:02:42 srv1 mysqld[18623]: final: no Mar 23 09:02:42 srv1 mysqld[18623]: own_index: 0 Mar 23 09:02:42 srv1 mysqld[18623]: members(1): Mar 23 09:02:42 srv1 mysqld[18623]: 0: 7d447799-8b22-11eb-915b-468cb230a09e, srv1 Mar 23 09:02:42 srv1 mysqld[18623]: ================================================= Mar 23 09:02:42 srv1 mysqld[18623]: 2021-03-23 9:02:42 11 [Note] WSREP: Non-primary view Mar 23 09:02:42 srv1 mysqld[18623]: 2021-03-23 9:02:42 11 [Note] WSREP: Server status change connected -> connected Mar 23 09:02:42 srv1 mysqld[18623]: 2021-03-23 9:02:42 11 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Mar 23 09:02:48 srv1 mysqld[18623]: 2021-03-23 9:02:48 0 [Note] WSREP: (7d447799-915b, 'ssl://0.0.0.0:4567') connection established to 6552b06c-a6b3 ssl://10.0.1.3:4567 Mar 23 09:02:48 srv1 mysqld[18623]: 2021-03-23 9:02:48 0 [Note] WSREP: remote endpoint ssl://10.0.1.3:4567 changed identity 6552b06c-87fd-11eb-a6b2-670c0c1acbe7 -> 6552b06c-87fd-11eb-a6b3-670c0c1acbe7 Mar 23 09:02:48 srv1 mysqld[18623]: 2021-03-23 9:02:48 0 [Note] WSREP: declaring 6552b06c-a6b3 at ssl://10.0.1.3:4567 stable Mar 23 09:02:48 srv1 mysqld[18623]: 2021-03-23 9:02:48 0 [Note] WSREP: view(view_id(NON_PRIM,6552b06c-a6b3,162) memb { Mar 23 09:02:48 srv1 mysqld[18623]: 6552b06c-a6b3,0 Mar 23 09:02:48 srv1 mysqld[18623]: 7d447799-915b,0 Mar 23 09:02:48 srv1 mysqld[18623]: } joined { Mar 23 09:02:48 srv1 mysqld[18623]: } left { Mar 23 09:02:48 srv1 mysqld[18623]: } partitioned { Mar 23 09:02:48 srv1 mysqld[18623]: 6552b06c-a6b2,0 Mar 23 09:02:48 srv1 mysqld[18623]: fa61149d-9ae2,0 Mar 23 09:02:48 srv1 mysqld[18623]: }) Mar 23 09:02:48 srv1 mysqld[18623]: 2021-03-23 9:02:48 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 1, memb_num = 2 Mar 23 09:02:48 srv1 mysqld[18623]: 2021-03-23 9:02:48 0 [Note] WSREP: Flow-control interval: [23, 23] Mar 23 09:02:48 srv1 mysqld[18623]: 2021-03-23 9:02:48 0 [Note] WSREP: Received NON-PRIMARY. Mar 23 09:02:48 srv1 mysqld[18623]: 2021-03-23 9:02:48 11 [Note] WSREP: ================================================ Mar 23 09:02:48 srv1 mysqld[18623]: View: Mar 23 09:02:48 srv1 mysqld[18623]: id: bd401d28-f285-11ea-9c06-4e99d1c864f6:1647668380 Mar 23 09:02:48 srv1 mysqld[18623]: status: non-primary Mar 23 09:02:48 srv1 mysqld[18623]: protocol_version: 4 Mar 23 09:02:48 srv1 mysqld[18623]: capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO Mar 23 09:02:48 srv1 mysqld[18623]: final: no Mar 23 09:02:48 srv1 mysqld[18623]: own_index: 1 Mar 23 09:02:48 srv1 mysqld[18623]: members(2): Mar 23 09:02:48 srv1 mysqld[18623]: 0: 6552b06c-87fd-11eb-a6b3-670c0c1acbe7, unspecified Mar 23 09:02:48 srv1 mysqld[18623]: 1: 7d447799-8b22-11eb-915b-468cb230a09e, srv1 Mar 23 09:02:48 srv1 mysqld[18623]: ================================================= Mar 23 09:02:48 srv1 mysqld[18623]: 2021-03-23 9:02:48 11 [Note] WSREP: Non-primary view Mar 23 09:02:48 srv1 mysqld[18623]: 2021-03-23 9:02:48 11 [Note] WSREP: Server status change connected -> connected Mar 23 09:02:48 srv1 mysqld[18623]: 2021-03-23 9:02:48 11 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Mar 23 09:03:01 srv1 mysqld[18623]: 2021-03-23 9:03:01 0 [Note] WSREP: (7d447799-915b, 'ssl://0.0.0.0:4567') connection established to fa61149d-9ae3 ssl://10.0.1.4:4567 Mar 23 09:03:01 srv1 mysqld[18623]: 2021-03-23 9:03:01 0 [Note] WSREP: remote endpoint ssl://10.0.1.4:4567 changed identity fa61149d-87ed-11eb-9ae2-be4d05c83bf4 -> fa61149d-87ed-11eb-9ae3-be4d05c83bf4 Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 0 [Note] WSREP: declaring 6552b06c-a6b3 at ssl://10.0.1.3:4567 stable Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 0 [Note] WSREP: declaring fa61149d-9ae3 at ssl://10.0.1.4:4567 stable Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 0 [Note] WSREP: re-bootstrapping prim from partitioned components Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 0 [Note] WSREP: view(view_id(PRIM,6552b06c-a6b3,163) memb { Mar 23 09:03:02 srv1 mysqld[18623]: 6552b06c-a6b3,0 Mar 23 09:03:02 srv1 mysqld[18623]: 7d447799-915b,0 Mar 23 09:03:02 srv1 mysqld[18623]: fa61149d-9ae3,0 Mar 23 09:03:02 srv1 mysqld[18623]: } joined { Mar 23 09:03:02 srv1 mysqld[18623]: } left { Mar 23 09:03:02 srv1 mysqld[18623]: } partitioned { Mar 23 09:03:02 srv1 mysqld[18623]: 6552b06c-a6b2,0 Mar 23 09:03:02 srv1 mysqld[18623]: fa61149d-9ae2,0 Mar 23 09:03:02 srv1 mysqld[18623]: }) Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 0 [Note] WSREP: save pc into disk Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 3 Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 30a0e386-8bae-11eb-96b2-5a30bedc374f Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 0 [Note] WSREP: STATE EXCHANGE: got state msg: 30a0e386-8bae-11eb-96b2-5a30bedc374f from 0 (srv2) Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 0 [Note] WSREP: STATE EXCHANGE: got state msg: 30a0e386-8bae-11eb-96b2-5a30bedc374f from 1 (srv1) Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 0 [Note] WSREP: STATE EXCHANGE: got state msg: 30a0e386-8bae-11eb-96b2-5a30bedc374f from 2 (srv3) Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 0 [Warning] WSREP: Quorum: No node with complete state: Mar 23 09:03:02 srv1 mysqld[18623]: Version : 6 Mar 23 09:03:02 srv1 mysqld[18623]: Flags : 0x1 Mar 23 09:03:02 srv1 mysqld[18623]: Protocols : 2 / 10 / 4 Mar 23 09:03:02 srv1 mysqld[18623]: State : NON-PRIMARY Mar 23 09:03:02 srv1 mysqld[18623]: Desync count : 0 Mar 23 09:03:02 srv1 mysqld[18623]: Prim state : NON-PRIMARY Mar 23 09:03:02 srv1 mysqld[18623]: Prim UUID : 00000000-0000-0000-0000-000000000000 Mar 23 09:03:02 srv1 mysqld[18623]: Prim seqno : -1 Mar 23 09:03:02 srv1 mysqld[18623]: First seqno : 1644976252 Mar 23 09:03:02 srv1 mysqld[18623]: Last seqno : 1647668374 Mar 23 09:03:02 srv1 mysqld[18623]: Commit cut : 1647668374 Mar 23 09:03:02 srv1 mysqld[18623]: Last vote : -1.0 Mar 23 09:03:02 srv1 mysqld[18623]: Vote policy : 0 Mar 23 09:03:02 srv1 mysqld[18623]: Prim JOINED : 0 Mar 23 09:03:02 srv1 mysqld[18623]: State UUID : 30a0e386-8bae-11eb-96b2-5a30bedc374f Mar 23 09:03:02 srv1 mysqld[18623]: Group UUID : bd401d28-f285-11ea-9c06-4e99d1c864f6 Mar 23 09:03:02 srv1 mysqld[18623]: Name : 'srv2' Mar 23 09:03:02 srv1 mysqld[18623]: Incoming addr: 'AUTO' Mar 23 09:03:02 srv1 mysqld[18623]: Version : 6 Mar 23 09:03:02 srv1 mysqld[18623]: Flags : 0x2 Mar 23 09:03:02 srv1 mysqld[18623]: Protocols : 2 / 10 / 4 Mar 23 09:03:02 srv1 mysqld[18623]: State : NON-PRIMARY Mar 23 09:03:02 srv1 mysqld[18623]: Desync count : 0 Mar 23 09:03:02 srv1 mysqld[18623]: Prim state : JOINED Mar 23 09:03:02 srv1 mysqld[18623]: Prim UUID : 20039b70-8bae-11eb-936b-5abdaa1c6f49 Mar 23 09:03:02 srv1 mysqld[18623]: Prim seqno : 5 Mar 23 09:03:02 srv1 mysqld[18623]: First seqno : 1644976267 Mar 23 09:03:02 srv1 mysqld[18623]: Last seqno : 1647668380 Mar 23 09:03:02 srv1 mysqld[18623]: Commit cut : 1647665736 Mar 23 09:03:02 srv1 mysqld[18623]: Last vote : -1.0 Mar 23 09:03:02 srv1 mysqld[18623]: Vote policy : 0 Mar 23 09:03:02 srv1 mysqld[18623]: Prim JOINED : 2 Mar 23 09:03:02 srv1 mysqld[18623]: State UUID : 30a0e386-8bae-11eb-96b2-5a30bedc374f Mar 23 09:03:02 srv1 mysqld[18623]: Group UUID : bd401d28-f285-11ea-9c06-4e99d1c864f6 Mar 23 09:03:02 srv1 mysqld[18623]: Name : 'srv1' Mar 23 09:03:02 srv1 mysqld[18623]: Incoming addr: 'AUTO' Mar 23 09:03:02 srv1 mysqld[18623]: Version : 6 Mar 23 09:03:02 srv1 mysqld[18623]: Flags : 00 Mar 23 09:03:02 srv1 mysqld[18623]: Protocols : 2 / 10 / 4 Mar 23 09:03:02 srv1 mysqld[18623]: State : NON-PRIMARY Mar 23 09:03:02 srv1 mysqld[18623]: Desync count : 0 Mar 23 09:03:02 srv1 mysqld[18623]: Prim state : NON-PRIMARY Mar 23 09:03:02 srv1 mysqld[18623]: Prim UUID : 00000000-0000-0000-0000-000000000000 Mar 23 09:03:02 srv1 mysqld[18623]: Prim seqno : -1 Mar 23 09:03:02 srv1 mysqld[18623]: First seqno : 1644976253 Mar 23 09:03:02 srv1 mysqld[18623]: Last seqno : 1647668374 Mar 23 09:03:02 srv1 mysqld[18623]: Commit cut : 1647668374 Mar 23 09:03:02 srv1 mysqld[18623]: Last vote : -1.0 Mar 23 09:03:02 srv1 mysqld[18623]: Vote policy : 0 Mar 23 09:03:02 srv1 mysqld[18623]: Prim JOINED : 0 Mar 23 09:03:02 srv1 mysqld[18623]: State UUID : 30a0e386-8bae-11eb-96b2-5a30bedc374f Mar 23 09:03:02 srv1 mysqld[18623]: Group UUID : bd401d28-f285-11ea-9c06-4e99d1c864f6 Mar 23 09:03:02 srv1 mysqld[18623]: Name : 'srv3' Mar 23 09:03:02 srv1 mysqld[18623]: Incoming addr: 'AUTO' Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 0 [Note] WSREP: Partial re-merge of primary 20039b70-8bae-11eb-936b-5abdaa1c6f49 found: 1 of 2. Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 0 [Note] WSREP: Quorum results: Mar 23 09:03:02 srv1 mysqld[18623]: version = 6, Mar 23 09:03:02 srv1 mysqld[18623]: component = PRIMARY, Mar 23 09:03:02 srv1 mysqld[18623]: conf_id = 5, Mar 23 09:03:02 srv1 mysqld[18623]: members = 1/3 (joined/total), Mar 23 09:03:02 srv1 mysqld[18623]: act_id = 1647668380, Mar 23 09:03:02 srv1 mysqld[18623]: last_appl. = 1647665736, Mar 23 09:03:02 srv1 mysqld[18623]: protocols = 2/10/4 (gcs/repl/appl), Mar 23 09:03:02 srv1 mysqld[18623]: vote policy= 0, Mar 23 09:03:02 srv1 mysqld[18623]: group UUID = bd401d28-f285-11ea-9c06-4e99d1c864f6 Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 0 [Note] WSREP: Flow-control interval: [28, 28] Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 0 [Note] WSREP: Restored state OPEN -> JOINED (1647668381) Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 11 [Note] WSREP: ####### processing CC 1647668381, local, ordered Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 11 [Note] WSREP: ####### My UUID: 7d447799-8b22-11eb-915b-468cb230a09e Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 11 [Note] WSREP: Skipping cert index reset Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 11 [Note] WSREP: REPL Protocols: 10 (5) Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 11 [Note] WSREP: ####### Adjusting cert position: 1647668380 -> 1647668381 Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 0 [Note] WSREP: Service thread queue flushed. Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 0 [Note] WSREP: Member 1.0 (srv1) synced with group. Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 1647668381) Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 11 [Note] WSREP: ================================================ Mar 23 09:03:02 srv1 mysqld[18623]: View: Mar 23 09:03:02 srv1 mysqld[18623]: id: bd401d28-f285-11ea-9c06-4e99d1c864f6:1647668381 Mar 23 09:03:02 srv1 mysqld[18623]: status: primary Mar 23 09:03:02 srv1 mysqld[18623]: protocol_version: 4 Mar 23 09:03:02 srv1 mysqld[18623]: capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO Mar 23 09:03:02 srv1 mysqld[18623]: final: no Mar 23 09:03:02 srv1 mysqld[18623]: own_index: 1 Mar 23 09:03:02 srv1 mysqld[18623]: members(3): Mar 23 09:03:02 srv1 mysqld[18623]: 0: 6552b06c-87fd-11eb-a6b3-670c0c1acbe7, srv2 Mar 23 09:03:02 srv1 mysqld[18623]: 1: 7d447799-8b22-11eb-915b-468cb230a09e, srv1 Mar 23 09:03:02 srv1 mysqld[18623]: 2: fa61149d-87ed-11eb-9ae3-be4d05c83bf4, srv3 Mar 23 09:03:02 srv1 mysqld[18623]: ================================================= Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 11 [Note] WSREP: Server status change connected -> joiner Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 11 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 11 [Note] WSREP: Server status change joiner -> initializing Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 11 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 11 [Note] WSREP: Server status change initializing -> initialized Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 11 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 11 [Note] WSREP: Server status change initialized -> joined Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 11 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 11 [Note] WSREP: Lowest cert index boundary for CC from group: 1647665737 Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 11 [Note] WSREP: Min available from gcache for CC from group: 1644976267 Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 11 [Note] WSREP: Server srv1 synced with group Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 11 [Note] WSREP: Server status change joined -> synced Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 11 [Note] WSREP: Synchronized with group, ready for connections Mar 23 09:03:02 srv1 mysqld[18623]: 2021-03-23 9:03:02 11 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Mar 23 09:03:03 srv1 mysqld[18623]: 2021-03-23 9:03:03 0 [Note] WSREP: Member 0.0 (srv2) requested state transfer from '*any*'. Selected 1.0 (srv1)(SYNCED) as donor. Mar 23 09:03:03 srv1 mysqld[18623]: 2021-03-23 9:03:03 0 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 1647668381) Mar 23 09:03:03 srv1 mysqld[18623]: 2021-03-23 9:03:03 11 [Note] WSREP: Detected STR version: 1, req_len: 145, req: STRv1 Mar 23 09:03:03 srv1 mysqld[18623]: 2021-03-23 9:03:03 11 [Note] WSREP: IST request: bd401d28-f285-11ea-9c06-4e99d1c864f6:1647668374-1647668381|ssl://10.0.1.3:4568 Mar 23 09:03:03 srv1 mysqld[18623]: 2021-03-23 9:03:03 11 [Note] WSREP: Server status change synced -> donor Mar 23 09:03:03 srv1 mysqld[18623]: 2021-03-23 9:03:03 11 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Mar 23 09:03:03 srv1 mysqld[18623]: 2021-03-23 9:03:03 0 [Note] WSREP: Donor monitor thread started to monitor Mar 23 09:03:03 srv1 mysqld[18623]: 2021-03-23 9:03:03 0 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'donor' --address '10.0.1.3:4444/xtrabackup_sst//1' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --gtid 'bd401d28-f285-11ea-9c06-4e99d1c864f6:1647668374' --gtid-domain-id '0' --binlog '/var/log/mysql/mariadb-bin' --binlog-index '/var/log/mysql/mariadb-bin.index' --bypass --mysqld-args --wsrep_start_position=bd401d28-f285-11ea-9c06-4e99d1c864f6:1644287162' Mar 23 09:03:03 srv1 mysqld[18623]: 2021-03-23 9:03:03 11 [Note] WSREP: sst_donor_thread signaled with 0 Mar 23 09:03:03 srv1 mysqld[18623]: 2021-03-23 9:03:03 0 [Note] WSREP: async IST sender starting to serve ssl://10.0.1.3:4568 sending 1647665737-1647668381, preload starts from 1647665737 Mar 23 09:03:03 srv1 mysqld[18623]: 2021-03-23 9:03:03 0 [Note] WSREP: IST sender 1647665737 -> 1647668381 Mar 23 09:03:03 srv1 mysqld[18623]: 2021-03-23 9:03:03 0 [Warning] WSREP: Member 2.0 (srv3) requested state transfer from '*any*', but it is impossible to select State Transfer donor: Resource temporarily unavailable Mar 23 09:03:03 srv1 mysqld[18623]: WSREP_SST: [INFO] Logging all stderr of SST/Innobackupex to syslog (20210323 09:03:03.138) Mar 23 09:03:03 srv1 mysqld[18623]: 2021-03-23 9:03:03 0 [Note] WSREP: SST sent: bd401d28-f285-11ea-9c06-4e99d1c864f6:1647668374 Mar 23 09:03:03 srv1 mysqld[18623]: 2021-03-23 9:03:03 0 [Note] WSREP: Server status change donor -> joined Mar 23 09:03:03 srv1 mysqld[18623]: 2021-03-23 9:03:03 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Mar 23 09:03:03 srv1 mysqld[18623]: 2021-03-23 9:03:03 0 [Note] WSREP: 1.0 (srv1): State transfer to 0.0 (srv2) complete. Mar 23 09:03:03 srv1 mysqld[18623]: 2021-03-23 9:03:03 0 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 1647668381) Mar 23 09:03:03 srv1 mysqld[18623]: 2021-03-23 9:03:03 0 [Note] WSREP: Member 1.0 (srv1) synced with group. Mar 23 09:03:03 srv1 mysqld[18623]: 2021-03-23 9:03:03 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 1647668381) Mar 23 09:03:03 srv1 mysqld[18623]: 2021-03-23 9:03:03 18 [Note] WSREP: Server srv1 synced with group Mar 23 09:03:03 srv1 mysqld[18623]: 2021-03-23 9:03:03 18 [Note] WSREP: Server status change joined -> synced Mar 23 09:03:03 srv1 mysqld[18623]: 2021-03-23 9:03:03 18 [Note] WSREP: Synchronized with group, ready for connections Mar 23 09:03:03 srv1 mysqld[18623]: 2021-03-23 9:03:03 18 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Mar 23 09:03:03 srv1 mysqld[18623]: 2021-03-23 9:03:03 0 [Note] WSREP: Donor monitor thread ended with total time 0 sec Mar 23 09:03:04 srv1 mysqld[18623]: 2021-03-23 9:03:04 0 [Note] WSREP: Member 2.0 (srv3) requested state transfer from '*any*'. Selected 1.0 (srv1)(SYNCED) as donor. Mar 23 09:03:04 srv1 mysqld[18623]: 2021-03-23 9:03:04 0 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 1647668381) Mar 23 09:03:04 srv1 mysqld[18623]: 2021-03-23 9:03:04 20 [Note] WSREP: Detected STR version: 1, req_len: 149, req: STRv1 Mar 23 09:03:04 srv1 mysqld[18623]: 2021-03-23 9:03:04 20 [Note] WSREP: IST request: bd401d28-f285-11ea-9c06-4e99d1c864f6:1647668374-1647668381|ssl://10.0.1.4:4568 Mar 23 09:03:04 srv1 mysqld[18623]: 2021-03-23 9:03:04 20 [Note] WSREP: Server status change synced -> donor Mar 23 09:03:04 srv1 mysqld[18623]: 2021-03-23 9:03:04 20 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Mar 23 09:03:04 srv1 mysqld[18623]: 2021-03-23 9:03:04 0 [Note] WSREP: Donor monitor thread started to monitor Mar 23 09:03:04 srv1 mysqld[18623]: 2021-03-23 9:03:04 0 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'donor' --address '10.0.1.4:4444/xtrabackup_sst//1' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --gtid 'bd401d28-f285-11ea-9c06-4e99d1c864f6:1647668374' --gtid-domain-id '0' --binlog '/var/log/mysql/mariadb-bin' --binlog-index '/var/log/mysql/mariadb-bin.index' --bypass --mysqld-args --wsrep_start_position=bd401d28-f285-11ea-9c06-4e99d1c864f6:1644287162' Mar 23 09:03:04 srv1 mysqld[18623]: 2021-03-23 9:03:04 20 [Note] WSREP: sst_donor_thread signaled with 0 Mar 23 09:03:04 srv1 mysqld[18623]: 2021-03-23 9:03:04 0 [Note] WSREP: async IST sender starting to serve ssl://10.0.1.4:4568 sending 1647665737-1647668381, preload starts from 1647665737 Mar 23 09:03:04 srv1 mysqld[18623]: 2021-03-23 9:03:04 0 [Note] WSREP: IST sender 1647665737 -> 1647668381 Mar 23 09:03:04 srv1 mysqld[18623]: WSREP_SST: [INFO] Logging all stderr of SST/Innobackupex to syslog (20210323 09:03:04.261) Mar 23 09:03:04 srv1 mysqld[18623]: 2021-03-23 9:03:04 0 [Note] WSREP: SST sent: bd401d28-f285-11ea-9c06-4e99d1c864f6:1647668374 Mar 23 09:03:04 srv1 mysqld[18623]: 2021-03-23 9:03:04 0 [Note] WSREP: Server status change donor -> joined Mar 23 09:03:04 srv1 mysqld[18623]: 2021-03-23 9:03:04 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Mar 23 09:03:04 srv1 mysqld[18623]: 2021-03-23 9:03:04 0 [Note] WSREP: 1.0 (srv1): State transfer to 2.0 (srv3) complete. Mar 23 09:03:04 srv1 mysqld[18623]: 2021-03-23 9:03:04 0 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 1647668381) Mar 23 09:03:04 srv1 mysqld[18623]: 2021-03-23 9:03:04 0 [Note] WSREP: Member 1.0 (srv1) synced with group. Mar 23 09:03:04 srv1 mysqld[18623]: 2021-03-23 9:03:04 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 1647668381) Mar 23 09:03:04 srv1 mysqld[18623]: 2021-03-23 9:03:04 21 [Note] WSREP: Server srv1 synced with group Mar 23 09:03:04 srv1 mysqld[18623]: 2021-03-23 9:03:04 21 [Note] WSREP: Server status change joined -> synced Mar 23 09:03:04 srv1 mysqld[18623]: 2021-03-23 9:03:04 21 [Note] WSREP: Synchronized with group, ready for connections Mar 23 09:03:04 srv1 mysqld[18623]: 2021-03-23 9:03:04 21 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Mar 23 09:03:04 srv1 mysqld[18623]: 2021-03-23 9:03:04 0 [Note] WSREP: Donor monitor thread ended with total time 0 sec Mar 23 09:03:04 srv1 mysqld[18623]: 2021-03-23 9:03:04 0 [Note] WSREP: async IST sender served Mar 23 09:03:04 srv1 mysqld[18623]: 2021-03-23 9:03:04 0 [Note] WSREP: 0.0 (srv2): State transfer from 1.0 (srv1) complete. Mar 23 09:03:04 srv1 mysqld[18623]: 2021-03-23 9:03:04 0 [Note] WSREP: Member 0.0 (srv2) synced with group. Mar 23 09:03:04 srv1 mysqld[18623]: 2021-03-23 9:03:04 0 [Note] WSREP: (7d447799-915b, 'ssl://0.0.0.0:4567') turning message relay requesting off Mar 23 09:03:05 srv1 mysqld[18623]: 2021-03-23 9:03:05 0 [Note] WSREP: async IST sender served Mar 23 09:03:05 srv1 mysqld[18623]: 2021-03-23 9:03:05 0 [Note] WSREP: 2.0 (srv3): State transfer from 1.0 (srv1) complete. Mar 23 09:03:05 srv1 mysqld[18623]: 2021-03-23 9:03:05 0 [Note] WSREP: Member 2.0 (srv3) synced with group.