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 年7 月 3 日 18:23 4

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

话题		回复	浏览量
Restore fails - could not create unique index Self-hosting	22	3970	2020 年7 月 6 日
Error on restore: could not create unique index Self-hosting	1	1783	2022 年3 月 12 日
Restoring from backup failing: failure creating postgres index Self-hosting	7	994	2020 年5 月 28 日
Error importing backup: "could not create unique index" Self-hosting	7	1038	2021 年11 月 1 日
"EXCEPTION: psql failed: DETAIL: Key (post_id)=(36946) is duplicated." Self-hosting	8	1229	2022 年6 月 20 日

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

相关话题