I was upgrading from 2.7.0.beta1 and got this error message: 2021-01-22 20:16:22.015 UTC [4055] discourse@discourse LOG: duration: 75335.241 ms statement: UPDATE notifications SET processed = true 2021-01-22 20:16:23.792 UTC [4055] discourse@discourse LOG: duration: 1776.591 ms statement: ALTER…

I think you can get the site back up with ./launcher start app Then take a look at ways to delete the duplicate: [画像] Duplicate data explorer key blocking rebuild support Hey all, Rare I ask for help, but I’m puzzled about how to resolve this. Just rebuilt my site and …

More information I should probably provide: This is a single container install. The first rebuild completed without any errors. This error occurred when I was running the second rebuild, after the first rebuild completed successfully. Thanks, Gunnar

Do you have enough disk space? Error related to the required PostgreSQL update to version 13 afaik. Did you follow this upgrade method ? cd /var/discourse git pull ./launcher rebuild app If you search the forum for those errors you’ll see a lot of past information and possible fixes. [画像] Gu…

I got the site back up by renaming postgres_data_old back to postgres_data and then running ./launcher start app to start the old image. So, I’m back to square 1, but at least the site is up. I tried to find the duplicate key, by entering this: select * from users WHERE username = 'DaveW'; (user…

You do have two, possibly capitalized differently in the DB: [Screen Shot 2021-01-22 at 3.25.53 PM]

[画像] omarfilip: You do have two Did you visit my site? :wink: I see what you mean, when I search the in the GUI, I do see two. However, when I click on both as an admin and bring up the details page, they appear to be the same user. I can’t find a single detail that’s different between the t…

[画像] Gunnar: Did you visit my site? :wink: Of course! :grinning: That should delete 19732 but I can’t guarantee the absence of any ill effects. In any case, a backup before proceeding further is advisable.

You might also change the username of one of the duplicates.

[画像] pfaffman: change the username Right. Once I do, should I be able to restart the upgrade from scratch? I.e. run rebuild twice? Thanks! Gunnar

That should work. Unless there are other duplicate users.

[画像] pfaffman: Unless there are other duplicate users. Turns out there are, at least one. PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_users_on_username_lower" DETAIL: Key (username_lower)=(robs) already exists. Is there any way I can scan the database…

2.7.0.beta2 のアップグレード中に ERROR: duplicate key が発生しました

サポートインストール

omarfilip 2021 年 1 月 22 日午後 8:37 2

./launcher start app でサイトを再起動できると思います。

その後、重複データを削除する方法を確認してください。

および

「いいね！」 5

トピック		返信	表示
Upgrade failed with "duplicate key value violates unique constraint" error Self-hosting	18	2499	2020 年 3 月 30 日
PG::UniqueViolation Problem during 3.1.0.beta4 upgrade Self-hosting	6	606	2023 年 5 月 19 日
Upgrade Issues: Failed Upgrade due to Duplicate Key, Failed Snapshot Restore Self-hosting	7	1689	2023 年 4 月 25 日
[Site Down :(] Upgrade\Rebuild Failure - DB Migration Issue? Self-hosting	9	681	2023 年 6 月 19 日
Upgrade Failed from 2.7.0.beta1 to 2.7.0.beta3 Self-hosting	13	2005	2021 年 2 月 15 日

2.7.0.beta2 のアップグレード中に ERROR: duplicate key が発生しました

関連トピック