• Login
  • Register
  • Login Register
    Login
    Username/Email:
    Password:
    Or login with a social network below
  • Forum
  • Website
  • GitHub
  • Status
  • Translation
  • Features
  • Team
  • Rules
  • Help
  • Feeds
User Links
  • Login
  • Register
  • Login Register
    Login
    Username/Email:
    Password:
    Or login with a social network below

    Useful Links Forum Website GitHub Status Translation Features Team Rules Help Feeds
    Jellyfin Forum Support Troubleshooting SQLite Error: database is locked

     
    • 0 Vote(s) - 0 Average

    SQLite Error: database is locked

    ---> Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 5: 'database is locked'.
    happyvoid
    Offline

    Junior Member

    Posts: 24
    Threads: 8
    Joined: 2023 Jun
    Reputation: 0
    #1
    2024-06-11, 04:52 AM (This post was last modified: 2024-06-14, 11:15 AM by Venson. Edited 2 times in total.)
    After using SynoCommunity packager for a few years with 10.8 running ok, after runnnig into issues with 10.9 switched to Docker setup on a Synology 218+.

    This is a new setup using the following docker_compose.yml file:

    Code:
    services:
      jellyfin:
        container_name: jellyfin
        image: jellyfin/jellyfin
        ports:
          - "8096:8096"
        environment:
          - PUID=UID_GOES_HERE (this is the actual UID)
          - PGID=100
          - UMASK=002
          - TZ=Europe/Berlin
        volumes:
          - /volume1/docker/jellyfin:/config
          - /volume1/Share1:/Share1:ro
          - /volume1/Share2:/Share2ro
          - /volume1/Share3:/Share3:ro
        devices:
          - /dev/dri:/dev/dri

    Added folders from the three different shares to Library. Let Jellyfin sit, scan and do it's thing for a few days.

    It seems scans and Audio Normalisation have finished. But whenever trying to access Jellyfin there is a lot of audible accessing going on on the NAS to the point where everything seems to lockup (two hhds on a 218+, no NVMe). Clicking menu items e.g. like Scheduled Tasks just shows the spinner and no info ever loads. Same is true trying to access home. Sometimes the items load, but it is slow to a point where the library is not usable.

    Looking at the logs, database is locked does not sound great:

    Code:
    [2024-06-11 06:23:54.110 +02:00] [ERR] [279] 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.SqliteDataReader.NextResult()
      at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
      at Microsoft.Data.Sqlite.SqliteConnectionExtensions.ExecuteNonQuery(SqliteConnection connection, String commandText, SqliteParameter[] parameters)
      at Microsoft.Data.Sqlite.SqliteTransaction..ctor(SqliteConnection connection, IsolationLevel isolationLevel, Boolean deferred)
      at System.Data.Common.DbConnection.BeginDbTransactionAsync(IsolationLevel isolationLevel, CancellationToken cancellationToken)
    --- End of stack trace from previous location ---

    More log: https://bin.disroot.org/?ce008bc32593b7a...SeDgtnf98N (1 month)

    Was unsure about
    Code:
    [2024-06-11 06:13:45.194 +02:00] [INF] [257] Jellyfin.Api.Auth.CustomAuthenticationHandler: "CustomAuthentication" was not authenticated. Failure message: "Invalid token."
    so tried logging out the old login on some devices and setting up the server and user again.

    Any idea what I am doing wrong or why the NAS chokes up? I know this isn't an ideal setup performance wise. But in the past this worked on acceptable level using v10.8 and the SynoCommunity package.
    Go to solution
    « Next Oldest | Next Newest »

    Users browsing this thread: 1 Guest(s)


    Messages In This Thread
    SQLite Error: database is locked - by happyvoid - 2024-06-11, 04:52 AM
    RE: SQLite Error: database is locked - by crobibero - 2024-06-11, 09:34 AM
    RE: SQLite Error: database is locked - by happyvoid - 2024-06-11, 11:37 AM
    RE: SQLite Error: database is locked - by pcm - 2024-06-11, 06:21 PM
    RE: SQLite Error: database is locked - by happyvoid - 2024-06-14, 10:30 AM
    RE: SQLite Error: database is locked - by gnattu - 2024-06-14, 04:00 PM

    • View a Printable Version
    • Subscribe to this thread
    Forum Jump:

    Home · Team · Help · Contact
    © Designed by D&D - Powered by MyBB
    L


    Jellyfin

    The Free Software Media System

    Linear Mode
    Threaded Mode