ERREUR RecordNotUnique sur l'index_discourse_solved_solved_topics_on_answer_post_id

thoka · Mars 26, 2025, 5:04

Semble corrigé avec ce correctif :

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.

Sujet		Réponses	Vues
"discourse_solved_solved_topics" violates not-null constraint during rebuild Support solved	9	98	Décembre 21, 2025
Cannot restore database: sql key is duplicated Installation	2	562	Août 30, 2022
Restore fails - could not create unique index Installation	22	3881	Juillet 6, 2020
Update failed - PG::UniqueViolation: ERROR Installation	8	804	Novembre 14, 2021
Error restoring backup "key is duplicated" Installation	8	1815	Août 31, 2017

ERREUR RecordNotUnique sur l'index_discourse_solved_solved_topics_on_answer_post_id

Sujets connexes