Not the answer you need?
Register and ask your own question!

Cluster unable to create/ join

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-tmpdir
2020-05-15T08:14:12.672546Z 0 [ERROR] [MY-000000] [WSREP-SST] Please remove it or specify alternative temporary directory location by setting [sst]/tmpdir
2020-05-15T08:14:12.672554Z 0 [ERROR] [MY-000000] [WSREP-SST] Line 1941
2020-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 received
2020-05-15T08:14:12.676274Z 3 [Note] [MY-000000] [Galera] SST received: 00000000-0000-0000-0000-000000000000:-1
2020-05-15T08:14:12.676296Z 3 [System] [MY-000000] [WSREP] SST completed
2020-05-15T08:14:12.676354Z 1 [Note] [MY-000000] [Galera]  str_proto_ver_: 3 sst_seqno_: -1 cc_seqno: 26 req->ist_len(): 69
2020-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-efdd11479e8f
2020-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 thread
2020-05-15T08:14:12.676492Z 1 [Note] [MY-000000] [Galera] gcomm: joining thread
2020-05-15T08:14:12.676525Z 1 [Note] [MY-000000] [Galera] gcomm: closing backend
2020-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$

Answers

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.