[jira] [Created] (CLOUDSTACK-3417) [Upgrade to 4.2.0] Upgrade to 4.2.0 fails with om.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'cloud.baremetal_dhcp_devices' doesn't exist

["Abhinav Roy (JIRA)" <ji...@apache.org>]

Abhinav Roy created CLOUDSTACK-3417:
---------------------------------------

             Summary: [Upgrade to 4.2.0] Upgrade to 4.2.0 fails with om.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'cloud.baremetal_dhcp_devices' doesn't exist 
                 Key: CLOUDSTACK-3417
                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-3417
             Project: CloudStack
          Issue Type: Bug
      Security Level: Public (Anyone can view this level - this is the default.)
          Components: Install and Setup
    Affects Versions: 4.2.0
            Reporter: Abhinav Roy
            Priority: Blocker
             Fix For: 4.2.0
         Attachments: management-server.log

Upgrade from CS 3.0.6 to 4.2.0 fails with the following error :

2013-07-09 16:08:56,133 ERROR [utils.db.ScriptRunner] (Timer-1:null) com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'cloud.baremetal_dhcp_devices' doesn't exist
2013-07-09 16:08:56,135 ERROR [cloud.upgrade.DatabaseUpgradeChecker] (Timer-1:null) Unable to execute upgrade script: /usr/share/cloudstack-management/setup/db/schema-410to420.sql
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'cloud.baremetal_dhcp_devices' doesn't exist
        at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:193)
        at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:87)
        at com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:211)
        at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:272)
        at com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:401)
        at com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:90)
        at com.cloud.servlet.CloudStartupServlet$1.run(CloudStartupServlet.java:50)
        at java.util.TimerThread.mainLoop(Timer.java:534)
        at java.util.TimerThread.run(Timer.java:484)
2013-07-09 16:08:56,139 ERROR [cloud.upgrade.DatabaseUpgradeChecker] (Timer-1:null) Unable to upgrade the database
com.cloud.utils.exception.CloudRuntimeException: Unable to execute upgrade script: /usr/share/cloudstack-management/setup/db/schema-410to420.sql
        at com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:220)
        at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:272)
        at com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:401)
        at com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:90)
        at com.cloud.servlet.CloudStartupServlet$1.run(CloudStartupServlet.java:50)
        at java.util.TimerThread.mainLoop(Timer.java:534)
        at java.util.TimerThread.run(Timer.java:484)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'cloud.baremetal_dhcp_devices' doesn't exist
        at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:193)
        at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:87)
        at com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:211)
        ... 6 more
2013-07-09 16:08:56,144 DEBUG [db.Transaction.Transaction] (Timer-1:null) Rolling back the transaction: Time = 1467 Name =  null; called by -Transaction.rollback:890-Transaction.removeUpTo:833-Transaction.close:657-DatabaseUpgradeChecker.upgrade:305-DatabaseUpgradeChecker.check:401-ComponentContext.initComponentsLifeCycle:90-CloudStartupServlet$1.run:50-TimerThread.mainLoop:534-TimerThread.run:484
2013-07-09 16:08:56,144 ERROR [utils.component.ComponentContext] (Timer-1:null) System integrity check failed. Refuse to startup





--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira