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'
