No way automatically, manually is OK and the only way forward since you are on the same version all the time.
Best, On Fri, 16 Oct 2020, 10:00 Darrin Hüsselmann, < darrin.husselm...@shapeblue.com> wrote: > 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 > > > >
