I attempted to upgrade my Discourse instance, however due to a handful of issues, it seems to have failed in a partially applied state. When running ./launcher rebuild app, I get the following error message, which indicates to me a migration that was already (partially) applied: I, [2022-03-24T21:13:16.043071 #1] INFO -- : > cd /var/www/discourse && su discourse -c 'bundle exec rake db:migrate' rake aborted! StandardError: An error has occurred, this and all later migrations canceled: PG::DuplicateColumn: ERROR: column "bookmarkable_id" of relation "bookmarks" already exists Any guidance on if there’s a way to recover from this (or if I need to bite the bullet and do a fresh install) would be appreciated. Thanks!

## Which Git revision should this container use? (default: tests-passed) #version: tests-passed Is this it?

:+1: samples/standalone.yml e30ccb904 db_default_text_search_config: "pg_catalog.english" ## Set db_shared_buffers to a max of 25% of the total memory. ## will be set automatically by bootstrap based on detected RAM, or you can override #db_shared_buffers: "256MB" ## can improve sorting performance, but adds memory usage per-connection #db_work_mem: "40MB" ## Which Git revision should this container use? (default: tests-passed) #version: tests-passed env: LC_ALL: en_US.UTF-8 LANG: en_US.UTF-8 LANGUAGE: en_US.UTF-8 EMBER_CLI_PROD_ASSETS: 1 # DISCOURSE_DEFAULT_LOCALE: en ## How many concurrent web requests are supported? Depends on memory and CPU cores. ## will be set automatically by bootstrap based on detected CPUs, or you can override

[image] Benjamin_D: version: cd7ce52138bed391d5efc56366e7a6517a6079e7 so replace #version: tests-passed With version: cd7ce52138bed391d5efc56366e7a6517a6079e7 Then /var/discourse/launcher rebuild app

[image] Benjamin_D: cd7ce52138bed391d5efc56366e7a6517a6079e7 Just making sure this is correct before i rebuild ## Which Git revision should this container use? (default: tests-passed) version: cd7ce52138bed391d5efc56366e7a6517a6079e7 do i have to indent it again? (beware of the indentation) Now the code looks like this ## Which Git revision should this container use? (default: tests-passed) version: cd7ce52138bed391d5efc56366e7a6517a6079e7 Rebuild?

## Which Git revision should this container use? (default: tests-passed) version: cd7ce52138bed391d5efc56366e7a6517a6079e7

Like your first one: [image] Nick_Tomlinson: ## Which Git revision should this container use? (default: tests-passed) version: cd7ce52138bed391d5efc56366e7

Recovering from failed/partially applied upgrade

Product Support Self-hosting

Nick_Tomlinson (Nick Tomlinson) April 3, 2022, 12:20pm 41

Ben, It worked!

Thank you so much for your time & effort in assisting me!

(please PM me so i can send you some coffee or beer money)

Topic		Replies	Views
Update failed for some reason? Self-hosting	1	802	March 30, 2022
Migration from discourse v2.8.13 (on Ubuntu 20.04.6 LTS) to latest Self-hosting	3	911	August 15, 2023
Help! Upgrade led to complete fail Self-hosting	7	1588	March 9, 2021
Error upgrading, failed to bootstrap Self-hosting	20	2205	March 26, 2022
Upgrade failed: ERROR: relation "idx_regular_post_search_data" already exists Self-hosting	2	762	August 21, 2020

Recovering from failed/partially applied upgrade

Related topics