innobackupex --apply-log (database backup prepare step fails)

gblazergblazer EntrantCurrent User Role Participant
I have a backup created on MySQL 5.1 InnoDB ​that I was able to restore before.

Now I download it, untar it, and attempt to run innobackupex --apply-log --use-memory=8G using these version

Instead I get the following error which suggests corruption of the backup.
https://gist.github.com/webdev/8816402

Is there any way to look deeper into this black box?

Comments

  • niljoshiniljoshi MySQL Sage Inactive User Role Leader
    Hi,

    Can you provide steps, how you took the backup? command line? Are you sure that backup was completed successfully?
    As per the log,
    140205  2:19:21  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: 'ib_logfile0' seems to be 'xtrabackup_logfile'. will retry.
    

    Are you sure all files are properly untar from the backup? it seems above files are not there and backup is corrupted.

    140205  2:19:21  InnoDB: Error: space id and page n:o stored in the page
    InnoDB: read in are 553091072:4913, should be 0:327693!
    InnoDB: Database page corruption on disk or a failed
    InnoDB: file read of page 327693.
    ....
    InnoDB: Ending processing because of a corrupt database page.
    innobackupex: Error: 
    innobackupex: ibbackup failed at /usr/bin/innobackupex line 386.
    
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.