Hello Users and Dev

Is there a way a new DB schema changes can be applied automatically
whenever I install new packages? My setup was running with two month old
changes of 4.15 and when I deployed new packages with latest changes, all
the recent db scheme changes are not applied and I need to run it manually.
How do I avoid it and how do you guys do it?

For example: This is the error I get

Caused by: java.sql.SQLSyntaxErrorException: Unknown column
'image_store.readonly' in 'field list'

and a big stack trace

This was fixed by applying changes from
https://github.com/apache/cloudstack/blob/master/engine/schema/src/main/resources/META-INF/db/schema-41400to41500.sql#L198-L222


Another error was

Caused by: java.sql.SQLSyntaxErrorException: Unknown column
'project_invitations.account_role' in 'field list'


So I had to apply the schema needed for project_role related queries
-- 
Thanks and regards
Rakesh

Reply via email to