Steven
December 21, 2025, 7:03am
6
Thanks @pfaffman and @JammyDodger , I’ll dig in the db to try to fix this.
With data explorer , I have the list of problematic rows, we can see this is very limited in time, maybe a bit of an issue with the plugin during that time?
I’ve seen this commit that tried to fix a similar issue?
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.
Interesting anyway. I’ll try to fix this, I’ll take my time since it’s very sensible
2 Likes
