docker-db-backup icon indicating copy to clipboard operation
docker-db-backup copied to clipboard
verified publisher icon tiredofit

SHM file gets deleted when backing up sqlite3 db, causing db to unusable until restarting app

Open Iceman248 opened this issue 4 months ago • 0 comments

Summary

It seems to trigger a checkpoint to move data from WAL file to main DB file, then backs up that file, then I noticed WAL file was zeroed out, but that SHM file was deleted and I was getting I/O errors and DB ultimately wouldn't work, had to restart app to get it going again. It recreated the SHM file.

Steps to reproduce

  1. Backup sqlite3 db file

What is the expected correct behavior?

Either doesn't delete SHM file or recreates it if needs to

Relevant logs and/or screenshots

Environment

  • Image version / tag: 4.1.21 / latest
  • Host OS: Unraid
Any logs | docker-compose.yml

Possible fixes

Iceman248 avatar Aug 19 '25 14:08 Iceman248