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

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
- 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 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?


Options: ReplyQuote

Written By
MySQL server doesn't start after restore from incremental backup (mysqlbackup)
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.