SQLite Error 5: 'database is locked'.

[Lion-Soul]

Hi
I Had Som Problem with my Jellyfin on docker Server

All is ok on can run it but on login page the system freese and i see on log

SQLite Error 5: 'database is locked'.

This is a jellyfin with a remote config file :

my docker compose

Code:

services:
  jellyfin:
    image: jellyfin/jellyfin:latest
    container_name: Jellyfin
    user: 1000:1000
    group_add:
      - '992'   
    environment:
      TZ: Europe/Paris
    healthcheck:
      test: timeout 10s bash -c ':> /dev/tcp/127.0.0.1/8096' || exit 1
      interval: 10s
      timeout: 5s
      retries: 3
      start_period: 90s
    volumes:
      - jellyfin-config:/config:rw
      - /home/lion-soul/Documents/docker/jellyfin/cache:/cache:rw
      - jellyfin-media:/media:rw
      - jellyfin-logs:/logs:rw
      - jellyfin-rmedia:/remote_media:rw
    restart: on-failure:5
    network_mode: host
    devices:
      - /dev/dri/renderD128:/dev/dri/renderD128
volumes:
  jellyfin-media:
        driver_opts:
          type: cifs
          o: username=Docker,password=*****,uid=1000,gid=1000,vers=3.0
          device: //192.168.50.30/Media
  jellyfin-rmedia:
        driver_opts:
          type: cifs
          o: username=Docker,password=*****,uid=1000,gid=1000,vers=3.0
          device: //192.168.50.30/usbshare1/Media
  jellyfin-config:
        driver_opts:
          type: cifs
          o: username=Docker,password=*****,uid=1000,gid=1000,vers=3.0
          device: //192.168.50.30/docker/jellyfin/config
  jellyfin-logs:
        driver_opts:
          type: cifs
          o: username=Docker,password=*****,uid=1000,gid=1000,vers=3.0
          device: //192.168.50.30/docker/jellyfin/logs

My container logs

Code:

[20:13:05] [ERR] [18] Jellyfin.Api.Middleware.ExceptionMiddleware: Error processing request. URL POST /Users/authenticatebyname.
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.ExecuteNonQuery()
  at Microsoft.Data.Sqlite.SqliteConnectionExtensions.ExecuteNonQuery(SqliteConnection connection, String commandText, SqliteParameter[] parameters)
  at Microsoft.Data.Sqlite.SqliteTransaction.Commit()
  at System.Data.Common.DbTransaction.CommitAsync(CancellationToken cancellationToken)
--- End of stack trace from previous location ---
  at Microsoft.EntityFrameworkCore.Storage.RelationalTransaction.CommitAsync(CancellationToken cancellationToken)
  at Microsoft.EntityFrameworkCore.Storage.RelationalTransaction.CommitAsync(CancellationToken cancellationToken)
  at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
  at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
  at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable`1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken)
  at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList`1 entriesToSave, CancellationToken cancellationToken)
  at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(StateManager stateManager, Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
  at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
  at Microsoft.EntityFrameworkCore.DbContext.SaveChangesAsync(Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken)
  at Jellyfin.Server.Implementations.Users.UserManager.UpdateUserInternalAsync(JellyfinDbContext dbContext, User user)
  at Jellyfin.Server.Implementations.Users.UserManager.UpdateUserAsync(User user)
  at Jellyfin.Server.Implementations.Users.UserManager.UpdateUserAsync(User user)
  at Jellyfin.Server.Implementations.Users.UserManager.IncrementInvalidLoginAttemptCount(User user)
  at Jellyfin.Server.Implementations.Users.UserManager.AuthenticateUser(String username, String password, String remoteEndPoint, Boolean isUserSession)
  at Emby.Server.Implementations.Session.SessionManager.AuthenticateNewSessionInternal(AuthenticationRequest request, Boolean enforcePassword)
  at Jellyfin.Api.Controllers.UserController.AuthenticateUserByName(AuthenticateUserByName request)
  at lambda_method584(Closure, Object)
  at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
  at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
  at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
  at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
  at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
  at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync()
--- End of stack trace from previous location ---
  at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextResourceFilter>g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
  at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context)
  at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
  at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.InvokeFilterPipelineAsync()
