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'
