• 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 Server crashed on SQL access

     
    • 0 Vote(s) - 0 Average

    Server crashed on SQL access

    Server crashed and won't restart
    Idanr
    Offline

    Junior Member

    Posts: 1
    Threads: 1
    Joined: 2023 Jul
    Reputation: 0
    Country:Israel
    #1
    2023-07-27, 08:07 PM
    I'm running jellyfin in a docker environment on my OMV server. I've let my server run out of storage which I assume caused the issue. The server became unavailable, and after restarting it started complaining about invalid XML file (0,0) during migration. I've deleted migrations.xml and tried again, but this time got an SQL error.
    I've tried deleting all the db files - jellyfin, library, library-journal, and migrations.xml again, and no dice. Jellyfin creates the again on restart and showes the same issue. 
    Here is the issue from the log:
    Code:
    [ERR] [1] Jellyfin.Server.Migrations.MigrationRunner: Could not apply migration 'MigrateActivityLogDatabase'
    CannotOpen: SQLitePCL.pretty.SQLiteException: unable to open database file
      at SQLitePCL.pretty.SQLiteException.Throw(Int32 rc, Int32 extended, String msg)
      at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
      at SQLitePCL.pretty.SQLiteDatabaseConnectionBuilder.Build()
      at Jellyfin.Server.Migrations.Routines.MigrateActivityLogDb.Perform()
      at Jellyfin.Server.Migrations.MigrationRunner.PerformMigrations(IMigrationRoutine[] migrations, MigrationOptions migrationOptions, Action`1 saveConfiguration, ILogger logger)
    [19:54:48] [FTL] [1] Main: Error while starting server.
    CannotOpen: SQLitePCL.pretty.SQLiteException: unable to open database file
      at SQLitePCL.pretty.SQLiteException.Throw(Int32 rc, Int32 extended, String msg)
      at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
      at SQLitePCL.pretty.SQLiteDatabaseConnectionBuilder.Build()
      at Jellyfin.Server.Migrations.Routines.MigrateActivityLogDb.Perform()
      at Jellyfin.Server.Migrations.MigrationRunner.PerformMigrations(IMigrationRoutine[] migrations, MigrationOptions migrationOptions, Action`1 saveConfiguration, ILogger logger)
      at Jellyfin.Server.Migrations.MigrationRunner.Run(CoreAppHost host, ILoggerFactory loggerFactory)
      at Jellyfin.Server.Program.StartApp(StartupOptions options)
    [19:54:48] [INF] [1] Main: Running query planner optimizations in the database... This might take a while
    [19:54:48] [INF] [1] Emby.Server.Implementations.ApplicationHost: Disposing CoreAppHost
    [19:54:48] [INF] [1] Emby.Server.Implementations.ApplicationHost: Disposing SchedulesDirect
    [19:54:48] [INF] [1] Emby.Server.Implementations.ApplicationHost: Disposing MusicBrainzAlbumProvider
    [19:54:48] [INF] [1] Emby.Server.Implementations.ApplicationHost: Disposing EmbyTV
    [19:54:48] [INF] [2] Main: Received a SIGTERM signal, shutting down
    [19:54:50] [INF] [1] Main: Jellyfin version: 10.8.10
    « Next Oldest | Next Newest »

    Users browsing this thread: 1 Guest(s)


    Messages In This Thread
    Server crashed on SQL access - by Idanr - 2023-07-27, 08:07 PM
    RE: Server crashed on SQL access - by TheDreadPirate - 2023-07-27, 08:24 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