[CLOUDSTACK-5902] Database upgrade fails, 4.2.1 to 4.3

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Not A Problem
• Affects Version/s: 4.3.0
• Fix Version/s: 4.3.0
• Component/s: Management Server, Upgrade
• Security Level: Public (Anyone can view this level - this is the default.)
• Labels: database management server
• Environment: CentOS 6.5 64bit
• Assignee: Unassigned
• Reporter: Nux
• Created: 18/Jan/14 15:49
• Updated: 20/Jan/14 18:45
• Resolved: 20/Jan/14 09:48

Description

Yum update completes nicely, but upon restart the management server fails to upgrade the DB:

"Duplicate column name 'related'"

http://paste.fedoraproject.org/69630/59802139/raw/

Snippet of the error

15:41:05,238 DEBUG [c.c.u.d.ScriptRunner] (main:null) ALTER TABLE `cloud`.`async_job` ADD COLUMN `related` CHAR(40) NOT NULL
2014-01-18 15:41:05,239 ERROR [c.c.u.d.ScriptRunner] (main:null) Error executing: ALTER TABLE `cloud`.`async_job` ADD COLUMN `related` CHAR(40) NOT NULL
2014-01-18 15:41:05,239 ERROR [c.c.u.d.ScriptRunner] (main:null) com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'related'
2014-01-18 15:41:05,240 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) Unable to execute upgrade script: /usr/share/cloudstack-management/setup/db/schema-421to430.sql
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'related'
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:223)
at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:288)
at com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:414)
at org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.checkIntegrity(CloudStackExtendedLifeCycle.java:68)
at org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.start(CloudStackExtendedLifeCycle.java:58)
at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:167)
at org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:51)