Error during upgrading from Beta 3.1.x to latest

[uwe_keim]

Thanks a lot.

The container is now running again, still the error persists.

Most likely I have the same Issue as here:

How does one run sql queries if the container doesn't start? (rebuild failed)

Hello. 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 [1166] discourse@discourse ERROR: could not create unique index "index_…

I’ll not try to resolve it the same way as described there.

Update 1 - Solution

OK, it seems I was able to resolve with these steps:

1. Edited the app.yaml and did:
   • Install the Data Explorer plugin
   • Pinned the version to a previous one
2. Rebuilt the image.
3. Activated and started Data Explorer plugin and used this query to identify the duplicate tags.
4. Used the regular admin GUI to identify the tags. Then renamed one tag to be unique again.
5. Removed the pinned version again.
6. Rebuilt Discourse sudo ./launcher rebuild app. This succeeded now.
7. After starting Discourse, I went to the tags admin area and further worked on the duplicated (deleted one of the formerly duplicate tags after assigning the other tag).