2022-06-16 15:56:51 0 [Note] WSREP: declaring a0b81398-acd8 at ssl://172.18.14.29:18301 stable 2022-06-16 15:56:51 0 [Note] WSREP: forgetting 21c56270-824e (ssl://172.21.53.29:18301) 2022-06-16 15:56:51 0 [Note] WSREP: Node 60932a90-982f state prim 2022-06-16 15:56:51 0 [Note] WSREP: view(view_id(PRIM,60932a90-982f,1030) memb { 60932a90-982f,0 a0b81398-acd8,0 } joined { } left { } partitioned { 21c56270-824e,0 }) 2022-06-16 15:56:51 0 [Note] WSREP: save pc into disk 2022-06-16 15:56:51 0 [Note] WSREP: forgetting 21c56270-824e (ssl://172.21.53.29:18301) 2022-06-16 15:56:51 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2 2022-06-16 15:56:51 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: e161ac63-ed49-11ec-b8c7-e317f78aaf6f 2022-06-16 15:56:51 0 [Note] WSREP: STATE EXCHANGE: sent state msg: e161ac63-ed49-11ec-b8c7-e317f78aaf6f 2022-06-16 15:56:51 0 [Note] WSREP: STATE EXCHANGE: got state msg: e161ac63-ed49-11ec-b8c7-e317f78aaf6f from 0 (p1vdbs-swdspmis-prdrptdb-1-01) 2022-06-16 15:56:51 0 [Note] WSREP: STATE EXCHANGE: got state msg: e161ac63-ed49-11ec-b8c7-e317f78aaf6f from 1 (garb) 2022-06-16 15:56:51 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 375, members = 2/2 (joined/total), act_id = 702707, last_appl. = 702614, protocols = 2/10/4 (gcs/repl/appl), vote policy= 0, group UUID = 00000000-0000-0000-0000-000000000000 2022-06-16 15:56:51 0 [Note] WSREP: Flow-control interval: [707, 707] 2022-06-16 15:56:51 2 [Note] WSREP: ####### processing CC 702708, local, ordered 2022-06-16 15:56:51 2 [Note] WSREP: ####### My UUID: 60932a90-4908-11ec-982f-12a73728d85f 2022-06-16 15:56:51 2 [Note] WSREP: Skipping cert index reset 2022-06-16 15:56:51 2 [Note] WSREP: REPL Protocols: 10 (5) 2022-06-16 15:56:51 2 [Note] WSREP: ####### Adjusting cert position: 702707 -> 702708 2022-06-16 15:56:51 0 [Note] WSREP: Service thread queue flushed. 2022-06-16 15:56:51 2 [Note] WSREP: ================================================ View: id: 00000000-0000-0000-0000-000000000000:702708 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: 60932a90-4908-11ec-982f-12a73728d85f, p1vdbs-swdspmis-prdrptdb-1-01 1: a0b81398-7aee-11ec-acd8-9b16ece7af36, garb ================================================= 2022-06-16 15:56:51 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2022-06-16 15:56:51 2 [Note] WSREP: Lowest cert index boundary for CC from group: 702615 2022-06-16 15:56:51 2 [Note] WSREP: Min available from gcache for CC from group: 555816 2022-06-16 15:56:56 0 [Note] WSREP: cleaning up 21c56270-824e (ssl://172.21.53.29:18301) 2022-06-16 16:00:02 18781665 [Note] InnoDB: Foreign Key referenced table rpt_db/spm_e_sub_meta not found for foreign table rpt_db/spm_e_sub 2022-06-16 16:02:50 18781981 [Warning] Aborted connection 18781981 to db: 'unconnected' user: 'unauthenticated' host: '172.17.28.37' (This connection closed normally without authentication) 2022-06-16 16:06:50 0 [Note] WSREP: (60932a90-982f, 'ssl://172.17.53.29:18301') connection established to 46ac5fc4-aef2 ssl://172.21.53.29:18301 2022-06-16 16:06:50 0 [Note] WSREP: (60932a90-982f, 'ssl://172.17.53.29:18301') turning message relay requesting on, nonlive peers: 2022-06-16 16:06:51 0 [Note] WSREP: declaring 46ac5fc4-aef2 at ssl://172.21.53.29:18301 stable 2022-06-16 16:06:51 0 [Note] WSREP: declaring a0b81398-acd8 at ssl://172.18.14.29:18301 stable 2022-06-16 16:06:51 0 [Note] WSREP: Node 60932a90-982f state prim 2022-06-16 16:06:51 0 [Note] WSREP: view(view_id(PRIM,46ac5fc4-aef2,1032) memb { 46ac5fc4-aef2,0 60932a90-982f,0 a0b81398-acd8,0 } joined { } left { } partitioned { }) 2022-06-16 16:06:51 0 [Note] WSREP: save pc into disk 2022-06-16 16:06:51 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 3 2022-06-16 16:06:51 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 2022-06-16 16:06:52 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 47927a88-ed4b-11ec-9c11-5609a680b1ed 2022-06-16 16:06:52 0 [Note] WSREP: STATE EXCHANGE: got state msg: 47927a88-ed4b-11ec-9c11-5609a680b1ed from 0 (p2vdbs-swdspmis-prdrptdb-2-01) 2022-06-16 16:06:52 0 [Note] WSREP: STATE EXCHANGE: got state msg: 47927a88-ed4b-11ec-9c11-5609a680b1ed from 1 (p1vdbs-swdspmis-prdrptdb-1-01) 2022-06-16 16:06:52 0 [Note] WSREP: STATE EXCHANGE: got state msg: 47927a88-ed4b-11ec-9c11-5609a680b1ed from 2 (garb) 2022-06-16 16:06:52 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 376, members = 2/3 (joined/total), act_id = 702730, last_appl. = 702614, protocols = 2/10/4 (gcs/repl/appl), vote policy= 0, group UUID = 00000000-0000-0000-0000-000000000000 2022-06-16 16:06:52 0 [Note] WSREP: Flow-control interval: [866, 866] 2022-06-16 16:06:52 2 [Note] WSREP: ####### processing CC 702731, local, ordered 2022-06-16 16:06:52 2 [Note] WSREP: ####### My UUID: 60932a90-4908-11ec-982f-12a73728d85f 2022-06-16 16:06:52 2 [Note] WSREP: Skipping cert index reset 2022-06-16 16:06:52 2 [Note] WSREP: REPL Protocols: 10 (5) 2022-06-16 16:06:52 2 [Note] WSREP: ####### Adjusting cert position: 702730 -> 702731 2022-06-16 16:06:52 0 [Note] WSREP: Service thread queue flushed. 2022-06-16 16:06:52 2 [Note] WSREP: ================================================ View: id: 00000000-0000-0000-0000-000000000000:702731 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: 1 members(3): 0: 46ac5fc4-ed4b-11ec-aef2-0a4cf2915ed2, p2vdbs-swdspmis-prdrptdb-2-01 1: 60932a90-4908-11ec-982f-12a73728d85f, p1vdbs-swdspmis-prdrptdb-1-01 2: a0b81398-7aee-11ec-acd8-9b16ece7af36, garb ================================================= 2022-06-16 16:06:52 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2022-06-16 16:06:52 2 [Note] WSREP: Lowest cert index boundary for CC from group: 702615 2022-06-16 16:06:52 2 [Note] WSREP: Min available from gcache for CC from group: 555816 2022-06-16 16:06:53 0 [Note] WSREP: Member 0.0 (p2vdbs-swdspmis-prdrptdb-2-01) requested state transfer from '*any*'. Selected 1.0 (p1vdbs-swdspmis-prdrptdb-1-01)(SYNCED) as donor. 2022-06-16 16:06:53 0 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 702731) 2022-06-16 16:06:53 2 [Note] WSREP: Detected STR version: 1, req_len: 175, req: STRv1 2022-06-16 16:06:53 2 [Note] WSREP: Cert index preload: 702615 -> 702731 2022-06-16 16:06:53 2 [Note] WSREP: SSL cipher list set to 'TLSv1.2,TLSv1.3' 2022-06-16 16:06:53 0 [Note] WSREP: async IST sender starting to serve ssl://p2vdbs-swdspmis-prdrptdb-2-01-db:18302 sending 702615-702731, preload starts from 702615 2022-06-16 16:06:53 0 [Note] WSREP: IST sender 702615 -> 702731 2022-06-16 16:06:53 2 [Note] WSREP: Server status change synced -> donor 2022-06-16 16:06:53 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2022-06-16 16:06:53 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2022-06-16 16:06:53 0 [Note] WSREP: Donor monitor thread started to monitor 2022-06-16 16:06:53 0 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'donor' --address 'p2vdbs-swdspmis-prdrptdb-2-01-db:18303/xtrabackup_sst//1' --local-port '19307' --socket '/var/run/mariadb/.mariadb.swdspmis_prdrptdb.socket' --datadir '/u01/mydata/swdspmis_prdrptdb/' --defaults-file '/u01/mycnf/swdspmis_prdrptdb/mariadb.cnf' --gtid '00000000-0000-0000-0000-000000000000:702731' --gtid-domain-id '0' --binlog '/u01/myarch/swdspmis_prdrptdb/mariadb-bin' --mysqld-args --defaults-file=/u01/mycnf/swdspmis_prdrptdb/mariadb.cnf --wsrep_start_position=16c56191-bf88-11eb-96c4-7a8ed27dd720:38209143' 2022-06-16 16:06:53 2 [Note] WSREP: sst_donor_thread signaled with 0 WSREP_SST: [INFO] SSL configuration: CA='', CERT='', KEY='', MODE='DISABLED', encrypt='0' (20220616 16:06:53.370) WSREP_SST: [INFO] Streaming with mbstream (20220616 16:06:53.620) WSREP_SST: [INFO] Using socat as streamer (20220616 16:06:53.623) WSREP_SST: [INFO] Using '/u01/mytmp/tmp.CIei1wrqOs' as mariabackup temporary directory (20220616 16:06:53.640) WSREP_SST: [INFO] Using '/tmp/tmp.Av2MylHjJC' as mariabackup working directory (20220616 16:06:53.646) WSREP_SST: [INFO] Streaming GTID file before SST (20220616 16:06:53.649) WSREP_SST: [INFO] Evaluating '/usr//bin/mbstream' -c 'xtrabackup_galera_info' | socat -u stdio TCP:p2vdbs-swdspmis-prdrptdb-2-01-db:18303; RC=( ${PIPESTATUS[@]} ) (20220616 16:06:53.653) WSREP_SST: [INFO] Sleeping before data transfer for SST (20220616 16:06:53.681) 2022-06-16 16:06:53 0 [Note] WSREP: (60932a90-982f, 'ssl://172.17.53.29:18301') turning message relay requesting off WSREP_SST: [INFO] Streaming the backup to joiner at p2vdbs-swdspmis-prdrptdb-2-01-db:18303 (20220616 16:07:03.687) WSREP_SST: [INFO] Evaluating /usr//bin/mariabackup --defaults-file='/u01/mycnf/swdspmis_prdrptdb/mariadb.cnf' --backup --no-version-check --databases-exclude='lost+found' --tmpdir='/u01/mytmp/tmp.CIei1wrqOs' --innodb-data-home-dir='/u01/mydata/swdspmis_prdrptdb' --log-bin='/u01/myarch/swdspmis_prdrptdb/mariadb-bin' --user='gcis_swdspmis_prdrptdb' --socket='/var/run/mariadb/.mariadb.swdspmis_prdrptdb.socket' --galera-info --stream=mbstream --target-dir='/tmp/tmp.Av2MylHjJC' --datadir='/u01/mydata/swdspmis_prdrptdb' --mysqld-args '--wsrep_start_position=16c56191-bf88-11eb-96c4-7a8ed27dd720:38209143' 2> '/u01/mydata/swdspmis_prdrptdb/mariabackup.backup.log' | socat -u stdio TCP:p2vdbs-swdspmis-prdrptdb-2-01-db:18303; RC=( ${PIPESTATUS[@]} ) (20220616 16:07:03.691) 2022-06-16 16:08:55 18782344 [Note] WSREP: Desyncing and pausing the provider 2022-06-16 16:08:55 18782344 [Note] WSREP: pause 2022-06-16 16:08:55 18782344 [Note] WSREP: Provider paused at 00000000-0000-0000-0000-000000000000:702735 (761417) 2022-06-16 16:08:55 18782344 [Note] WSREP: Provider paused at: 702735 2022-06-16 16:08:56 18782344 [Note] WSREP: Resuming and resyncing the provider 2022-06-16 16:08:56 18782344 [Note] WSREP: resume 2022-06-16 16:08:56 18782344 [Note] WSREP: resuming provider at 761417 2022-06-16 16:08:56 18782344 [Note] WSREP: Provider resumed. 2022-06-16 16:08:56 0 [Note] WSREP: SST sent: 00000000-0000-0000-0000-000000000000:702731 2022-06-16 16:08:56 0 [Note] WSREP: Server status change donor -> joined 2022-06-16 16:08:56 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. WSREP_SST: [INFO] Total time on donor: 0 seconds (20220616 16:08:56.701) WSREP_SST: [INFO] Cleaning up temporary directories (20220616 16:08:56.705) 2022-06-16 16:08:56 0 [Note] WSREP: Donor monitor thread ended with total time 123 sec 2022-06-16 16:08:57 0 [Note] WSREP: async IST sender served 2022-06-16 16:08:57 0 [Note] WSREP: declaring a0b81398-acd8 at ssl://172.18.14.29:18301 stable 2022-06-16 16:08:57 0 [Note] WSREP: forgetting 46ac5fc4-aef2 (ssl://172.21.53.29:18301) 2022-06-16 16:08:57 0 [Note] WSREP: Node 60932a90-982f state prim 2022-06-16 16:08:57 0 [Note] WSREP: view(view_id(PRIM,60932a90-982f,1033) memb { 60932a90-982f,0 a0b81398-acd8,0 } joined { } left { } partitioned { 46ac5fc4-aef2,0 }) 2022-06-16 16:08:57 0 [Note] WSREP: save pc into disk 2022-06-16 16:08:57 0 [Note] WSREP: forgetting 46ac5fc4-aef2 (ssl://172.21.53.29:18301) 2022-06-16 16:08:57 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2 2022-06-16 16:08:57 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 92486c01-ed4b-11ec-a26d-0adf5b3a3520 2022-06-16 16:08:57 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 92486c01-ed4b-11ec-a26d-0adf5b3a3520 2022-06-16 16:08:57 0 [Note] WSREP: STATE EXCHANGE: got state msg: 92486c01-ed4b-11ec-a26d-0adf5b3a3520 from 0 (p1vdbs-swdspmis-prdrptdb-1-01) 2022-06-16 16:08:57 0 [Note] WSREP: STATE EXCHANGE: got state msg: 92486c01-ed4b-11ec-a26d-0adf5b3a3520 from 1 (garb) 2022-06-16 16:08:57 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 377, members = 2/2 (joined/total), act_id = 702735, last_appl. = 702614, protocols = 2/10/4 (gcs/repl/appl), vote policy= 0, group UUID = 00000000-0000-0000-0000-000000000000 2022-06-16 16:08:57 0 [Note] WSREP: Flow-control interval: [707, 707] 2022-06-16 16:08:57 2 [Note] WSREP: ####### processing CC 702736, local, ordered 2022-06-16 16:08:57 2 [Note] WSREP: ####### My UUID: 60932a90-4908-11ec-982f-12a73728d85f 2022-06-16 16:08:57 2 [Note] WSREP: Skipping cert index reset 2022-06-16 16:08:57 2 [Note] WSREP: REPL Protocols: 10 (5) 2022-06-16 16:08:57 2 [Note] WSREP: ####### Adjusting cert position: 702735 -> 702736 2022-06-16 16:08:57 0 [Note] WSREP: Service thread queue flushed. 2022-06-16 16:08:57 0 [Warning] WSREP: Could not find peer: 46ac5fc4-ed4b-11ec-aef2-0a4cf2915ed2 2022-06-16 16:08:57 0 [Note] WSREP: 0.0 (p1vdbs-swdspmis-prdrptdb-1-01): State transfer to -1.-1 (left the group) complete. 2022-06-16 16:08:57 0 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 702736) 2022-06-16 16:08:57 0 [Note] WSREP: Member 0.0 (p1vdbs-swdspmis-prdrptdb-1-01) synced with group. 2022-06-16 16:08:57 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 702736) 2022-06-16 16:08:57 2 [Note] WSREP: ================================================ View: id: 00000000-0000-0000-0000-000000000000:702736 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: 60932a90-4908-11ec-982f-12a73728d85f, p1vdbs-swdspmis-prdrptdb-1-01 1: a0b81398-7aee-11ec-acd8-9b16ece7af36, garb ================================================= 2022-06-16 16:08:57 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2022-06-16 16:08:57 2 [Note] WSREP: Lowest cert index boundary for CC from group: 702615 2022-06-16 16:08:57 2 [Note] WSREP: Min available from gcache for CC from group: 555816 2022-06-16 16:08:57 2 [Note] WSREP: Server p1vdbs-swdspmis-prdrptdb-1-01 synced with group 2022-06-16 16:08:57 2 [Note] WSREP: Server status change joined -> synced 2022-06-16 16:08:57 2 [Note] WSREP: Synchronized with group, ready for connections 2022-06-16 16:08:57 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2022-06-16 16:09:02 0 [Note] WSREP: cleaning up 46ac5fc4-aef2 (ssl://172.21.53.29:18301)