• 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 Error 8: 'attempt to write a readonly database'.

    Pages (2): « Previous 1 2

     
    • 0 Vote(s) - 0 Average

    SQLite Error 8: 'attempt to write a readonly database'.

    Windows/Jellyfin issue: SQLite Error 8: 'attempt to write a readonly database'.
    drnickriviera
    Offline

    Junior Member

    Posts: 11
    Threads: 2
    Joined: 2023 Aug
    Reputation: 0
    Country:United States
    #11
    2023-08-23, 12:26 PM
    Any more help to be offered? Here is what we know.

    Jellyfin crashes on computer startup (not good).
    If I run "C:\Program Files\Jellyfin\Server\Jellyfin.Windows.Tray.exe" it crashes.
    If I run the desktop shortcut to "C:\Program Files\Jellyfin\Server\Jellyfin.Windows.Tray.exe" it DOES NOT crash.
    When I run Jellyfin from "C:\Program Files\Jellyfin\Server\Jellyfin.Windows.Tray.exe" as administrator it DOES NOT CRASH.
    I don't see the shortcut running the program as administrator.
    I don't really want to set "C:\Program Files\Jellyfin\Server\Jellyfin.Windows.Tray.exe" to always run as administrator because it requires an "OK" click every time.

    So what could be different about that shortcut?
    TheDreadPirate
    Offline

    Community Moderator

    Posts: 15,375
    Threads: 10
    Joined: 2023 Jun
    Reputation: 460
    Country:United States
    #12
    2023-08-23, 03:33 PM
    If it were me, I would backup Jellyfin and reinstall jellyfin as a service.

    C:\ProgramData\jellyfin has all the databases and configs.
    Jellyfin 10.10.7 (Docker)
    Ubuntu 24.04.2 LTS w/HWE
    Intel i3 12100
    Intel Arc A380
    OS drive - SK Hynix P41 1TB
    Storage
        4x WD Red Pro 6TB CMR in RAIDZ1
    [Image: GitHub%20Sponsors-grey?logo=github]
    drnickriviera
    Offline

    Junior Member

    Posts: 11
    Threads: 2
    Joined: 2023 Aug
    Reputation: 0
    Country:United States
    #13
    2023-08-23, 06:35 PM
    I'd rather not go that route just because if I end up having the same issue it'll be even more of a pain to get jellyfin started every time. Thanks though.
    pongscript
    Offline

    Junior Member

    Posts: 1
    Threads: 0
    Joined: 2025 Apr
    Reputation: 0
    Country:Philippines
    #14
    2025-04-02, 10:31 PM
    I did encounter this, after modifying the library.db using sql lite editor(to remove duplicates). though I created a backup before modifying anything. then when i encounter this error I tried to revert back to original library.db, but still got same error.

    what i found out that the permission on the file was altered somehow. So I go to File Properties->SecurityTab->Advanced
    then change the owner to NETWORK SERVICE, I am running it as a service but if you are running it as a user-startup-app, then you might need to check the order file in the folder to get the correct owner.

    if all else fail, just add "everyone" with all permission(this is generally safe as long as the parent folder is still have proper permission). you still need to inherit the parent folders permission, this will be an additional permission on top for this specific file. but if you could identify the correct user that would be preferrable.

    you might also need to shutdown jellyfin first, or restart it after the modification, I always shutdown jellyfin before I do anything on the files, to ensure I wont get a race event(where jellyfin is trying to do something on the file and I will get an outdated file in the end due to that).
    Petrus Vermaak
    Offline

    Junior Member

    Posts: 3
    Threads: 0
    Joined: 2025 Apr
    Reputation: 0
    #15
    2025-04-28, 06:32 AM
    solved here: https://forum.jellyfin.org/t-solved-sqli...y-database
    Pages (2): « Previous 1 2

    « Next Oldest | Next Newest »

    Users browsing this thread: 1 Guest(s)


    • 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