starred/jellyfin
1
0
Fork 0
mirror of https://github.com/jellyfin/jellyfin.git synced 2026-01-23 23:20:51 +01:00
Code Issues 725 Projects Packages Wiki Activity Actions 2

Upgrade from 10.5 to 10.6 fails on MigrateUserDatabase with "SQLite Error 19: 'FOREIGN KEY constraint failed" #2042

New issue
Closed
opened 2025-12-21 20:02:20 +01:00 by backuprepo · 11 comments
backuprepo commented 2025-12-21 20:02:20 +01:00
Owner
Copy link

Originally created by @adamcik on GitHub (Aug 14, 2020).

Originally assigned to: @barronpm on GitHub.

Describe the bug

Jellyfin does not start up after upgrading to 10.6, it is crash looping trying to apply the MigrateUserDatabase step which fails with SQLite Error 19: 'FOREIGN KEY constraint failed.

I've tried skimming over https://github.com/jellyfin/jellyfin/blob/master/Jellyfin.Server/Migrations/Routines/MigrateUserDb.cs, but since I'm not familiar with your code or database schema's it's not obvious where the error is actually being triggered and if I can workaround it (other than wiping all the databases and starting clean).

I would be happy to poke at my sqlite databases if that would help debugging.

System (please complete the following information):

  • OS: Debian 10
  • Virtualization: KVM
  • Clients: Browser, Android, Chromecast
  • Browser: Chrome 84.0.4147.105
  • Jellyfin Version: 10.6.2
  • Playback: n/a
  • Installed Plugins: Open subtitles
  • Reverse Proxy: nginx
  • Base URL: none
  • Networking: Bridge/NAT
  • Storage: NFS

To Reproduce

  1. Perform debian upgrade from 10.5.5-1 to 10.6.2-1
  2. Startup fails on MigrateUserDatabase with SQLite Error 19: 'FOREIGN KEY constraint failed'.

Expected behavior

Migration completes and system starts up.

Logs

[2020-08-13 04:03:49.069 +02:00] [INF] Jellyfin version: "10.6.2"
[2020-08-13 04:03:49.089 +02:00] [INF] Environment Variables: ["[JELLYFIN_WEB_OPT, --webdir=/usr/share/jellyfin/web]", "[JELLYFIN_RESTART_OPT, --restartpath=/usr/lib/jellyfin/restart.sh]", "[JELLYFIN_USER, jellyfin]", "[JELLYFIN_LOG_DIR, /var/log/jellyfin]", "[JELLYFIN_CACHE_DIR, /var/cache/jellyfin]", "[JELLYFIN_ARGS, $JELLYFIN_WEB_OPT $JELLYFIN_RESTART_OPT $JELLYFIN_FFMPEG_OPT $JELLYFIN_SERVICE_OPT $JELLYFIN_NOWEBAPP_OPT]", "[JELLYFIN_DATA_DIR, /var/lib/jellyfin]", "[JELLYFIN_CONFIG_DIR, /etc/jellyfin]", "[JELLYFIN_FFMPEG_OPT, --ffmpeg=/usr/lib/jellyfin-ffmpeg/ffmpeg]"]
[2020-08-13 04:03:49.102 +02:00] [INF] Arguments: ["/usr/lib/jellyfin/bin/jellyfin.dll", "--webdir=/usr/share/jellyfin/web", "--restartpath=/usr/lib/jellyfin/restart.sh", "--ffmpeg=/usr/lib/jellyfin-ffmpeg/ffmpeg", ""]
[2020-08-13 04:03:49.102 +02:00] [INF] Operating system: "Linux"
[2020-08-13 04:03:49.102 +02:00] [INF] Architecture: X64
[2020-08-13 04:03:49.103 +02:00] [INF] 64-Bit Process: True
[2020-08-13 04:03:49.103 +02:00] [INF] User Interactive: True
[2020-08-13 04:03:49.103 +02:00] [INF] Processor count: 1
[2020-08-13 04:03:49.103 +02:00] [INF] Program data path: "/var/lib/jellyfin"
[2020-08-13 04:03:49.103 +02:00] [INF] Web resources path: "/usr/share/jellyfin/web"
[2020-08-13 04:03:49.104 +02:00] [INF] Application directory: "/usr/lib/jellyfin/bin/"
[2020-08-13 04:03:49.217 +02:00] [INF] Setting cache path: "/var/cache/jellyfin"
[2020-08-13 04:03:49.223 +02:00] [INF] Loading assemblies
[2020-08-13 04:03:49.229 +02:00] [INF] Loaded assembly "OpenSubtitlesHandler, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null" from "/var/lib/jellyfin/plugins/Open Subtitles/OpenSubtitlesHandler.dll"
[2020-08-13 04:03:49.231 +02:00] [INF] Loaded assembly "Jellyfin.Plugin.OpenSubtitles, Version=7.0.0.0, Culture=neutral, PublicKeyToken=null" from "/var/lib/jellyfin/plugins/Open Subtitles/Jellyfin.Plugin.OpenSubtitles.dll"
[2020-08-13 04:03:57.223 +02:00] [INF] Applying migration '"MigrateUserDatabase"'
[2020-08-13 04:03:57.227 +02:00] [INF] Migrating the user database may take a while, do not stop Jellyfin.
[2020-08-13 04:03:57.456 +02:00] [ERR] Could not apply migration '"MigrateUserDatabase"'
Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details.
 ---> Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 19: 'FOREIGN KEY constraint failed'.
   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.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader()
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   --- End of inner exception stack trace ---
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChanges(IList`1 entries)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IList`1 entriesToSave)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(DbContext _, Boolean acceptAllChangesOnSuccess)
   at Microsoft.EntityFrameworkCore.Storage.Internal.NoopExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)
   at Jellyfin.Server.Migrations.Routines.MigrateUserDb.Perform()
   at Jellyfin.Server.Migrations.MigrationRunner.Run(CoreAppHost host, ILoggerFactory loggerFactory)
[2020-08-13 04:03:57.461 +02:00] [FTL] Error while starting server.
Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details.
 ---> Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 19: 'FOREIGN KEY constraint failed'.
   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.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader()
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   --- End of inner exception stack trace ---
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChanges(IList`1 entries)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IList`1 entriesToSave)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(DbContext _, Boolean acceptAllChangesOnSuccess)
   at Microsoft.EntityFrameworkCore.Storage.Internal.NoopExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)
   at Jellyfin.Server.Migrations.Routines.MigrateUserDb.Perform()
   at Jellyfin.Server.Migrations.MigrationRunner.Run(CoreAppHost host, ILoggerFactory loggerFactory)
   at Jellyfin.Server.Program.StartApp(StartupOptions options)
[2020-08-13 04:03:57.464 +02:00] [INF] Disposing "CoreAppHost"
[2020-08-13 04:03:57.464 +02:00] [INF] Disposing "ActivityLogWebSocketListener"
[2020-08-13 04:03:57.466 +02:00] [INF] Disposing "SessionInfoWebSocketListener"
[2020-08-13 04:03:57.467 +02:00] [INF] Disposing "ScheduledTasksWebSocketListener"
[2020-08-13 04:03:57.468 +02:00] [INF] Disposing "SessionWebSocketListener"
[2020-08-13 04:03:57.469 +02:00] [INF] Disposing "EmbyTV"
[2020-08-13 04:03:57.470 +02:00] [INF] Received a SIGTERM signal, shutting down

Screenshots

Additional context

This system previously had an Emby install before switching to Jellyfin, I assume there was some auto import / conversion of the databases from it, but I never actively did anything beyond using apt to install jellyfin. So I'm not sure if I started clean at some point and forgot or if this is a converted database.

Originally created by @adamcik on GitHub (Aug 14, 2020). Originally assigned to: @barronpm on GitHub. **Describe the bug** <!-- A clear and concise description of what the bug is. --> Jellyfin does not start up after upgrading to 10.6, it is crash looping trying to apply the `MigrateUserDatabase` step which fails with `SQLite Error 19: 'FOREIGN KEY constraint failed`. I've tried skimming over https://github.com/jellyfin/jellyfin/blob/master/Jellyfin.Server/Migrations/Routines/MigrateUserDb.cs, but since I'm not familiar with your code or database schema's it's not obvious where the error is actually being triggered and if I can workaround it (other than wiping all the databases and starting clean). I would be happy to poke at my sqlite databases if that would help debugging. **System (please complete the following information):** - OS: Debian 10 - Virtualization: KVM - Clients: Browser, Android, Chromecast - Browser: Chrome 84.0.4147.105 - Jellyfin Version: 10.6.2 - Playback: n/a - Installed Plugins: Open subtitles - Reverse Proxy: nginx - Base URL: none - Networking: Bridge/NAT - Storage: NFS **To Reproduce** <!-- Steps to reproduce the behavior: --> 1. Perform debian upgrade from 10.5.5-1 to 10.6.2-1 1. Startup fails on `MigrateUserDatabase` with `SQLite Error 19: 'FOREIGN KEY constraint failed'.` **Expected behavior** <!-- A clear and concise description of what you expected to happen. --> Migration completes and system starts up. **Logs** <!-- Please paste any log errors. --> ``` [2020-08-13 04:03:49.069 +02:00] [INF] Jellyfin version: "10.6.2" [2020-08-13 04:03:49.089 +02:00] [INF] Environment Variables: ["[JELLYFIN_WEB_OPT, --webdir=/usr/share/jellyfin/web]", "[JELLYFIN_RESTART_OPT, --restartpath=/usr/lib/jellyfin/restart.sh]", "[JELLYFIN_USER, jellyfin]", "[JELLYFIN_LOG_DIR, /var/log/jellyfin]", "[JELLYFIN_CACHE_DIR, /var/cache/jellyfin]", "[JELLYFIN_ARGS, $JELLYFIN_WEB_OPT $JELLYFIN_RESTART_OPT $JELLYFIN_FFMPEG_OPT $JELLYFIN_SERVICE_OPT $JELLYFIN_NOWEBAPP_OPT]", "[JELLYFIN_DATA_DIR, /var/lib/jellyfin]", "[JELLYFIN_CONFIG_DIR, /etc/jellyfin]", "[JELLYFIN_FFMPEG_OPT, --ffmpeg=/usr/lib/jellyfin-ffmpeg/ffmpeg]"] [2020-08-13 04:03:49.102 +02:00] [INF] Arguments: ["/usr/lib/jellyfin/bin/jellyfin.dll", "--webdir=/usr/share/jellyfin/web", "--restartpath=/usr/lib/jellyfin/restart.sh", "--ffmpeg=/usr/lib/jellyfin-ffmpeg/ffmpeg", ""] [2020-08-13 04:03:49.102 +02:00] [INF] Operating system: "Linux" [2020-08-13 04:03:49.102 +02:00] [INF] Architecture: X64 [2020-08-13 04:03:49.103 +02:00] [INF] 64-Bit Process: True [2020-08-13 04:03:49.103 +02:00] [INF] User Interactive: True [2020-08-13 04:03:49.103 +02:00] [INF] Processor count: 1 [2020-08-13 04:03:49.103 +02:00] [INF] Program data path: "/var/lib/jellyfin" [2020-08-13 04:03:49.103 +02:00] [INF] Web resources path: "/usr/share/jellyfin/web" [2020-08-13 04:03:49.104 +02:00] [INF] Application directory: "/usr/lib/jellyfin/bin/" [2020-08-13 04:03:49.217 +02:00] [INF] Setting cache path: "/var/cache/jellyfin" [2020-08-13 04:03:49.223 +02:00] [INF] Loading assemblies [2020-08-13 04:03:49.229 +02:00] [INF] Loaded assembly "OpenSubtitlesHandler, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null" from "/var/lib/jellyfin/plugins/Open Subtitles/OpenSubtitlesHandler.dll" [2020-08-13 04:03:49.231 +02:00] [INF] Loaded assembly "Jellyfin.Plugin.OpenSubtitles, Version=7.0.0.0, Culture=neutral, PublicKeyToken=null" from "/var/lib/jellyfin/plugins/Open Subtitles/Jellyfin.Plugin.OpenSubtitles.dll" [2020-08-13 04:03:57.223 +02:00] [INF] Applying migration '"MigrateUserDatabase"' [2020-08-13 04:03:57.227 +02:00] [INF] Migrating the user database may take a while, do not stop Jellyfin. [2020-08-13 04:03:57.456 +02:00] [ERR] Could not apply migration '"MigrateUserDatabase"' Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 19: 'FOREIGN KEY constraint failed'. 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.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) --- End of inner exception stack trace --- at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChanges(IList`1 entries) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IList`1 entriesToSave) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(DbContext _, Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.Storage.Internal.NoopExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess) at Jellyfin.Server.Migrations.Routines.MigrateUserDb.Perform() at Jellyfin.Server.Migrations.MigrationRunner.Run(CoreAppHost host, ILoggerFactory loggerFactory) [2020-08-13 04:03:57.461 +02:00] [FTL] Error while starting server. Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 19: 'FOREIGN KEY constraint failed'. 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.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) --- End of inner exception stack trace --- at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChanges(IList`1 entries) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IList`1 entriesToSave) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(DbContext _, Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.Storage.Internal.NoopExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess) at Jellyfin.Server.Migrations.Routines.MigrateUserDb.Perform() at Jellyfin.Server.Migrations.MigrationRunner.Run(CoreAppHost host, ILoggerFactory loggerFactory) at Jellyfin.Server.Program.StartApp(StartupOptions options) [2020-08-13 04:03:57.464 +02:00] [INF] Disposing "CoreAppHost" [2020-08-13 04:03:57.464 +02:00] [INF] Disposing "ActivityLogWebSocketListener" [2020-08-13 04:03:57.466 +02:00] [INF] Disposing "SessionInfoWebSocketListener" [2020-08-13 04:03:57.467 +02:00] [INF] Disposing "ScheduledTasksWebSocketListener" [2020-08-13 04:03:57.468 +02:00] [INF] Disposing "SessionWebSocketListener" [2020-08-13 04:03:57.469 +02:00] [INF] Disposing "EmbyTV" [2020-08-13 04:03:57.470 +02:00] [INF] Received a SIGTERM signal, shutting down ``` **Screenshots** <!-- If applicable, add screenshots to help explain your problem. --> **Additional context** <!-- Add any other context about the problem here. --> This system previously had an Emby install before switching to Jellyfin, I **assume** there was some auto import / conversion of the databases from it, but I never actively did anything beyond using apt to install jellyfin. So I'm not sure if I started clean at some point and forgot or if this is a converted database.
backuprepo 2025-12-21 20:02:20 +01:00
backuprepo commented 2025-12-21 20:02:24 +01:00
Author
Owner
Copy link

