Continuing the discussion from SSO Broken - The requested URL or resource could not be found : [画像] SSO Broken - The requested URL or resource could not be found ActiveRecord::RecordNotUnique (PG::UniqueViolation: ERROR: duplicate key value violates unique constraint “idx_tag_users_ix1” DETAIL: K…

I don’t know how it came to be, but I could remove duplicate tags: TagUser.all.where(user_id: 80, tag_id:2).last.destroy For each duplicate (did it manually). Thanks Jay!

I think it’s because you have tags that are mixed case (you have tag and Tag). Is this happening on a rebuild or some other time? I think the thing to do is to try to rebuild the index and then either fix the case of the tags (if I’m right about that) or just delete one of the duplicate entries.

Hmmm… Hardly the case. Tag.all.pluck(:name) => ["welcome", "faq", "sysadmin", "offdem-0x03", "reference", "tutorial", "local-organization", "collective-data", "power-relations", "offdem-topic", "offdem-0x00", "offdem-0x01", "offdem-0x02", "discourse-plugin", "page", "how-to", "about…

Note that the symptom is cleared, but the cause is not clear at all. :thinking: I suspect that group notifications on tags, when applied retroactively, do not check for existing entries @pfaffman

[画像] hellekin: Note that the symptom is cleared, but the cause is not clear at all. That’s usually the case on these duplicate whatever issues.

ActiveRecord::RecordNotUnique on idx_tag_users_ix1: 修正方法は？

サポート

hellekin 2023 年 11 月 30 日午後 2:41 5

症状は解消されたものの、原因は全く不明です。

タグのグループ通知が遡及的に適用された場合、既存のエントリを確認しないのではないかと疑っています @pfaffman

Staff tags cause duplicate tag index

トピック		返信	表示
Add Tags 500 Error Self-hosting	5	935	2019 年 9 月 20 日
Staff tags cause duplicate tag index Bug tags	7	423	2024 年 1 月 31 日
Internal Server Error on using some tags (ERROR: duplicate key value violates unique constraint "index_tags_on_name") Bug	19	3361	2019 年 11 月 8 日
Problem in upgrade: duplicate key value violates unique constraint Self-hosting	2	977	2023 年 3 月 2 日
Getting this error during restore: `could not create unique index` Self-hosting	1	6921	2020 年 1 月 15 日

ActiveRecord::RecordNotUnique on idx_tag_users_ix1: 修正方法は？

関連トピック