Error during latest upgrade
Hi all,
Just updated to the most recent Docker container (from the second most recent, they are updated regularly), experienced errors when running the two database upgrade commands.
When running yarn database:migrate:prod the first error occurs during the output, see attached.
When running yarn command:prod upgrade the second error occurs during the output, see attached.
After that the CRM reports "User does not have permission" when trying to open any records.
Any advice would be appreciated.
5 Replies
Second screenshot
I applied the command:
yarn command:prod upgrade:0-44:initialize-permissions
This resolved the first error
I have read in another thread I should either a) re-run an upgrade, or b) edit the workspace version, however I'm not 100% certain how to carry out either of these steps.
I can connect to postgres via pgadmin, however I'm not familiar with this tool; what table contains the version?
or... alternatively... which version should I redeploy in docker to restage the previous upgrade?
Hello @Rorschach, first of all congrats on your debug investigation you're very close from resolving your issue
Regarding the last blocking point:
- 1/ Downgrade your twenty version to the latest
0.44 version and run the classic combo ( migrate upgrade ). This should fix your workspaces version. Then retry 0.5 upgrade
- 2/ Manual fixing your workspaces version value ( located in postgres_schema core table workspaces )
several ways to do
A) Using a db explorer GUI such as Dbeaver, you will have to setup the connection and will be able to run queries from a user friendly interface
B) using psql directly on your db and related table and workspacesThank you @prastoin I will give it a try
Ok, if you're encountering any issues please let me know !