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…

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: [이미지] Error upgrading, failed to bootstrap Self-hosting 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 …

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.

[이미지] pfaffman: DROP COLUMN bookmarkable_type; didn’t work unfortunately, still getting PG::DuplicateColumn: ERROR: column "bookmarkable_id" of relation "bookmarks" already exists Was there anymore action to take after these commands? ALTER TABLE bookmarks DROP COLUMN bookmarkable_id DRO…

Hi Nick, I trying to reproduce this, what is the commit of your instance? you could try with version: cd7ce52138bed391d5efc56366e7a6517a6079e7 in your app.yml, that’s 10 days ago, just before the redo of a reverted commit that seems to have had similar issues.

Morning Ben, Would it be possible to give me the run through of commands to do this please? I can update and all that easy but this is the first time something has gone wrong and to be honest I’m totally out of my comfort zone lol

Could you ./launcher start app and check the installed version in https://your.domain/admin so I can try to retrace your steps. Any plugin ?

실패하거나 일부 적용된 업그레이드에서 복구

지원 자체 호스팅

Nick_Tomlinson (Nick Tomlinson) 4월 1, 2022, 6:39오전 11

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

글		댓글	조회수
Update failed for some reason? Self-hosting	1	743	3월 30, 2022
Migration from discourse v2.8.13 (on Ubuntu 20.04.6 LTS) to latest Self-hosting	3	828	8월 15, 2023
Help! Upgrade led to complete fail Self-hosting	7	1472	3월 9, 2021
Error upgrading, failed to bootstrap Self-hosting	20	1982	3월 26, 2022
Upgrade failed: ERROR: relation "idx_regular_post_search_data" already exists Self-hosting	2	723	8월 21, 2020

실패하거나 일부 적용된 업그레이드에서 복구

Related topics