MySQL Forums
Forum List  »  Backup

MySQL server doesn't start after restore from incremental backup (mysqlbackup)
Posted by: Vitaly Karasik
Date: July 12, 2015 02:43AM

Hi,
I'm trying to use mysqlbackup's incremental backups, but recovery from incremental doesn't work for me.
Environment: RHEL 6.5, MySQL 5.6.24, MEB 3.9
Steps to reproduce:
1) backup
1.1) full backup:
mysqlbackup --backup-dir=/backups/full --backup-image=full.mbi backup-to-image --compress
1.2) incremental backup:
mysqlbackup --incremental --incremental-base=dir:/backups/full/2015-07-12_06-50-26 --incremental-backup-dir=/backups --backup-image=differential.mbi backup-to-image
2) restore:
2.1) restore from full backup:
mysqlbackup --defaults-file=/backups/full-12-07-2015/2015-07-12_06-50-26/backup-my.cnf --backup-image=full.mbi --backup-dir=/backups/full/2015-07-12_06-50-26 --datadir=/data/mysql --uncompress copy-back-and-apply-log
Result: everything is OK - I'm able to start MySQL server
2.2) applying incremental backup:
mysqlbackup --defaults-file=/backups/2015-07-12_07-14-35/backup-my.cnf --backup-image=differential.mbi --backup-dir=/backups/2015-07-12_07-14-35/ --datadir=/data/mysql --incremental copy-back-and-apply-log
Result:
- mysqlbackup status is "OK
- but MySQL server cannot start, it crashes with

2015-07-12 04:00:08 7ff5e2122700 InnoDB: Assertion failure in thread 140694036555520 in file trx0purge.cc line 699
InnoDB: Failing assertion: purge_sys->iter.trx_no <= purge_sys->rseg->last_trx_no
InnoDB: We intentionally generate a memory trap.

Any ideas?

TIA,
Vitaly

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL server doesn't start after restore from incremental backup (mysqlbackup)
2296
July 12, 2015 02:43AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.