Sitio restaurado - Las URL deben corregirse, ¿tienes alguna idea?

[agemo]

El error que sigo encontrando parece ser repetido o muy similar al error de detención que necesitaba una corrección aquí:

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))=...

Al intentar la reasignación:

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

¿Quizás @david tenga alguna idea al respecto?