+- 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
SQLite Error 8: 'attempt to write a readonly database'. - drnickriviera - 2023-08-22
Hi all. I hope you can help me with this problem. I've been using Jellyfin for a few years now with no issues - but I'm not a power-user by any means. I started having some problems with my database (constant spinning circle for days) after having to move my media after a lightning strike took out a computer. Eventually I decided to start from scratch. I totally removed Jellyfin and its install directories and installed version 10.8.10 using the Windows installer.
Now HALF OF THE TIME when Jellyfin starts up it immediately crashes. Basically, Jellyfin starts, immediately crashes, click OK, exit Jellyfin from the tray and restart from the icon and it works fine from that point (although I think if you start stop it again you have to go through the same crash/no crash procedure).
There are no entries in the Jellyfin log but the Windows Event Log shows the following. Does anyone know why this issue is sporadic, more importantly, how to fix it? It's not the end of the world but I'd like to see it go back to working flawlessly. Thanks in advance.
Application: jellyfin.exe
CoreCLR Version: 6.0.1623.17311
.NET Version: 6.0.16
Description: The process was terminated due to an unhandled exception.
Exception Info: Microsoft.Data.Sqlite.SqliteException (0x80004005):
SQLite Error 8: 'attempt to write a readonly database'.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32
rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior
behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQuery(RelationalCommandParameterObject
parameterObject)
at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.ExecuteSqlRaw(DatabaseFacade
databaseFacade, String sql, IEnumerable`1 parameters)
at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.ExecuteSqlRaw(DatabaseFacade
databaseFacade, String sql, Object[] parameters)
at Jellyfin.Server.Program.StartApp(StartupOptions options)
at Jellyfin.Server.Program.<Main>(String[] args)
RE: SQLite Error 8: 'attempt to write a readonly database'. - Venson - 2023-08-22
Hey @drnickriviera
The error "attempt to write a readonly database" usually indicates 2 instances of the jellyfin server running concurrently.
RE: SQLite Error 8: 'attempt to write a readonly database'. - drnickriviera - 2023-08-22
OK. How would I determine that? I ask because I don't see any evidence of that. I only see one instance of Jellyfin in the system tray when this happens.
RE: SQLite Error 8: 'attempt to write a readonly database'. - Venson - 2023-08-22
Did you check on the Task Manager if there is maybe another instance running? Or a Jellyfin as a service?
RE: SQLite Error 8: 'attempt to write a readonly database'. - drnickriviera - 2023-08-22
I added a screen capture to the original post. I don't see anything under services. I see 4 things under "Startup Apps" for Jellyfin - but I don't see anything duplicated. Am I looking in the right place?
RE: SQLite Error 8: 'attempt to write a readonly database'. - Venson - 2023-08-22
Try look at the Details Tab and look for instances of jellyfin server
RE: SQLite Error 8: 'attempt to write a readonly database'. - TheDreadPirate - 2023-08-22
Is jellyfin running as a service or as a user startup app?
RE: SQLite Error 8: 'attempt to write a readonly database'. - drnickriviera - 2023-08-22
OK. Thanks for trying to help me with this. I rebooted the PC to get through the whole process.
PC starts. JellyFin Tray Icon appears.
Error - jellyfin.exe has stopped working (see screenshot SC1)
Task Manager DETAILS shows only one JellyFin running (see screenshot SC2)
Task Manager PROCESSES shows only one Jellyfin running (see screenshot SC3)
Task Manager STARTUP APPS shows four items, no duplicates (see screenshot SC4)
System Tray only shows one instance of Jellyfin running (see screenshot sc5)
Right click the tray icon and exit. Restart from desktop icon and now everything works perfectly.
RE: SQLite Error 8: 'attempt to write a readonly database'. - TheDreadPirate - 2023-08-22
I'm assuming "rkast" is your user? Which tells me this is running as a user startup application.
What happens when you run Jellyfin as administrator?
RE: SQLite Error 8: 'attempt to write a readonly database'. - drnickriviera - 2023-08-22
I feel like we are getting somewhere. Some recent finds:
1) When I run Jellyfin from the desktop shortcut it works fine. (points to "C:\Program Files\Jellyfin\Server\Jellyfin.Windows.Tray.exe")
2) When I try to run Jellyfin from "C:\Program Files\Jellyfin\Server\Jellyfin.Windows.Tray.exe" it crashes.
3) When I run Jellyfin from "C:\Program Files\Jellyfin\Server\Jellyfin.Windows.Tray.exe" as administrator it DOES NOT CRASH
I'm looking at that desktop shortcut that works and I don't see anything indicating that it is running as administrator so I have no idea what the difference could be. Thoughts?