DB restore (the DUMP you should have taken before the first time upgrade) - would probably do as well.
The first link (PR 3221) - you could work around that if you have the proper cloud user credentials - the issues you originally shared suggest that you did not have the "proper" MySQL credentials (user/password) created on that mariadb centos7. The definer is indeed not though of properly.. Good to see it solved, Cheers On Sat, 16 May 2020 at 01:09, hanumant borwandkar < hanumant.borwand...@gmail.com> wrote: > Hi, > > Issue resolved and able to upgrade from 4.11.3 to 4.13.1.0-1 with the > reading fix mentioned in the post > *https://github.com/apache/cloudstack/issues/3221 > <https://github.com/apache/cloudstack/issues/3221>* able to get going > schema restore. > and the following commands execution on mariadb centos 7 * > https://www.mail-archive.com/users@cloudstack.apache.org/msg27985.html > <https://www.mail-archive.com/users@cloudstack.apache.org/msg27985.html>. > * > > delete from guest_os_hypervisor where guest_os_id >= 277; > delete from guest_os where id >= 277; > SET FOREIGN_KEY_CHECKS=0; > drop table direct_download_certificate; > drop table vpc_offering_details; > SET FOREIGN_KEY_CHECKS=1; > alter table data_center drop column sort_key; > alter table vpc_offerings drop column sort_key; > alter table disk_offering add column domain_id int(32) not null; > alter table service_offering_details add constraint > uk_service_offering_id_name unique (id); > alter table network_offering_details DROP COLUMN `display`; > > Thanks, > Hanumant B > > > > > On Fri, May 15, 2020 at 12:28 PM hanumant borwandkar < > hanumant.borwand...@gmail.com> wrote: > > > Hi, > > > > Thanks for the replies i will try to reproduce errors again may be i am > > doing anything wrong., But I referring latest documentation relating > > upgrade from 4.11.x to 4.13 > > > > Not sure why I am getting access denied & need of super user previledges > > error as I am upgrading with root user and yum upgrade command and using > > mentioned yum repo in documentation > > > > As there are two management servers and I am using mariadb 5.5.65 from > > centos7 repo in master slave scenario. > > > > Both the management server are upgraded from 4.11.0 to 4.11.3 successful > > previously some months ago. > > > > Regards, > > Hanumant B > > > > On Fri, May 15, 2020, 11:51 Thomas Joseph <thomas.jo...@gmail.com> > wrote: > > > >> Hello Hanumant > >> > >> Are you using the correct user for running the related scripts? > >> > >> *020-05-15 00:12:42,059 ERROR [c.c.u.d.ScriptRunner] (main:null) > (logid:) > >> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access > denied; > >> you need (at least one of) the SUPER privilege(s) for this > >> operation2020-05-15 00:12:42,081 ERROR [c.c.u.DatabaseUpgradeChecker] > >> (main:null) (logid:) Unable to execute upgrade > >> scriptcom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access > >> denied; you need (at least one of) the SUPER privilege(s) for this > >> operation* > >> > >> With regards > >> Thomas Joseph > >> > >> On Fri, 15 May 2020, 5:20 am Luis, <lmartinez...@yahoo.com.invalid> > >> wrote: > >> > >> > Hi. What lines did you use for the upgrade? > >> > > >> > Sent from Yahoo Mail on Android > >> > > >> > On Thu, May 14, 2020 at 6:43 PM, hanumant borwandkar< > >> > hanumant.borwand...@gmail.com> wrote: HI, > >> > > >> > Trying to upgrade cloudstack 4.11.3 to 4.13 latest but unable get > >> success > >> > also tried to upgrade to 4.14-RC3 test build both time got same error > as > >> > follows. > >> > > >> > CentOS Linux release 7.6.1810 (Core) > >> > > >> > > >> > ERROR > >> > 2 > >> > > >> > > >> > *020-05-15 00:12:42,059 ERROR [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access > >> denied; > >> > you need (at least one of) the SUPER privilege(s) for this > >> > operation2020-05-15 00:12:42,081 ERROR [c.c.u.DatabaseUpgradeChecker] > >> > (main:null) (logid:) Unable to execute upgrade > >> > scriptcom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: > Access > >> > denied; you need (at least one of) the SUPER privilege(s) for this > >> > operation* > >> > > >> > > >> > logs > >> > 2020-05-15 00:12:41,329 DEBUG [c.c.u.d.VersionDaoImpl] (main:null) > >> (logid:) > >> > Checking to see if the database is at a version before it was the > >> version > >> > table is created > >> > 2020-05-15 00:12:41,368 INFO [c.c.u.DatabaseUpgradeChecker] > (main:null) > >> > (logid:) DB version = 4.11.3.0 Code Version = 4.13.1.0 > >> > 2020-05-15 00:12:41,368 INFO [c.c.u.DatabaseUpgradeChecker] > (main:null) > >> > (logid:) Database upgrade must be performed from 4.11.3.0 to 4.13.1.0 > >> > 2020-05-15 00:12:41,392 DEBUG [c.c.u.DatabaseUpgradeChecker] > (main:null) > >> > (logid:) Running upgrade Upgrade41120to41200 to upgrade from > >> > 4.11.2.0-4.12.0.0 to 4.12.0.0 > >> > 2020-05-15 00:12:41,397 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > -- Licensed to the Apache Software Foundation (ASF) under one > >> > 2020-05-15 00:12:41,397 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > -- or more contributor license agreements. See the NOTICE file > >> > 2020-05-15 00:12:41,397 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > -- distributed with this work for additional information > >> > 2020-05-15 00:12:41,397 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > -- regarding copyright ownership. The ASF licenses this file > >> > 2020-05-15 00:12:41,397 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > -- to you under the Apache License, Version 2.0 (the > >> > 2020-05-15 00:12:41,397 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > -- "License"); you may not use this file except in compliance > >> > 2020-05-15 00:12:41,397 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > -- with the License. You may obtain a copy of the License at > >> > 2020-05-15 00:12:41,397 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > -- > >> > 2020-05-15 00:12:41,397 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > -- http://www.apache.org/licenses/LICENSE-2.0 > >> > 2020-05-15 00:12:41,397 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > -- > >> > 2020-05-15 00:12:41,397 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > -- Unless required by applicable law or agreed to in writing, > >> > 2020-05-15 00:12:41,397 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > -- software distributed under the License is distributed on an > >> > 2020-05-15 00:12:41,397 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > -- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY > >> > 2020-05-15 00:12:41,397 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > -- KIND, either express or implied. See the License for the > >> > 2020-05-15 00:12:41,398 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > -- specific language governing permissions and limitations > >> > 2020-05-15 00:12:41,398 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > -- under the License. > >> > 2020-05-15 00:12:41,398 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > --; > >> > 2020-05-15 00:12:41,398 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > -- Schema upgrade from 4.11.2.0 to 4.12.0.0 > >> > 2020-05-15 00:12:41,398 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > --; > >> > 2020-05-15 00:12:41,398 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > -- [CLOUDSTACK-10314] Add reason column to ACL rule table > >> > 2020-05-15 00:12:41,403 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > ALTER TABLE `cloud`.`network_acl_item` ADD COLUMN `reason` > VARCHAR(2500) > >> > AFTER `display` > >> > 2020-05-15 00:12:41,442 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > -- [CLOUDSTACK-9846] Make provision to store content and subject for > >> Alerts > >> > in separate columns. > >> > 2020-05-15 00:12:41,442 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > ALTER TABLE `cloud`.`alert` ADD COLUMN `content` VARCHAR(5000) > >> > 2020-05-15 00:12:41,533 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > -- Fix the name of the column used to hold IPv4 range in 'vlan' table. > >> > 2020-05-15 00:12:41,534 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > ALTER TABLE `vlan` CHANGE `description` `ip4_range` varchar(255) > >> > 2020-05-15 00:12:41,569 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > -- [CLOUDSTACK-10344] bug when moving ACL rules (change order with > drag > >> and > >> > drop) > >> > 2020-05-15 00:12:41,569 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > -- We are only adding the permission to the default rules. Any custom > >> rule > >> > must be configured by the root admin. > >> > 2020-05-15 00:12:41,569 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > INSERT INTO `cloud`.`role_permissions` (`uuid`, `role_id`, `rule`, > >> > `permission`, `sort_order`) values (UUID(), 2, 'moveNetworkAclI > >> > tem', 'ALLOW', 100) ON DUPLICATE KEY UPDATE rule=rule > >> > 2020-05-15 00:12:41,573 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > INSERT INTO `cloud`.`role_permissions` (`uuid`, `role_id`, `rule`, > >> > `permission`, `sort_order`) values (UUID(), 3, 'moveNetworkAclI > >> > tem', 'ALLOW', 302) ON DUPLICATE KEY UPDATE rule=rule > >> > 2020-05-15 00:12:41,574 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > INSERT INTO `cloud`.`role_permissions` (`uuid`, `role_id`, `rule`, > >> > `permission`, `sort_order`) values (UUID(), 4, 'moveNetworkAclI > >> > tem', 'ALLOW', 260) ON DUPLICATE KEY UPDATE rule=rule > >> > 2020-05-15 00:12:41,575 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > UPDATE `cloud`.`async_job` SET `removed` = now() WHERE `removed` IS > NULL > >> > 2020-05-15 00:12:41,578 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > -- PR#1448 update description of > >> > 'execute.in.sequence.network.element.commands' parameter to reflect an > >> > unused command that has be > >> > en removed. The removed class command is 'UserDataCommand'. > >> > 2020-05-15 00:12:41,578 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > update `cloud`.`configuration` set description = 'If set to true, > >> > DhcpEntryCommand, SavePasswordCommand, VmDataCommand will be syn > >> > chronized on the agent side. If set to false, these commands become > >> > asynchronous. Default value is false.' where name = > >> > 'execute.in.sequence.network.element.commands' > >> > 2020-05-15 00:12:41,580 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Storage', > 'DEFAULT', > >> > 'StorageManager', 'kvm.storage.offline.migration.wait', ' > >> > 10800', 'Timeout in seconds for offline (non-live) storage migration > to > >> > complete on KVM', '10800', null, 'Global', 0) > >> > 2020-05-15 00:12:41,581 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Storage', > 'DEFAULT', > >> > 'StorageManager', 'kvm.storage.online.migration.wait', '1 > >> > 0800', 'Timeout in seconds for online (live) storage migration to > >> complete > >> > on KVM (migrateVirtualMachineWithVolume)', '10800', null, 'Global', 0) > >> > 2020-05-15 00:12:41,581 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Storage', > 'DEFAULT', > >> > 'StorageManager', 'max.number.managed.clustered.file.syst > >> > ems', '200', 'XenServer and VMware only: Maximum number of managed SRs > >> or > >> > datastores per compute cluster', '200', null, 'Cluster', 0) > >> > 2020-05-15 00:12:41,582 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > -- add KVM Guest OS mapping for Windows Server 2019 > >> > 2020-05-15 00:12:41,582 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > INSERT IGNORE INTO `cloud`.`guest_os` (id, uuid, category_id, > >> display_name, > >> > created) VALUES (276, UUID(), 6, 'Windows Server 2019 > >> > (64-bit)', now()) > >> > 2020-05-15 00:12:41,586 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > INSERT IGNORE INTO `cloud`.`guest_os_hypervisor` (uuid, > hypervisor_type, > >> > hypervisor_version, guest_os_name, guest_os_id, created, > >> > is_user_defined) VALUES (UUID(), 'KVM', 'default', 'Windows Server > >> 2019', > >> > 276, now(), 0) > >> > 2020-05-15 00:12:41,589 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > -- changed fingerprint type to TEXT, it avoids db exception when > >> creating > >> > the certificate issue #3123 > >> > 2020-05-15 00:12:41,589 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > ALTER TABLE `cloud`.`sslcerts` MODIFY `fingerprint` TEXT > >> > 2020-05-15 00:12:41,652 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > -- add KVM / qemu io bursting options PR 3133 > >> > 2020-05-15 00:12:41,652 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > alter table `cloud`.`disk_offering` add `bytes_read_rate_max` > bigint(20) > >> > default null after `bytes_read_rate` > >> > 2020-05-15 00:12:41,718 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > alter table `cloud`.`disk_offering` add `bytes_read_rate_max_length` > >> > bigint(20) default null after `bytes_read_rate_max` > >> > 2020-05-15 00:12:41,776 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > alter table `cloud`.`disk_offering` add `bytes_write_rate_max` > >> bigint(20) > >> > default null after `bytes_write_rate` > >> > 2020-05-15 00:12:41,821 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > alter table `cloud`.`disk_offering` add `bytes_write_rate_max_length` > >> > bigint(20) default null after `bytes_write_rate_max` > >> > 2020-05-15 00:12:41,855 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > alter table `cloud`.`disk_offering` add `iops_read_rate_max` > bigint(20) > >> > default null after `iops_read_rate` > >> > 2020-05-15 00:12:41,892 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > alter table `cloud`.`disk_offering` add `iops_read_rate_max_length` > >> > bigint(20) default null after `iops_read_rate_max` > >> > 2020-05-15 00:12:41,922 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > alter table `cloud`.`disk_offering` add `iops_write_rate_max` > bigint(20) > >> > default null after `iops_write_rate` > >> > 2020-05-15 00:12:41,955 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > alter table `cloud`.`disk_offering` add `iops_write_rate_max_length` > >> > bigint(20) default null after `iops_write_rate_max` > >> > 2020-05-15 00:12:41,978 DEBUG [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > ALTER VIEW `cloud`.`disk_offering_view` AS SELECT > >> > `disk_offering`.`id` AS `id`, `disk_offering`.`uuid` AS `uui > >> > d`, `disk_offering`.`name` AS `name`, > >> > `disk_offering`.`display_text` AS `display_text`, > >> > `disk_offering`.`provisioning_type` AS `provisioning_type`, > >> > `disk_offering`.`disk_si > >> > ze` AS `disk_size`, `disk_offering`.`min_iops` AS `min_iops`, > >> > `disk_offering`.`max_iops` AS `max_iops`, > >> > `disk_offering`.`created` AS `created`, `disk_offering`.`tags` > >> AS `t > >> > ags`, `disk_offering`.`customized` AS `customized`, > >> > `disk_offering`.`customized_iops` AS `customized_iops`, > >> > `disk_offering`.`removed` AS `removed`, > `disk_offering`.`use_loc > >> > al_storage` AS `use_local_storage`, > `disk_offering`.`system_use` > >> AS > >> > `system_use`, `disk_offering`.`hv_ss_reserve` AS > `hv_ss_reserve`, > >> > `disk_offering`.`bytes_read_rate` AS `bytes_re > >> > ad_rate`, `disk_offering`.`bytes_read_rate_max` AS > >> > `bytes_read_rate_max`, > >> `disk_offering`.`bytes_read_rate_max_length` > >> > AS `bytes_read_rate_max_length`, `disk_offering`.`bytes_write > >> > _rate` AS `bytes_write_rate`, > >> > `disk_offering`.`bytes_write_rate_max` AS `bytes_write_rate_max`, > >> > `disk_offering`.`bytes_write_rate_max_length` AS > >> > `bytes_write_rate_max_length`, `dis > >> > k_offering`.`iops_read_rate` AS `iops_read_rate`, > >> > `disk_offering`.`iops_read_rate_max` AS `iops_read_rate_max`, > >> > `disk_offering`.`iops_read_rate_max_length` AS > >> `iops_read_rate_max_length`, > >> > `disk_offering`.`iops_write_rate` AS `iops_write_rate`, > >> > `disk_offering`.`iops_write_rate_max` AS `iops_write_rate_max`, > >> > `disk_offering`.`iops_write_rate_max_length` AS `iops_write_ > >> > rate_max_length`, `disk_offering`.`cache_mode` AS `cache_mode`, > >> > `disk_offering`.`sort_key` AS `sort_key`, > >> > `disk_offering`.`type` AS `type`, > >> `disk_offering`.`display_offerin > >> > g` AS `display_offering`, `domain`.`id` AS `domain_id`, > >> > `domain`.`uuid` AS `domain_uuid`, `domain`.`name` AS > >> `domain_name`, > >> > `domain`.`path` AS `domain_path` FROM > >> > (`disk_offering` LEFT JOIN `domain` ON > >> > ((`disk_offering`.`domain_id` = `domain`.`id`))) WHERE > >> > (`disk_offering`.`state` = 'ACTIVE') > >> > 2020-05-15 00:12:42,056 ERROR [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > Error executing: ALTER VIEW `cloud`.`disk_offering_view` AS SELECT > >> > `disk_offering`.`id` AS `id`, `disk_offerin > >> > g`.`uuid` AS `uuid`, `disk_offering`.`name` AS `name`, > >> > `disk_offering`.`display_text` AS `display_text`, > >> > `disk_offering`.`provisioning_type` AS `provisioning_type`, > >> `disk_o > >> > ffering`.`disk_size` AS `disk_size`, `disk_offering`.`min_iops` > >> AS > >> > `min_iops`, `disk_offering`.`max_iops` AS `max_iops`, > >> > `disk_offering`.`created` AS `created`, `disk_offer > >> > ing`.`tags` AS `tags`, `disk_offering`.`customized` AS > >> > `customized`, `disk_offering`.`customized_iops` AS > >> > `customized_iops`, `disk_offering`.`removed` AS `removed`, > >> > `disk_o > >> > ffering`.`use_local_storage` AS `use_local_storage`, > >> > `disk_offering`.`system_use` AS `system_use`, > >> > `disk_offering`.`hv_ss_reserve` AS `hv_ss_reserve`, > >> > `disk_offering`.`bytes_read_r > >> > ate` AS `bytes_read_rate`, > `disk_offering`.`bytes_read_rate_max` > >> AS > >> > `bytes_read_rate_max`, > >> `disk_offering`.`bytes_read_rate_max_length` > >> > AS `bytes_read_rate_max_length`, `disk_offer > >> > ing`.`bytes_write_rate` AS `bytes_write_rate`, > >> > `disk_offering`.`bytes_write_rate_max` AS `bytes_write_rate_max`, > >> > `disk_offering`.`bytes_write_rate_max_length` AS > >> `bytes_write_rate_max_leng > >> > th`, `disk_offering`.`iops_read_rate` AS `iops_read_rate`, > >> > `disk_offering`.`iops_read_rate_max` AS `iops_read_rate_max`, > >> > `disk_offering`.`iops_read_rate_max_length` AS `iops_read_r > >> > ate_max_length`, `disk_offering`.`iops_write_rate` AS > >> > `iops_write_rate`, `disk_offering`.`iops_write_rate_max` AS > >> > `iops_write_rate_max`, > >> `disk_offering`.`iops_write_rate_max_length > >> > ` AS `iops_write_rate_max_length`, `disk_offering`.`cache_mode` > >> AS > >> > `cache_mode`, `disk_offering`.`sort_key` AS `sort_key`, > >> > `disk_offering`.`type` AS `type`, `disk_offering` > >> > .`display_offering` AS `display_offering`, `domain`.`id` AS > >> > `domain_id`, `domain`.`uuid` AS `domain_uuid`, > >> > `domain`.`name` AS `domain_name`, `domain`.`path` AS > `domain_path > >> > ` FROM (`disk_offering` LEFT JOIN `domain` ON > >> > ((`disk_offering`.`domain_id` = `domain`.`id`))) WHERE > >> > (`disk_offering`.`state` = 'ACTIVE') > >> > 2 > >> > > >> > > >> > *020-05-15 00:12:42,059 ERROR [c.c.u.d.ScriptRunner] (main:null) > >> (logid:) > >> > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access > >> denied; > >> > you need (at least one of) the SUPER privilege(s) for this > >> > operation2020-05-15 00:12:42,081 ERROR [c.c.u.DatabaseUpgradeChecker] > >> > (main:null) (logid:) Unable to execute upgrade > >> > scriptcom.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:185) > >> > at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:87) > >> > at > >> > > >> > > >> > com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:199) > >> > at > >> > > >> > > >> > com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:254) > >> > at > >> > > >> > > >> > com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:338) > >> > at > >> > > >> > > >> > org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.checkIntegrity(CloudStackExtendedLifeCycle.java:65) > >> > at > >> > > >> > > >> > org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.start(CloudStackExtendedLifeCycle.java:55) > >> > at > >> > > >> > > >> > org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:183) > >> > at > >> > > >> > > >> > org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:52) > >> > at > >> > > >> > > >> > org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:358) > >> > at > >> > > >> > > >> > org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:159) > >> > at > >> > > >> > > >> > org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:123) > >> > at > >> > > >> > > >> > org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:884) > >> > at > >> > > >> > > >> > org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:552) > >> > at > >> > > >> > > >> > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.java:145) > >> > ... > >> > ... > >> > 2020-05-15 00:12:42,086 ERROR [c.c.u.DatabaseUpgradeChecker] > (main:null) > >> > (logid:) Unable to upgrade the database > >> > com.cloud.utils.exception.CloudRuntimeException: Unable to execute > >> upgrade > >> > script > >> > at > >> > > >> > > >> > com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:205) > >> > at > >> > > >> > > >> > com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:254) > >> > at > >> > > >> > > >> > com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:338) > >> > at > >> > > >> > > >> > org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.checkIntegrity(CloudStackExtendedLifeCycle.java:65) > >> > at > >> > > >> > > >> > org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.start(CloudStackExtendedLifeCycle.java:55) > >> > at > >> > > >> > > >> > org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:183) > >> > at > >> > > >> > > >> > org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:52) > >> > at > >> > > >> > > >> > org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:358) > >> > at > >> > > >> > > >> > org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:159) > >> > at > >> > > >> > > >> > org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:123) > >> > at > >> > > >> > > >> > org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:884) > >> > at > >> > > >> > > >> > org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:552) > >> > at > >> > > >> > > >> > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.java:145) > >> > at > >> > > >> > > >> > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:122) > >> > at > >> > > >> > > >> > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:245) > >> > at > >> > > >> > > >> > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:250) > >> > at > >> > > >> > > >> > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:233) > >> > at > >> > > >> > > >> > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContexts(DefaultModuleDefinitionSet.java:117) > >> > at > >> > > >> > > >> > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.load(DefaultModuleDefinitionSet.java:79) > >> > at > >> > > >> > > >> > org.apache.cloudstack.spring.module.factory.ModuleBasedContextFactory.loadModules(ModuleBasedContextFactory.java:37) > >> > at > >> > > >> > > >> > org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.init(CloudStackSpringContext.java:71) > >> > at > >> > > >> > > >> > org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:58) > >> > at > >> > > >> > > >> > org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:62) > >> > at > >> > > >> > > >> > org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListener.contextInitialized(CloudStackContextLoaderListener.java:52) > >> > at > >> > > >> > > >> > org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:890) > >> > at > >> > > >> > > >> > org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:532) > >> > at > >> > > >> > > >> > org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:853) > >> > at > >> > > >> > > >> > org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:344) > >> > at > >> > > >> > org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1515) > >> > at > >> > > >> > > >> > org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1477) > >> > at > >> > > >> > > >> > org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:785) > >> > at > >> > > >> > > >> > org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:261) > >> > at > >> org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:545) > >> > at > >> > > >> > > >> > org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) > >> > at > >> > > >> > > >> > org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:133) > >> > at > >> > > >> > > >> > org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:107) > >> > at > >> > > >> > > >> > org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:113) > >> > at > >> > > >> > > >> > org.eclipse.jetty.server.handler.gzip.GzipHandler.doStart(GzipHandler.java:273) > >> > at > >> > > >> > > >> > org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68) > >> > at > >> > > >> > > >> > org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:133) > >> > > >> > Had to downgrade the cloudstack. > >> > > >> > Anyhelp appriciated. > >> > > >> > Regards, > >> > Hanumant B > >> > > >> > > >> > > > -- Andrija Panić
