Yes, I've sent them email on that, the create-schema should not diverge from 4.0 create-schema except for the drop table rules. There is another thread on that http://markmail.org/message/2v3hqmanasol6okw
And I started a thread on fixing those diversions: http://markmail.org/thread/z32xdbr2injgjrrp We have to move them (the changes) to schema upgrade paths in schema-40to41 and schema-41to42 as applicable and as soon as possible. Regards. On Tue, Feb 19, 2013 at 5:56 PM, Sanjay Tripathi <sanjay.tripa...@citrix.com> wrote: > > As a workaround, in DatabaseUpgradeChecker I added the upgrade path in maps > and commented out the database version check with MS code Version, that > worked. > > > @Koushik: while running the jetty server, getting this error: > > ERROR [utils.db.ScriptRunner] (main:) Error executing: ALTER TABLE > `cloud`.`hypervisor_capabilities` ADD COLUMN `max_hosts_per_cluster` int > unsigned DEFAULT NULL COMMENT 'Max. hosts in cluster supported by hypervisor' > ERROR [utils.db.ScriptRunner] (main:) > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column > name 'max_hosts_per_cluster' > > I checked create-schema.sql and "max_hosts_percluster" column is already > present in "hypervisor_capabilities" table. > Can you pls remove the sql queries which are not required in > schema-410to420.sql. > > Thanks, > Sanjay > >> -----Original Message----- >> From: rohityada...@gmail.com [mailto:rohityada...@gmail.com] On Behalf >> Of Rohit Yadav >> Sent: Tuesday, February 19, 2013 4:10 PM >> To: cloudstack-dev@incubator.apache.org >> Subject: Re: unable to upgrade database to 4.2.0 >> >> On Mon, Feb 18, 2013 at 11:49 PM, Sanjay Tripathi >> <sanjay.tripa...@citrix.com> wrote: >> > Hi all, >> > >> > It seems like CloudStack is not upgrading the database to 4.2.0. >> > I checked the DatabaseUpgradeChecker file and the Upgrade410to420() >> was missing from "upgradeMap", so I added it but after this, CloudStack >> throwing this error: >> > "The end upgrade version is actually at 4.2.0 but our management server >> code version is at 4.1.0-SNAPSHOT". >> > This is because our MS code version is 4.1.0 so CS is not allowing to >> > upgrade >> database beyond 4.1.0 . >> > >> > Is there any other way to upgrade the database or we have to change the >> MS code version to 4.2.0-SNAPSHOT? >> >> That is one way to fix it in pom, or if you want to enforce you can change >> the >> target or pkg version in DatabaseUpgraderChecker (make sure you add an >> upgrade path in the maps): >> String dbVersion = _dao.getCurrentVersion(); >> String currentVersion = >> this.getClass().getPackage().getImplementationVersion(); >> >> I'll send out an email to change the version to 4.2.0 now that we've branched >> out 4.1 already. >> >> Regards. >> >> > >> > Regards, >> > Sanjay