Can't create logfiles after successfull backup

[Viktor Lavrov]

Hey!
I am trying to use Percona XtraBackup for creating backups of mysql with InnoDB tables.
First I start to create backup from slave server:

sudo innobackupex --defaults-file=/etc/my.cnf --parallel=4 --password='mypass' --slave-info --safe-slave-backup --compress --compress-threads=4 --rsync --throttle=30 /backups/test/

Some InnoDB info:
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 2
xtrabackup: innodb_log_file_size = 1073741824


After 15 minutes I recieve message
innobackupex: completed OK!

I see files:
backup-my.cnf
mysql
xtrabackup_checkpoints
zabbix
ibdata1
performance_schema
xtrabackup_info
ibdata1.qp
test
xtrabackup_slave_info

Then, if I understood everything correctly, I must re-create log files. So I do
sudo innobackupex --apply-log --redo-only --defaults-file=/etc/my.cnf --parallel=4 --password='mypass' --no-timestamp --slave-info --safe-slave-backup --compress --compress-threads=4 --rsync --throttle=30 /backups/test/2015-02-17_09-26-12

And I see:
xtrabackup version 2.2.6 based on MySQL server 5.6.21 Linux (x86_64) (revision id: )
xtrabackup: cd to /backups/test/2015-02-17_09-26-12
xtrabackup: This target seems to be not prepared yet.
2015-02-17 12:56:25 7ff58bdc8720 InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
xtrabackup: Warning: cannot open ./xtrabackup_logfile. will try to find.
xtrabackup: Fatal error: cannot find ./xtrabackup_logfile.
xtrabackup: Error: xtrabackup_init_temp_log() failed.
innobackupex: got a fatal error with the following stacktrace: at /usr/bin/innobackupex line 2632
main::apply_log() called at /usr/bin/innobackupex line 1561
innobackupex: Error:
innobackupex: ibbackup failed at /usr/bin/innobackupex line 2632.

For some reason I do not have "xtrabackup_logfile", although backup creation was completed successfully.

Do you have any ideas about what am I doing wrong?

Thanks in advance, Viktor.

[Jaime Crespo]

You need to decompress all files before processing them:

To decompress, use --decompress, or qpress to decompress the individual .qp files manually:

# innobackupex --decompress \
  /media/backups/2017-07-08_13-22-12

# find . -name "*.qp" -execdir qpress -d \{\} . \;

If that doesn't work, please provide a full output of the backup/compression log.

--
You received this message because you are subscribed to the Google Groups "Percona Discussion" group.
To unsubscribe from this group and stop receiving emails from it, send an email to percona-discuss...@googlegroups.com.
To post to this group, send email to percona-d...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Jaime Crespo

<http://dbahire.com>

[Viktor Lavrov]

Thanks! I did not know about that. After new attemp, xtrabackup_logfile had been created. Then I decompressed .qp file, and now applylog worked perfectly.

Again, thanks!

вторник, 17 февраля 2015 г., 15:29:05 UTC+3 пользователь Viktor Lavrov написал:

[Wagner Bianchi]

It's going to be a good reading regarding this subject:

http://www.percona.com/doc/percona-xtrabackup/2.2/howtos/recipes_ibkx_compressed.html

Cheers,

--

Wagner Bianchi, +55.31.8654.9510

Oracle ACE Director, MySQL Certified Professional

Email: m...@wagnerbianchi.com

Skype: wbianchijr

--