while upgrading to 3.1.0.beta4 I got the following error I, [2023-04-19T00:02:26.057232 #1] INFO -- : > cd /var/www/discourse && su discourse -c 'LOAD_PLUGINS=0 bundle exec rake plugin:pull_compatible_all' I, [2023-04-19T00:02:27.340128 #1] INFO -- : discourse-adplugin is already at latest compat…

That looks like either a corrupt index or that somehow users were able to create accounts with the same username with different capitalization. You should be able to start the old container with ./launcher start app You can then try to reindex the table, see which user is broken, fix it, and repe…

Thanks for your reply. Yes, I am able to start / enter the app, I am also doing as you suggested. discourse=# REINDEX TABLE users; ERROR: could not create unique index "index_users_on_username_lower" DETAIL: Key (username_lower)=(mostafa11) is duplicated. The problem is duplicates keep coming, …

[image] Ahmed Eldeep: there any way to check how many duplicates or list all of them? I’m not aware of one. It shouldn’t happen, I think. What version are you upgrading from? Maybe you can search for users where username! = username_lower? [image] Ahmed Eldeep: My website is now offline…

Thanks Jay I was able to rebuild and get my website online again. First as you suggested the solution is to reindex, fix and repeat until done. I used the following command to see how many SELECT username_lower, count(*) from users GROUP by username_lower HAVING count(*) > 1; it was giving me ze…

PG::UniqueViolation Problem during 3.1.0.beta4 upgrade

Product Support Self-hosting

pfaffman (Jay Pfaffman) April 19, 2023, 5:16pm 6

Great! So glad you got it figured out. Your notes should be very helpful to others with the same issue.

I edited your post to make it easier for others to copy/paste your SQL.

Topic		Replies	Views
2.7.0.beta2 upgrade failed with ERROR: duplicate key Self-hosting	24	2552	January 26, 2021
[Site Down :(] Upgrade\Rebuild Failure - DB Migration Issue? Self-hosting	8	891	June 19, 2023
Upgrade issue with duplicate username in DB Self-hosting	2	545	January 29, 2021
Upgrade fails while migrating Self-hosting	4	963	July 11, 2019
Upgrade Issues: Failed Upgrade due to Duplicate Key, Failed Snapshot Restore Self-hosting	7	1808	April 25, 2023

PG::UniqueViolation Problem during 3.1.0.beta4 upgrade

Related topics