[PR #14656] [CLOSED] Avoid duplicate ItemValues #14063

Closed
opened 2026-02-07 07:23:47 +03:00 by OVERLORD · 0 comments
Owner

📋 Pull Request Information

Original PR: https://github.com/jellyfin/jellyfin/pull/14656
Author: @evan314159
Created: 8/16/2025
Status: Closed

Base: masterHead: avoid-duplicate-itemvalues


📝 Commits (3)

  • 5db6ce4 Avoid duplicate ItemValues, BaseItems, BaseItemProvideers using
  • d111c16 convert complex query to string concatenation
  • 3c38769 Update Jellyfin.Server.Implementations/Item/BaseItemRepository.cs

📊 Changes

1 file changed (+126 additions, -13 deletions)

View changed files

📝 Jellyfin.Server.Implementations/Item/BaseItemRepository.cs (+126 -13)

📄 Description

Changes
Avoid duplicate ItemValues, BaseItem, BaseItemProviders with bulk INSERT ON CONFLICT using Polly, similar to Peoples.

Issues
Addresses occasional duplicate ItemValues, BaseItem, BaseItemProviders.

Note: EF Core will log duplicate key errors (x3 for command error retry), however they are followed by a log showing that Jellyfin rematched the records.


🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.

## 📋 Pull Request Information **Original PR:** https://github.com/jellyfin/jellyfin/pull/14656 **Author:** [@evan314159](https://github.com/evan314159) **Created:** 8/16/2025 **Status:** ❌ Closed **Base:** `master` ← **Head:** `avoid-duplicate-itemvalues` --- ### 📝 Commits (3) - [`5db6ce4`](https://github.com/jellyfin/jellyfin/commit/5db6ce436027a7dcd139244f24d0465a92f14b03) Avoid duplicate ItemValues, BaseItems, BaseItemProvideers using - [`d111c16`](https://github.com/jellyfin/jellyfin/commit/d111c166fd2c4694ea2ac5d13a6ebf6e18a46dd8) convert complex query to string concatenation - [`3c38769`](https://github.com/jellyfin/jellyfin/commit/3c387693bb4f1aa32f39ccce0046816c6aa130f2) Update Jellyfin.Server.Implementations/Item/BaseItemRepository.cs ### 📊 Changes **1 file changed** (+126 additions, -13 deletions) <details> <summary>View changed files</summary> 📝 `Jellyfin.Server.Implementations/Item/BaseItemRepository.cs` (+126 -13) </details> ### 📄 Description **Changes** Avoid duplicate ItemValues, BaseItem, BaseItemProviders with bulk INSERT ON CONFLICT using Polly, similar to Peoples. **Issues** Addresses occasional duplicate ItemValues, BaseItem, BaseItemProviders. Note: EF Core will log duplicate key errors (x3 for command error retry), however they are followed by a log showing that Jellyfin rematched the records. --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
OVERLORD added the pull-request label 2026-02-07 07:23:47 +03:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/jellyfin#14063