+- Jellyfin Forum (https://forum.jellyfin.org)
+-- Forum: Support (https://forum.jellyfin.org/f-support)
+--- Forum: Troubleshooting (https://forum.jellyfin.org/f-troubleshooting)
+--- Thread: Database Update to 10.11.2 fails (/t-database-update-to-10-11-2-fails)
Database Update to 10.11.2 fails - nerdnils - 2025-11-11
Hi there,
I migrated my raspberry pi 4 from buster to trixie and now i want to install jellyfin again/restore my backup into the new installation.
The jellyfin server seems to try to update my database but fails because there is a table missing in the database. How to fix the error/how
to update the database correctly?
Here is the relevant log, please ask if you need any more information!
[2025-11-11 17:18:33.334 +01:00] [INF] Migration "20241112232041_FixMediaStreams" was successfully applied
[2025-11-11 17:18:33.335 +01:00] [INF] Perform migration "20241112234144_FixMediaStreams2"
[2025-11-11 17:18:33.608 +01:00] [INF] Migration "20241112234144_FixMediaStreams2" was successfully applied
[2025-11-11 17:18:33.609 +01:00] [INF] Perform migration "20241113133548_EnforceUniqueItemValue"
[2025-11-11 17:18:33.732 +01:00] [INF] Migration "20241113133548_EnforceUniqueItemValue" was successfully applied
[2025-11-11 17:18:33.733 +01:00] [INF] Perform migration "20250202021306_FixedCollation"
[2025-11-11 17:18:33.940 +01:00] [INF] Migration "20250202021306_FixedCollation" was successfully applied
[2025-11-11 17:18:33.941 +01:00] [INF] Perform migration "20250204092455_MakeStartEndDateNullable"
[2025-11-11 17:18:34.174 +01:00] [INF] Migration "20250204092455_MakeStartEndDateNullable" was successfully applied
[2025-11-11 17:18:34.175 +01:00] [INF] Perform migration "20250214031148_ChannelIdGuid"
[2025-11-11 17:18:34.281 +01:00] [INF] Migration "20250214031148_ChannelIdGuid" was successfully applied
[2025-11-11 17:18:34.281 +01:00] [INF] Perform migration "20250326065026_AddInheritedParentalRatingSubValue"
[2025-11-11 17:18:34.401 +01:00] [INF] Migration "20250326065026_AddInheritedParentalRatingSubValue" was successfully applied
[2025-11-11 17:18:34.401 +01:00] [INF] Perform migration "20250327101120_AddKeyframeData"
[2025-11-11 17:18:34.518 +01:00] [INF] Migration "20250327101120_AddKeyframeData" was successfully applied
[2025-11-11 17:18:34.518 +01:00] [INF] Perform migration "20250327171413_AddHdr10PlusFlag"
[2025-11-11 17:18:34.630 +01:00] [INF] Migration "20250327171413_AddHdr10PlusFlag" was successfully applied
[2025-11-11 17:18:34.630 +01:00] [INF] Perform migration "20250331182844_FixAttachmentMigration"
[2025-11-11 17:18:34.835 +01:00] [INF] Migration "20250331182844_FixAttachmentMigration" was successfully applied
[2025-11-11 17:18:34.835 +01:00] [INF] Perform migration "20250401142247_FixAncestors"
[2025-11-11 17:18:34.941 +01:00] [INF] Migration "20250401142247_FixAncestors" was successfully applied
[2025-11-11 17:18:34.941 +01:00] [INF] Perform migration "20250405075612_FixItemValuesIndices"
[2025-11-11 17:18:35.050 +01:00] [INF] Migration "20250405075612_FixItemValuesIndices" was successfully applied
[2025-11-11 17:18:35.050 +01:00] [INF] Perform migration "20250609115616_DetachUserDataInsteadOfDelete"
[2025-11-11 17:18:35.288 +01:00] [INF] Migration "20250609115616_DetachUserDataInsteadOfDelete" was successfully applied
[2025-11-11 17:18:35.289 +01:00] [INF] Perform migration "20250622170802_BaseItemImageInfoDateModifiedNullable"
[2025-11-11 17:18:35.488 +01:00] [INF] Migration "20250622170802_BaseItemImageInfoDateModifiedNullable" was successfully applied
[2025-11-11 17:18:35.488 +01:00] [INF] Perform migration "20250714044826_ResetJournalMode"
[2025-11-11 17:18:35.597 +01:00] [INF] Migration "20250714044826_ResetJournalMode" was successfully applied
[2025-11-11 17:18:35.597 +01:00] [INF] Perform migration "20250913211637_AddProperParentChildRelationBaseItemWithCascade"
[2025-11-11 17:18:35.846 +01:00] [INF] Migration "20250913211637_AddProperParentChildRelationBaseItemWithCascade" was successfully applied
[2025-11-11 17:18:35.846 +01:00] [INF] Perform migration "20250925203415_ExtendPeopleMapKey"
[2025-11-11 17:18:36.049 +01:00] [INF] Migration "20250925203415_ExtendPeopleMapKey" was successfully applied
[2025-11-11 17:18:38.305 +01:00] [INF] Loaded plugin: "TMDb" "10.11.2.0"
[2025-11-11 17:18:38.308 +01:00] [INF] Loaded plugin: "Studio Images" "10.11.2.0"
[2025-11-11 17:18:38.309 +01:00] [INF] Loaded plugin: "OMDb" "10.11.2.0"
[2025-11-11 17:18:38.347 +01:00] [INF] Loaded plugin: "MusicBrainz" "10.11.2.0"
[2025-11-11 17:18:38.348 +01:00] [INF] Loaded plugin: "AudioDB" "10.11.2.0"
[2025-11-11 17:18:38.519 +01:00] [INF] There are 26 migrations for stage AppInitialisation.
[2025-11-11 17:18:38.519 +01:00] [INF] Perform migration "20250420050000_DisableTranscodingThrottling"
[2025-11-11 17:18:38.524 +01:00] [INF] Migration "20250420050000_DisableTranscodingThrottling" was successfully applied
[2025-11-11 17:18:38.525 +01:00] [INF] Perform migration "20250420060000_CreateUserLoggingConfigFile"
[2025-11-11 17:18:38.592 +01:00] [INF] Migration "20250420060000_CreateUserLoggingConfigFile" was successfully applied
[2025-11-11 17:18:38.592 +01:00] [INF] Perform migration "20250420070000_MigrateActivityLogDb"
[2025-11-11 17:18:38.604 +01:00] [WRN] "/var/lib/jellyfin/data/activitylog.db" doesn't exist, nothing to migrate
[2025-11-11 17:18:38.606 +01:00] [INF] Migration "20250420070000_MigrateActivityLogDb" was successfully applied
[2025-11-11 17:18:38.606 +01:00] [INF] Perform migration "20250420080000_RemoveDuplicateExtras"
[2025-11-11 17:18:38.621 +01:00] [FTL] Error: "SQLite Error 1: 'no such table: TypedBaseItems'."
[2025-11-11 17:18:38.622 +01:00] [ERR] Migration "20250420080000_RemoveDuplicateExtras" failed
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: 'no such table: TypedBaseItems'.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements()+MoveNext()
at Microsoft.Data.Sqlite.SqliteCommand.GetStatements()+MoveNext()
at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader()
at Emby.Server.Implementations.Data.SqliteExtensions.Query(SqliteConnection sqliteConnection, String commandText)+MoveNext()
at System.Linq.Enumerable.IEnumerableSelectIterator
2.MoveNext()
at System.String.Join(String separator, IEnumerable1 values)at Jellyfin.Server.Migrations.Routines.RemoveDuplicateExtras.Perform()
at Jellyfin.Server.Migrations.Stages.CodeMigration.Perform(IServiceProvider serviceProvider, IStartupLogger logger, CancellationToken cancellationToken)
at Jellyfin.Server.Migrations.JellyfinMigrationService.InternalCodeMigration.PerformAsync(IStartupLogger logger)
at Jellyfin.Server.Migrations.JellyfinMigrationService.MigrateStepAsync(JellyfinMigrationStageTypes stage, IServiceProvider serviceProvider)
[2025-11-11 17:18:38.641 +01:00] [INF] Attempt to rollback librarydb.
[2025-11-11 17:18:38.641 +01:00] [INF] Attempt to rollback JellyfinDb.
[2025-11-11 17:18:38.672 +01:00] [FTL] Error while starting server
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: 'no such table: TypedBaseItems'.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements()+MoveNext()
at Microsoft.Data.Sqlite.SqliteCommand.GetStatements()+MoveNext()
at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader()
at Emby.Server.Implementations.Data.SqliteExtensions.Query(SqliteConnection sqliteConnection, String commandText)+MoveNext()
at System.Linq.Enumerable.IEnumerableSelectIterator
2.MoveNext()
at System.String.Join(String separator, IEnumerable1 values)at Jellyfin.Server.Migrations.Routines.RemoveDuplicateExtras.Perform()
at Jellyfin.Server.Migrations.Stages.CodeMigration.Perform(IServiceProvider serviceProvider, IStartupLogger logger, CancellationToken cancellationToken)
at Jellyfin.Server.Migrations.JellyfinMigrationService.InternalCodeMigration.PerformAsync(IStartupLogger logger)
at Jellyfin.Server.Migrations.JellyfinMigrationService.MigrateStepAsync(JellyfinMigrationStageTypes stage, IServiceProvider serviceProvider)
at Jellyfin.Server.Migrations.JellyfinMigrationService.MigrateStepAsync(JellyfinMigrationStageTypes stage, IServiceProvider serviceProvider)
at Jellyfin.Server.Migrations.JellyfinMigrationService.MigrateStepAsync(JellyfinMigrationStageTypes stage, IServiceProvider serviceProvider)
at Jellyfin.Server.Program.StartServer(IServerApplicationPaths appPaths, StartupOptions options, IConfiguration startupConfig)
[2025-11-11 17:28:38.736 +01:00] [INF] Running query planner optimizations in the database... This might take a while
[2025-11-11 17:28:38.779 +01:00] [INF] Disposing "CoreAppHost"
[2025-11-11 17:28:38.780 +01:00] [INF] Disposing "MusicBrainzArtistProvider"
[2025-11-11 17:28:38.781 +01:00] [INF] Disposing "MusicBrainzAlbumProvider"
[2025-11-11 17:28:38.782 +01:00] [INF] Disposing "PluginManager"
RE: Database Update to 10.11.2 fails - kandykarter - 2025-11-11
What version of Jellyfin were you updating from?
RE: Database Update to 10.11.2 fails - nerdnils - 2025-11-11
I don't know for sure. Any way to find out using the backup? I have /etc/jellyfin including all contents and the database.
@kandykarter is Jellyfin Web in the database the verion of the server or the browser? If it is the server it looks like it is 10.10.8
RE: Database Update to 10.11.2 fails - kandykarter - 2025-11-11
I'm not sure how to find the version from your backup, but I'm pretty sure there was no 10.10.8, I think the 10.10 line topped out at 10.10.7.
The reason I ask is the 10.11 branch can *only* be updated to by 10.10.7, so if you were using something older, that could be the source of your trouble.
RE: Database Update to 10.11.2 fails - nerdnils - 2025-11-11
(3 hours ago)kandykarter Wrote: I'm not sure how to find the version from your backup, but I'm pretty sure there was no 10.10.8, I think the 10.10 line topped out at 10.10.7.
The reason I ask is the 10.11 branch can *only* be updated to by 10.10.7, so if you were using something older, that could be the source of your trouble.
Sadly, no. Just downgraded to 10.10.7 using https://repo.jellyfin.org/?path=/server/debian/previous-stable/arm64 and still getting the same error:
[2025-11-11 18:16:04.809 +01:00] [FTL] Error while starting server
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: 'no such table: ActivityLog'.
at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements()+MoveNext()
at Microsoft.Data.Sqlite.SqliteCommand.GetStatements()+MoveNext()
at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader()
at Emby.Server.Implementations.Data.SqliteExtensions.Query(SqliteConnection sqliteConnection, String commandText)+MoveNext()
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.StartServer(IServerApplicationPaths appPaths, StartupOptions options, IConfiguration startupConfig)
[2025-11-11 18:16:04.811 +01:00] [INF] Running query planner optimizations in the database... This might take a while
[2025-11-11 18:16:04.860 +01:00] [INF] Disposing "CoreAppHost"
[2025-11-11 18:16:04.863 +01:00] [INF] Disposing "MusicBrainzArtistProvider"
[2025-11-11 18:16:04.865 +01:00] [INF] Disposing "MusicBrainzAlbumProvider"
[2025-11-11 18:16:04.866 +01:00] [INF] Disposing "PluginManager"
[2025-11-11 18:16:28.132 +01:00] [INF] Jellyfin version: "10.10.7"
[2025-11-11 18:16:28.231 +01:00] [INF] Environment Variables: ["[JELLYFIN_ARGS, $JELLYFIN_WEB_OPT $JELLYFIN_FFMPEG_OPT $JELLYFIN_SERVICE_OPT $JELLYFIN_NOWEBAPP_OPT $JELLFIN_ADDITIONAL_OPTS --datadir $JELLYFIN_DATA_DIR --configdir $JELLYFIN_CONFIG_DIR --logdir $JELLYFIN_LOG_DIR --cachedir $JELLYFIN_CACHE_DIR]", "[JELLYFIN_USER, jellyfin]", "[JELLYFIN_FFMPEG_OPT, --ffmpeg=/usr/lib/jellyfin-ffmpeg/ffmpeg]", "[JELLYFIN_LOG_DIR, /var/log/jellyfin]", "[JELLYFIN_ADDITIONAL_OPTS, ]", "[JELLYFIN_CACHE_DIR, /var/cache/jellyfin]", "[JELLYFIN_WEB_OPT, --webdir=/usr/share/jellyfin/web]", "[JELLYFIN_CONFIG_DIR, /etc/jellyfin]", "[JELLYFIN_DATA_DIR, /var/lib/jellyfin]"]
[2025-11-11 18:16:28.239 +01:00] [INF] Arguments: ["/usr/lib/jellyfin/bin/jellyfin.dll", "--webdir=/usr/share/jellyfin/web", "--ffmpeg=/usr/lib/jellyfin-ffmpeg/ffmpeg"]
[2025-11-11 18:16:28.247 +01:00] [INF] Operating system: "Debian GNU/Linux 13 (trixie)"
[2025-11-11 18:16:28.248 +01:00] [INF] Architecture: Arm64
[2025-11-11 18:16:28.251 +01:00] [INF] 64-Bit Process: True
[2025-11-11 18:16:28.251 +01:00] [INF] User Interactive: True
[2025-11-11 18:16:28.252 +01:00] [INF] Processor count: 4
[2025-11-11 18:16:28.252 +01:00] [INF] Program data path: "/var/lib/jellyfin"
[2025-11-11 18:16:28.252 +01:00] [INF] Log directory path: "/var/log/jellyfin"
[2025-11-11 18:16:28.252 +01:00] [INF] Config directory path: "/etc/jellyfin"
[2025-11-11 18:16:28.253 +01:00] [INF] Cache path: "/var/cache/jellyfin"
[2025-11-11 18:16:28.253 +01:00] [INF] Temp directory path: "/tmp/jellyfin"
[2025-11-11 18:16:28.254 +01:00] [INF] Web resources path: "/usr/share/jellyfin/web"
[2025-11-11 18:16:28.254 +01:00] [INF] Application directory: "/usr/lib/jellyfin/bin/"
[2025-11-11 18:16:28.717 +01:00] [INF] Setting cache path: "/var/cache/jellyfin"
[2025-11-11 18:16:28.820 +01:00] [INF] Loading assemblies
[2025-11-11 18:16:29.052 +01:00] [INF] Defined LAN subnets: ["MYSUBNET"]
[2025-11-11 18:16:29.053 +01:00] [INF] Defined LAN exclusions: []
[2025-11-11 18:16:29.054 +01:00] [INF] Used LAN subnets: ["MYSUBNET"]
[2025-11-11 18:16:29.058 +01:00] [INF] Filtered interface addresses: ["IPs"]
[2025-11-11 18:16:29.061 +01:00] [INF] Bind Addresses ["0.0.0.0"]
[2025-11-11 18:16:29.062 +01:00] [INF] Remote IP filter is "Allowlist"
[2025-11-11 18:16:29.062 +01:00] [INF] Filtered subnets: ["SUBNET"]
[2025-11-11 18:16:34.492 +01:00] [INF] Loaded plugin: "TMDb" "10.10.7.0"
[2025-11-11 18:16:34.495 +01:00] [INF] Loaded plugin: "Studio Images" "10.10.7.0"
[2025-11-11 18:16:34.496 +01:00] [INF] Loaded plugin: "OMDb" "10.10.7.0"
[2025-11-11 18:16:34.556 +01:00] [INF] Loaded plugin: "MusicBrainz" "10.10.7.0"
[2025-11-11 18:16:34.557 +01:00] [INF] Loaded plugin: "AudioDB" "10.10.7.0"
[2025-11-11 18:16:34.746 +01:00] [INF] Applying migration '"MigrateActivityLogDatabase"'
[2025-11-11 18:16:34.756 +01:00] [WRN] Migrating the activity database may take a while, do not stop Jellyfin.
[2025-11-11 18:16:34.817 +01:00] [ERR] Could not apply migration '"MigrateActivityLogDatabase"'
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: 'no such table: ActivityLog'.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements()+MoveNext()
at Microsoft.Data.Sqlite.SqliteCommand.GetStatements()+MoveNext()
at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader()
at Emby.Server.Implementations.Data.SqliteExtensions.Query(SqliteConnection sqliteConnection, String commandText)+MoveNext()
at Jellyfin.Server.Migrations.Routines.MigrateActivityLogDb.Perform()
at Jellyfin.Server.Migrations.MigrationRunner.PerformMigrations(IMigrationRoutine[] migrations, MigrationOptions migrationOptions, Action1 saveConfiguration, ILogger logger)at Jellyfin.Server.Migrations.MigrationRunner.Run(CoreAppHost host, ILoggerFactory loggerFactory)
at Jellyfin.Server.Program.StartServer(IServerApplicationPaths appPaths, StartupOptions options, IConfiguration startupConfig)
[2025-11-11 18:16:34.835 +01:00] [FTL] Error while starting server
Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: 'no such table: ActivityLog'.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements()+MoveNext()
at Microsoft.Data.Sqlite.SqliteCommand.GetStatements()+MoveNext()
at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader()
at Emby.Server.Implementations.Data.SqliteExtensions.Query(SqliteConnection sqliteConnection, String commandText)+MoveNext()
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.StartServer(IServerApplicationPaths appPaths, StartupOptions options, IConfiguration startupConfig)
[2025-11-11 18:16:34.837 +01:00] [INF] Running query planner optimizations in the database... This might take a while
[2025-11-11 18:16:34.886 +01:00] [INF] Disposing "CoreAppHost"
[2025-11-11 18:16:34.888 +01:00] [INF] Disposing "MusicBrainzArtistProvider"
[2025-11-11 18:16:34.890 +01:00] [INF] Disposing "MusicBrainzAlbumProvider"
[2025-11-11 18:16:34.890 +01:00] [INF] Disposing "PluginManager"
RE: Database Update to 10.11.2 fails - kandykarter - 2025-11-11
I'm by no means an expert, but it's my best guess, yes. The recommended path is to upgrade to 10.10.7, and THEN to the 10.11 branch. If you're using docker, you can just edit the compose. Not sure how you'd do it on your pi.
RE: Database Update to 10.11.2 fails - nerdnils - 2025-11-11
(3 hours ago)kandykarter Wrote: I'm by no means an expert, but it's my best guess, yes. The recommended path is to upgrade to 10.10.7, and THEN to the 10.11 branch. If you're using docker, you can just edit the compose. Not sure how you'd do it on your pi.
Sorry, just did. No change.