• Login
  • Register
  • Login Register
    Login
    Username/Email:
    Password:
    Or login with a social network below
  • Forum
  • Website
  • GitHub
  • Status
  • Translation
  • Features
  • Team
  • Rules
  • Help
  • Feeds
User Links
  • Login
  • Register
  • Login Register
    Login
    Username/Email:
    Password:
    Or login with a social network below

    Useful Links Forum Website GitHub Status Translation Features Team Rules Help Feeds
    Jellyfin Forum Support Troubleshooting SQLite Database Corruption in Jellyfin 10.10.6 - Sudden Failure Without System Change

     
    • 0 Vote(s) - 0 Average

    SQLite Database Corruption in Jellyfin 10.10.6 - Sudden Failure Without System Change

    gvns
    Offline

    Junior Member

    Posts: 9
    Threads: 2
    Joined: 2024 Oct
    Reputation: 0
    #1
    2025-03-05, 03:23 AM (This post was last modified: 2025-03-06, 04:15 AM by gvns. Edited 4 times in total.)
    Environment
    • Unraid Version: 7.0.1
    • Jellyfin Version: 10.10.6
    • Container Source: bbergle-jellyfin container template from https://github.com/BBergle/unraid-templa...llyfin.xml
    • Tailscale 1.80.2


    Issue Description
    My Jellyfin instance has suddenly stopped working - specifically, I cannot get playback to function at all. The system was working normally last night, but today it's failing with database corruption errors. What's particularly concerning is that this happened without any:
    • Power outages
    • Container restarts
    • System updates
    • Manual intervention
    • lack of disk space: (I have plenty)- I have ~11TB free on the share Jellyfin is using, and ~1TB free on its cache drive

    Error Messages
    The primary error I'm seeing is:
    [ERR] Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 11: 'database disk image is malformed'.

    This appears to be a SQLite database corruption issue. Interestingly, I've recently encountered similar SQLite database corruption in other "arr" applications in my stack, suggesting there might be a common underlying cause. In all the other cases, I simply restored from a .bak of the .db though the fact that this is reoccurring across several different containers is concerning. 

    Full log from today:  https://forum.jellyfin.org/attachment.php?aid=6979

    Troubleshooting Attempted
    So far I've identified the error in logs but haven't attempted recovery procedures as I wanted to get community input first.
    I've found some potential recovery commands from this Stack Overflow post that suggest running:

     to check integrity:

    Code:
    sqlite3 library.db "PRAGMA integrity_check;"
     
    and I get the output "ok" - which does not tell me much.


    or to recover (have not tried this yet)

    Code:
    sqlite3 broken.db ".recover" | sqlite3 new.db


    However, I'm hesitant to try these without guidance as they may just be band-aid solutions if there's a more severe underlying issue causing database corruption across multiple applications.

    Questions
    1. Has anyone else experienced spontaneous SQLite corruption in Jellyfin recently?
    2. What's the recommended recovery approach? (Database restore, repair attempt, etc.)
    3. Given that this has happened across multiple applications using SQLite, should I be concerned about underlying storage issues? I have not noted anything else that would indicate a storage problem (regular parity checks succeed)
    4. Are there any known issues with SQLite databases in the bbergle-jellyfin container specifically?

    Additional Information
    - I am using an SSD dedicated for my container appdata - this does make me wonder if that is suspect. The SMART Info does not seem to imply it is at fault.

    Thank you!
    « Next Oldest | Next Newest »

    Users browsing this thread: 1 Guest(s)


    Messages In This Thread
    SQLite Database Corruption in Jellyfin 10.10.6 - Sudden Failure Without System Change - by gvns - 2025-03-05, 03:23 AM
    RE: SQLite Database Corruption in Jellyfin 10.10.6 - Sudden Failure Without System Change - by theguymadmax - 2025-03-05, 03:31 AM
    RE: SQLite Database Corruption in Jellyfin 10.10.6 - Sudden Failure Without System Change - by gvns - 2025-03-05, 03:38 AM
    RE: SQLite Database Corruption in Jellyfin 10.10.6 - Sudden Failure Without System Change - by TheDreadPirate - 2025-03-05, 05:30 PM
    RE: SQLite Database Corruption in Jellyfin 10.10.6 - Sudden Failure Without System Change - by gvns - 2025-03-05, 08:46 PM
    RE: SQLite Database Corruption in Jellyfin 10.10.6 - Sudden Failure Without System Change - by TheDreadPirate - 2025-03-05, 11:55 PM
    RE: SQLite Database Corruption in Jellyfin 10.10.6 - Sudden Failure Without System Change - by gvns - 2025-03-06, 04:14 AM
    RE: SQLite Database Corruption in Jellyfin 10.10.6 - Sudden Failure Without System Change - by Alison Santos - 2025-05-29, 11:33 PM

    • View a Printable Version
    • Subscribe to this thread
    Forum Jump:

    Home · Team · Help · Contact
    © Designed by D&D - Powered by MyBB
    L


    Jellyfin

    The Free Software Media System

    Linear Mode
    Threaded Mode