Difference between core.view and workspace_schema.view in v1.4
In the v1.4 database, what’s the difference between the core.view table and the workspace_schema.view table?
I would like to know, as we are getting an issue while migrating from v1.3 to v1.4.
16 Replies
Hello, in 1.4 the
workspace_schema.views is getting deprecated for the core.view table@Prastoin Can we have a quick call? I have a few doubts about the upgrade, If you are available?
Sorry unavailable in vocal, please feel free to share your concerns
This migration seems to be for v1.3 to v1.4, but in the v1.4.12 codebase, it's declared as a v1.5 migration command.
And due to that, I am getting this issue to upgrade to 1.4.
Issue thread: https://discord.com/channels/1130383047699738754/1418203013197332560
In v1.4.12, there is one change to remove the view relation from the favorite object, but the migration is declared as v1.5 command.
We've been manually running the command on prod 1.4 but make them run for self hosters on 1.5
It should not be an issue
As we are self-hosting, I plan to upgrade to v1.4 using the v1.4.12 tag. Do I need to run the manual upgrade commands that are listed in the v1.5 instructions? Later, when we merge v1.5.0, which upgrade commands should be executed, considering that some of them would have already been run during the previous upgrade?
From what version of 1.4 exactly ?
1.4.12
Commands are idempotent by definition
You're upgrading from 1.4.12 to 1.4.12 ?
from v1.3.1 to v1.4.12
Unless I'm mistaken your workspace is still erroring due to the relation convert col error ?
I woudl rather manually fix the workspace in 1.3 first
That is fixed by running the "migrate:1-5:remove-favorite-view-relation", command specified in v1.5 commands.
Ok I see
You can proceed to upgrade to 1.4 and so on
Re running the command will only attempt to fix previously migrated view anw
Please be sure to make a backup still beforehand
In the twenty env name APP_VERSION is there, and from the current DB core.workspace and APP_VERSION, the upgrade command is automatically run the upgrade command, right? If I am not wrong?
Upgrade will be run within the entrypoint.sh, so yes you should be able to find its logs at the start of your twenty server container