Specify Unstable Release Number

Oct 13, 2025 by pinkandtrash.com 148 views

Introduction

Jellyfin is a popular media server software that allows users to manage and stream their media collections. However, some users have reported experiencing database locked errors whenever any scan is occurring, resulting in no page loads. In this article, we will delve into the details of this issue, including the reproduction steps, current behavior, expected behavior, and environment details.

Description of the Bug

Whenever any library scan (even just a single season/folder) is occurring, no page of Jellyfin loads. All pages are stuck on the loading screen. Additionally, a lot of database lock errors are seen in the logs.

Reproduction Steps

Update a Jellyfin 10.10 installation to unstable build 2025031005.
Run any scan, either the general Library Scan task or any scan on any series/season.
Try to navigate around the Jellyfin interface.
Observe that all pages just show a loading screen.
Interrupt the scan task (for instance in the dashboard)
Observe that pages now load again.

Current Bug Behavior

Pages do not load, loading screen stays until the scan task fails.

Expected Correct Behavior

All pages load successfully, even if a scan is currently in progress.

Jellyfin Server Version

Unstable

Specify Commit Id

No response

Specify Unstable Release Number

2025031005

Specify Version Number

No response

Specify the Build Version

2025031005

Environment

OS: -
Linux Kernel: -
Virtualization: Docker on Kubernetes (containerd)
Clients: Windows 11
Browser: Firefox
FFmpeg Version: whatever the Docker container has
Playback Method: -
Hardware Acceleration: -
GPU Model: -
Plugins: AudioDB, MusicBrainz, OMDb, Open Subtitles, Studio Images, TMDb, TheTVDB
Reverse Proxy: Traefik on Kubernetes ingress
Base URL: -
Networking: -
Storage: local disk (NVMe)

Jellyfin Logs

The logs show a lot of database lock errors, including:

