Differences

This shows you the differences between two versions of the page.

--- wiki:jellyfin_troubleshooting [2025/12/29 17:18] – created antisa
+++ wiki:jellyfin_troubleshooting [2026/08/15 09:38] (current) – add deleting phantom shows antisa
@@ Line 48: / Line 48: @@
 In this specific case, the user didn't have permission to do transcoding, so enable that in  //Dashboard>Users>Allow video playback that requires transcoding//.
+===== Can't remove old show/update new shows =====
+Logs show smth like:
-====== Tested on ======
+<code | download>
-  *
+[2026-08-15 00:28:19.345 +02:00] [INF] [16] Emby.Server.Implementations.Library.LibraryManager: Removing item, Type: "Series", Name: "Steins;Gate", Path: "/media/nas/Anime/Serije/Steins;Gate (2011)", Id: 2bb5ccf7-fc73-f4ee-1abf-2c9696edcb57
+[2026-08-15 00:28:19.625 +02:00] [ERR] [16] Microsoft.EntityFrameworkCore.Database.Command: Failed executing DbCommand ("5"ms) [Parameters=["@__date_1='?' (DbType = DateTime), @__p_0='?' (Size = 2341)"], CommandType='Text', CommandTimeout='30']"
+""UPDATE \"UserData\" AS \"u\"
+SET \"ItemId\" = '00000000-0000-0000-0000-000000000001',
+    \"RetentionDate\" = @__date_1
+WHERE \"u\".\"ItemId\" IN (
+    SELECT \"p\".\"value\"
+    FROM json_each(@__p_0) AS \"p\"
+)"
+[2026-08-15 00:28:19.627 +02:00] [ERR] [16] Microsoft.EntityFrameworkCore.Query: An exception occurred while executing an 'ExecuteUpdate' operation for context type '"Jellyfin.Database.Implementations.JellyfinDbContext"'."
+""Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 19: 'UNIQUE constraint failed: UserData.ItemId, UserData.UserId, UserData.CustomDataKey'.
+</code>
+You need to delete those entries from sqlite DB. Find the db first, if it's in docker check the volume
+  find config/ -name jellyfin.db
+  apt install sqlite3
+Enter the database and find the missing path with SELECT first then use DELETE to remove them:
+<code | download>
+sqlite3 jellyfin.db
+sqlite> SELECT Path FROM BaseItems WHERE Path LIKE '/media/nas/Anime/Serije/Steins;Gate%';
+/media/nas/Anime/Serije/Steins;Gate (2011)
+/media/nas/Anime/Serije/Steins;Gate (2011)/Movie
+/media/nas/Anime/Serije/Steins;Gate (2011)/Movie/Steins;gate - Movie - Fuka Ryouiki No Deja Vu.mkv
+/media/nas/Anime/Serije/Steins;Gate (2011)/S01E01 - Turning Point.mkv
+...
+</code>
+Then delete them with
+<code | download>
+sqlite> DELETE FROM BaseItems WHERE Path LIKE '/media/nas/Anime/Serije/Steins;Gate%';
+sqlite> .quit
+</code>
+Rescan should now work.
+==== Tested on ====
+  * Jellyfin 10.12.0 dockerized
+  * Raspberry Pi, Debian 12.15
 ====== See also ======
 ====== References ======
+  * https://web.archive.org/web/20260815092900/https://racedorsey.com/posts/2025/jellyfin-delete-phantom-library-entries/