Skip to content

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

@Iceman248

Description

@Iceman248

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions