Hi, I’m trying to restore a backup on to a new Discourse instance as I am performing a server migration. Unfortunately I get this error: I’ve had a read of this: Restore fails - could not create unique index - #2 by simon and deleted the indexes. Now when I do: [2] pry(main)> IncomingReferer.wh…

Unfortunately this didn’t help, and I still get this message when restoring: [2021-07-03 16:53:41] ERROR: could not create unique index "index_incoming_referers_on_path_and_incoming_domain_id" [2021-07-03 16:53:41] DETAIL: Key (path, incoming_domain_id)=(/search, 4502) is duplicated. [2021-07-03 …

Something is still wrong. I am getting: [2021-07-03 17:28:53] ERROR: could not create unique index "index_incoming_referers_on_path_and_incoming_domain_id" [2021-07-03 17:28:53] DETAIL: Key (path, incoming_domain_id)=(/osmc/osmc, 2939) is duplicated. [2021-07-03 17:28:53] EXCEPTION: psql failed: …

[圖片] pfaffman: Can’t restore due to corrupt indexes (with some clues on how to deal with corrupt indexes) might offer some clues. Thanks. I’ve read this, but I don’t know what commands or queries to run to solve my problem. Sam

Basically, you want to try to rebuild the index and keep deleting stuff until you can reindex it. It looks like you’re doing the right stuff, you just need to keep doing it for all of the duplicate entries. If you have a budget you can post in Marketplace .

Hi Jay It’s not legal in the UK to expose our database to third parties to fix these issues, and even if it was, I have no interest in doing so for the interests of protecting user’s privacy. As an open source maintainer myself, the idea to take this to Marketplace is disappointing, particularly w…

Hey Sam. Sorry I wasn’t able to provide you with sufficient instruction to solve your problem yourself, but that’s how you made it sound. I thought it might be a relief rather than a disappointment that there are other ways to get your forum back online. Cheers

Hi Jay [圖片] pfaffman: Sorry I wasn’t able to provide you with sufficient instruction to solve your problem yourself, but that’s how you made it sound. I thought it might be a relief rather than a disappointment that there are other ways to get your forum back online. Not at all. You don’t ow…

Unfortunately this is still a problem for us, and we cannot migrate servers, which is rather concerning. Happy to pay someone to get this solved, but after this issue, and the acknowledgement of it numerous times without a clear solution in the forum, we are seriously considering migrating to a dif…

There were indeed quite a few bugs in Postgres that would cause corrupted indexes. We think most of them are resolved in Postgres 13.x.

还原失败：无法创建唯一索引

支持安装

pfaffman (Jay Pfaffman) 2021年七月3日 18:23 4

Can't restore due to corrupt indexes (with some clues on how to deal with corrupt indexes) 可能提供一些线索。

話題		回覆	觀看
Backup restoration fails Self-hosting backups	16	451	2026年六月16日
Restore fails - could not create unique index Self-hosting	21	4170	2020年七月4日
Error on restore: could not create unique index Self-hosting	1	1876	2022年三月12日
Restoring from backup failing: failure creating postgres index Self-hosting	7	1103	2020年五月28日
Error importing backup: "could not create unique index" Self-hosting	6	1136	2021年十一月1日

还原失败：无法创建唯一索引

相關主題