Node failing to join cluster after downtime

I started a new cluster, I got 2 nodes on the cluster. To test the joining and replication process I stopped node 2 (stopped the service) added data to node 1. On restart of node 2 I am getting a failure.
In the system log on node2 I am getting.

Starting Percona XtraDB Cluster...
mysql.service: Main process exited, code=killed, status=6/ABRT
mysql-systemd[946119]:  WARNING: mysql pid file /var/run/mysqld/mysqld.pid empty or not readable
mysql-systemd[946119]:  WARNING: mysql may be already dead
systemd[1]: mysql.service: Failed with result 'signal'.
systemd[1]: Failed to start Percona XtraDB Cluster.

In the error log on node2 I am getting

Log of wsrep recovery (--wsrep-recover):
INFO: WSREP: Running position recovery with --log_error='/db1/wsrep_recovery_verbose.QeOQvb' --pid-file='/db1/node2-recover.pid'
INFO: WSREP: Recovered position bc54efc2-52bc-11ec-9ba9-fbe9dc3b2f33:267
[Warning] [MY-000000] [Galera] Fail to access the file (/db1//gvwstate.dat) error (No such file or directory). It is possible if node is booting for first time or re-booting after a graceful shutdown
[Galera] (10cee6c3-a7f3, 'ssl://0.0.0.0:4567') connection established to 87846d53-828c ssl://192.168.2.61:4567
[Warning] [MY-000000] [WSREP-SST] Found a stale sst_in_progress file: /db1//sst_in_progress
[Note] [MY-000000] [WSREP] Prepared SST request: xtrabackup-v2|192.168.4.71:4444/xtrabackup_sst//1
[ERROR] [MY-000000] [WSREP-SST] FATAL: PXC is receiving an SST from a node with a higher version.
[ERROR] [MY-000000] [WSREP-SST] This node's PXC version is 8.0.25.  The donor's PXC version is 8.0.26.

How can I check the PXC version?

1 Like

Hi Danarashad,

The error is:

[ERROR] [MY-000000] [WSREP-SST] This node’s PXC version is 8.0.25. The donor’s PXC version is 8.0.26.

Try upgrading the joiner node to match the same version as the donor.

Regards

2 Likes