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

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% s…

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 14.Июнь.2023 20:57:40 2

Похоже, система считает, что у вас есть два пользователя с именем racerx. Я думаю, что здесь есть тема о подобной проблеме:

Также есть более свежая тема здесь:

Тема		Ответов	Просм.
Upgrade issue with duplicate username in DB Self-hosting	3	496	29.01.2021
PG::UniqueViolation Problem during 3.1.0.beta4 upgrade Self-hosting	6	611	19.05.2023
2.7.0.beta2 upgrade failed with ERROR: duplicate key Self-hosting	25	2301	25.02.2021
How does one run sql queries if the container doesn't start? (rebuild failed) Self-hosting	7	726	19.02.2023
Error importing backup: "could not create unique index" Self-hosting	7	1045	01.11.2021

[Сайт недоступен :(] Сбой обновления/перестройки — проблема с миграцией БД?

Связанные темы