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

[imagem] 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? [imagem] Ahmed Eldeep: My website is now offli…

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…

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.

Problema PG::UniqueViolation durante o upgrade para 3.1.0.beta4

Suporte ao Produto Instalação

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

Ótimo! Fico feliz que você tenha resolvido. Suas anotações devem ser muito úteis para outras pessoas com o mesmo problema.

Editei sua postagem para facilitar a cópia/colagem do seu SQL por outras pessoas.

Tópico		Respostas	Visualizações
2.7.0.beta2 upgrade failed with ERROR: duplicate key Self-hosting	24	2561	26 de Janeiro de 2021
[Site Down :(] Upgrade\Rebuild Failure - DB Migration Issue? Self-hosting	8	905	19 de Junho de 2023
Upgrade issue with duplicate username in DB Self-hosting	2	546	29 de Janeiro de 2021
Upgrade fails while migrating Self-hosting	4	968	11 de Julho de 2019
Upgrade Issues: Failed Upgrade due to Duplicate Key, Failed Snapshot Restore Self-hosting	7	1814	25 de Abril de 2023

Problema PG::UniqueViolation durante o upgrade para 3.1.0.beta4

Tópicos relacionados