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 …

[图片] 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…

[图片] Gunnar: find them and fix them all before I try again A less invasive approach may be to reindex the database before upgrading and should tell you which ones need to be fixed. [图片] Corrupt indexes in PG12, how do I fix? installation Sorry for bumping this once…

[图片] omarfilip: reindex the database I’m not a database guy, so that looks scary. And if I read it correctly, you then end up with duplicate indices, and have to delete them manually? Besides, here’s the strange part. Like you found on my site with the previous duplicate, I found a duplicate…

I tried rebuilding again, and found yet another duplicate with the username “drc”. In the GUI, I found these two: Deborah C David C Try clicking on either user to see their details on their profile “card”. You’ll see that no matter which of them you click, you’ll see the details for Deborah C. I…

I wonder what the following would return: select id, username FROM users WHERE username_lower = 'robs' OR username = 'RobS': It’s not something silly like one of the username entries has whitespace, or a non-printing character / unicode somehow in it?

2.7.0.beta2 升级失败，出现 ERROR: duplicate key

支持安装

pfaffman (Jay Pfaffman) 2021 年1 月 25 日 17:26 21

我认为我过去就是这样解决类似问题的。重建索引，当它失败时，会提示你哪个是重复项，然后你修复它，再试一次。重复此过程。

话题		回复	浏览量
Upgrade failed with "duplicate key value violates unique constraint" error Self-hosting	18	2514	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	1694	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	2011	2021 年2 月 15 日

2.7.0.beta2 升级失败，出现 ERROR: duplicate key

相关话题