search

ShahriyarR / MySQL-AutoXtraBackup

MySQL-AutoXtraBackup commandline tool written in Python 3 based on Percona XtraBackup
https://autoxtrabackup.azepug.az/
MIT License
140 stars 79 forks source link

If permission error, then can't backup anymore #329

Closed BarbzYHOOL closed 5 years ago

BarbzYHOOL commented 5 years ago

If there was a permission error (to write the backup)

then it will print:

RuntimeError: FAILED: INCREMENT BACKUP
2018-12-22 12:16:55 DEBUG    <pid.PidFile object at 0x7f73a15c5688> closing pidfile: /tmp/autoxtrabackup/pid/autoxtrabackup.pid

because the script created an empty directory and it's looking for that file xtrabackup_checkpoints inc/2018-12-22_12-14-17//xtrabackup_checkpoints

ShahriyarR commented 5 years ago

@BarbzYHOOL If you failed to make full backup then it is normal to have such issue. Because to make incremental backup Percona XtraBackup is looking for xtrabackup_checkpoints file.

BarbzYHOOL commented 5 years ago

ok maybe you could add a message in the debug to check for empty backups or automatically delete them?

ShahriyarR commented 5 years ago

Well, if full backup failed and you did not fixed the issue - it is in general failed backup. After that If I will delete empty full backup directory autoxtrabackup will detect it and will try to make another full backup which will fail again isn't it? :)

BarbzYHOOL commented 5 years ago

After that If I will delete empty full backup directory autoxtrabackup will detect it and will try to make another full backup which will fail again isn't it? :)

true :D

maybe debug msg with a hint?