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:1…

Yep, I’m aware of that (and have done so) - however, I’m wondering what my next move should be as far as upgrading.

Oh. That wasn’t helpful then :person_shrugging: I had a similar problem, but it seems unlikely my solution will help you. You don’t have SKIP_POST_DEPLOYMENT_MIGRATIONS set in your app.yml do you? If so, you need to migrate the database with it set to zero and then rebuild, but I don’t think that’…

That’s what I thought. So there might be an actual problem that has to do with being able to migrate from one particular point to the current one. But that’s not supposed to happen.

Check this out: [image] Error upgrading, failed to bootstrap installation Sorry. I’m on my phone and not quite thinking well enough to explain… After the start app su - postgres psql discourse And then the drop table discourse_reactions_reactions ; And then type …

Sounds right, @undasein . I think that you want to remove the bookmarkable_id column from the bookmarks table. So after you get into the container and into postgres like this: cd /var/discourse ./launcher enter app su - postgres psql Then you would ALTER TABLE bookmarks DROP COLUMN bookmarkable_…

Same issue here! Is this the correct solution to follow?

That was my guess. You can give it a shot and let us know.

I’m not discourse savvy. @sam any ideas how to go forward? Standard install and upgrade turns out to be a nightmare. Is the above the correct way to fix this issue? TIA

Recovering from failed/partially applied upgrade

Support Self-hosting

pfaffman (Jay Pfaffman) March 24, 2022, 9:28pm 2

You can do a

 ./launcher start app

To start the old container. That’ll get you back up.

Update failed for some reason?

Topic		Replies	Views
Update failed for some reason? Self-hosting	1	689	March 30, 2022
Migration from discourse v2.8.13 (on Ubuntu 20.04.6 LTS) to latest Self-hosting	4	740	August 15, 2023
Help! Upgrade led to complete fail Self-hosting	8	1375	March 9, 2021
Error upgrading, failed to bootstrap Self-hosting	21	1862	April 25, 2022
Upgrade failed: ERROR: relation "idx_regular_post_search_data" already exists Self-hosting	3	666	September 20, 2020

Recovering from failed/partially applied upgrade

Related topics