cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Harikrishna Patnala <harikrishna.patn...@citrix.com>
Subject Re: Database upgrade
Date Wed, 25 Sep 2013 05:05:43 GMT
My comments inline

-Harikrishna

On 25-Sep-2013, at 10:18 AM, Indra Pramana <indra@sg.or.id> wrote:

> Dear all,
> 
> During my (failed) upgrade attempt from CloudStack 4.1.1 to 4.2.0 early
> this week, I noted that CloudStack management server will automatically
> detect the database version and upgrade the database automatically.
> 
> ===
> 2013-09-24 02:23:48,145 INFO  [utils.component.ComponentContext]
> (Timer-1:null) Running SystemIntegrityChecker managementServerNode
> 2013-09-24 02:23:48,145 INFO  [utils.component.ComponentContext]
> (Timer-1:null) Running SystemIntegrityChecker databaseUpgradeChecker
> 2013-09-24 02:23:48,145 INFO  [cloud.upgrade.DatabaseUpgradeChecker]
> (Timer-1:null) Grabbing lock to check for database upgrade.
> 2013-09-24 02:23:48,147 DEBUG [upgrade.dao.VersionDaoImpl] (Timer-1:null)
> Checking to see if the database is at a version before it was the version
> table is created
> 2013-09-24 02:23:48,154 INFO  [cloud.upgrade.DatabaseUpgradeChecker]
> (Timer-1:null) DB version = 4.1.1 Code Version = 4.2.0
> 2013-09-24 02:23:48,154 INFO  [cloud.upgrade.DatabaseUpgradeChecker]
> (Timer-1:null) Database upgrade must be performed from 4.1.1 to 4.2.0
> 2013-09-24 02:23:48,154 DEBUG [cloud.upgrade.DatabaseUpgradeChecker]
> (Timer-1:null) Running upgrade Upgrade410to420 to upgrade from 4.1.0-4.1.1
> to 4.2.0
> 2013-09-24 02:23:48,159 DEBUG [utils.script.Script] (Timer-1:null) Looking
> for db/schema-410to420.sql in the classpath
> 2013-09-24 02:23:48,160 DEBUG [utils.script.Script] (Timer-1:null) System
> resource: file:/usr/share/cloudstack-management/setup/db/schema-410to420.sql
> 2013-09-24 02:23:48,160 DEBUG [utils.script.Script] (Timer-1:null) Absolute
> path =  /usr/share/cloudstack-management/setup/db/schema-410to420.sql
> ===
> 
> My questions:
> 
> (1) Am I right to say that this database check and upgrade is done when the
> cloudstack-management 4.2.0 service is started? It's not performed during
> the installation/upgrade of the cloudstack-management app (in my case,
> apt-get install cloudstack-management)?
>>> Yes database upgrade happens during the start of MS. It compares the CS version
in DB and MS version if upgrade path is defined DB upgrades to the MS version.
Even during any fresh install, DB points to 4.0 and during start of MS, DB upgrade happens
to the MS version. 
> 
> (2) I used a new set of disk for my upgrade attempt by cloning the existing
> disk to a new one (using dd), and perform the upgrade on the new disk. When
> I failed the upgrade attempt, I just reverted back to the old disk and
> restore the database (which is hosted on a different server). The new set
> of disk is still containing the new 4.2.0 of cloudstack-management app
> inside.
> 
> To perform another upgrade attempt, can I just boot-up using the new set of
> disk (instead of re-cloning and re-doing the upgrade)? Will it again detect
> that the existing database is still version 4.1.1, and will automatically
> upgrade the database to version 4.2.0 when the service is started?
>>> Yes, upgrade happens again since you have restored the DB to 4.1 and during MS
start it gets the DB version from version table(here it is 4.1).
> 
> Looking forward to your reply, thank you.
> 
> Cheers.


Mime
View raw message