[
https://issues.apache.org/jira/browse/CLOUDSTACK-5838?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jason Villalta updated CLOUDSTACK-5838:
---------------------------------------
Component/s: (was: Install and Setup)
Upgrade
Management Server
Description:
While upgrading from 4.1.1 to 4.2.1 the database scheme upgrade script fails.
Unable to execute upgrade script:
/usr/share/cloudstack-management/setup/db/schema-410to420.sql
was:
While upgrading from 4.1.1 to 4.2.0 the database scheme upgrade script fails.
scheme-410to420.sql
Error: column "default" already exits
Affects Version/s: (was: 4.2.0)
4.2.1
Summary: Upgrade from Cloudstack 4.1.1 to 4.2.1 fails in database
scheme script. (was: Upgrade from Cloudstack 4.1.1 to 4.2.0 fails in database
scheme script.)
2014-02-08 07:57:44,773 DEBUG [utils.db.ScriptRunner] (Timer-1:null) -- Add
"default" field to account/user tables
2014-02-08 07:57:44,774 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
TABLE `cloud`.`account` ADD COLUMN `default` int(1) unsigned NOT NULL DEFAULT
'0' COMMENT '1 if account is default'
2014-02-08 07:57:44,793 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
TABLE `cloud_usage`.`account` ADD COLUMN `default` int(1) unsigned NOT NULL
DEFAULT '0' COMMENT '1 if account is default'
2014-02-08 07:57:44,797 ERROR [utils.db.ScriptRunner] (Timer-1:null) Error
executing: ALTER TABLE `cloud_usage`.`account` ADD COLUMN `default` int(1)
unsigned NOT NULL DEFAULT '0' COMMENT '1 if account is default'
2014-02-08 07:57:44,797 ERROR [utils.db.ScriptRunner] (Timer-1:null)
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'cloud_usage.account' doesn't exist
2014-02-08 07:57:44,800 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_usage.account' doesn't exist
> Upgrade from Cloudstack 4.1.1 to 4.2.1 fails in database scheme script.
> -----------------------------------------------------------------------
>
> Key: CLOUDSTACK-5838
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-5838
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Components: Management Server, Upgrade
> Affects Versions: 4.2.1
> Environment: Ubuntu Package Installation
> Reporter: Jason Villalta
>
> While upgrading from 4.1.1 to 4.2.1 the database scheme upgrade script fails.
> Unable to execute upgrade script:
> /usr/share/cloudstack-management/setup/db/schema-410to420.sql
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)
