Automated backups not containing database files

[DieselTech]

What happened?

Some users have reported that the kavita.db file is missing in backups.

At first glance it seems like if the file is in use when the backup job fires off it will not copy the database. If nothing else, we should check the backup after it is created to make sure the DB exists in it. If not, fail the job. (Bonus, send an email to the admin if they have it setup)

Ideally, we can do some testing of the sqlite vacuum function to make sure nothing gets lost or discarded, then use the function to make a copy of the database at backup time. That would create a space optimized and compacted database users would be able restore to gain some performance back over time.

What did you expect?

Backups to contain the database.

Kavita Version Number - If you don not see your version number listed, please update Kavita and see if your issue still persists.

0.8.4.2 - Stable

What operating system is Kavita being hosted from?

None

If the issue is being seen on Desktop, what OS are you running where you see the issue?

None

If the issue is being seen in the UI, what browsers are you seeing the problem on?

No response

If the issue is being seen on Mobile, what OS are you running where you see the issue?

None

If the issue is being seen on the Mobile UI, what browsers are you seeing the problem on?

No response

Relevant log output

No response

Additional Notes

No response

[majora2007]

I wasn't able to reproduce this, I have also validated a few times since this was opened and all my backups have a db file.