Many of our intra-forum links are broken after moving to a new server. I had created the new server at a temporary url staging.example.com to help with the transition, but now that the transition is complete, many links at forum.example.com still point to staging.example.com (which no longer exists).
> /var/www/discourse# discourse remap staging.example.com forum.example.com
> Rewriting all occurences of staging.example.com to forum.example.com
> THIS TASK WILL REWRITE DATA, ARE YOU SURE (type YES)
> Error: ERROR: duplicate key value violates unique constraint "unique_post_links"
> DETAIL: Key (topic_id, post_id, url)=(8718, 57455, https://forum.example.com/t/exampletopic/4606/336) already exists.
> The remap has only been partially applied due to the error above. Please re-run the script again.
I re-ran it as instructed and got the same error, on the same (topic_id, post_id, url) key.
I can get to the rails console and run some SQL/ActiveRecord if you can tell me what to run. Or Data Explorer.