# IST fails when joining slaves back to cluster

**URL:** <https://forums.percona.com/t/ist-fails-when-joining-slaves-back-to-cluster/2523>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [December 18, 2012, 4:52am UTC](https://forums.percona.com/t/ist-fails-when-joining-slaves-back-to-cluster/2523 "2012-12-18T04:52:34Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ceksu](https://avatars.discourse-cdn.com/v4/letter/c/e8c25b/32.png) [@Ceksu](https://forums.percona.com/u/Ceksu)\
**Post date:** [December 18, 2012, 4:52am UTC](https://forums.percona.com/t/ist-fails-when-joining-slaves-back-to-cluster/2523/1 "2012-12-18T04:52:34Z")

</div>

Hi!

We are building master/slave setup for website that required autoincrementals to be +1 (thats the main reason for master/slave and not putting up multimaster).

Thus far we have been successful in getting our cluster up and running but after our slave server was rebooted we noticed that they can’t join back in to the cluster without doing full SST transfer first.

I think there is something wrong with our grastate.dat files.

This is from one of our joined slaves after full SST and left running for few hours:

# GALERA saved stateversion: 2.1uuid: c369e192-4818-11e2-0800-7697bb058ff4seqno: -1cert\_index:

I did notice that the seqno is set to -1, then I checked it up from our Master and seqno was -1 there too. Is this the reason why IST fails and if so, how to fix it?

Settings from master1 related to wsrep: (wsrep\_provider\_options is in 1 row)

wsrep\_provider = /usr/lib64/libgalera\_smm.sowsrep\_cluster\_address = gcomm://slave1IpHere,slave2IpHere,slave3IpHerewsrep\_provider\_options = 'gcache.size=4G; gcs.fc\_limit = 256; gcs.fc\_factor=0.9; gcs.fc\_master\_slave = yes; pc.bootstrap=1’wsrep\_auto\_increment\_control = 0 # This is disabled so that autoinc is 1wsrep\_slave\_threads = 24wsrep\_cluster\_name = ourClusterwsrep\_sst\_method = xtrabackupwsrep\_sst\_auth = SstUserHere:SstPwdHerewsrep\_node\_name = master1wsrep\_node\_address = master1IpHerewsrep\_causal\_reads = ON

And settings from slave1 about wsrep: (wsrep\_provider\_options is in 1 row)

wsrep\_provider = /usr/lib64/libgalera\_smm.sowsrep\_cluster\_address = gcomm://master1IpHere?pc.wait\_prim=yeswsrep\_provider\_options = 'gcache.size=4G; gcs.fc\_limit = 256; gcs.fc\_factor=0.9; gcs.fc\_master\_slave = yes; evs.keepalive\_period = PT3S; evs.inactive\_check\_period = PT10S; evs.suspect\_timeout = PT30S; evs.inactive\_timeout = PT1M; evs.install\_timeout = PT1M’wsrep\_sst\_auth = SstUserHere:SstPwdHerewsrep\_auto\_increment\_control = 0 # This is disabled so that autoinc is 1wsrep\_slave\_threads = 24wsrep\_cluster\_name = ourClusterwsrep\_sst\_method = xtrabackupwsrep\_node\_name = slave1wsrep\_node\_address = slave1IpHerewsrep\_causal\_reads = ON

List of installed Percona software, all servers are running 64bit CentOS 6.3:  
Percona-XtraDB-Cluster-client.x86\_64 1:5.5.28-23.7.369.rhel6 @percona  
Percona-XtraDB-Cluster-galera.x86\_64 2.0-1.117.rhel6 @percona  
Percona-XtraDB-Cluster-server.x86\_64 1:5.5.28-23.7.369.rhel6 @percona  
Percona-XtraDB-Cluster-shared.x86\_64 1:5.5.28-23.7.369.rhel6 @percona  
percona-release.x86\_64 0.0-1 installed  
percona-xtrabackup.x86\_64 2.0.4-484.rhel6 @percona