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