@adamcik commented on GitHub (Aug 14, 2020):

One a side note, I'm not able to downgrade (assuming that would even be safe to do) as it seems the apt repository doesn't provide 10.5 packages any more. It would be nice if the repo could keep the last couple of versions around so people can mitigate by rolling back if something breaks.

@adamcik commented on GitHub (Aug 14, 2020): One a side note, I'm not able to downgrade (assuming that would even be safe to do) as it seems the apt repository doesn't provide 10.5 packages any more. It would be nice if the repo could keep the last couple of versions around so people can mitigate by rolling back if something breaks.
backuprepo commented 2025-12-21 20:02:25 +01:00
Author
Owner
Copy link

@PrplHaz4 commented on GitHub (Aug 14, 2020):

One a side note, I'm not able to downgrade (assuming that would even be safe to do) as it seems the apt repository doesn't provide 10.5 packages any more. It would be nice if the repo could keep the last couple of versions around so people can mitigate by rolling back if something breaks.

Since there were db schema changes during this upgrade, rolling back is not as simple as just getting the old binaries.

If you took a backup of the db, this might help you downgrade: https://github.com/jellyfin/jellyfin-docs/pull/372/files

@PrplHaz4 commented on GitHub (Aug 14, 2020): > > > One a side note, I'm not able to downgrade (assuming that would even be safe to do) as it seems the apt repository doesn't provide 10.5 packages any more. It would be nice if the repo could keep the last couple of versions around so people can mitigate by rolling back if something breaks. Since there were db schema changes during this upgrade, rolling back is not as simple as just getting the old binaries. If you took a backup of the db, this might help you downgrade: https://github.com/jellyfin/jellyfin-docs/pull/372/files
backuprepo commented 2025-12-21 20:02:27 +01:00
Author
Owner
Copy link

@adamcik commented on GitHub (Aug 14, 2020):

Sadly I didn't backup before upgrading, and since this is "just" a VM for jellyfin I never setup any more persistent backup scheme. But thanks for the pointer. I'll leave things in the state they are or at least make a backup before wiping things clean in case it helps the investigation. Loosing the state for what we've watched isn't the end of the world :-)