[18:38:55] [INF] [44] Emby.Server.Implementations.HttpServer.WebSocketManager: WS <IP> request
[18:39:05] [ERR] [10] Microsoft.EntityFrameworkCore.Database.Command: Failed executing DbCommand (30,030ms) [Parameters=[@__filter_IsFolder_0='?' (DbType = Boolean), @__filter_User_Id_1='?' (DbType = Guid), @__filter_IsPlayed_2='?' (DbType = Boolean), @__isVirtualItem_Value_3='?' (DbType = Boolean), @__mediaTypes_4='?' (Size = 9), @__8__locals2_queryTopParentIds_5='?' (Size = 40), @__p_6='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT "b2"."ItemId", "b2"."ProviderId", "b2"."ProviderValue", "b6"."Id"
FROM (
    SELECT "b0"."Id", "b0"."DateCreated", "b0"."SortName", "b0"."ProductionYear"
    FROM (
        SELECT DISTINCT "b"."Id", "b"."Album", "b"."AlbumArtists", "b"."Artists", "b"."Audio", "b"."ChannelId", "b"."CleanName", "b"."CommunityRating", "b"."CriticRating", "b"."CustomRating", "b"."Data", "b"."DateCreated", "b"."DateLastMediaAdded", "b"."DateLastRefreshed", "b"."DateLastSaved", "b"."DateModified", "b"."EndDate", "b"."EpisodeTitle", "b"."ExternalId", "b"."ExternalSeriesId", "b"."ExternalServiceId", "b"."ExtraIds", "b"."ExtraType", "b"."ForcedSortName", "b"."Genres", "b"."Height", "b"."IndexNumber", "b"."InheritedParentalRatingValue", "b"."IsFolder", "b"."IsInMixedFolder", "b"."IsLocked", "b"."IsMovie", "b"."IsRepeat", "b"."IsSeries", "b"."IsVirtualItem", "b"."LUFS", "b"."MediaType", "b"."Name", "b"."NormalizationGain", "b"."OfficialRating", "b"."OriginalTitle", "b"."Overview", "b"."OwnerId", "b"."ParentId", "b"."ParentIndexNumber", "b"."Path", "b"."PreferredMetadataCountryCode", "b"."PreferredMetadataLanguage", "b"."PremiereDate", "b"."PresentationUniqueKey", "b"."PrimaryVersionId", "b"."ProductionLocations", "b"."ProductionYear", "b"."RunTimeTicks", "b"."SeasonId", "b"."SeasonName", "b"."SeriesId", "b"."SeriesName", "b"."SeriesPresentationUniqueKey", "b"."ShowId", "b"."Size", "b"."SortName", "b"."StartDate", "b"."Studios", "b"."Tagline", "b"."Tags", "b"."TopParentId", "b"."TotalBitrate", "b"."Type", "b"."UnratedType", "b"."Width"
        FROM "BaseItems" AS "b"
        WHERE "b"."IsFolder" = @__filter_IsFolder_0 AND COALESCE((
            SELECT "u"."Played"
            FROM "UserData" AS "u"
            WHERE "b"."Id" = "u"."ItemId" AND "u"."UserId" = @__filter_User_Id_1
            LIMIT 1), 0) = @__filter_IsPlayed_2 AND "b"."IsVirtualItem" = @__isVirtualItem_Value_3 AND "b"."MediaType" IN (
            SELECT "m"."value"
            FROM json_each(@__mediaTypes_4) AS "m"
        ) AND "b"."TopParentId" IN (
            SELECT "8"."value"
            FROM json_each(@__8__locals2_queryTopParentIds_5) AS "8"
        )
    ) AS "b0"
    ORDER BY "b0"."DateCreated" DESC, "b0"."SortName" DESC, "b0"."ProductionYear" DESC
    LIMIT @__p_6
) AS "b6"
INNER JOIN "BaseItemProviders" AS "b2" ON "b6"."Id" = "b2"."ItemId"
ORDER BY "b6"."DateCreated" DESC, "b6"."SortName" DESC, "b6"."ProductionYear" DESC, "b6"."Id"
[18:39:05] [ERR] [33] Microsoft.EntityFrameworkCore.Database.Command: Failed executing DbCommand (30,027ms) [Parameters=[@__includeTypeName_0='?' (Size = 43), @__filter_ParentIndexNumberNotEquals_Value_1='?' (DbType = Int32), @__filter_User_Id_2='?' (DbType = Guid), @__filter_IsPlayed_3='?' (DbType = Boolean), @__filter_SeriesPresentationUniqueKey_4='?' (Size = 32), @__p_5='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT "b0"."Id", "b0"."Album", "b0"."AlbumArtists", "b0"."Artists", "b0"."Audio", "b0"."ChannelId", "b0"."CleanName", "b0"."CommunityRating", "b0"."CriticRating", "b0"."CustomRating", "b0"."Data", "b0"."DateCreated", "b0"."DateLastMediaAdded", "b0"."DateLastRefreshed", "b0"."DateLastSaved", "b0"."DateModified", "b0"."EndDate", "b0"."EpisodeTitle", "b0"."ExternalId", "b0"."ExternalSeriesId", "b0"."ExternalServiceId", "b0"."ExtraIds", "b0"."ExtraType", "b0"."ForcedSortName", "b0"."Genres", "b0"."Height", "b0"."IndexNumber", "b0"."InheritedParentalRatingValue", "b0"."IsFolder", "b0"."IsInMixedFolder", "b0"."IsLocked", "b0"."IsMovie", "b0"."IsRepeat", "b0"."IsSeries", "b0"."IsVirtualItem", "b0"."LUFS", "b0"."MediaType", "b0"."Name", "b0"."NormalizationGain", "b0"."OfficialRating", "b0"."OriginalTitle", "b0"."Overview", "b0"."OwnerId", "b0"."ParentId", "b0"."ParentIndexNumber", "b0"."Path", "b0"."PreferredMetadataCountryCode", "b0"."PreferredMetadataLanguage", "b0"."PremiereDate", "b0"."PresentationUniqueKey", "b0"."PrimaryVersionId", "b0"."ProductionLocations", "b0"."ProductionYear", "b0"."RunTimeTicks", "b0"."SeasonId", "b0"."SeasonName", "b0"."SeriesId", "b0"."SeriesName<br/>
**Q&A: Database Locked Errors Whenever Any Scan is Occurring, No Page Loads**
====================================================================================

**Q: What is the issue with Jellyfin's database?**
------------------------------------------------

A: The issue is that the database becomes locked whenever any scan is occurring, resulting in no page loads.

**Q: What happens when a scan is in progress?**
--------------------------------------------

A: When a scan is in progress, the database becomes locked, and no page loads. The loading screen stays until the scan task fails.

**Q: What is the expected behavior?**
--------------------------------------

A: The expected behavior is that all pages load successfully, even if a scan is currently in progress.

**Q: What are the reproduction steps?**
--------------------------------------

A: The reproduction steps are:

1.  Update a Jellyfin 10.10 installation to unstable build `2025031005`.
2.  Run any scan, either the general Library Scan task or any scan on any series/season.
3.  Try to navigate around the Jellyfin interface.
4.  Observe that all pages just show a loading screen.
5.  Interrupt the scan task (for instance in the dashboard)
6.  Observe that pages now load again.

**Q: What are the environment details?**
-----------------------------------------

A: The environment details are:

*   **OS:** -
*   **Linux Kernel:** -
*   **Virtualization:** Docker on Kubernetes (containerd)
*   **Clients:** Windows 11
*   **Browser:** Firefox
*   **FFmpeg Version:** whatever the Docker container has
*   **Playback Method:** -
*   **Hardware Acceleration:** -
*   **GPU Model:** -
*   **Plugins:** AudioDB, MusicBrainz, OMDb, Open Subtitles, Studio Images, TMDb, TheTVDB
*   **Reverse Proxy:** Traefik on Kubernetes ingress
*   **Base URL:** - 
*   **Networking:** -
*   **Storage:** local disk (NVMe)

**Q: What are the relevant logs?**
----------------------------------

A: The relevant logs show a lot of database lock errors, including:

```markdown
[18:38:55] [INF] [44] Emby.Server.Implementations.HttpServer.WebSocketManager: WS <IP> request
[18:39:05] [ERR] [10] Microsoft.EntityFrameworkCore.Database.Command: Failed executing DbCommand (30,030ms) [Parameters=[@__filter_IsFolder_0='?' (DbType = Boolean), @__filter_User_Id_1='?' (DbType = Guid), @__filter_IsPlayed_2='?' (DbType = Boolean), @__isVirtualItem_Value_3='?' (DbType = Boolean), @__mediaTypes_4='?' (Size = 9), @__8__locals2_queryTopParentIds_5='?' (Size = 40), @__p_6='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT "b2"."ItemId", "b2"."ProviderId", "b2"."ProviderValue", "b6"."Id"
FROM (
    SELECT "b0"."Id", "b0"."DateCreated", "b0"."SortName", "b0"."ProductionYear"
    FROM (
        SELECT DISTINCT "b"."Id", "b"."Album", "b"."AlbumArtists", "b"."Artists", "b"."Audio", "b"."ChannelId", "b"."CleanName", "b"."CommunityRating", "b"."CriticRating", "b"."CustomRating", "b"."Data", "b"."DateCreated", "b"."DateLastMediaAdded", "b"."DateLastRefreshed", "b"."DateLastSaved", "b"."DateModified", "b"."EndDate", "b"."EpisodeTitle", "b"."ExternalId", "b"."ExternalSeriesId", "b"."ExternalServiceId", "b"."ExtraIds", "b"."ExtraType", "b"."ForcedSortName", "b"."Genres", "b"."Height", "b"."IndexNumber", "b"."InheritedParentalRatingValue", "b"."IsFolder", "b"."IsInMixedFolder", "b"."IsLocked", "b"."IsMovie", "b"."IsRepeat", "b"."IsSeries", "b"."IsVirtualItem", "b"."LUFS", "b"."MediaType", "b"."Name", "b"."NormalizationGain", "b"."OfficialRating", "b"."OriginalTitle", "b"."Overview", "b"."OwnerId", "b"."ParentId", "b"."ParentIndexNumber", "b"."Path", "b"."PreferredMetadataCountryCode", "b"."PreferredMetadataLanguage", "b"."PremiereDate", "b"."PresentationUniqueKey", "b"."PrimaryVersionId", "b"."ProductionLocations", "b"."ProductionYear", "b"."RunTimeTicks", "b"."SeasonId", "b"."SeasonName", "b"."SeriesId", "b"."SeriesName", "b"."SeriesPresentationUniqueKey", "b"."ShowId", "b"."Size", "b"."SortName", "b"."StartDate", "b"."Studios", "b"."Tagline", "b"."Tags", "b"."TopParentId", "b"."TotalBitrate", "b"."Type", "b"."UnratedType", "b"."Width"
        FROM "BaseItems" AS "b"
        WHERE "b"."IsFolder" = @__filter_IsFolder_0 AND COALESCE((
            SELECT "u"."Played"
            FROM "UserData" AS "u"
            WHERE "b"."Id" = "u"."ItemId" AND "u"."UserId" = @__filter_User_Id_1
            LIMIT 1), 0) = @__filter_IsPlayed_2 AND "b"."IsVirtualItem" = @__isVirtualItem_Value_3 AND "b"."MediaType" IN (
            SELECT "m"."value"
            FROM json_each(@__mediaTypes_4) AS "m"
        ) AND "b"."TopParentId" IN (
            SELECT "8"."value"
            FROM json_each(@__8__locals2_queryTopParentIds_5) AS "8"
        )
    ) AS "b0"
    ORDER BY "b0"."DateCreated" DESC, "b0"."SortName" DESC, "b0"."ProductionYear" DESC
    LIMIT @__p_6
) AS "b6"
INNER JOIN "BaseItemProviders" AS "b2" ON "b6"."Id" = "b2"."ItemId"
ORDER BY "b6"."DateCreated" DESC, "b6"."SortName" DESC, "b6"."ProductionYear" DESC, "b6"."Id"
[18:39:05] [ERR] [33] Microsoft.EntityFrameworkCore.Database.Command: Failed executing DbCommand (30,027ms) [Parameters=[@__includeTypeName_0='?' (Size = 43), @__filter_ParentIndexNumberNotEquals_Value_1='?' (DbType = Int32), @__filter_User_Id_2='?' (DbType = Guid), @__filter_IsPlayed_3='?' (DbType = Boolean), @__filter_SeriesPresentationUniqueKey_4='?' (Size = 32), @__p_5='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT "b0"."Id", "b0"."Album", "b0"."AlbumArtists", "b0"."Artists", "b0"."Audio", "b0"."ChannelId", "b0"."CleanName", "b0"."CommunityRating", "b0"."CriticRating", "b0"."CustomRating", "b0"."Data", "b0"."DateCreated", "b0"."DateLastMediaAdded", "b0"."DateLastRefreshed", "b0"."DateLastSaved", "b0"."DateModified", "b0"."EndDate", "b0"."EpisodeTitle", "b0"."ExternalId", "b0"."ExternalSeriesId", "b0"."ExternalServiceId", "b0"."ExtraIds", "b0"."ExtraType", "b0"."ForcedSortName", "b0"."Genres", "b0"."Height", "b0"."IndexNumber", "b0"."InheritedParentalRatingValue", "b0"."IsFolder", "b0"."IsInMixedFolder", "b0"."IsLocked", "b0"."IsMovie", "b0"."IsRepeat", "b0"."IsSeries", "b0"."IsVirtualItem", "b0"."LUFS", "b0"."MediaType", "b0"."Name", "b0"."NormalizationGain", "b0"."OfficialRating", "b0"."OriginalTitle", "b0"."Overview", "b0"."OwnerId", "b0"."ParentId", "b0"."ParentIndexNumber", "b0"."Path", "b0"."PreferredMetadataCountryCode", "b0"."PreferredMetadataLanguage", "b0"."PremiereDate", "b0"."PresentationUniqueKey", "b0"."PrimaryVersionId", "b0"."ProductionLocations", "b0"."ProductionYear", "b0"."RunTimeTicks", "b0"."SeasonId", "b0"."SeasonName", "b0"."SeriesId", "b0"."SeriesName", "b0"."SeriesPresentationUniqueKey", "b0"."ShowId", "b0"."Size", "b0"."SortName", "b0"."StartDate", "b0"."Studios", "b0"."Tagline", "b0"."Tags", "b0"."TopParentId", "b0"."TotalBitrate", "b0"."Type", "