You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@cloudstack.apache.org by "frank zhang (JIRA)" <ji...@apache.org> on 2013/07/27 00:17:49 UTC
[jira] [Commented] (CLOUDSTACK-3833) 3.0.6 to ASF 4.2 Upgrade:
"cloud" Database Schema Inconsistencies on the Upgraded Setup - Tables
"baremetal_dhcp_devices" and "baremetal_pxe_devices"
[ https://issues.apache.org/jira/browse/CLOUDSTACK-3833?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13721294#comment-13721294 ]
frank zhang commented on CLOUDSTACK-3833:
-----------------------------------------
Chandan, how do you do the upgrade, I am trying but is blocked by below issue. I am using latest ACS build
2013-07-26 13:13:28,390 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER TABLE `cloud`.`usage_event` ADD COLUMN `virtual_size` bigint unsigned
2013-07-26 13:13:28,402 ERROR [utils.db.ScriptRunner] (Timer-1:null) Error executing: ALTER TABLE `cloud`.`usage_event` ADD COLUMN `virtual_size` bigint unsigned
2013-07-26 13:13:28,403 ERROR [utils.db.ScriptRunner] (Timer-1:null) com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'virtual_size'
2013-07-26 13:13:28,407 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: Duplicate column name 'virtual_size'
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:190)
at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:251)
at com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:380)
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-26 13:13:28,430 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:199)
at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:251)
at com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:380)
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: Duplicate column name 'virtual_size'
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:190)
> 3.0.6 to ASF 4.2 Upgrade: "cloud" Database Schema Inconsistencies on the Upgraded Setup - Tables "baremetal_dhcp_devices" and "baremetal_pxe_devices"
> -----------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: CLOUDSTACK-3833
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-3833
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the default.)
> Components: Upgrade
> Affects Versions: 4.2.0
> Reporter: Chandan Purushothama
> Assignee: frank zhang
> Priority: Critical
> Fix For: 4.2.0
>
>
> Table 1: baremetal_dhcp_devices
> On ASF 4.2 Setup:
> `nsp_id` bigint(20) UNSIGNED DEFAULT NULL,
> `pod_id` bigint(20) UNSIGNED DEFAULT NULL,
> `device_type` varchar(255) DEFAULT NULL,
> `physical_network_id` bigint(20) UNSIGNED DEFAULT NULL,
> `host_id` bigint(20) UNSIGNED DEFAULT NULL,
> On the 4.2 Upgraded Setup:
> `nsp_id` bigint(20) UNSIGNED NOT NULL,
> `pod_id` bigint(20) UNSIGNED NOT NULL,
> `device_type` varchar(255) NOT NULL,
> `physical_network_id` bigint(20) UNSIGNED NOT NULL,
> `host_id` bigint(20) UNSIGNED NOT NULL,
> Table 2: baremetal_pxe_devices
> On ASF 4.2 Setup:
> `nsp_id` bigint(20) UNSIGNED DEFAULT NULL,
> `device_type` varchar(255) DEFAULT NULL,
> `physical_network_id` bigint(20) UNSIGNED DEFAULT NULL,
> `host_id` bigint(20) UNSIGNED DEFAULT NULL,
> On the 4.2 Upgraded Setup:
> `nsp_id` bigint(20) UNSIGNED NOT NULL,
> `device_type` varchar(255) NOT NULL,
> `physical_network_id` bigint(20) UNSIGNED NOT NULL,
> `host_id` bigint(20) UNSIGNED NOT NULL,
--
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