L'utilisation échoue en raison d'une erreur de clé dupliquée ("indexue le média hotlinké sur post id et url md5")

david · Mai 3, 2022, 9:30

Super, merci de confirmer !

J’ai ouvert une PR avec une correction pour celle-ci :

github.com/discourse/discourse

FIX: Handle enum types during database restore

main ← fix-restore-enums

opened 09:27PM - 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)

Sujet		Réponses	Vues
Restore fails with "hotlinked_media_status" already exists Support	7	71	Novembre 14, 2024
Restore fails - could not create unique index Installation	22	3836	Juillet 6, 2020
Upgrade failed with "duplicate key value violates unique constraint" error Installation	18	2422	Mars 30, 2020
Error restoring backup "key is duplicated" Installation	8	1806	Août 31, 2017
Cannot restore database: sql key is duplicated Installation	2	556	Août 30, 2022

L'utilisation échoue en raison d'une erreur de clé dupliquée ("indexue le média hotlinké sur post id et url md5")

Sujets connexes