Interesting errors, just by any change are you using the database on Amazon RDS?
2013/10/2 Indra Pramana <in...@sg.or.id> > Dear all, > > I tried to simulate upgrading the database from Cloudstack 4.1.1 to 4.2.0 > on my test environment and getting below error message: > > MySQLSyntaxErrorException: Access denied; you need (at least one of) the > SUPER privilege(s) for this operation > > Anyone can advise what super privilege is required? The database worked > fine on 4.1.1 prior to the upgrade. > > Below is more logs from the management-server.log: > > ==== > 2013-10-02 20:33:05,876 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE > `cloud`.`account` SET `cloud`.`account`.`default`=1 WHERE id IN (1,2) > 2013-10-02 20:33:05,913 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE > `cloud_usage`.`account` SET `default`=1 WHERE id IN (1,2) > 2013-10-02 20:33:05,914 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE > `cloud`.`user` SET `cloud`.`user`.`default`=1 WHERE id IN (1,2) > 2013-10-02 20:33:05,915 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER > VIEW `cloud`.`user_view` AS select user.id, > user.uuid, user.username, user.password, > user.firstname, user.lastname, user.email, > user.state, user.api_key, user.secret_key, > user.created, user.removed, user.timezone, > user.registration_token, user.is_registered, > user.incorrect_login_attempts, user.default, > account.idaccount_id, account.uuid account_uuid, > account.account_name > account_name, account.type account_type, > domain.iddomain_id, domain.uuid domain_uuid, > domain.name domain_name, domain.path domain_path, > async_job.id job_id, async_job.uuid job_uuid, > async_job.job_status job_status, async_job.account_id > job_account_id from `cloud`.`user` inner > join `cloud`.`account` ON user.account_id = account.id > inner join `cloud`.`domain` ON account.domain_id = domain.id > left join `cloud`.`async_job` ON async_job.instance_id = > user.id > and async_job.instance_type = 'User' and async_job.job_status = > 0 > 2013-10-02 20:33:06,007 ERROR [utils.db.ScriptRunner] (Timer-1:null) Error > executing: ALTER VIEW `cloud`.`user_view` AS select > user.id, > user.uuid, user.username, user.password, > user.firstname, user.lastname, user.email, > user.state, user.api_key, user.secret_key, > user.created, user.removed, user.timezone, > user.registration_token, user.is_registered, > user.incorrect_login_attempts, user.default, > account.idaccount_id, account.uuid account_uuid, > account.account_name > account_name, account.type account_type, > domain.iddomain_id, domain.uuid domain_uuid, > domain.name domain_name, domain.path domain_path, > async_job.id job_id, async_job.uuid job_uuid, > async_job.job_status job_status, async_job.account_id > job_account_id from `cloud`.`user` inner > join `cloud`.`account` ON user.account_id = account.id > inner join `cloud`.`domain` ON account.domain_id = domain.id > left join `cloud`.`async_job` ON async_job.instance_id = > user.id > and async_job.instance_type = 'User' and async_job.job_status = > 0 > 2013-10-02 20:33:06,007 ERROR [utils.db.ScriptRunner] (Timer-1:null) > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied; > you need (at least one of) the SUPER privilege(s) for this operation > 2013-10-02 20:33:06,009 ERROR [cloud.upgrade.DatabaseUpgradeChecker] > (Timer-1:null) Unable to execute upgrade script: > /usr/share/cloudstack-management/setup/db/schema-410to420.sql > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied; > you need (at least one of) the SUPER privilege(s) for this operation > 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:201) > at > > com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:262) > at > > com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:391) > at > > com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:90) > at > com.cloud.servlet.CloudStartupServlet$1.run(CloudStartupServlet.java:54) > at java.util.TimerThread.mainLoop(Timer.java:534) > at java.util.TimerThread.run(Timer.java:484) > 2013-10-02 20:33:06,011 ERROR [cloud.upgrade.DatabaseUpgradeChecker] > (Timer-1:null) Unable to upgrade the database > com.cloud.utils.exception.CloudRuntimeException: Unable to execute upgrade > script: /usr/share/cloudstack-management/setup/db/schema-410to420.sql > at > > com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:210) > at > > com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:262) > at > > com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:391) > at > > com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:90) > at > com.cloud.servlet.CloudStartupServlet$1.run(CloudStartupServlet.java:54) > at java.util.TimerThread.mainLoop(Timer.java:534) > at java.util.TimerThread.run(Timer.java:484) > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: > Access denied; you need (at least one of) the SUPER privilege(s) for this > operation > 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:201) > ... 6 more > === > -- Rafael Weingartner