Been using innobackupex for a few years now. While setting up some new infrastructure, I noticed the following:
- innobackupex version 2.3.4 Linux (x86_64) (revision id: e80c779)
- backup and restore works fine (I have some script automating most of the usage)
- when restoring, innobackupex does not restore the ib_logfile0 file, which is expected
however, if one does another backup, shortly after the restore operation, and there was no write on the database in the mean time (at least I think that’s the reason), then the next backup fails with:
2016-06-16 08:20:01 7f32156b4740 InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: File ./ib_logfile0: ‘open’ returned OS error 71. Cannot continue operation
Restore is done with:
innobackupex –defaults-file=/etc/mysql/my.cnf --copy-back db_tmp Am I missing something somewhere?
I suspect on a real production server, this won’t be an issue, as there will always be some writes in between a restore and next backup but still a bit strange.
Thanks for any input.