You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cloudstack.apache.org by Min Chen <mi...@citrix.com> on 2012/10/12 00:30:39 UTC

[ASF40]ant debug failed to upgrade database

Hi there,

                I have mysql DB of version 2.2.14, now when I run ant debug using ASF 4.0 branch, it failed in running DatabaseUpgradeChecker, see errors below:

     [java] INFO  [utils.component.ComponentLocator] (main:) Found component: co
m.cloud.utils.component.SystemIntegrityChecker in com.cloud.upgrade.PremiumDatab
aseUpgradeChecker - DatabaseUpgradeChecker
     [java] INFO  [utils.component.ComponentLocator] (main:) Adding system integ
rity checker: DatabaseUpgradeChecker
     [java] INFO  [cloud.upgrade.DatabaseIntegrityChecker] (main:) Grabbing lock
to check for database integrity.
     [java] INFO  [cloud.upgrade.DatabaseIntegrityChecker] (main:) Performing da
tabase integrity check
     [java] INFO  [cloud.upgrade.DatabaseUpgradeChecker] (main:) Grabbing lock t
o check for database upgrade.
     [java] INFO  [cloud.upgrade.DatabaseUpgradeChecker] (main:) DB version = 2.
2.14 Code Version = 4.0.0.2012-10-10T18:25:05Z
     [java] INFO  [cloud.upgrade.DatabaseUpgradeChecker] (main:) Database upgrad
e must be performed from 2.2.14 to 4.0.0.2012-10-10T18:25:05Z
     [java] WARN  [utils.script.Script] (main:) Unable to find script db/schema-
2214to30.sql
     [java] ERROR [utils.component.ComponentLocator] (main:) Problems with runni
ng checker:DatabaseUpgradeChecker

Anybody knows how to solve this issue?
                Thanks
                -min

RE: [ASF40]ant debug failed to upgrade database

Posted by Prachi Damle <Pr...@citrix.com>.
I see this sometimes on my windows dev setup - it should be some tomcat classpath issue. 

I workaround this on my setup by putting all scema files under {tomcat.home}/webapps/client/WEB-INF/lib/db/db/*.* to one  level up in {tomcat.home}/webapps/client/WEB-INF/lib/db

-Prachi

-----Original Message-----
From: Min Chen [mailto:min.chen@citrix.com] 
Sent: Thursday, October 11, 2012 3:31 PM
To: cloudstack-dev@incubator.apache.org
Subject: [ASF40]ant debug failed to upgrade database

Hi there,

                I have mysql DB of version 2.2.14, now when I run ant debug using ASF 4.0 branch, it failed in running DatabaseUpgradeChecker, see errors below:

     [java] INFO  [utils.component.ComponentLocator] (main:) Found component: co m.cloud.utils.component.SystemIntegrityChecker in com.cloud.upgrade.PremiumDatab aseUpgradeChecker - DatabaseUpgradeChecker
     [java] INFO  [utils.component.ComponentLocator] (main:) Adding system integ rity checker: DatabaseUpgradeChecker
     [java] INFO  [cloud.upgrade.DatabaseIntegrityChecker] (main:) Grabbing lock to check for database integrity.
     [java] INFO  [cloud.upgrade.DatabaseIntegrityChecker] (main:) Performing da tabase integrity check
     [java] INFO  [cloud.upgrade.DatabaseUpgradeChecker] (main:) Grabbing lock t o check for database upgrade.
     [java] INFO  [cloud.upgrade.DatabaseUpgradeChecker] (main:) DB version = 2.
2.14 Code Version = 4.0.0.2012-10-10T18:25:05Z
     [java] INFO  [cloud.upgrade.DatabaseUpgradeChecker] (main:) Database upgrad e must be performed from 2.2.14 to 4.0.0.2012-10-10T18:25:05Z
     [java] WARN  [utils.script.Script] (main:) Unable to find script db/schema- 2214to30.sql
     [java] ERROR [utils.component.ComponentLocator] (main:) Problems with runni ng checker:DatabaseUpgradeChecker

Anybody knows how to solve this issue?
                Thanks
                -min