cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "frank zhang (JIRA)" <j...@apache.org>
Subject [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"
Date Fri, 26 Jul 2013 22:17:49 GMT

    [ 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

Mime
View raw message