Jump to content

  • SQLite database corruption back?

    coldtech

    By coldtech

      • Urgent

    Hi everyone,

     

    so there was this issue quite some time ago:
    https://forums.unraid.net/bug-reports/prereleases/sqlite-data-corruption-testing-r664/page/5/

     

    Soooo I know it's been quite a while and seems to have been fixed, but I'm running into this exact same problem with SQLite DB corruption. In my case I'm running the frigate (NVR) docker container.

     

    Is there a possibility that this issue is back? I just now changed all my volume mappings to address the disk directly instead of /mnt/user/appdata based on a hunch before reading the above link. I also disabled secondary storage now (so appdata should only sit on one NVME SSD, no secondary storage on the array).

     

    Also, I'm running ZFS on the NVME, which I first suspected as the culprit.

    Was there any working configuration that I could try? Also, did this really only happen to SQLite DBs, or was other data affected as well? I'm just migrating everything back to unRaid after running Synology for a few months (used Synology because of their integrated NVR). I was about to migrate my InfluxDB as well, but after seeing these corruption issues I am afraid to do so.

    I'm currently on unRaid 6.12.2

    Go to reports Stable Releases

    User Feedback

    Recommended Comments

    coldtech

    Will do as soon as it happens again, unfortunately I can‘t force it to happen yet.

    So I guess so far I am the only one experiencing this…

    Link to comment
    coldtech

    Quick update: since having changed the docker volume paths to use /mnt/drivename/appdata instead of /mnt/user/appdata and disabling secondary storage for the appdata share, the issue did not happen again.

     

    Before, it happened about once a day. So I'm strongly suspecting there is indeed some kind of issue with SQLite corruption again, but I can not narrow it down in any way right now. Weird that I seem to be the only one experiencing this.

    Edited by coldtech
    Link to comment


    Join the conversation

    You can post now and register later. If you have an account, sign in now to post with your account.
    Note: Your post will require moderator approval before it will be visible.

    Guest
    Add a comment...

    ×   Pasted as rich text.   Restore formatting

      Only 75 emoji are allowed.

    ×   Your link has been automatically embedded.   Display as a link instead

    ×   Your previous content has been restored.   Clear editor

    ×   You cannot paste images directly. Upload or insert images from URL.

    ×

  • Status Definitions

     

    Open = Under consideration.

     

    Solved = The issue has been resolved.

     

    Solved version = The issue has been resolved in the indicated release version.

     

    Closed = Feedback or opinion better posted on our forum for discussion. Also for reports we cannot reproduce or need more information. In this case just add a comment and we will review it again.

     

    Retest = Please retest in latest release.

    Priority Definitions

     

    Minor = Something not working correctly.

     

    Urgent = Server crash, data loss, or other showstopper.

     

    Annoyance = Doesn't affect functionality but should be fixed.

     

    Other = Announcement or other non-issue.

×
×
  • Create New...