错误：在 index_discourse_solved_solved_topics_on_answer_post_id 上记录不唯一

thoka · 2025 年3 月 26 日 17:04

Seems to be fixed with this patch:

FIX: Multiple topics may have the same post as its solution (#348)

committed 02:21PM - 26 Mar 25 UTC

We are seeing some errors when migrating and adding indexes on `answer_post_id`.… ``` #<StandardError:"An error has occurred, all later migrations canceled:\n\nPG::UniqueViolation: ERROR: could not create unique index \"index_discourse_solved_solved_topics_on_answer_post_id\"\nDETAIL: Key (answer_post_id)=(13006) is duplicated.\n"> ``` This PR modifies the earlier migration, and also adds one before the addition of indexes to remove duplicates.

话题		回复	浏览量
Cannot restore database: sql key is duplicated Installation	2	549	2022 年8 月 30 日
Restore fails - could not create unique index Installation	22	3789	2020 年7 月 6 日
Update failed - PG::UniqueViolation: ERROR Installation	8	783	2021 年11 月 14 日
Error restoring backup "key is duplicated" Installation	8	1802	2017 年8 月 31 日
Error importing backup: "could not create unique index" Installation	7	994	2021 年11 月 1 日

错误：在 index_discourse_solved_solved_topics_on_answer_post_id 上记录不唯一

相关话题