--- End of stack trace from previous location ---
  at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)
  at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)
  at Jellyfin.Api.Middleware.ServerStartupMessageMiddleware.Invoke(HttpContext httpContext, IServerApplicationHost serverApplicationHost, ILocalizationManager localizationManager)
  at Jellyfin.Api.Middleware.WebSocketHandlerMiddleware.Invoke(HttpContext httpContext, IWebSocketManager webSocketManager)
  at Jellyfin.Api.Middleware.IPBasedAccessValidationMiddleware.Invoke(HttpContext httpContext, INetworkManager networkManager)
  at Jellyfin.Api.Middleware.LanFilteringMiddleware.Invoke(HttpContext httpContext, INetworkManager networkManager, IServerConfigurationManager serverConfigurationManager)
  at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context)
  at Jellyfin.Api.Middleware.QueryStringDecodingMiddleware.Invoke(HttpContext httpContext)
  at Swashbuckle.AspNetCore.ReDoc.ReDocMiddleware.Invoke(HttpContext httpContext)
  at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIMiddleware.Invoke(HttpContext httpContext)
  at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext, ISwaggerProvider swaggerProvider)
  at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
  at Jellyfin.Api.Middleware.RobotsRedirectionMiddleware.Invoke(HttpContext httpContext)
  at Jellyfin.Api.Middleware.LegacyEmbyRouteRewriteMiddleware.Invoke(HttpContext httpContext)
  at Microsoft.AspNetCore.ResponseCompression.ResponseCompressionMiddleware.InvokeCore(HttpContext context)
  at Jellyfin.Api.Middleware.ResponseTimeMiddleware.Invoke(HttpContext context, IServerConfigurationManager serverConfigurationManager)
  at Jellyfin.Api.Middleware.ExceptionMiddleware.Invoke(HttpContext context)
[20:13:44] [DBG] [8] Jellyfin.Plugin.Webhook.Notifiers.ItemDeletedNotifier.ItemDeletedManager: ProcessItemsAsync
[20:13:44] [INF] [8] Emby.Server.Implementations.ScheduledTasks.TaskManager: Webhook Item Deleted Notifier Completed after 0 minute(s) and 0 seconds
[20:13:44] [DBG] [8] Jellyfin.Plugin.Webhook.Notifiers.ItemAddedNotifier.ItemAddedManager: ProcessItemsAsync
[20:13:44] [INF] [8] Emby.Server.Implementations.ScheduledTasks.TaskManager: Webhook Item Added Notifier Completed after 0 minute(s) and 0 seconds
[20:15:00] [INF] [31] Jellyfin.Api.Auth.CustomAuthenticationHandler: CustomAuthentication was not authenticated. Failure message: Invalid token.
[20:15:00] [INF] [31] Jellyfin.Api.Auth.CustomAuthenticationHandler: CustomAuthentication was not authenticated. Failure message: Invalid token.
[20:15:00] [INF] [31] Jellyfin.Api.Auth.CustomAuthenticationHandler: AuthenticationScheme: CustomAuthentication was challenged.
[20:15:15] [DBG] [32] Jellyfin.Plugin.Webhook.Notifiers.ItemDeletedNotifier.ItemDeletedManager: ProcessItemsAsync
[20:15:15] [INF] [32] Emby.Server.Implementations.ScheduledTasks.TaskManager: Webhook Item Deleted Notifier Completed after 0 minute(s) and 0 seconds
[20:15:15] [DBG] [32] Jellyfin.Plugin.Webhook.Notifiers.ItemAddedNotifier.ItemAddedManager: ProcessItemsAsync
[20:15:15] [INF] [32] Emby.Server.Implementations.ScheduledTasks.TaskManager: Webhook Item Added Notifier Completed after 0 minute(s) and 0 seconds
[20:16:46] [DBG] [32] Jellyfin.Plugin.Webhook.Notifiers.ItemDeletedNotifier.ItemDeletedManager: ProcessItemsAsync
[20:16:46] [INF] [32] Emby.Server.Implementations.ScheduledTasks.TaskManager: Webhook Item Deleted Notifier Completed after 0 minute(s) and 0 seconds
[20:16:46] [DBG] [32] Jellyfin.Plugin.Webhook.Notifiers.ItemAddedNotifier.ItemAddedManager: ProcessItemsAsync
[20:16:46] [INF] [32] Emby.Server.Implementations.ScheduledTasks.TaskManager: Webhook Item Added Notifier Completed after 0 minute(s) and 0 seconds

Can you help me?

[bitmap]

As far as I know, DB locking on current versions is akin to DB corruption. You may be able to salvage if you have the skills to play with the DB, but this generally means there was an unexpected event while the DB was being written to (e.g., power outage, hard reset). I believe 10.11 is supposed to help with issues like this, but we're still a ways away from seeing a full release.

[Lion-Soul]

The db work with an other container jellyfin with local paths (no at the same time)

I had a corrupt db yestyrday and i ha repared the jellyfin.db file

May i must make a full new install for see?