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 dupli…

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) [image] nattsw …

ERROR RecordNotUnique on index_discourse_solved_solved_topics_on_answer_post_id

Support

fhe (Florian) March 26, 2025, 5:07pm 9

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

2 Likes

Topic		Replies	Views
Cannot restore database: sql key is duplicated Installation	2	543	August 30, 2022
Restore fails - could not create unique index Installation	22	3773	July 6, 2020
Update failed - PG::UniqueViolation: ERROR Installation	8	770	November 14, 2021
Error restoring backup "key is duplicated" Installation	8	1784	August 31, 2017
Error importing backup: "could not create unique index" Installation	7	975	November 1, 2021

ERROR RecordNotUnique on index_discourse_solved_solved_topics_on_answer_post_id

Related topics