Restored Site - URLS need to be corrected, any ideas?

[agemo]

The error I am still hitting seems to be the repeat or very similar to the stop error here that needed a fix:

Upgrade fails on duplicate key error ("index post hotlinked media on post id and url md5")

Had an automatic rebuild fail, looks like variations on this issue: 2022-05-03 15:30:54.370 UTC [1262] discourse@discourse LOG: duration: 1707.909 ms statement: INSERT INTO post_hotlinked_media (post_id, url, status, upload_id, created_at, updated_at) SELECT post_id, obj.key AS url, 'downloaded', obj.value::bigint AS upload_id, pcf.created_at, pcf.updated_at FROM post_custom_fields pcf JOIN json_each_text(pcf.…

Error: ERROR:  duplicate key value violates unique constraint "index_post_hotlinked_media_on_post_id_and_url_md5"
DETAIL:  Key (post_id, md5(url::text))=...

When trying the remap:

RAILS_ENV=production discourse remap //sub.domain.com //domain.com

Maybe @david might have an insight here?