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

Prepare backup on different server using xtrabackup

paulbpaulb EntrantCurrent User Role Beginner
Hi,

I successfully ran a partial backup on server A for database X.
I then copied the partial directory to server B where I tried to prepare the backup for database X.

Server A & B are Solaris SPARC 64-bit.

When I backup and prepare on the same server, everything is fine.
However, when I tried to prepare the backup on server B, I got the following error.

120106 16:49:05 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 120106 16:50:28InnoDB: Assertion failure in thread 7 in file log0recv.c line 886
InnoDB: Failing assertion: !page || (ibool)!!page_is_comp(page)==index->table->comp
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html
InnoDB: about forcing recovery.
InnoDB: Thread ./prepare_hot_backup.sh: line 236: 17380 Segmentation Fault (core dumped) xtrabackup_50 --prepare --apply-log-only --target-dir=$TMP_DIR_PARTIAL

Apart from copying over the partial folder created during the partial backup, do I need anything else? Is this a bug?

Thanks.

Comments

  • revinrevin Contributor Current User Role Beginner
    Are you using the same cnf file for both servers? Dump a stacktrace of the dumped core so we can see :)
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.