Key (username_lower)=(philippe) already exists.
Take a Full backup before trying to fix anything as there is a risk that you might end up breaking it even more.
There are a few topics that provide guidance on how to deal with duplication errors (you basically have to find and delete the duplicates before proceeding)
I was upgrading from 2.7.0.beta1 and got this error message:
2021-01-22 20:16:22.015 UTC [4055] discourse@discourse LOG: duration: 75335.241 ms statement: UPDATE notifications SET processed = true
2021-01-22 20:16:23.792 UTC [4055] discourse@discourse LOG: duration: 1776.591 ms statement: ALTER TABLE "notifications" ALTER COLUMN "processed" SET NOT NULL
2021-01-22 20:16:25.198 UTC [4055] discourse@discourse LOG: duration: 1323.298 ms statement: CREATE INDEX "index_notifications_on_proce…
Sorry for bumping this once again, I got a very strange
discourse=# REINDEX SCHEMA CONCURRENTLY public;
ERROR: could not create unique index "index_tags_on_name_ccnew"
DETAIL: Key (name)=(chronicillness) is duplicated.
I’m assuming it can be fixed by the solution suggested above by @riking but I’m unable to figure out how to modify the syntax to suit my case.
Hello,
I just used the upgrade tool to upgrade my discourse instance. Oddly, the forum is now down. When I tried to rebuild using the command line, I am getting this error:
duplicate key value violates unique constraint "index_tags_on_lower_name"
This error is repeated multiple times in the log so I recon its something about it.
Here is the full logs:
https://paste.apps.7ho.st/dezomakasu.sql (This is a portion of the logs, but here is the full log)
Could anyone help me out? I also restored…
5 Likes