cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Animesh Chaturvedi (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CLOUDSTACK-5902) Database upgrade fails, 4.2.1 to 4.3
Date Sat, 18 Jan 2014 20:34:19 GMT

    [ https://issues.apache.org/jira/browse/CLOUDSTACK-5902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13875740#comment-13875740
] 

Animesh Chaturvedi commented on CLOUDSTACK-5902:
------------------------------------------------

Nux

Can you put db dump for debugging. This did not come up in earlier upgrade testing so a bit
surprised to see it

> Database upgrade fails, 4.2.1 to 4.3
> ------------------------------------
>
>                 Key: CLOUDSTACK-5902
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-5902
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the default.) 
>          Components: Management Server, Upgrade
>    Affects Versions: 4.3.0
>         Environment: CentOS 6.5 64bit
>            Reporter: Nux
>            Priority: Blocker
>              Labels: database, management, server
>             Fix For: 4.3.0
>
>
> 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)



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)

Mime
View raw message