• SQLite Database corruption issues


    onyx00
    • Minor

    Running Unraid 6.8.3 I was receiving "database locked" SQLite exceptions whenever Sonarr or Radarr tried to import a completed download.  I tried numerous things from ensuring the dockers were only on a cache drive, to checking my paths, etc.  I believe I finally found the issue after stumbling on this thread for pre-release testing: SQLITE DATA CORRUPTION TESTING.  

     

    Following the advice in this thread I changed Settings/Disk Settings/'Tunable (scheduler)' to 'none'.  Since I had taken the array down I also took the opportunity to re-format my cache drive to XFS.  Everything seems to be working perfectly now, no errors in Sonarr and Radarr with numerous downloads completed.

     

    I wanted to submit this because the reference thread mentioned this was an issue for SQLite databases on the array, however I was observing the same issue on my cache drive.  My Unraid has undergone several upgrades from all the way to 4.x so my situation could be a corner case due to old settings, etc.  Anyway, just wanted to report this in case it is helpful, and especially in case others hit this as I spent far too much time trying to figure this out (and re-installing all my dockers 😪).



    User Feedback

    Recommended Comments

    There are no comments to display.



    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.