Announcement

Announcement Module
Collapse
No announcement yet.

Prepare backup on different server using xtrabackup

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Prepare backup on different server using xtrabackup

    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.

  • #2
    Are you using the same cnf file for both servers? Dump a stacktrace of the dumped core so we can see
    Our documentation has a lot of answers about common questions on Percona software, have you checked there before posting that question here? http://www.percona.com/forums/core/i...lies/smile.png

    Join us at the annual Percona Live MySQL Users Conference - http://www.percona.com/live/mysql-conference-2014/

    Comment

    Working...
    X