Hi Rakesh, db changes are applied automatically if the Cloudstack version changes and there is an upgrade path in the code, I think you may have not changed version.
Cheers Darrin ________________________________ From: Rakesh Venkatesh <www.rakeshv....@gmail.com> Sent: Friday, October 16, 2020 9:56 AM To: users <us...@cloudstack.apache.org>; dev <dev@cloudstack.apache.org> Subject: Automatically applying DB schema changes 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 darrin.husselm...@shapeblue.com www.shapeblue.com 3 London Bridge Street, 3rd floor, News Building, London SE1 9SGUK @shapeblue
