+- Jellyfin Forum (https://forum.jellyfin.org)
+-- Forum: Support (https://forum.jellyfin.org/f-support)
+--- Forum: Troubleshooting (https://forum.jellyfin.org/f-troubleshooting)
+--- Thread: SQLite Error 8: 'attempt to write a readonly database'. (/t-sqlite-error-8-attempt-to-write-a-readonly-database)
Pages:
1
2
RE: SQLite Error 8: 'attempt to write a readonly database'. - drnickriviera - 2023-08-23
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?
RE: SQLite Error 8: 'attempt to write a readonly database'. - TheDreadPirate - 2023-08-23
If it were me, I would backup Jellyfin and reinstall jellyfin as a service.
C:\ProgramData\jellyfin has all the databases and configs.
RE: SQLite Error 8: 'attempt to write a readonly database'. - drnickriviera - 2023-08-23
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.
RE: SQLite Error 8: 'attempt to write a readonly database'. - pongscript - 2025-04-02
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).