I tried to run updates & rebuild, but I ended up with this beautiful error:
I, [2023-01-18T08:05:48.701709 #1] INFO -- : > cd /var/www/discourse && su discourse -c 'LOAD_PLUGINS=0 bundle exec rake plugin:pull_compatible_all'
I, [2023-01-18T08:05:52.431210 #1] INFO -- :
I, [2023-01-18T08:05:52.431807 #1] INFO -- : > cd /var/www/discourse && su discourse -c 'bundle exec rake db:migrate'
2023-01-18 08:05:59.081 UTC  discourse@discourse ERROR: could not create unique index "index_tags_on_name_ccnew_ccnew_ccnew5"
2023-01-18 08:05:59.081 UTC  discourse@discourse DETAIL: Key (name)=(vuejs) is duplicated.
2023-01-18 08:05:59.081 UTC  discourse@discourse STATEMENT: REINDEX INDEX CONCURRENTLY index_tags_on_name_ccnew_ccnew
StandardError: An error has occurred, all later migrations canceled:
PG::UniqueViolation: ERROR: could not create unique index "index_tags_on_name_ccnew_ccnew_ccnew5"
DETAIL: Key (name)=(vuejs) is duplicated.
There are other topics on the forum with similar issues (1, 2, 3) but when I try to enter the container I get this:
/var/discourse# ./launcher enter app
x86_64 arch detected.
Error: No such container: app
Therefore I’m unable to drop indices manually.
Any other suggestion on what aproach should I take next?
Thanks for the bug report. I will have a look at this, but I believe there is an issue with an index in your database and a recent migration attempts to fix that, but some issues cannot be fixed without a human intervention.
I believe the commit that introduced the migration that fails is this one:
You can try pinning your Discourse instance to the previous version which is commit 690e2f15ab9549486aaa6750e1093c1336bf17f2. Edit your app.yml file and set the version key under params. Make sure to uncomment that key too!
Then, everything should start and you should be able to remove the duplicated vuejs tag, but that might have some unwanted effects if the duplicated tag is in use. We will try to find a better solution, but this should work until then.