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: …

[Bild] 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 [Bild] 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 …

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.

Restore schlägt fehl: Konnte keinen unique index erstellen

Unterstützung Installation

pfaffman (Jay Pfaffman) 3. Juli 2021 um 18:23 4

Can't restore due to corrupt indexes (with some clues on how to deal with corrupt indexes) könnte einige Hinweise bieten.

Thema		Antworten	Aufrufe
Restore fails - could not create unique index Self-hosting	22	3970	6. Juli 2020
Error on restore: could not create unique index Self-hosting	1	1783	12. März 2022
Restoring from backup failing: failure creating postgres index Self-hosting	7	994	28. Mai 2020
Error importing backup: "could not create unique index" Self-hosting	7	1038	1. November 2021
"EXCEPTION: psql failed: DETAIL: Key (post_id)=(36946) is duplicated." Self-hosting	8	1229	20. Juni 2022

Restore schlägt fehl: Konnte keinen unique index erstellen

Verwandte Themen