Upgrading to current version of Discourse today, the rebuild is failing and I’m not exactly sure what’s causing it. The install was quite a few iterations behind (I think 2.8x). The docker image update went fine when I went to upgrade Discourse I was asked to do a manual pull & rebuild (Most of the …

Expanding on what @Canapin has said, in case you haven’t already figured it out, it should be straightforward to get the usernames unique since you’ve already established that racerx is the only duplicated username. First, if you haven’t already, make sure racerx2 doesn’t already exist so you aren’…

It seems to think you have two users called racerx. I think there’s a topic about a similar issue here: [圖片] Import failing with `could not create unique index` We also had 8 users which had a duplicate username_lower (too many mike’s and marco’s). We renamed those by updating both username and u…

Thanks I will start down that path… wish me luck..

I’m stuck on how to kickoff the re indexing. I’ve been able to start (Although it’s not web accessible) and enter the app but no luck moving forward from that. [image]

You need to run those commands inside the container. Something like ./launcher start app ./launcher enter app Before you sudo postgres Edit: oh, you got in the container. That postgres -c needs sudo before it.

I guess sudo wouldn’t work, but su did and now I’m poking around in postgres. So now I need to figure out how to actually fix the duplicates. The query appears to be.. UPDATE users SET username_lower = 'xxx' WHERE id = xxx; I tried a couple of variations to no avail. As you can tell I’m not 100% …

Did you figure out how to fix it? I’d return the users’ ID (which is unique) as well to identify them properly and then rename one of these two users :slight_smile:

Update (Was in drafts for a few days, sorry) Looks like I got it figured out. Not sure if it what I did was the right approach, but it rebuilt successfully. Found it hard to modify\append the racerx value in the username_lower column using the syntax so I went about it another way. by looking up t…

[网站宕机 :(] 升级\重建失败 - 数据库迁移问题？

支持安装

JammyDodger 2023年六月14日 20:57 2

它似乎认为您有两个名为 racerx 的用户。我认为这里有一个关于类似问题的帖子：

这里还有一个最近的帖子：

話題		回覆	觀看
Upgrade issue with duplicate username in DB Self-hosting	2	531	2021年一月29日
PG::UniqueViolation Problem during 3.1.0.beta4 upgrade Self-hosting	5	668	2023年四月19日
2.7.0.beta2 upgrade failed with ERROR: duplicate key Self-hosting	24	2495	2021年一月26日
How does one run sql queries if the container doesn't start? (rebuild failed) Self-hosting	6	821	2023年一月20日
Error importing backup: "could not create unique index" Self-hosting	6	1136	2021年十一月1日

[网站宕机 :(] 升级\重建失败 - 数据库迁移问题？

相關主題