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…

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…

[사이트 다운 :(] 업그레이드/재구축 실패 - DB 마이그레이션 문제?

제품 지원 자체 호스팅

JammyDodger 6월 14, 2023, 8:57오후 2

두 개의 racerx 사용자가 있는 것으로 보입니다. 비슷한 문제에 대한 주제가 여기 있습니다:

또한 여기 더 최근의 사례도 있습니다:

글		댓글	조회수
Upgrade issue with duplicate username in DB Self-hosting	2	545	1월 29, 2021
PG::UniqueViolation Problem during 3.1.0.beta4 upgrade Self-hosting	5	694	4월 19, 2023
2.7.0.beta2 upgrade failed with ERROR: duplicate key Self-hosting	24	2552	1월 26, 2021
How does one run sql queries if the container doesn't start? (rebuild failed) Self-hosting	6	856	1월 20, 2023
Error importing backup: "could not create unique index" Self-hosting	6	1170	11월 1, 2021

[사이트 다운 :(] 업그레이드/재구축 실패 - DB 마이그레이션 문제?

Related topics