xtrabackup: error: log block numbers mismatch:

[sharma....@gmail.com]

Hi,

I need to backup db of 84GB size.

Using RHEL(6.2) with following things installed

1. MySQL Ver 14.14 Distrib 5.5.11
2. Percona / xtrabackup version 2.0.0 for Percona Server 5.1.59 unknown-linux-gnu (x86_64) (revision id: 417)
3. innodb_log_file_size 524MB

Ran below command:
sudo innobackupex --user=xxxx --password=xxxx --defaults-file="/etc/my.cnf" --tables-file="/home/xxxx/xyz.txt" /home/abc/defg/

Error:

xtrabackup: error: log block numbers mismatch:
xtrabackup: error: expected log block no. 462050438, but got no. 462070910 from the log file.
xtrabackup: error: it looks like InnoDB log has wrapped around before xtrabackup could process all records due to either log copying being too slow, or log files being too small.
xtrabackup: Error: xtrabackup_copy_logfile() failed.

Guys, am I missing some configuration? Please share your solution.

Thanks

[Vadim Tkachenko]

Unless there is some bug, the error message is descriptive - you have
small innodb_log_file_size,
the database can't be copied fully as logs are getting rotated.
You need to increase innodb_log_file_size, However in 5.1 it has to be
done careful.
https://www.percona.com/blog/2011/07/09/how-to-change-innodb_log_file_size-safely/

> --
> 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.
> Visit this group at https://groups.google.com/group/percona-discussion.
> To view this discussion on the web visit https://groups.google.com/d/msgid/percona-discussion/0e5f206f-8d79-4031-8374-5260cee24eda%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.



--
Vadim Tkachenko, CTO, Percona
Phone +1-919-249-7483, Skype: vadimtk153

The Premier Open Source Database Performance Conference in North America
https://www.percona.com/live/17/

[sharma....@gmail.com]

Thanks Vadim