Database is locked - Jellyfin 10.9.8

[Ammer Ashraf Emon]

I am facing this issue every few hours "SQLite Error 5: 'database is locked'." When this happens I have to restart the jellyfin service. My media libraries are shared from a NAS and mounted to the VM. I tried to increase the values of ulimit in Linux, but nothing solved this issue. Any help would be appreciated. Thanks.

OS: Ubuntu 22.04 LTS
Jellyfin Version: 10.9.8

Logs:
[2024-08-02 18:01:57.700 +06:00] [ERR] [3675] Microsoft.EntityFrameworkCore.Update: An exception occurred in the database while saving changes for context type '"Jellyfin.Server.Implementations.JellyfinDbContext"'."
""Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details.
---> Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
  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.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
  at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
  at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
  at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)
  --- End of inner exception stack trace ---
  at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken)
  at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
  at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)

[Efficient_Good_5784]

1. Is the drive that Jellyfin's config folder is installed on running out of space?

2. Did you ever upgrade to any v10.9.# release and immediately restart or shut down the server right after the update was done?

[Ammer Ashraf Emon]

1. No it has sufficient available space, more than 200GB
2. I am not sure, I am upgrading to every 10.9 version since the release.

[TheDreadPirate]

Is this from a restart from the dasbharod or from a systemctl restart/stop/start?

And what plugins do you have installed? I had issues with the playback reporting plugin causing occasional database lock issues when initiating a restart from the dashboard.

[Ammer Ashraf Emon]

I restart the jellyfin from the terminal using systemctl restart, I can not access jellyfin web when this happens. Normally when this occurs, the 'thr' number in 'htop' gets higher(I have seen minimum 2000-15000+) and keeps increasing.
I had playback reporting plugin installed previously, to figure out this issue I uninstalled relevant plugins.

I have a VM with 12core and 16GB RAM where Jellyfin is installed, and nothing else is running in this VM.

---

I think I will remove the VM and start everything fresh. It will be a lot of work to reorganize everything again. But I will do it again to solve this issue.