2020-11-06T10:58:12.581455Z 2 [Note] WSREP: Setting wsrep_ready to false 2020-11-06T10:58:12.581579Z 0 [Note] WSREP: Initiating SST/IST transfer on JOINER side (wsrep_sst_xtrabackup-v2 --role 'joiner' --address '[joiner ip]' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf' --defaults-group-suffix '' --parent '31630' --mysqld-version '5.7.31-34-57' '' ) 2020-11-06T10:58:12.760055Z WSREP_SST: [WARNING] WARNING: xtrabackup-plugin-dir (under xtrabackup section) missing 2020-11-06T10:58:12.761644Z WSREP_SST: [WARNING] xtrabackup installation will lookout for plugin at default location 2020-11-06T10:58:12.956339Z WSREP_SST: [INFO] Streaming with xbstream 2020-11-06T10:58:12.987922Z WSREP_SST: [WARNING] Found a stale sst_in_progress file: /var/lib/mysql//sst_in_progress 2020/11/06 10:58:13 socat[32132] E SSL_CTX_load_verify_locations(): error:02001002:system library:fopen:No such file or directory 2020-11-06T10:58:13.049672Z WSREP_SST: [ERROR] ******************* FATAL ERROR ********************** 2020-11-06T10:58:13.051220Z WSREP_SST: [ERROR] Error while getting data from donor node: exit codes: 1 0 2020-11-06T10:58:13.052721Z WSREP_SST: [ERROR] ****************************************************** 2020-11-06T10:58:13.054996Z WSREP_SST: [ERROR] Cleanup after exit with status:32 2020-11-06T10:58:15.079006Z 0 [Note] WSREP: (f62699a6, 'ssl://0.0.0.0:4567') turning message relay requesting off 2020-11-06T10:59:32.324588Z 2 [Note] WSREP: Prepared SST/IST request: xtrabackup-v2|[joiner ip]:4444/xtrabackup_sst//1 2020-11-06T10:59:32.324633Z 2 [Note] WSREP: Auto Increment Offset/Increment re-align with cluster membership change (Offset: 1 -> 3) (Increment: 1 -> 3) 2020-11-06T10:59:32.324650Z 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-11-06T10:59:32.324687Z 2 [Note] WSREP: Assign initial position for certification: 29236817, protocol version: 4 2020-11-06T10:59:32.324792Z 0 [Note] WSREP: Service thread queue flushed. 2020-11-06T10:59:32.324872Z 0 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup-v2 --role 'joiner' --address '[joiner ip]' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf' --defaults-group-suffix '' --parent '31630' --mysqld-version '5.7.31-34-57' '' : 32 (Broken pipe) 2020-11-06T10:59:32.324915Z 0 [ERROR] WSREP: Failed to read uuid:seqno from joiner script. 2020-11-06T10:59:32.324927Z 0 [ERROR] WSREP: SST script aborted with error 32 (Broken pipe) 2020-11-06T10:59:32.324952Z 0 [ERROR] WSREP: SST failed: 32 (Broken pipe) 2020-11-06T10:59:32.324986Z 0 [ERROR] Aborting 2020-11-06T10:59:32.324995Z 0 [Note] WSREP: Signalling cancellation of the SST request. 2020-11-06T10:59:32.325008Z 0 [Note] WSREP: SST request was cancelled 2020-11-06T10:59:32.325017Z 0 [Note] Giving 2 client threads a chance to die gracefully 2020-11-06T10:59:32.324892Z 2 [Note] WSREP: Check if state gap can be serviced using IST 2020-11-06T10:59:32.325056Z 2 [Note] WSREP: Local UUID: 00000000-0000-0000-0000-000000000000 != Group UUID: 0e2f3973-4c07-11ea-a5a9-2ae1559801a1 2020-11-06T10:59:32.325128Z 2 [Note] WSREP: State gap can't be serviced using IST. Switching to SST 2020-11-06T10:59:32.325140Z 2 [Note] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (0e2f3973-4c07-11ea-a5a9-2ae1559801a1): 1 (Operation not permitted) at galera/src/replicator_str.cpp:prepare_for_IST():538. IST will be unavailable. 2020-11-06T10:59:32.326551Z 0 [Note] WSREP: Member 2.0 (pxc-cluster-node-4) requested state transfer from 'pxc-cluster-node-2'. Selected 1.0 (pxc-cluster-node-2)(SYNCED) as donor. 2020-11-06T10:59:32.326567Z 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 29261687) 2020-11-06T10:59:32.326601Z 2 [Note] WSREP: Requesting state transfer: success, donor: 1 2020-11-06T10:59:32.326618Z 2 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> 0e2f3973-4c07-11ea-a5a9-2ae1559801a1:29236817 2020-11-06T10:59:32.859780Z 0 [Warning] WSREP: 1.0 (pxc-cluster-node-2): State transfer to 2.0 (pxc-cluster-node-4) failed: -32 (Broken pipe) 2020-11-06T10:59:32.859801Z 0 [ERROR] WSREP: gcs/src/gcs_group.cpp:gcs_group_handle_join_msg():807: Will never receive state. Need to abort. 2020-11-06T10:59:32.859823Z 0 [Note] WSREP: gcomm: terminating thread 2020-11-06T10:59:32.859844Z 0 [Note] WSREP: gcomm: joining thread 2020-11-06T10:59:32.859991Z 0 [Note] WSREP: gcomm: closing backend