[
https://issues.apache.org/jira/browse/CLOUDSTACK-5902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13876666#comment-13876666
]
Alena Prokharchyk commented on CLOUDSTACK-5902:
-----------------------------------------------
Applied the DB. Although the DB version says 4.2.1, it looks like the upgrade
from 4.2.1 to 4.3 was run. Presence of this table - s2s_vpn_connection_details-
proves it as this table is inserted as a part of 4.2.1-4.3 upgrade.
Nux, did the DB dump you've provided, was taken before you've executed "Yum
update completes nicely and management server was restarted"? Issues like that
happen when DB upgrade fails in the middle, so some fields get upgraded, but
the final version doesn't change. So next time you try to restart MS, the
upgrade will be tried to perform again. And of course it will fail.
I've installed 4.2.1, and upgraded to 4.3 w/o any problems. Is it possible you
run the test once again on your setup. Follow this:
1) Roll back to your original 4.2.1 (not the one you've attached to the bug as
it has some fields from 4.3), or install fresh 4.2.1.
2) Get 4.3 tar ball. Run "Yum update". Before restarting MS, check the version
(select * from version). The last field should say 4.3. If it doesn't, then the
upgrade failed by some reason, and we have to do more debugging.
3) If the version table contains 4.3, restart MS and see if you run into the
same issue.
> 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)
