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 >> > >> > >> >
