Backups: temporary files not deleted on fail

Nathan Geerinck

Live

When a backup of a database fails, temporary files are not deleted.

Needs extra investigation:

Sites with Zero Downtime Deployments;
Large SQL files;

Dennis

· 1 year ago · Edited

Merged Delete SQL file when database backup fails into this item \n\n Created by: tygoegmond \n\n Hello,

We're dealing with a sizable dataset here. In the event of a database backup failure occurring once or twice, it has the potential to exhaust all available disk space on the server. This is primarily due to the presence of approximately three times the size of the database on the disk.

To mitigate this issue, I propose that in the event of a database backup failure, Ploi should attempt to remove the associated .sql file that was created.

2 total votes

michael

· 10 months ago · Edited

An alternative approach may be to scan for earlier failed back up files on the next backup run. Deleting failed backup files older than a certain amount of time, say, for example, over six hours old or two days old. This would allow for someone to investigate the current failed backup final should they be aware of the failure right when it happens.