Mar 18 11:29:40 srv1 mysqld[1383]: 2021-03-18 11:29:40 0 [Note] WSREP: SSL handshake successful, remote endpoint ssl://10.0.1.4:54388 local endpoint ssl://10.0.1.2:4567 cipher: TLS_AES_256_GCM_SHA384 compression: none Mar 18 11:29:40 srv1 mysqld[1383]: 2021-03-18 11:29:40 0 [Note] WSREP: (dafec258-8a91, 'ssl://0.0.0.0:4567') connection established to d88cac52-b227 ssl://10.0.1.4:4567 Mar 18 11:29:40 srv1 mysqld[1383]: 2021-03-18 11:29:40 0 [Note] WSREP: (dafec258-8a91, 'ssl://0.0.0.0:4567') turning message relay requesting on, nonlive peers: Mar 18 11:29:41 srv1 mysqld[1383]: 2021-03-18 11:29:41 0 [Note] WSREP: declaring 392d3dc7-bc88 at ssl://10.0.1.3:4567 stable Mar 18 11:29:41 srv1 mysqld[1383]: 2021-03-18 11:29:41 0 [Note] WSREP: declaring a22c801a-83c8 at ssl://10.0.2.1:4567 stable Mar 18 11:29:41 srv1 mysqld[1383]: 2021-03-18 11:29:41 0 [Note] WSREP: declaring abcb93ce-b122 at ssl://10.0.2.2:4567 stable Mar 18 11:29:41 srv1 mysqld[1383]: 2021-03-18 11:29:41 0 [Note] WSREP: declaring d88cac52-b227 at ssl://10.0.1.4:4567 stable Mar 18 11:29:41 srv1 mysqld[1383]: 2021-03-18 11:29:41 0 [Note] WSREP: Node 392d3dc7-bc88 state prim Mar 18 11:29:41 srv1 mysqld[1383]: 2021-03-18 11:29:41 0 [Note] WSREP: view(view_id(PRIM,392d3dc7-bc88,100) memb { Mar 18 11:29:41 srv1 mysqld[1383]: 392d3dc7-bc88,0 Mar 18 11:29:41 srv1 mysqld[1383]: a22c801a-83c8,0 Mar 18 11:29:41 srv1 mysqld[1383]: abcb93ce-b122,0 Mar 18 11:29:41 srv1 mysqld[1383]: d88cac52-b227,0 Mar 18 11:29:41 srv1 mysqld[1383]: dafec258-8a91,0 Mar 18 11:29:41 srv1 mysqld[1383]: } joined { Mar 18 11:29:41 srv1 mysqld[1383]: } left { Mar 18 11:29:41 srv1 mysqld[1383]: } partitioned { Mar 18 11:29:41 srv1 mysqld[1383]: }) Mar 18 11:29:41 srv1 mysqld[1383]: 2021-03-18 11:29:41 0 [Note] WSREP: save pc into disk Mar 18 11:29:41 srv1 mysqld[1383]: 2021-03-18 11:29:41 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 4, memb_num = 5 Mar 18 11:29:41 srv1 mysqld[1383]: 2021-03-18 11:29:41 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. Mar 18 11:29:41 srv1 mysqld[1383]: 2021-03-18 11:29:41 0 [Note] WSREP: STATE EXCHANGE: sent state msg: d9299f34-87d4-11eb-bc75-a390948aa8b4 Mar 18 11:29:41 srv1 mysqld[1383]: 2021-03-18 11:29:41 0 [Note] WSREP: STATE EXCHANGE: got state msg: d9299f34-87d4-11eb-bc75-a390948aa8b4 from 0 (srv2) Mar 18 11:29:41 srv1 mysqld[1383]: 2021-03-18 11:29:41 0 [Note] WSREP: STATE EXCHANGE: got state msg: d9299f34-87d4-11eb-bc75-a390948aa8b4 from 1 (garb) Mar 18 11:29:41 srv1 mysqld[1383]: 2021-03-18 11:29:41 0 [Note] WSREP: STATE EXCHANGE: got state msg: d9299f34-87d4-11eb-bc75-a390948aa8b4 from 2 (garb) Mar 18 11:29:41 srv1 mysqld[1383]: 2021-03-18 11:29:41 0 [Note] WSREP: STATE EXCHANGE: got state msg: d9299f34-87d4-11eb-bc75-a390948aa8b4 from 4 (srv1) Mar 18 11:29:41 srv1 mysqld[1383]: 2021-03-18 11:29:41 0 [Note] WSREP: STATE EXCHANGE: got state msg: d9299f34-87d4-11eb-bc75-a390948aa8b4 from 3 (srv3) Mar 18 11:29:41 srv1 mysqld[1383]: 2021-03-18 11:29:41 0 [Note] WSREP: Quorum results: Mar 18 11:29:41 srv1 mysqld[1383]: version = 6, Mar 18 11:29:41 srv1 mysqld[1383]: component = PRIMARY, Mar 18 11:29:41 srv1 mysqld[1383]: conf_id = 95, Mar 18 11:29:41 srv1 mysqld[1383]: members = 4/5 (joined/total), Mar 18 11:29:41 srv1 mysqld[1383]: act_id = 1613609852, Mar 18 11:29:41 srv1 mysqld[1383]: last_appl. = 1613609792, Mar 18 11:29:41 srv1 mysqld[1383]: protocols = 2/10/4 (gcs/repl/appl), Mar 18 11:29:41 srv1 mysqld[1383]: vote policy= 0, Mar 18 11:29:41 srv1 mysqld[1383]: group UUID = bd401d28-f285-11ea-9c06-4e99d1c864f6 Mar 18 11:29:41 srv1 mysqld[1383]: 2021-03-18 11:29:41 0 [Note] WSREP: Flow-control interval: [36, 36] Mar 18 11:29:41 srv1 mysqld[1383]: 2021-03-18 11:29:41 15 [Note] WSREP: ####### processing CC 1613609853, local, ordered Mar 18 11:29:41 srv1 mysqld[1383]: 2021-03-18 11:29:41 15 [Note] WSREP: ####### My UUID: dafec258-8662-11eb-8a91-af36e33159ed Mar 18 11:29:41 srv1 mysqld[1383]: 2021-03-18 11:29:41 15 [Note] WSREP: Skipping cert index reset Mar 18 11:29:41 srv1 mysqld[1383]: 2021-03-18 11:29:41 15 [Note] WSREP: REPL Protocols: 10 (5) Mar 18 11:29:41 srv1 mysqld[1383]: 2021-03-18 11:29:41 15 [Note] WSREP: ####### Adjusting cert position: 1613609852 -> 1613609853 Mar 18 11:29:41 srv1 mysqld[1383]: 2021-03-18 11:29:41 0 [Note] WSREP: Service thread queue flushed. Mar 18 11:29:41 srv1 mysqld[1383]: 2021-03-18 11:29:41 15 [Note] WSREP: ================================================ Mar 18 11:29:41 srv1 mysqld[1383]: View: Mar 18 11:29:41 srv1 mysqld[1383]: id: bd401d28-f285-11ea-9c06-4e99d1c864f6:1613609853 Mar 18 11:29:41 srv1 mysqld[1383]: status: primary Mar 18 11:29:41 srv1 mysqld[1383]: protocol_version: 4 Mar 18 11:29:41 srv1 mysqld[1383]: capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO Mar 18 11:29:41 srv1 mysqld[1383]: final: no Mar 18 11:29:41 srv1 mysqld[1383]: own_index: 4 Mar 18 11:29:41 srv1 mysqld[1383]: members(5): Mar 18 11:29:41 srv1 mysqld[1383]: 0: 392d3dc7-865f-11eb-bc88-862108ff01ef, srv2 Mar 18 11:29:41 srv1 mysqld[1383]: 1: a22c801a-84ad-11eb-83c8-675ebd437f88, garb Mar 18 11:29:41 srv1 mysqld[1383]: 2: abcb93ce-84ad-11eb-b122-2275e9a2eb12, garb Mar 18 11:29:41 srv1 mysqld[1383]: 3: d88cac52-87d4-11eb-b227-b222be318098, srv3 Mar 18 11:29:41 srv1 mysqld[1383]: 4: dafec258-8662-11eb-8a91-af36e33159ed, srv1 Mar 18 11:29:41 srv1 mysqld[1383]: ================================================= Mar 18 11:29:41 srv1 mysqld[1383]: 2021-03-18 11:29:41 15 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Mar 18 11:29:41 srv1 mysqld[1383]: 2021-03-18 11:29:41 15 [Note] WSREP: Lowest cert index boundary for CC from group: 1613609793 Mar 18 11:29:41 srv1 mysqld[1383]: 2021-03-18 11:29:41 15 [Note] WSREP: Min available from gcache for CC from group: 1612144660 Mar 18 11:29:42 srv1 mysqld[1383]: 2021-03-18 11:29:42 0 [Note] WSREP: Member 3.0 (srv3) requested state transfer from '*any*'. Selected 4.0 (srv1)(SYNCED) as donor. Mar 18 11:29:42 srv1 mysqld[1383]: 2021-03-18 11:29:42 0 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 1613609997) Mar 18 11:29:42 srv1 mysqld[1383]: 2021-03-18 11:29:42 15 [Note] WSREP: Detected STR version: 1, req_len: 149, req: STRv1 Mar 18 11:29:42 srv1 mysqld[1383]: 2021-03-18 11:29:42 15 [Note] WSREP: IST request: bd401d28-f285-11ea-9c06-4e99d1c864f6:1613577582-1613609853|ssl://xxx.xxx.xxx.xxx:4568 Mar 18 11:29:42 srv1 mysqld[1383]: 2021-03-18 11:29:42 15 [Note] WSREP: Server status change synced -> donor Mar 18 11:29:42 srv1 mysqld[1383]: 2021-03-18 11:29:42 15 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Mar 18 11:29:42 srv1 mysqld[1383]: 2021-03-18 11:29:42 0 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'donor' --address 'xxx.xxx.xxx.xxx:4444/xtrabackup_sst//1' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --gtid 'bd401d28-f285-11ea-9c06-4e99d1c864f6:1613577582' --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:1598700981' Mar 18 11:29:42 srv1 mysqld[1383]: 2021-03-18 11:29:42 0 [Note] WSREP: Donor monitor thread started to monitor Mar 18 11:29:42 srv1 mysqld[1383]: 2021-03-18 11:29:42 15 [Note] WSREP: sst_donor_thread signaled with 0 Mar 18 11:29:42 srv1 mysqld[1383]: 2021-03-18 11:29:42 15 [Note] WSREP: IST sender using ssl Mar 18 11:29:42 srv1 mysqld[1383]: 2021-03-18 11:29:42 0 [Note] WSREP: async IST sender starting to serve ssl://xxx.xxx.xxx.xxx:4568 sending 1613577583-1613609853, preload starts from 1613609793 Mar 18 11:29:42 srv1 mysqld[1383]: 2021-03-18 11:29:42 0 [Note] WSREP: IST sender 1613577583 -> 1613609853 Mar 18 11:29:42 srv1 mysqld[1383]: WSREP_SST: [INFO] Logging all stderr of SST/Innobackupex to syslog (20210318 11:29:42.464) Mar 18 11:29:42 srv1 mysqld[1383]: 2021-03-18 11:29:42 0 [Note] WSREP: SST sent: bd401d28-f285-11ea-9c06-4e99d1c864f6:1613577582 Mar 18 11:29:42 srv1 mysqld[1383]: 2021-03-18 11:29:42 0 [Note] WSREP: Server status change donor -> joined Mar 18 11:29:42 srv1 mysqld[1383]: 2021-03-18 11:29:42 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Mar 18 11:29:42 srv1 mysqld[1383]: 2021-03-18 11:29:42 0 [Note] WSREP: 4.0 (srv1): State transfer to 3.0 (srv3) complete. Mar 18 11:29:42 srv1 mysqld[1383]: 2021-03-18 11:29:42 0 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 1613610020) Mar 18 11:29:42 srv1 mysqld[1383]: 2021-03-18 11:29:42 0 [Note] WSREP: Member 4.0 (srv1) synced with group. Mar 18 11:29:42 srv1 mysqld[1383]: 2021-03-18 11:29:42 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 1613610020) Mar 18 11:29:42 srv1 mysqld[1383]: 2021-03-18 11:29:42 23 [Note] WSREP: Server srv1 synced with group Mar 18 11:29:42 srv1 mysqld[1383]: 2021-03-18 11:29:42 23 [Note] WSREP: Server status change joined -> synced Mar 18 11:29:42 srv1 mysqld[1383]: 2021-03-18 11:29:42 23 [Note] WSREP: Synchronized with group, ready for connections Mar 18 11:29:42 srv1 mysqld[1383]: 2021-03-18 11:29:42 23 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Mar 18 11:29:42 srv1 mysqld[1383]: 2021-03-18 11:29:42 0 [Note] WSREP: Donor monitor thread ended with total time 0 sec Mar 18 11:29:43 srv1 mysqld[1383]: 2021-03-18 11:29:43 0 [Note] WSREP: (dafec258-8a91, 'ssl://0.0.0.0:4567') turning message relay requesting off Mar 18 11:29:45 srv1 mysqld[1383]: 2021-03-18 11:29:45 0 [Note] WSREP: async IST sender served Mar 18 11:29:45 srv1 mysqld[1383]: 2021-03-18 11:29:45 0 [Note] WSREP: (dafec258-8a91, 'ssl://0.0.0.0:4567') turning message relay requesting on, nonlive peers: ssl://10.0.1.4:4567 Mar 18 11:29:46 srv1 mysqld[1383]: 2021-03-18 11:29:46 0 [Note] WSREP: (dafec258-8a91, 'ssl://0.0.0.0:4567') reconnecting to d88cac52-b227 (ssl://10.0.1.4:4567), attempt 0 Mar 18 11:29:50 srv1 mysqld[1383]: 2021-03-18 11:29:50 0 [Note] WSREP: evs::proto(dafec258-8a91, GATHER, view_id(REG,392d3dc7-bc88,100)) suspecting node: d88cac52-b227 Mar 18 11:29:50 srv1 mysqld[1383]: 2021-03-18 11:29:50 0 [Note] WSREP: evs::proto(dafec258-8a91, GATHER, view_id(REG,392d3dc7-bc88,100)) suspected node without join message, declaring inactive Mar 18 11:29:51 srv1 mysqld[1383]: 2021-03-18 11:29:51 0 [Note] WSREP: declaring 392d3dc7-bc88 at ssl://10.0.1.3:4567 stable Mar 18 11:29:51 srv1 mysqld[1383]: 2021-03-18 11:29:51 0 [Note] WSREP: declaring a22c801a-83c8 at ssl://10.0.2.1:4567 stable Mar 18 11:29:51 srv1 mysqld[1383]: 2021-03-18 11:29:51 0 [Note] WSREP: declaring abcb93ce-b122 at ssl://10.0.2.2:4567 stable Mar 18 11:29:51 srv1 mysqld[1383]: 2021-03-18 11:29:51 0 [Note] WSREP: Node 392d3dc7-bc88 state prim Mar 18 11:29:51 srv1 mysqld[1383]: 2021-03-18 11:29:51 0 [Note] WSREP: view(view_id(PRIM,392d3dc7-bc88,101) memb { Mar 18 11:29:51 srv1 mysqld[1383]: 392d3dc7-bc88,0 Mar 18 11:29:51 srv1 mysqld[1383]: a22c801a-83c8,0 Mar 18 11:29:51 srv1 mysqld[1383]: abcb93ce-b122,0 Mar 18 11:29:51 srv1 mysqld[1383]: dafec258-8a91,0 Mar 18 11:29:51 srv1 mysqld[1383]: } joined { Mar 18 11:29:51 srv1 mysqld[1383]: } left { Mar 18 11:29:51 srv1 mysqld[1383]: } partitioned { Mar 18 11:29:51 srv1 mysqld[1383]: d88cac52-b227,0 Mar 18 11:29:51 srv1 mysqld[1383]: }) Mar 18 11:29:51 srv1 mysqld[1383]: 2021-03-18 11:29:51 0 [Note] WSREP: save pc into disk Mar 18 11:29:51 srv1 mysqld[1383]: 2021-03-18 11:29:51 0 [Note] WSREP: forgetting d88cac52-b227 (ssl://10.0.1.4:4567) Mar 18 11:29:51 srv1 mysqld[1383]: 2021-03-18 11:29:51 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 3, memb_num = 4 Mar 18 11:29:51 srv1 mysqld[1383]: 2021-03-18 11:29:51 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. Mar 18 11:29:51 srv1 mysqld[1383]: 2021-03-18 11:29:51 0 [Note] WSREP: (dafec258-8a91, 'ssl://0.0.0.0:4567') turning message relay requesting off Mar 18 11:29:51 srv1 mysqld[1383]: 2021-03-18 11:29:51 0 [Note] WSREP: STATE EXCHANGE: sent state msg: df20ae89-87d4-11eb-8842-0ab78035796d Mar 18 11:29:51 srv1 mysqld[1383]: 2021-03-18 11:29:51 0 [Note] WSREP: STATE EXCHANGE: got state msg: df20ae89-87d4-11eb-8842-0ab78035796d from 0 (srv2) Mar 18 11:29:51 srv1 mysqld[1383]: 2021-03-18 11:29:51 0 [Note] WSREP: STATE EXCHANGE: got state msg: df20ae89-87d4-11eb-8842-0ab78035796d from 1 (garb) Mar 18 11:29:51 srv1 mysqld[1383]: 2021-03-18 11:29:51 0 [Note] WSREP: STATE EXCHANGE: got state msg: df20ae89-87d4-11eb-8842-0ab78035796d from 2 (garb) Mar 18 11:29:51 srv1 mysqld[1383]: 2021-03-18 11:29:51 0 [Note] WSREP: STATE EXCHANGE: got state msg: df20ae89-87d4-11eb-8842-0ab78035796d from 3 (srv1) Mar 18 11:29:51 srv1 mysqld[1383]: 2021-03-18 11:29:51 0 [Note] WSREP: Quorum results: Mar 18 11:29:51 srv1 mysqld[1383]: version = 6, Mar 18 11:29:51 srv1 mysqld[1383]: component = PRIMARY, Mar 18 11:29:51 srv1 mysqld[1383]: conf_id = 96, Mar 18 11:29:51 srv1 mysqld[1383]: members = 4/4 (joined/total), Mar 18 11:29:51 srv1 mysqld[1383]: act_id = 1613610101, Mar 18 11:29:51 srv1 mysqld[1383]: last_appl. = 1613610067, Mar 18 11:29:51 srv1 mysqld[1383]: protocols = 2/10/4 (gcs/repl/appl), Mar 18 11:29:51 srv1 mysqld[1383]: vote policy= 0, Mar 18 11:29:51 srv1 mysqld[1383]: group UUID = bd401d28-f285-11ea-9c06-4e99d1c864f6 Mar 18 11:29:51 srv1 mysqld[1383]: 2021-03-18 11:29:51 0 [Note] WSREP: Flow-control interval: [32, 32] Mar 18 11:29:51 srv1 mysqld[1383]: 2021-03-18 11:29:51 12 [Note] WSREP: ####### processing CC 1613610102, local, ordered Mar 18 11:29:51 srv1 mysqld[1383]: 2021-03-18 11:29:51 12 [Note] WSREP: ####### My UUID: dafec258-8662-11eb-8a91-af36e33159ed Mar 18 11:29:51 srv1 mysqld[1383]: 2021-03-18 11:29:51 12 [Note] WSREP: Skipping cert index reset Mar 18 11:29:51 srv1 mysqld[1383]: 2021-03-18 11:29:51 12 [Note] WSREP: REPL Protocols: 10 (5) Mar 18 11:29:51 srv1 mysqld[1383]: 2021-03-18 11:29:51 12 [Note] WSREP: ####### Adjusting cert position: 1613610101 -> 1613610102 Mar 18 11:29:51 srv1 mysqld[1383]: 2021-03-18 11:29:51 0 [Note] WSREP: Service thread queue flushed. Mar 18 11:29:51 srv1 mysqld[1383]: 2021-03-18 11:29:51 12 [Note] WSREP: ================================================ Mar 18 11:29:51 srv1 mysqld[1383]: View: Mar 18 11:29:51 srv1 mysqld[1383]: id: bd401d28-f285-11ea-9c06-4e99d1c864f6:1613610102 Mar 18 11:29:51 srv1 mysqld[1383]: status: primary Mar 18 11:29:51 srv1 mysqld[1383]: protocol_version: 4 Mar 18 11:29:51 srv1 mysqld[1383]: capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO Mar 18 11:29:51 srv1 mysqld[1383]: final: no Mar 18 11:29:51 srv1 mysqld[1383]: own_index: 3 Mar 18 11:29:51 srv1 mysqld[1383]: members(4): Mar 18 11:29:51 srv1 mysqld[1383]: 0: 392d3dc7-865f-11eb-bc88-862108ff01ef, srv2 Mar 18 11:29:51 srv1 mysqld[1383]: 1: a22c801a-84ad-11eb-83c8-675ebd437f88, garb Mar 18 11:29:51 srv1 mysqld[1383]: 2: abcb93ce-84ad-11eb-b122-2275e9a2eb12, garb Mar 18 11:29:51 srv1 mysqld[1383]: 3: dafec258-8662-11eb-8a91-af36e33159ed, srv1 Mar 18 11:29:51 srv1 mysqld[1383]: ================================================= Mar 18 11:29:51 srv1 mysqld[1383]: 2021-03-18 11:29:51 12 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Mar 18 11:29:51 srv1 mysqld[1383]: 2021-03-18 11:29:51 12 [Note] WSREP: Lowest cert index boundary for CC from group: 1613610068 Mar 18 11:29:51 srv1 mysqld[1383]: 2021-03-18 11:29:51 12 [Note] WSREP: Min available from gcache for CC from group: 1612144989 Mar 18 11:29:53 srv1 mysqld[1383]: 2021-03-18 11:29:53 0 [Note] WSREP: cleaning up d88cac52-b227 (ssl://10.0.1.4:4567)