중복 키 오류("index post hotlinked media on post id and url md5")로 업그레이드 실패

david · 5월 3, 2022, 9:30오후

확인해 주셔서 감사합니다!

해당 문제에 대한 수정을 담은 PR을 열었습니다:

github.com/discourse/discourse

FIX: Handle enum types during database restore (#16624)

main ← fix-restore-enums

merged 10:40PM - 03 May 22 UTC

davidtaylorhq

+9 -0

c1db9687 introduced an postgres enum type. Our database restore logic did not ha…ndle custom types correctly, and would therefore raise a 'type already exists' error when restoring any backup. This commit adds restore handling for enums, mirroring the similar logic for tables and views. --- (This code is not tested by rspec, but it is tested by a regular internal job at CDCK, which correctly picked up on this issue)

글		댓글	조회수
Restore fails with "hotlinked_media_status" already exists Product Support	5	172	11월 14, 2024
Restore fails - could not create unique index Self-hosting	21	4216	7월 4, 2020
Upgrade failed with "duplicate key value violates unique constraint" error Self-hosting	17	2723	2월 29, 2020
Error restoring backup "key is duplicated" Self-hosting	7	1991	8월 30, 2017
Cannot restore database: sql key is duplicated Self-hosting	2	655	8월 30, 2022

중복 키 오류("index post hotlinked media on post id and url md5")로 업그레이드 실패

Related topics