Try commenting out both the min_iops and max_iops lines.
________________________________________ From: Dustin Wright <dwri...@untangledtechnology.com> Sent: Wednesday, November 25, 2015 8:58 AM To: users@cloudstack.apache.org Subject: Re: Failed CloudStack 4.6 Upgrade This was a fresh 4.5.2 install. No previous upgrades. I tried commenting out the offending SQL and it errors on the next line. I will try to gather more info later today after I put out some other fires. Dustin Sent from my iPhone > On Nov 25, 2015, at 7:51 AM, Simon Weller <swel...@ena.com> wrote: > > 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'