I’m getting this error when trying to update via ./launcher rebuild app ActiveRecord::RecordNotUnique: PG::UniqueViolation: ERROR: could not create unique index "index_discourse_solved_solved_topics_on_answer_post_id" (ActiveRecord::RecordNotUnique) DETAIL: Key (answer_post_id)=(201795) is duplicated. Any ideas on how to resolve this issue?

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 (UTC) [imagem] nattsw +169 -28 We are seeing some errors when migrating and adding indexes on `answer_post_id`.… ``` # ``` This PR modifies the earlier migration, and also adds one before the addition of indexes to remove duplicates.

Delete one of the SolvedTopic records via rails console: DiscourseSolved::SolvedTopic.where(answer_post_id:201795).last.destroy

Thank you. I’ve tried to access those, but I’m getting NameError: uninitialized constant SolvedTopic Any other ideas?

I’ve now connected to the database directly and deleted the record with the duplicate answer_post_id from discourse_solved_solved_topics. All good now. Thanks again for your quick reply!

Hm. discourse-solved was updated recently. There is a chance, that this error was thrown during database migration.

Yes, this happened during database migration.

Excellent! Thanks for the heads up — I’ve marked your post as solution.

ERRO RecordNotUnique no índice_discourse_solved_solved_topics_on_answer_post_id

Suporte ao Produto

fhe (Florian) 26 Março , 2025 17:07 9

Excelente! Obrigado pelo aviso — marquei sua postagem como solução.

Tópico		Respostas	Vistas
"discourse_solved_solved_topics" violates not-null constraint during rebuild Product Support solved	9	372	21 Dezembro , 2025
Cannot restore database: sql key is duplicated Self-hosting	2	662	30 Agosto , 2022
Restore fails - could not create unique index Self-hosting	21	4243	4 Julho , 2020
Update failed - PG::UniqueViolation: ERROR Self-hosting	7	964	21 Dezembro , 2018
Error restoring backup "key is duplicated" Self-hosting	7	2014	30 Agosto , 2017

ERRO RecordNotUnique no índice_discourse_solved_solved_topics_on_answer_post_id

Related topics