Dustin, Was 4.5.2 a fresh install, or did you upgrade from a previous version to it? If so, can you tell us the upgrade order?
- Si ________________________________________ From: Dustin Wright <dwri...@untangledtechnology.com> Sent: Wednesday, November 25, 2015 6:21 AM To: users@cloudstack.apache.org Subject: Re: Failed CloudStack 4.6 Upgrade This was a fairly vanilla ACS 4.5.2. It has maybe 1 cluster, 6 HV's and 10 HVM VM's with advanced networking (single port, vlan) Never touched DB or UI. All I did to upgrade was removed AWS APi as directed and loaded up the 4.6 repo. I was going to troubleshoot more today might restore back. Dustin Sent from my iPhone > On Nov 25, 2015, at 5:56 AM, Rajani Karuturi <raj...@apache.org> wrote: > > from which version are you trying to upgrade? Were there any custom changes > on top of ACS? > > ~Rajani > > On Tue, Nov 24, 2015 at 3:39 AM, Dustin Wright < > dwri...@untangledtechnology.com> wrote: > >> I’ve facing an SQL error while trying to upgrade a CloudStack environment. >> Any suggestions? >> >> [root@controller management]# tail management-server.log -f >> Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to >> execute upgrade script: >> /usr/share/cloudstack-management/setup/db/schema-452to460.sql >> at >> com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:284) >> at >> com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:341) >> at >> com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:468) >> ... 45 more >> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: >> Duplicate column name 'min_iops' >> at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:185) >> at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:87) >> at >> com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:275) >> ... 47 more >> ^C >> [root@controller management]# mysql cloud < >> /usr/share/cloudstack-management/setup/db/schema-452to460.sql >> ERROR 1060 (42S21) at line 22: Duplicate column name 'min_iops'