I am facing a problem after the recent update when I updated discourse. Now I am rebuilding using ssh, which shows an error root@ask:~# cd /var/discourse root@ask:/var/discourse# ./launcher rebuild app Ensuring launcher is up to date Fetching origin Launcher is up-to-date Stopping old container + …

I would try updating once more from the command line via SSH and see if that helps: cd /var/discourse ./launcher rebuild app Reply with the log of what happens when you try that.

same error occurred please help as the forum is down

If you need urgent help I suggest paying Jay at literatecomputing.com for support. It looks like you’re hitting duplicate key value errors: I, [2021-03-07T19:02:48.138872 #1] INFO -- : > cd /var/www/discourse && su discourse -c 'bundle exec rake db:migrate' 2021-03-07 19:02:53.906 UTC [692] disco…

[image] ankur1857: PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_users_on_username_lower" DETAIL: Key (username_lower)=(ravi_kumar) already exists. Looks like you have a corruption in your users table … one record for ravi_kumar appears twice. Very compl…

Yep, to give you an idea of what’s involved take a look at this example of a similar problem and resolution on a different table: Failed upgrade: UniqueViolation: duplicate key value violates unique constraint "data_explorer_queries_pkey"

Where can I run the following command? SELECT username_lower, count() from users GROUP by username_lower HAVING count() > 1; it shows following error bash: syntax error near unexpected token `(’

Did you follow the same process as the link I shared, specifically?: [image] Failed upgrade: UniqueViolation: duplicate key value violates unique constraint "data_explorer_queries_pkey" Self-hosting So restart the container? ./launcher start app Then you wan…

Nothing is happening using the following commands can anyone help to solve this? root@ask:~# cd /var/discourse root@ask:/var/discourse# ./launcher enter app root@ask-app:/var/www/discourse# su postgres -c ‘psql discourse’ psql (13.1 (Debian 13.1-1.pgdg100+1)) Type “help” for help. discourse=# …

That’s just logged you into the database CLI. Now you need to explore and rectify the issue.

Problem after Discourse update

Support Self-hosting

sam (Sam Saffron) March 8, 2021, 4:36am 6

Looks like you have a corruption in your users table … one record for ravi_kumar appears twice.

Very complicated to fix, recommend you commission help. You need to boot up the postgres server and delete the dupe record.

Topic		Replies	Views
Update Not Completed and Discourse not opening Self-hosting	16	786	June 17, 2024
Forum went down and rebuilding gives db:migrate error Self-hosting	5	1774	June 22, 2021
Unable to rebuild app Self-hosting	12	2075	January 20, 2022
Failed to Bootstrap, due to discourse-alt-logo theme component Self-hosting	7	1459	June 30, 2021
Unable to boostrap Discourse since last upgrade Self-hosting	4	841	January 22, 2023

Problem after Discourse update

Related topics