# Обновление не удалось из-за ошибки дублирования ключа ("index post hotlinked media on post id and url md5")

**URL:** <https://meta.discourse.org/t/upgrade-fails-on-duplicate-key-error-index-post-hotlinked-media-on-post-id-and-url-md5/226002>\
**Category:** Bug\
**Created:** [03.Май.2022 15:34:51 UTC](https://meta.discourse.org/t/upgrade-fails-on-duplicate-key-error-index-post-hotlinked-media-on-post-id-and-url-md5/226002 "2022-05-03T15:34:51Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![axfelix](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/axfelix/32/65166_2.png) [@axfelix](https://meta.discourse.org/u/axfelix)\
**Post date:** [03.Май.2022 15:34:52 UTC](https://meta.discourse.org/t/upgrade-fails-on-duplicate-key-error-index-post-hotlinked-media-on-post-id-and-url-md5/226002/1 "2022-05-03T15:34:52Z")

</div>

Автоматическая пересборка завершилась неудачей. Похоже на вариацию этой проблемы:

```plaintext
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.value::json) obj ON true
        JOIN uploads ON obj.value::bigint = uploads.id
        WHERE name='downloaded_images'

```

`ERROR: duplicate key value violates unique constraint "index_post_hotlinked_media_on_post_id_and_url_md5"`

Пересборка проводилась менее месяца назад без ошибок, значит, проблема появилась недавно.

---

_[View the full topic](https://meta.discourse.org/t/upgrade-fails-on-duplicate-key-error-index-post-hotlinked-media-on-post-id-and-url-md5/226002)._
