App Outage: Found 1 workspaces with pending migrationsdock
Hi, something weird has happened to my self-hosted twenty instance...
It was working fine on 0.55.9 - about three weeks ago I had a failed attempt at upgrading to 1.0.0, but managed to roll back successfully - at least that's how it appeard at the time, and it was working fine until I left for holidays. I dropped by the office to fix some internet issues and had to reboot the host machine as well, and now nothing works - I keep getting various error messages and can't see any of the data models in the UI. In the admin panel the app is marked with outage, and claims that it found 1 workspace with pending migrations.
According to docker ps all containers are healthy, but there are numerous SELECT errors in the twenty-server logs.
The first one is this:
query failed: SELECT "favorite"."position" AS "favorite_position" ...
error: error: column favorite.knowledgeBaseId does not exist
I had some issues when trying to create that data model and I suspect that the rollback wasn't as successful as I hoped. Any ideas how to resolve this?
6 Replies
All data is still in the database and I can fetch it from other applications through the API.
Hello you're missing a migration
Please share your workspace version
default.core.workspace.version
Hi, workspace version in the db seems to be 0.54.6
You need to restore a backup from this version
And re upgrade, checking why it might fail
Is there any way to manually run the missing migration instead?
Looks like I'm in a bit of trouble here with restoring. I'm going to set up a new server at any rate and will run a fresh install with the latest version there. What's the easiest way to migrate existing data between versions? CSV export/import?
Yep CSV export import is atm the easiest to go with
You will still have to define object and fields definition manually