Continuing the discussion from Upgrade fails on duplicate key error ("index post hotlinked media on post id and url md5") : I’m now trying to restore from one prod site to a staging site and I’m getting: ERROR: type "hotlinked_media_status" already exists EXCEPTION: psql failed: ERROR: type "hotl…

Are you able to reproduce the issue on any other installation? It’s quite surprising that this issue is cropping up more than 2 years later, and without any other reports :thinking:

How are you restoring the site? Via the UI? discourse CLI? direct psql?

From the command line restoring the most recent backup (I figured out this sed trick today, but it was the same if I copy/pasted). $(discourse restore |sed -n '3p') And the backup is on S3 restored from a slightly older version: Discourse 3.4.0.beta1-dev - https://github.com/discourse/discourse v…

[이미지] David Taylor: Are you able to reproduce the issue on any other installation? Maybe not? I did successfully restore that same backup on my dev box. Do you have any idea what I might have done to cause this or what I can do to fix it? I dropped the database and than was able to restore. …

One very valuable insight that I just had is that hotlinked_media_status is simply the first thing happening in the restore file. If you remove it manually in the existing database the restore will fail on the next statement (CREATE TABLE public.admin_notices). So this is not about that specific ty…

복원이 실패합니다: "hotlinked_media_status"이(가) 이미 존재합니다

지원

david (David Taylor) 8월 28, 2024, 4:25오후 2

사이트를 어떻게 복구하고 있나요? UI를 통해서인가요? discourse CLI인가요? 아니면 직접 psql를 사용하고 있나요?

글		댓글	조회수
Upgrade fails on duplicate key error ("index post hotlinked media on post id and url md5") Bug	9	1070	5월 4, 2022
An error occurred while restoring from a backup: discourse_functions.raise_discourse_voting_category_settings_readonly() does not exist Self-hosting backups	5	295	8월 28, 2024
Error restoring backup "key is duplicated" Self-hosting	7	1961	8월 30, 2017
Backup Restore Error Support	16	2488	9월 20, 2022
Cannot restore database: sql key is duplicated Self-hosting	2	648	8월 30, 2022

복원이 실패합니다: "hotlinked_media_status"이(가) 이미 존재합니다

Related topics