错误：在 index_discourse_solved_solved_topics_on_answer_post_id 上记录不唯一

thoka · 2025年三月26日 17:04

此补丁似乎已修复：

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.

話題		回覆	觀看
"discourse_solved_solved_topics" violates not-null constraint during rebuild Support solved	9	299	2025年十二月21日
Cannot restore database: sql key is duplicated Self-hosting	2	640	2022年八月30日
Restore fails - could not create unique index Self-hosting	21	4173	2020年七月4日
Update failed - PG::UniqueViolation: ERROR Self-hosting	7	920	2018年十二月21日
Error restoring backup "key is duplicated" Self-hosting	7	1941	2017年八月30日

错误：在 index_discourse_solved_solved_topics_on_answer_post_id 上记录不唯一

相關主題