@adamcik commented on GitHub (Aug 14, 2020): Sadly I didn't backup before upgrading, and since this is "just" a VM for jellyfin I never setup any more persistent backup scheme. But thanks for the pointer. I'll leave things in the state they are or at least make a backup before wiping things clean in case it helps the investigation. Loosing the state for what we've watched isn't the end of the world :-)
backuprepo commented 2025-12-21 20:02:29 +01:00
Author
Owner
Copy link

@adamcik commented on GitHub (Oct 11, 2020):

I've tried debugging, but ended up giving up on this and have purged all the jellyfin data to start fresh :( As such I can't really help reproduce this any longer. So feel free to close this issue if that makes sense.

@adamcik commented on GitHub (Oct 11, 2020): I've tried debugging, but ended up giving up on this and have purged all the jellyfin data to start fresh :( As such I can't really help reproduce this any longer. So feel free to close this issue if that makes sense.
backuprepo commented 2025-12-21 20:02:30 +01:00
Author
Owner
Copy link

@gerroon commented on GitHub (Dec 12, 2020):

These sql schema changes constantly breaking existing databases and upgrades have been a recurring theme. It would be nice if the devs are more careful about this. Iso far wiped my Jellyfin database at least 3 times already.

@gerroon commented on GitHub (Dec 12, 2020): These sql schema changes constantly breaking existing databases and upgrades have been a recurring theme. It would be nice if the devs are more careful about this. Iso far wiped my Jellyfin database at least 3 times already.
backuprepo commented 2025-12-21 20:02:32 +01:00
Author
Owner
Copy link

@cvium commented on GitHub (Apr 9, 2021):

Since this is a data issue we really need access to a database that exhibits this.

@cvium commented on GitHub (Apr 9, 2021): Since this is a data issue we really need access to a database that exhibits this.
backuprepo commented 2025-12-21 20:02:33 +01:00
Author
Owner
Copy link

@wouterla commented on GitHub (Jun 16, 2021):

I'm having this same issue, I think.
I will attach the users.db file, since I'll have to change the passwords anyway.

This is the log:

[23:22:12] [INF] [1] Jellyfin.Server.Migrations.MigrationRunner: Applying migration 'MigrateUserDatabase'
[23:22:12] [INF] [1] Jellyfin.Server.Migrations.Routines.MigrateUserDb: Migrating the user database may take a while, do not stop Jellyfin.
[23:22:14] [ERR] [1] Jellyfin.Server.Migrations.MigrationRunner: Could not apply migration 'MigrateUserDatabase'
Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details.
---> Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 19: 'FOREIGN KEY constraint failed'.
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.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
--- End of inner exception stack trace ---
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection)
at Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChanges(IList`1 entries)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IList`1 entriesToSave)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(DbContext _, Boolean acceptAllChangesOnSuccess)
at Microsoft.EntityFrameworkCore.Storage.NonRetryingExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess)
at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)
at Jellyfin.Server.Migrations.Routines.MigrateUserDb.Perform()
at Jellyfin.Server.Migrations.MigrationRunner.Run(CoreAppHost host, ILoggerFactory loggerFactory)
[23:22:14] [FTL] [1] Main: Error while starting server.
Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details.
---> Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 19: 'FOREIGN KEY constraint failed'.
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.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
--- End of inner exception stack trace ---
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection)
at Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChanges(IList`1 entries)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IList`1 entriesToSave)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(DbContext _, Boolean acceptAllChangesOnSuccess)
at Microsoft.EntityFrameworkCore.Storage.NonRetryingExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess)
at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)
at Jellyfin.Server.Migrations.Routines.MigrateUserDb.Perform()
at Jellyfin.Server.Migrations.MigrationRunner.Run(CoreAppHost host, ILoggerFactory loggerFactory)
at Jellyfin.Server.Program.StartApp(StartupOptions options)
[23:22:14] [INF] [1] Emby.Server.Implementations.ApplicationHost: Disposing CoreAppHost
[23:22:14] [INF] [1] Emby.Server.Implementations.ApplicationHost: Disposing EmbyTV
[23:22:14] [INF] [2] Main: Received a SIGTERM signal, shutting down

