• 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 SOLVED: Database table randomly locking

     
    • 0 Vote(s) - 0 Average

    SOLVED: Database table randomly locking

    Database table randomly locking
    magguzu
    Offline

    Junior Member

    Posts: 23
    Threads: 3
    Joined: 2024 Jul
    Reputation: 0
    Country:United States
    #1
    2024-07-17, 05:57 AM
    Hi folks! Since today my server has become intermittedly unresponsive. When it happens it seems to be related to database locking
    Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details.

    ---> Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 6: 'database table 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 ---

    I'm not entireley sure but this seems related:
    https://github.com/jellyfin/jellyfin/pull/11901

    In the meantime can anyone recommend temporary fixes? Any plugins to disable, schedule restarts, etc? This wasn't occurring before today.
    Running 10.9.7 which I upgraded to from 10.9.6 today where it was also occurring.
    Go to solution
    « Next Oldest | Next Newest »

    Users browsing this thread: 1 Guest(s)


    Messages In This Thread
    Database table randomly locking - by magguzu - 2024-07-17, 05:57 AM
    RE: Database table randomly locking - by Efficient_Good_5784 - 2024-07-17, 10:08 AM
    RE: Database table randomly locking - by magguzu - 2024-07-17, 01:36 PM
    RE: Database table randomly locking - by TheDreadPirate - 2024-07-17, 03:04 PM
    RE: Database table randomly locking - by magguzu - 2024-07-17, 04:06 PM
    RE: Database table randomly locking - by TheDreadPirate - 2024-07-17, 04:17 PM
    RE: Database table randomly locking - by magguzu - 2024-07-17, 04:33 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