Hi all. I’m trying to perform a server migration. I followed this process. Upon trying to restore the database via the CLI, it bombs out with the following error: CREATE INDEX ERROR: could not create unique index "unique_post_links" DETAIL: Key (topic_id, post_id, url)=(19891, 32700, http://www.dhl-usa.com/home/home.asp) is duplicated. EXCEPTION: psql failed: DETAIL: Key (topic_id, post_id, url)=(19891, 32700, http://www.dhl-usa.com/home/home.asp) is duplicated. /var/www/discourse/lib/backup_restore/database_restorer.rb:92:in `restore_dump' /var/www/discourse/lib/backup_restore/database_restorer.rb:26:in `restore' /var/www/discourse/lib/backup_restore/restorer.rb:51:in `run' script/discourse:149:in `restore' /var/www/discourse/vendor/bundle/ruby/2.7.0/gems/thor-1.2.1/lib/thor/command.rb:27:in `run' /var/www/discourse/vendor/bundle/ruby/2.7.0/gems/thor-1.2.1/lib/thor/invocation.rb:127:in `invoke_command' /var/www/discourse/vendor/bundle/ruby/2.7.0/gems/thor-1.2.1/lib/thor.rb:392:in `dispatch' /var/www/discourse/vendor/bundle/ruby/2.7.0/gems/thor-1.2.1/lib/thor/base.rb:485:in `start' script/discourse:290:in ` ' /usr/local/lib/ruby/gems/2.7.0/gems/bundler-2.3.18/lib/bundler/cli/exec.rb:58:in `load' /usr/local/lib/ruby/gems/2.7.0/gems/bundler-2.3.18/lib/bundler/cli/exec.rb:58:in `kernel_load' /usr/local/lib/ruby/gems/2.7.0/gems/bundler-2.3.18/lib/bundler/cli/exec.rb:23:in `run' /usr/local/lib/ruby/gems/2.7.0/gems/bundler-2.3.18/lib/bundler/cli.rb:483:in `exec' /usr/local/lib/ruby/gems/2.7.0/gems/bundler-2.3.18/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run' /usr/local/lib/ruby/gems/2.7.0/gems/bundler-2.3.18/lib/bundler/vendor/thor/lib/thor/invocation.rb:127:in `invoke_command' /usr/local/lib/ruby/gems/2.7.0/gems/bundler-2.3.18/lib/bundler/vendor/thor/lib/thor.rb:392:in `dispatch' /usr/local/lib/ruby/gems/2.7.0/gems/bundler-2.3.18/lib/bundler/cli.rb:31:in `dispatch' /usr/local/lib/ruby/gems/2.7.0/gems/bundler-2.3.18/lib/bundler/vendor/thor/lib/thor/base.rb:485:in `start' /usr/local/lib/ruby/gems/2.7.0/gems/bundler-2.3.18/lib/bundler/cli.rb:25:in `start' /usr/local/lib/ruby/gems/2.7.0/gems/bundler-2.3.18/exe/bundle:48:in `block in ' /usr/local/lib/ruby/gems/2.7.0/gems/bundler-2.3.18/lib/bundler/friendly_errors.rb:120:in `with_friendly_errors' /usr/local/lib/ruby/gems/2.7.0/gems/bundler-2.3.18/exe/bundle:36:in ` ' /usr/local/bin/bundle:25:in `load' /usr/local/bin/bundle:25:in ` ' Trying to rollback... Rolling back... Cleaning stuff up... Dropping functions from the discourse_functions schema... Removing tmp '/var/www/discourse/tmp/restores/default/2022-08-29-194458' directory... Unpausing sidekiq... Marking restore as finished... Notifying 'system' of the end of the restore... Finished! [FAILED] Restore done. The forum is running fine on the old server. I put it in read-only mode, took the backup, transfered it to the new machine and started the restore. Any ideas how to resolve this, please?

It looks like you have a corrupt index. You’ll need to delete or update those entries. If you search I think there may still be some topics that describe generally hour to do it. On the old server you try to reindex that table and keep changing stuff until it succeeds. If you’re not familiar with sql and have a budget then you can ask in #marketplace or contact me. What version of Discourse and postgres are you running? I haven’t seen many cases of this since postgres 13.

לא ניתן לשחזר database: sql key משוכפל

תמיכה התקנה

Amethi (Jay Van der Zant) 30 באוגוסט,‏ 2022,‏ 6:22pm 4

Thanks Jay. I’ll reach out. I’m maxed out atm.

נושא		תגובות	צפיות
"EXCEPTION: psql failed: DETAIL: Key (post_id)=(36946) is duplicated." Self-hosting	7	1373	20 ביוני,‏ 2022
Error restoring backup "key is duplicated" Self-hosting	7	2018	30 באוגוסט,‏ 2017
Error on restore: could not create unique index Self-hosting	1	1918	12 במרץ,‏ 2022
Error importing backup: "could not create unique index" Self-hosting	6	1215	1 בנובמבר,‏ 2021
Restore fails: could not create unique index Self-hosting	10	1375	13 בפברואר,‏ 2022

לא ניתן לשחזר database: sql key משוכפל

נושאים קשורים