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

xtrabackup: error: log block numbers mismatch

olegmeolegme EntrantCurrent User Role Beginner
Running innobackupex I see the following in its output:

xtrabackup: error: log block numbers mismatch:
xtrabackup: error: expected log block no. 91292509, but got no. 90768229 from the log file.
xtrabackup: Error: xtrabackup_copy_logfile() failed.

innobackupex continues, but at the end I see this:

innobackupex: xtrabackup_55 failed! (exit code 1) The backup may not be complete.

Studying Bug #805593 I understood that one possible reason for this error message could be transaction log being wrapped around while xtrabackup works.

Will much appretiate if you answer the following:
1) Is it really transaction log wrapping issue?
Is there a way to find out?
2) If the above is true, how the backup logic should be build?
Restart backup?
Shall this go to FAQ/User Guide?
3) Is it possible to delay log wrapping till xtrabackup ends?

I'm using
Ubuntu Natty 11.04(2.6.38-8-server #42-Ubuntu SMP Mon Apr 11 03:49:04 UTC 2011 x86_64 x86_64 x86_64 GNU/Linux)
Percona Server 5.5.17-rel22.1

Please let me know if you need any further details to investgate the issue.

Thank you and best regards


  • xaprbxaprb Mentor Inactive User Role Beginner
    You should file this as a bug on launchpad.
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.