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

IST first seqno 7 not found from cache, falling back to SST

quantaquanta EntrantCurrent User Role Beginner
xtrabackup: version 2.0.2
MySQL: version 5.5.27
Distro: CentOS 5.7

my.cnf on the donor:


my.cnf on the joiner:


The backup are performed by running:

innobackupex --galera-info --stream=tar ./ | gzip - | nc 9999</pre>

grastate.dat on the joiner (sure, take it from the xtrabackup_galera_info)

# GALERA saved stateversion: 2.1uuid: f68ad1a2-0a4e-11e2-0800-7441f90e56cfseqno: 6cert_index:</pre>

mysqld.log on the donor:

120930 17:00:49 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 8)120930 17:00:49 [Note] WSREP: IST request: f68ad1a2-0a4e-11e2-0800-7441f90e56cf:6-8|tcp:// 17:00:49 [Note] WSREP: IST first seqno 7 not found from cache, falling back to SST</pre>

mysqld.log on the joiner:

120930 17:01:54 [Note] WSREP: Prepared SST request: xtrabackup| 17:01:54 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.120930 17:01:54 [Note] WSREP: Assign initial position for certification: 8, protocol version: 2120930 17:01:54 [Note] WSREP: Prepared IST receiver, listening at: tcp:// 17:01:54 [Note] WSREP: Node 2 (SVR282-5197.localdomain) requested state transfer from '*any*'. Selected 0 (x)(SYNCED) as donor.120930 17:01:54 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 8)120930 17:01:54 [Note] WSREP: Requesting state transfer: success, donor: 0120930 17:03:18 [Note] WSREP: 0 (SVR120-27148.localdomain): State transfer to 2 (SVR282-5197.localdomain) complete.120930 17:03:18 [Note] WSREP: Member 0 (SVR120-27148.localdomain) synced with group.120930 17:03:29 [Note] WSREP: SST complete, seqno: 8</pre>

The second node joined the cluster successfully but it does a SST instead of an IST. Why it doesn't find the sequence number from cache? My database is only ~ 3GB, there is a little changes from the time of the backup until the restore is complete.

sst.err on the joiner is empty.
Some lines at the end of innobackup.backup.log on the donor:

...innobackupex: Resuming ibbackup xtrabackup: The latest check point (for incremental): '1850952486'xtrabackup: Stopping log copying thread..>> log scanned up to (1850952640) xtrabackup: Streaming transaction log from a temporary file...xtrabackup: Done.xtrabackup: Transaction log of lsn (1850952486) to (1850952640) was copied.120930 18:52:04 innobackupex: All tables unlocked120930 18:52:04 innobackupex: Connection to database server closed innobackupex: Backup created in directory '/tmp'innobackupex: MySQL binlog position: filename 'mysql-bin.000185', position 107innobackupex: You must use -i (--ignore-zeros) option for extraction of the tar stream.120930 18:52:04 innobackupex: completed OK!</pre>
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.