Upgrading version of jellyfin server gives me trouble

[alike]

When i try to upgrade from an older version the migration fails.
Running windows 11.
It wont start at all if my server app is not running as admin. Error code is: 

Code:

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 Emby.Server.Implementations.Data.SqliteExtensions.Execute(SqliteConnection sqliteConnection, String commandText)
  at Emby.Server.Implementations.Data.ManagedConnection.Execute(String commandText)
  at Emby.Server.Implementations.Data.BaseSqliteRepository.Initialize()
  at Emby.Server.Implementations.Data.SqliteItemRepository.Initialize()
  at Emby.Server.Implementations.ApplicationHost.InitializeServices()
  at Jellyfin.Server.Program.StartServer(IServerApplicationPaths appPaths, StartupOptions options, IConfiguration startupConfig)

If i change the tray app shortcut to run as admin i can start the server app, but when im inside the app doesnt have access to my RAR2FS network drives. 
When looking at the rar2fs folder permissions they do look weird. But it worked before.

I was struggling with this earlier. I almost threw the whole project down the drain and wanted to get back paying for netflix and all that crap. But i finally got it to work. But since then, each time i have tried to upgrade version, this happened. https://forum.jellyfin.org/t-solved-jell...5#pid39765

[TheDreadPirate]

Can you share your full jellyfin logs pre-upgrade and post-upgrade via privatebin.net?

[alike]

I tried installing jellyfin server as a service, same problem that it cant find my rar2fs drives. Both as network service user and local service user.
I tried changing the network service user to the same user that should have access to the rar2fs folder, but i get the same result.

I installed rar2fs according to this manual, and it gives my user these rights to the rar2fs folders. https://github.com/hasse69/rar2fs/wiki/Windows-HOWTO

[alike]

Can you share your full jellyfin logs pre-upgrade and post-upgrade via privatebin.net?

Unfortunately the log only goes to today at 15:56. No idea why, could be i by mistake or design changed how long back it keeps them.

https://privatebin.net/?a0f9cf4781cb5016...QxpyHqWrSb

[TheDreadPirate]

Try renaming the playback reporting plugin DB. Pretty sure it is in C:\ProgramData\Jellyfin\Server\data

Rename playback_reporting.db to playback_reporting.db.old or something like that.

[alike]

Try renaming the playback reporting plugin DB.  Pretty sure it is in C:\ProgramData\Jellyfin\Server\data

Rename playback_reporting.db to playback_reporting.db.old or something like that.

I did this. After starting the server back up i checked but i don't see any difference. What are your thoughs?

[TheDreadPirate]

You still see a database error? Exact same one?

[alike]

You still see a database error?  Exact same one?

SQLite Error is gone after this. But this only came when i was not running the server(Jellyfin.Windows.Tray.exe) in admin mode.
I will try running it in non-admin mode again and see if the results change. Looks like the issue with not finding those Rar2FS drives is only when i run the server in admin mode. But i am not 100% sure as i don't remember which version i had from before the upgrade to reinstall old version and check.

Edit: When i changed the service to run a user without admin rights, the app won't start. The log does not create any input, so i think im going to try to reinstall the app in "normal way" again to see if i can see the error message. Im almost sure that this is the "SQLite error" that is kicking in again.

[alike]

I cant even start the app this way. It does not care to write logs when it fails. Last log entry is:
[2025-03-04 16:51:29.308 +01:00] [INF] [10] Emby.Server.Implementations.ApplicationHost: Disposing "PluginManager"

Running the file in admin mode and im back right in. But without rights to see the rar2fs drives. Log:
https://privatebin.net/?d513244216100c70...KEfYnxx9qF

[TheDreadPirate]

Does it write logs in a different directory when run as a service? I'm not even sure where to look to figure that out. Event viewer?