• 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
    TheDreadPirate
    Offline

    Community Moderator

    Posts: 15,374
    Threads: 10
    Joined: 2023 Jun
    Reputation: 460
    Country:United States
    #2
    2023-07-27, 08:24 PM
    At this point I would move, not delete, the entire jellyfin config directory and start from scratch. Who knows what was corrupted when it ran out of storage. There could be a lot more partially written files than just the DB files.
    Jellyfin 10.10.7 (Docker)
    Ubuntu 24.04.2 LTS w/HWE
    Intel i3 12100
    Intel Arc A380
    OS drive - SK Hynix P41 1TB
    Storage
        4x WD Red Pro 6TB CMR in RAIDZ1
    [Image: GitHub%20Sponsors-grey?logo=github]
    « Next Oldest | Next Newest »

    Users browsing this thread: 1 Guest(s)


    • 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