I am trying to upgrade to Cloudstack 4.2.1 but the database upgrade process is failing with the following error.
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 Has anyone run into this? I had originally upgraded from 4.0.1 to 4.1.1 and that went fine several months ago. -- -- *Jason Villalta* Co-founder [image: Inline image 1] 800.799.4407x1230 | www.RubixTechnology.com<http://www.rubixtechnology.com/>
