[jira] [Commented] (CLOUDSTACK-5902) Database upgrade fails, 4.2.1 to 4.3
[ https://issues.apache.org/jira/browse/CLOUDSTACK-5902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13876234#comment-13876234 ] Abhinav Roy commented on CLOUDSTACK-5902: - Hi Nux, I used the rpms from this location http://cloudstack.apt-get.eu/rhel/4.2/ to install 4.3 . Create VMs, volumes, templates,snapshots etc and then upgraded to 4.3. But i didn't get into any DB upgrade issue. Thanks, Abhinav 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)
[jira] [Commented] (CLOUDSTACK-5902) Database upgrade fails, 4.2.1 to 4.3
[ https://issues.apache.org/jira/browse/CLOUDSTACK-5902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13876287#comment-13876287 ] Nux commented on CLOUDSTACK-5902: - Thanks a lot Abhinav. I think I was coming from an installation of this: http://tmp.nux.ro/w7F-cloudsnap42/ I think those were built from the same day's github 4.2. It probably had some issues .. 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)
[jira] [Commented] (CLOUDSTACK-5902) Database upgrade fails, 4.2.1 to 4.3
[ https://issues.apache.org/jira/browse/CLOUDSTACK-5902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13876595#comment-13876595 ] Alena Prokharchyk commented on CLOUDSTACK-5902: --- Nux, can you please send me the DB dump of your pre-upgraded DB? Before you ran the upgrade to 4.3. 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)
[jira] [Commented] (CLOUDSTACK-5902) Database upgrade fails, 4.2.1 to 4.3
[ https://issues.apache.org/jira/browse/CLOUDSTACK-5902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13876623#comment-13876623 ] Nux commented on CLOUDSTACK-5902: - Alena, Sure http://tmp.nux.ro/jhgrall.sql.zip (same as posted above) 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)
[jira] [Commented] (CLOUDSTACK-5902) Database upgrade fails, 4.2.1 to 4.3
[ https://issues.apache.org/jira/browse/CLOUDSTACK-5902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13876639#comment-13876639 ] Alena Prokharchyk commented on CLOUDSTACK-5902: --- Nux, can you please take the DB dump just of cloud/cloud_usage dbs? I see the mysql dump you've provided, contains all the DBs, including mysql. I don't wanna apply it because it will break my existing mysql configuration (happened tons of times before), and I don't wanna deal with reconfiguring/reinstallation. Thanks, 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)
[jira] [Commented] (CLOUDSTACK-5902) Database upgrade fails, 4.2.1 to 4.3
[ https://issues.apache.org/jira/browse/CLOUDSTACK-5902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=1387#comment-1387 ] 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)
[jira] [Commented] (CLOUDSTACK-5902) Database upgrade fails, 4.2.1 to 4.3
[ https://issues.apache.org/jira/browse/CLOUDSTACK-5902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13876686#comment-13876686 ] Nux commented on CLOUDSTACK-5902: - Alena, I think the issue was me using a 4.2 SNAPSHOT. I have already tested a clean 4.2.1 upgrade to 4.3 and it worked out fine. To the best of my knowledge the SQL I attached to this issue is the pre-4.3 one, I do not have another one. 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)
[jira] [Commented] (CLOUDSTACK-5902) Database upgrade fails, 4.2.1 to 4.3
[ https://issues.apache.org/jira/browse/CLOUDSTACK-5902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13876163#comment-13876163 ] Animesh Chaturvedi commented on CLOUDSTACK-5902: Are you using the release build from 4.2.1 or one of the intermediate snapshots and then try to upgrade to 4.3? 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)
[jira] [Commented] (CLOUDSTACK-5902) Database upgrade fails, 4.2.1 to 4.3
[ https://issues.apache.org/jira/browse/CLOUDSTACK-5902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13875704#comment-13875704 ] Nux commented on CLOUDSTACK-5902: - Just a bit more information that I just discovered: If I reset the DB by running cloudstack-setup-databases before upgrading to 4.3 then it appears to go smoothly, so a virgin DB seems to be no problem. Now, whatever happened to my running 4.2.1 DB to trigger this problem may have also happened to others, it may be worth investigating a bit. 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 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/ -- This message was sent by Atlassian JIRA (v6.1.5#6160)
[jira] [Commented] (CLOUDSTACK-5902) Database upgrade fails, 4.2.1 to 4.3
[ https://issues.apache.org/jira/browse/CLOUDSTACK-5902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=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)
[jira] [Commented] (CLOUDSTACK-5902) Database upgrade fails, 4.2.1 to 4.3
[ https://issues.apache.org/jira/browse/CLOUDSTACK-5902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13875748#comment-13875748 ] Nux commented on CLOUDSTACK-5902: - Animesh, Sure, here it is: http://tmp.nux.ro/jhgrall.sql.zip It may well be something I did as I played for a while with 4.2.1 SNAPSHOT. I do seem to have a talent of getting in weird problems. As I said, a clean 4.2.1 DB upgrades to 4.3 without problems. 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)
