SST recovery loop after node reboot

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Hello.

We are running a Percona XtraDB Cluster with 2 nodes and 1 arbitrator.

The problem is that we have rebooted one of the nodes and, after rebooting, instead of an IST recovery it has entered a SST recovery. And after finishing the SST transfer it has restarted again the SST transfer, entering in what looks like a recovery infinite loop.

The version in both nodes is the last stable version available from Percona respositories:

mysqld --version

mysqld Ver 5.7.26-29-57 for debian-linux-gnu on x86_64 (Percona XtraDB Cluster (GPL), Release rel29, Revision 03540a3, WSREP version 31.37, wsrep_31.37)

And this is xtrabackup version in both nodes:
xtrabackup version 2.4.15 based on MySQL server 5.7.19 Linux (x86_64) (revision id: 544842a)

I attach the logs of both the joiner and the donor.

I had successfully rebooted the nodes after updating to this Percona version on July 1st and everything went smoothly.

The only thing that has changed since the this last reboot was xtrabackup version, which changed from 2.4.14 to 2.4.15

Could you please help us with this issue?

Oscar

donor.txt (39.8 KB)

joiner.txt (65 KB)

2

Hi again.

After rebooting the joiner node again it has started SST again and this time it has finished successfully, both nodes are synchronized now.

Oscar

3

Thank you for the update Oscar, appreciated. It could help someone else down the track. If you have any other question don’t hesitate to return.