[
https://issues.apache.org/jira/browse/CLOUDSTACK-3417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13703664#comment-13703664
]
Alena Prokharchyk commented on CLOUDSTACK-3417:
-----------------------------------------------
Fixed the missing table problem. Add it as a part of 306-41 upgrade. Now
reassigning the bug to Sheng as he needs to fix the foreign key insertion
portion for those tables. Currently the keys are being inserted in .sql file;
it should be moved to java part of the code and be inserted only when they
don't exist. Because some setups might have those keys, and some might miss
them. if the setup has the keys, you run into this exception during the upgrade:
INFO [cloud.upgrade.DatabaseUpgradeChecker] (Timer-2:) Database upgrade must
be performed from 3.0.6.2013-07-09T18:58:51Z to 4.2.0-SNAPSHOT
ERROR [utils.db.ScriptRunner] (Timer-2:) Error executing: ALTER TABLE
`cloud`.`baremetal_dhcp_devices` ADD CONSTRAINT
`fk_external_dhcp_devices_nsp_id` FOREIGN KEY (`nsp_id`) REFERENCES
`physical_network_service_providers` (`id`) ON DELETE CASCADE
ERROR [utils.db.ScriptRunner] (Timer-2:) java.sql.SQLException: Can't create
table 'cloud.#sql-c2_bc' (errno: 121)
ERROR [cloud.upgrade.DatabaseUpgradeChecker] (Timer-2:) Unable to execute
upgrade script:
/Users/alena/campo/client/target/utilities/scripts/db/db/schema-410to420.sql
java.sql.SQLException: Can't create table 'cloud.#sql-c2_bc' (errno: 121)
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
> [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
> Assignee: Alena Prokharchyk
> 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
