Hello team,
I am creating the pxc operator on k8s local cluster and facing below error.
Could you please suggest me how to resolve the issue.
cluster1-pxc-1 logs:
2020-05-15T08:14:12.671781Z 0 [ERROR] [MY-000000] [WSREP-SST] ******************* FATAL ERROR **********************2020-05-15T08:14:12.672531Z 0 [ERROR] [MY-000000] [WSREP-SST] FATAL: Found existing /var/lib/mysql//sst-xb-tmpdir2020-05-15T08:14:12.672546Z 0 [ERROR] [MY-000000] [WSREP-SST] Please remove it or specify alternative temporary directory location by setting [sst]/tmpdir2020-05-15T08:14:12.672554Z 0 [ERROR] [MY-000000] [WSREP-SST] Line 19412020-05-15T08:14:12.672563Z 0 [ERROR] [MY-000000] [WSREP-SST] ******************************************************
2020-05-15T08:14:12.672576Z 0 [ERROR] [MY-000000] [WSREP-SST] Cleanup after exit with status:2
2020-05-15T08:14:12.676113Z 0 [ERROR] [MY-000000] [WSREP] Process completed with error: wsrep_sst_xtrabackup-v2 --role ‘joiner’ --address ‘192.168.165.21’ --datadir ‘/var/lib/mysql/’ --basedir ‘/usr/’ --plugindir ‘/usr/lib64/mysql/plugin/’ --defaults-file ‘/etc/my.cnf’ --defaults-group-suffix ‘’ --parent ‘1’ --mysqld-version ‘8.0.18-9’ ‘’ : 2 (No such file or directory)
2020-05-15T08:14:12.676151Z 0 [ERROR] [MY-000000] [WSREP] Failed to read uuid:seqno from joiner script.
2020-05-15T08:14:12.676166Z 0 [ERROR] [MY-000000] [WSREP] SST script aborted with error 2 (No such file or directory)
2020-05-15T08:14:12.676247Z 3 [Note] [MY-000000] [Galera] Processing SST received2020-05-15T08:14:12.676274Z 3 [Note] [MY-000000] [Galera] SST received: 00000000-0000-0000-0000-000000000000:-12020-05-15T08:14:12.676296Z 3 [System] [MY-000000] [WSREP] SST completed2020-05-15T08:14:12.676354Z 1 [Note] [MY-000000] [Galera] str_proto_ver_: 3 sst_seqno_: -1 cc_seqno: 26 req->ist_len(): 692020-05-15T08:14:12.676392Z 1 [ERROR] [MY-000000] [Galera] Application received wrong state: Received: 00000000-0000-0000-0000-000000000000 Required: ce471a14-9680-11ea-a94d-efdd11479e8f2020-05-15T08:14:12.676407Z 1 [ERROR] [MY-000000] [Galera] Application state transfer failed. This is unrecoverable condition, restart required.2020-05-15T08:14:12.676421Z 1 [Note] [MY-000000] [Galera] ReplicatorSMM::abort()2020-05-15T08:14:12.676439Z 1 [Note] [MY-000000] [Galera] Closing send monitor…2020-05-15T08:14:12.676457Z 1 [Note] [MY-000000] [Galera] Closed send monitor.2020-05-15T08:14:12.676470Z 1 [Note] [MY-000000] [Galera] gcomm: terminating thread2020-05-15T08:14:12.676492Z 1 [Note] [MY-000000] [Galera] gcomm: joining thread2020-05-15T08:14:12.676525Z 1 [Note] [MY-000000] [Galera] gcomm: closing backend2020-05-15T08:14:13.679368Z 1 [Note] [MY-000000] [Galera] Current view of cluster as seen by this node-------======================================================================
======================================================================
JOINER innobackup.backup.log
200515 08:41:31 >> log scanned up to (31269631)
200515 08:41:32
>> log scanned up to (31269631)
200515 08:41:33
>> log scanned up to (31269631)
xtrabackup: Error writing file ‘UNOPENED’ (OS errno 32 - Broken pipe)
[03] xtrabackup: Error: failed to copy datafile.
xtrabackup: Error writing file ‘UNOPENED’ (OS errno 32 - Broken pipe)
[02] xtrabackup: Error: failed to copy datafile.
xtrabackup: Error writing file ‘UNOPENED’ (OS errno 32 - Broken pipe)
xb_stream_write_data() failed.
xtrabackup: Error writing file ‘UNOPENED’ (OS errno 32 - Broken pipe)
[01] xtrabackup: Error: xtrabackup_copy_datafile() failed.
[01] xtrabackup: Error: failed to copy datafile.
200515 08:41:34
[04] Streaming ./mysql.ibd
xtrabackup: Error writing file ‘UNOPENED’ (OS errno 32 - Broken pipe)
xb_stream_write_data() failed.
xtrabackup: Error writing file ‘UNOPENED’ (OS errno 32 - Broken pipe)
[04] xtrabackup: Error: xtrabackup_copy_datafile() failed.
[04] xtrabackup: Error: failed to copy datafile.
200515 08:41:34 >> log scanned up to (31269631)
bash-4.2$