users.db.gz

@wouterla commented on GitHub (Jun 16, 2021): I'm having this same issue, I think. I will attach the users.db file, since I'll have to change the passwords anyway. This is the log: ```[23:22:12] [INF] [1] Jellyfin.Server.Migrations.MigrationRunner: Migration 'AddDefaultPluginRepository' applied successfully [23:22:12] [INF] [1] Jellyfin.Server.Migrations.MigrationRunner: Applying migration 'MigrateUserDatabase' [23:22:12] [INF] [1] Jellyfin.Server.Migrations.Routines.MigrateUserDb: Migrating the user database may take a while, do not stop Jellyfin. [23:22:14] [ERR] [1] Jellyfin.Server.Migrations.MigrationRunner: Could not apply migration 'MigrateUserDatabase' Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 19: 'FOREIGN KEY constraint failed'. 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.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) --- End of inner exception stack trace --- at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChanges(IList`1 entries) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IList`1 entriesToSave) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(DbContext _, Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.Storage.NonRetryingExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess) at Jellyfin.Server.Migrations.Routines.MigrateUserDb.Perform() at Jellyfin.Server.Migrations.MigrationRunner.Run(CoreAppHost host, ILoggerFactory loggerFactory) [23:22:14] [FTL] [1] Main: Error while starting server. Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 19: 'FOREIGN KEY constraint failed'. 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.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) --- End of inner exception stack trace --- at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChanges(IList`1 entries) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IList`1 entriesToSave) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(DbContext _, Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.Storage.NonRetryingExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess) at Jellyfin.Server.Migrations.Routines.MigrateUserDb.Perform() at Jellyfin.Server.Migrations.MigrationRunner.Run(CoreAppHost host, ILoggerFactory loggerFactory) at Jellyfin.Server.Program.StartApp(StartupOptions options) [23:22:14] [INF] [1] Emby.Server.Implementations.ApplicationHost: Disposing CoreAppHost [23:22:14] [INF] [1] Emby.Server.Implementations.ApplicationHost: Disposing EmbyTV [23:22:14] [INF] [2] Main: Received a SIGTERM signal, shutting down ``` [users.db.gz](https://github.com/jellyfin/jellyfin/files/6665954/users.db.gz)
backuprepo commented 2025-12-21 20:02:35 +01:00
Author
Owner
Copy link

@ShadwDrgn commented on GitHub (Sep 1, 2022):

has anyone figured this out at all because my jellyfin instance is now down because i tried to upgrade and it's completely broken restarting over and over trying to migrate and crashing :( going from 10.7 to 10.8

@ShadwDrgn commented on GitHub (Sep 1, 2022): has anyone figured this out at all because my jellyfin instance is now down because i tried to upgrade and it's completely broken restarting over and over trying to migrate and crashing :( going from 10.7 to 10.8
backuprepo commented 2025-12-21 20:02:36 +01:00
Author
Owner
Copy link

@knuxbbs commented on GitHub (Apr 23, 2023):

has anyone figured this out at all because my jellyfin instance is now down because i tried to upgrade and it's completely broken restarting over and over trying to migrate and crashing :( going from 10.7 to 10.8

Same here.

@knuxbbs commented on GitHub (Apr 23, 2023): > has anyone figured this out at all because my jellyfin instance is now down because i tried to upgrade and it's completely broken restarting over and over trying to migrate and crashing :( going from 10.7 to 10.8 Same here.
backuprepo commented 2025-12-21 20:02:37 +01:00
Author
Owner
Copy link

@barronpm commented on GitHub (Apr 24, 2023):

has anyone figured this out at all because my jellyfin instance is now down because i tried to upgrade and it's completely broken restarting over and over trying to migrate and crashing :( going from 10.7 to 10.8

So in your logs, MigrateUserDatabase is the one that fails? This migration shouldn't even be running unless you are updating from 10.5 or earlier. What does your migrations.xml look like?

@barronpm commented on GitHub (Apr 24, 2023): > has anyone figured this out at all because my jellyfin instance is now down because i tried to upgrade and it's completely broken restarting over and over trying to migrate and crashing :( going from 10.7 to 10.8 So in your logs, `MigrateUserDatabase` is the one that fails? This migration shouldn't even be running unless you are updating from 10.5 or earlier. What does your migrations.xml look like?
backuprepo commented 2025-12-21 20:02:38 +01:00
Author
Owner
Copy link

@sevenrats commented on GitHub (Oct 5, 2023):

both of these server versions are eol.

@sevenrats commented on GitHub (Oct 5, 2023): both of these server versions are eol.
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
master
renovate/ci-deps
release-10.11.z
renovate/major-swashbuckle-aspnetcore-monorepo
renovate/svg.skia-3.x
explicit-load-v2
explicit-load
renovate/skiasharp-monorepo
only-count-folder-item
openapi-cache
release-10.10.z
release-10.9.z
feature/entity-framework
release-10.8.z
release-10.7.z
EraYaN-add-management-interface
release-10.6.z
release-10.5.z
release-10.4.z
release-10.3.z
release-10.2.z
release-10.1.0
v10.11.6
v10.11.5
v10.11.4
v10.11.3
v10.11.2
v10.11.1
v10.11.0
v10.11.0-rc9
v10.11.0-rc8
v10.11.0-rc7
v10.11.0-rc6
v10.11.0-rc5
v10.11.0-rc4
v10.11.0-rc3
v10.11.0-rc2
v10.11.0-rc1
v10.10.7
v10.10.6
v10.10.5
v10.10.4
v10.10.3
v10.10.2
v10.10.1
v10.10.0
v10.9.11
v10.9.10
v10.9.9
v10.9.8
v10.9.7
v10.9.6
v10.9.5
v10.9.4
v10.9.3
v10.9.2
v10.9.1
v10.9.0
v10.8.13
v10.8.12
v10.8.11
v10.8.10
v10.8.9
v10.8.8
v10.8.7
v10.8.6
v10.8.5
v10.8.4
v10.8.3
v10.8.2
v10.8.1
v10.8.0
v10.8.0-beta3
v10.8.0-beta2
v10.8.0-beta1
v10.8.0-alpha5
v10.8.0-alpha4
v10.8.0-alpha3
v10.8.0-alpha2
v10.8.0-alpha1
v10.7.7
v10.7.6
v10.7.5
v10.7.4
v10.7.3
v10.7.2
v10.7.1
v10.7.0
v10.7.0-rc4
v10.7.0-rc3
v10.7.0-rc2
v10.7.0-rc1
v10.6.4
v10.6.3
v10.6.2
v10.6.1
v10.6.0
v10.5.5
v10.5.4
v10.5.3
v10.5.2
v10.5.1
v10.5.0
v10.4.3
v10.4.2
v10.4.1
v10.4.0
v10.3.7
v10.3.6
v10.3.5
v10.3.4
v10.3.3
v10.3.2
v10.3.1
v10.3.0
v10.3.0-rc2
v10.3.0-rc1
v10.2.2
v10.2.1
v10.2.0
v10.1.0
v10.0.1
v10.0.0
v10.0.2
v3.5.2-5
Labels
Clear labels   
area:database

   
awaiting-feedback

   
backend

   
blocked

   
breaking change: web api

   
bug

   
build

   
ci

   
confirmed

   
discussion needed

   
dotnet future

   
downstream

   
duplicate

   
EFjellyfin.db

   
enhancement

   
feature

   
future

   
github-actions

   
good first issue

   
hdr

   
help wanted

   
invalid

   
investigation

   
librarydb

   
live-tv

   
lyrics

   
media playback

   
music

   
needs testing

   
nuget

   
performance

   
platform

   
pull-request

Mirrored from GitHub Pull Request

  
question

   
regression

   
release critical

   
requires-web

   
roadmap

   
security

   
security

   
stale

   
support

   
syncplay

   
ui & ux

   
upstream

   
wontfix
No labels
area:database
awaiting-feedback
backend
blocked
breaking change: web api
bug
build
ci
confirmed
discussion needed
dotnet future
downstream
duplicate
EFjellyfin.db
enhancement
feature
future
github-actions
good first issue
hdr
help wanted
invalid
investigation
librarydb
live-tv
lyrics
media playback
music
needs testing
nuget
performance
platform
pull-request
question
regression
release critical
requires-web
roadmap
security
security
stale
support
syncplay
ui & ux
upstream
wontfix
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: starred/jellyfin#2042
No description provided.
Delete branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?