[SELF_HOST] v0.60 cannot upgrade due to relation "core.settingPermission" does not exist
As title states, migration is failing from 0.55.5 due to this error when starting container running 0.60.7.
32 Replies
Any update on this?
@Prastoin could you take a look at this in free time?
@Rorschach could you run yarn database:migrate:prod on the v0.60 container?
Your postgres core schema is missing some tables
(Note that "database:migrate:prod" is part of "command:prod upgrade" command)
Done
This comes up when trying to login
@Rorschach what timezone are you on? Let's schedule a call so I can help you, it will be easier
UK time
I'm having an office hour tomorrow for self-hosters, 11am Paris time, would it work for you?
Sorry I didn't get a notification
Let me know another time that suits
would next week same hour work for you?
What day?
same day!
okay
What time would suit @charles ?
Would 11am Paris time work?
Should be good
I can give you direct access to the postgres database if that's beneficial
Hey @Rorschach I would rather recommend planning a peer session rather than fixing your instance on your side so you can learn from it
Also, regarding your issue downgrading your instance to the twenty version where your workspace is blocked in order to incrementally upgrade it to the newest version should do the trick
It's already on the correct version to do the upgrade, but it's still blocked
or do you mean upgrade to 1.3 or 1.4?
Could you please share the whole logs from twenty-server ? searching for upgrade command of the blocked version error
I don't think there is an upgrade error, you looked at the log 2 weeks ago and the error you noted is the one in the subject of this post
If there's no errors than your workspace version in database should get incremented allowing you to incrementally upgrade your twenty instance up to the latest released twenty version
Are you sure you downgraded to the version your workspace is blocked at ?
I did as you instructed
The error was the one noted in this post heading
Ok ! So the upgrade is not working as expect
Please downgrade to 0.55.9
run in your twenty-server container
And re-attempt 0.60 upgrade
Please share any suspicious logs
Doing
Same error on login
could you please run
yarn command:prod upgrade on 0.55.9 ?
no need to update your workspace version just wanna check logs@Rorschach let's go 🙂
This is the only thing I see in the server container that looks like an error
The full line is too long to paste into chat
I'm DMing you
GitHub
twenty/packages/twenty-server/src/database/typeorm/core/migrations/...
Building a modern alternative to Salesforce, powered by the community. - twentyhq/twenty