duplicate key value violates unique constraint "IX_ItemValues_Type_Value"

[chadouming]

My logs are currently getting spammed with the following error:

2025-11-27 17:04:15.795 EST [3755482] ERROR: duplicate key value violates unique constraint "IX_ItemValues_Type_Value"
2025-11-27 17:04:15.795 EST [3755482] DETAIL: Key ("Type", "Value")=(6, "name of item") already exists.
2025-11-27 17:04:15.795 EST [3755482] STATEMENT: INSERT INTO "ItemValues" ("ItemValueId", "CleanValue", "Type", "Value")
VALUES ($1, $2, $3, $4)

The constraint is an index in the ItemValue table.

[VslVictor7]

Hello, this was the same issue i had in #15, in there i said how you can fix that.

This is mostly an issue with the migration of sqlite to postgres instead of the plugin's fault.

[chadouming]

Hello, this was the same issue i had in #15, in there i said how you can fix that.

This is mostly an issue with the migration of sqlite to postgres instead of the plugin's fault.

I did not upgrade from SQLite but started from scratch 🤔

[VslVictor7]

Oh. Yeah well that's my bad. Sorry.

[pceimpulsive]

Should it be an

Insert into...

On conflict do update set ...?

That or the unique constraint is incorrect and SQLLite wasn't strict?¿

This is a known problem. The fix is as you note (use UPSERT logic) but because the problem does not occur on SQLite and Postgres is not supported the change will not be accepted into Jellyfin mainline until Postgres is a supported platform. In practice it does not seem to cause serious impact.