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

SST can not be done on a running server with SST-method set to xtrabackup-v2?

steinexsteinex EntrantInactive User Role Beginner
Hi,

we're running a 3-node XtraDB-Cluster and observed the following issue: if one node looses connectivity to the rest of the cluster (using iptables DROP for testing), then inserting enough to a table so that an SST becomes necessary and try to re-join the firewalled node, it can't do an SST stating "WSREP: You have configured 'xtrabackup-v2' state snapshot transfer method which cannot be performed on a running server. Wsrep provider won't be able to fall back to it if other means of state transfer are unavailable. In that case you will need to restart the server."

We don't think this is expected beharviour?

Please see attached logs.


Here the node gets connectivity again, tries to rejoin the cluster, and fails:
http://pastebin.com/G4JHsgS8


And this is the log of the donor Node where the previously offline node gains connectivity again:
http://pastebin.com/1ZjGi3Zh


Versions are as follows (Debian wheezy, packages from Percona):
percona-xtrabackup 2.1.9-744-1.wheezy
percona-xtradb-cluster-56 5.6.15-25.5-759.wheezy
percona-xtradb-cluster-client-5.6 5.6.15-25.5-759.wheezy
percona-xtradb-cluster-common-5.6 5.6.15-25.5-770.wheezy
percona-xtradb-cluster-galera-3.x 216.wheezy
percona-xtradb-cluster-server-5.6 5.6.15-25.5-759.wheezy

Do you have any idea why this is not working? Thanks in advance! Btw, logs were generated with wsrep_debug, wsrep_log_conflicts and general_log set to ON. If you need even more verbosity, let me know!

Best regards and thanks in advance,
Frank

Comments

  • percojdpercojd Entrant Current User Role Beginner
    Hello Frank,

    We have the same problem, where you able to resolve this issue?

    Thanks,
    Jeroen
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.