You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cloudstack.apache.org by hanumant borwandkar <ha...@gmail.com> on 2020/05/14 22:43:28 UTC
Cloudstack Upgrade Filed
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
Re: Cloudstack Upgrade Filed
Posted by Andrija Panic <an...@gmail.com>.
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.borwandkar@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.borwandkar@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 <th...@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, <lm...@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.borwandkar@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ć
Re: Cloudstack Upgrade Filed
Posted by hanumant borwandkar <ha...@gmail.com>.
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.borwandkar@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 <th...@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, <lm...@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.borwandkar@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
>> >
>> >
>>
>
Re: Cloudstack Upgrade Filed
Posted by hanumant borwandkar <ha...@gmail.com>.
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 <th...@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, <lm...@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.borwandkar@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
> >
> >
>
Re: Cloudstack Upgrade Filed
Posted by Thomas Joseph <th...@gmail.com>.
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, <lm...@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.borwandkar@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
>
>
Re: Cloudstack Upgrade Filed
Posted by Luis <lm...@yahoo.com.INVALID>.
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<ha...@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