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

SST recovery loop after node reboot

ofriasofrias ContributorInactive User Role Novice
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

Comments

  • ofriasofrias Contributor Inactive User Role Novice
    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
  • lorraine.pocklingtonlorraine.pocklington Percona Community Manager Legacy User Role Patron
    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.
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.