For first time I upgrade and start the MGMT server , it show following error:
2020-12-26 09:02:32,499 DEBUG [c.c.u.d.Upgrade41400to41500] (main:null) (logid:) Updating System Vm template IDs 2020-12-26 09:02:32,503 DEBUG [c.c.u.d.Upgrade41400to41500] (main:null) (logid:) Updating KVM System Vms 2020-12-26 09:02:32,511 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Unable to upgrade the database com.cloud.utils.exception.CloudRuntimeException: 4.15.0.0KVM SystemVm template not found. Cannot upgrade system Vms at com.cloud.upgrade.dao.Upgrade41400to41500.updateSystemVmTemplates(Upgrade41400to41500.java:214) at com.cloud.upgrade.dao.Upgrade41400to41500.performDataMigration(Upgrade41400to41500.java:70) at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:262) at com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:342) at org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.checkIntegrity(CloudStackExtendedLifeCycle.java:64) at org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.start(CloudStackExtendedLifeCycle.java:54) at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:182) at org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:53) at org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:360) at org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:158) at org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:122) at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:894) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:553) at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.java:144) at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:121) at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:244) at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:249) at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:232) at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContexts(DefaultModuleDefinitionSet.java:116) at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.load(DefaultModuleDefinitionSet.java:78) at org.apache.cloudstack.spring.module.factory.ModuleBasedContextFactory.loadModules(ModuleBasedContextFactory.java:37) at org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.init(CloudStackSpringContext.java:70) at org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:57) at org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:61) at org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListener.contextInitialized(CloudStackContextLoaderListener.java:51) at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:933) at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:553) at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:892) at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:356) at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1445) at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1409) at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:825) at org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:275) at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:524) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:72) at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169) at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:110) at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:97) at org.eclipse.jetty.server.handler.gzip.GzipHandler.doStart(GzipHandler.java:425) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:72) at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169) at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:117) at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:97) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:72) at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169) at org.eclipse.jetty.server.Server.start(Server.java:407) at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:110) at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:97) at org.eclipse.jetty.server.Server.doStart(Server.java:371) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:72) at org.apache.cloudstack.ServerDaemon.start(ServerDaemon.java:188) at org.apache.cloudstack.ServerDaemon.main(ServerDaemon.java:104) 2020-12-26 09:02:32,530 DEBUG [c.c.u.d.T.Transaction] (main:null) (logid:) Rolling back the transaction: Time = 109257 Name = Upgrade; called by -TransactionLegacy.rollback:888-TransactionLegacy.removeUpTo:831-TransactionLegacy.close:655-DatabaseUpgradeChecker.upgrade:273-DatabaseUpgradeChecker.check:342-CloudStackExtendedLifeCycle.checkIntegrity:64-CloudStackExtendedLifeCycle.start:54-DefaultLifecycleProcessor.doStart:182-DefaultLifecycleProcessor.access$200:53-DefaultLifecycleProcessor$LifecycleGroup.start:360-DefaultLifecycleProcessor.startBeans:158-DefaultLifecycleProcessor.onRefresh:122 after I found the error on system template, (before i do mgmt upgrade, i do upload system tempate 4.15 at GUI ) , I restart again the MGMT server, and it show the error in prevous reply. On Sat, Dec 26, 2020 at 5:39 PM Hean Seng <heans...@gmail.com> wrote: > I. am trying to run the upgrade on my test environment, it seem getting > error after finish upgrade and restart mgmt server: > > 020-12-26 09:33:56,338 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > --; > > 2020-12-26 09:33:56,338 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- Project roles > > 2020-12-26 09:33:56,339 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > CREATE TABLE IF NOT EXISTS `cloud`.`project_role` ( `id` bigint(20) > unsigned NOT NULL AUTO_INCREMENT, `uuid` varchar(255) UNIQUE, `name` > varchar(255) COMMENT 'unique name of the dynamic project role', `removed` > datetime COMMENT 'date removed', `description` text COMMENT > 'description of the project role', `project_id` bigint(20) unsigned > COMMENT 'Id of the project to which the role belongs', PRIMARY KEY > (`id`), KEY `i_project_role__name` (`name`), UNIQUE KEY (`name`, > `project_id`), CONSTRAINT `fk_project_role__project_id` FOREIGN > KEY(`project_id`) REFERENCES `projects`(`id`) ON DELETE CASCADE ) > ENGINE=InnoDB DEFAULT CHARSET=utf8 > > 2020-12-26 09:33:56,340 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- Project role permissions table > > 2020-12-26 09:33:56,340 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > CREATE TABLE IF NOT EXISTS `cloud`.`project_role_permissions` ( `id` > bigint(20) unsigned NOT NULL AUTO_INCREMENT, `uuid` varchar(255) > UNIQUE, `project_id` bigint(20) unsigned NOT NULL COMMENT 'id of the > role', `project_role_id` bigint(20) unsigned NOT NULL COMMENT 'id of > the role', `rule` varchar(255) NOT NULL COMMENT 'rule for the role, api > name or wildcard', `permission` varchar(255) NOT NULL COMMENT 'access > authority, allow or deny', `description` text COMMENT 'description of > the rule', `sort_order` bigint(20) unsigned NOT NULL DEFAULT 0 COMMENT > 'permission sort order', PRIMARY KEY (`id`), KEY > `fk_project_role_permissions__project_role_id` (`project_role_id`), KEY > `i_project_role_permissions__sort_order` (`sort_order`), UNIQUE KEY > (`project_role_id`, `rule`), CONSTRAINT > `fk_project_role_permissions__project_id` FOREIGN KEY(`project_id`) > REFERENCES `projects`(`id`) ON DELETE CASCADE, CONSTRAINT > `fk_project_role_permissions__project_role_id` FOREIGN KEY > (`project_role_id`) REFERENCES `project_role` (`id`) ON DELETE CASCADE ) > ENGINE=InnoDB DEFAULT CHARSET=utf8 > > 2020-12-26 09:33:56,341 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- Alter project accounts table to include user_id and project_role_id for > role based users in projects > > 2020-12-26 09:33:56,341 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > ALTER TABLE `cloud`.`project_account` ADD COLUMN `user_id` bigint > unsigned COMMENT 'ID of user to be added to the project' AFTER `account_id`, > ADD CONSTRAINT `fk_project_account__user_id` FOREIGN KEY > `fk_project_account__user_id`(`user_id`) REFERENCES `user`(`id`) ON DELETE > CASCADE, ADD COLUMN `project_role_id` bigint unsigned COMMENT 'Project > role id' AFTER `project_account_id`, ADD CONSTRAINT > `fk_project_account__project_role_id` FOREIGN KEY (`project_role_id`) > REFERENCES `project_role` (`id`) ON DELETE SET NULL, DROP FOREIGN KEY > `fk_project_account__account_id`, DROP INDEX `account_id` > > 2020-12-26 09:33:56,361 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) > Error executing: ALTER TABLE `cloud`.`project_account` ADD COLUMN > `user_id` bigint unsigned COMMENT 'ID of user to be added to the project' > AFTER `account_id`, ADD CONSTRAINT `fk_project_account__user_id` FOREIGN > KEY `fk_project_account__user_id`(`user_id`) REFERENCES `user`(`id`) ON > DELETE CASCADE, ADD COLUMN `project_role_id` bigint unsigned COMMENT > 'Project role id' AFTER `project_account_id`, ADD CONSTRAINT > `fk_project_account__project_role_id` FOREIGN KEY (`project_role_id`) > REFERENCES `project_role` (`id`) ON DELETE SET NULL, DROP FOREIGN KEY > `fk_project_account__account_id`, DROP INDEX `account_id` > > 2020-12-26 09:33:56,362 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) > java.sql.SQLSyntaxErrorException: Can't DROP > 'fk_project_account__account_id'; check that column/key exists > > 2020-12-26 09:33:56,364 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) > (logid:) Unable to execute upgrade script > > java.sql.SQLSyntaxErrorException: Can't DROP > 'fk_project_account__account_id'; check that column/key exists > > 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:203) > > at > com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:258) > > at > com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:342) > > at > org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.checkIntegrity(CloudStackExtendedLifeCycle.java:64) > > at > org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.start(CloudStackExtendedLifeCycle.java:54) > > at > org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:182) > > at > org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:53) > > at > org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:360) > > at > org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:158) > > at > org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:122) > > at > org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:894) > > at > org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:553) > > at > org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.java:144) > > at or > > On Thu, Dec 24, 2020 at 11:14 AM Rohit Yadav <rohit.ya...@shapeblue.com> > wrote: > >> >> All, >> >> Here are the convenience packages build from 4.15.0.0-RC3 if you don't >> want to build CloudStack from the source artifacts: >> >> Packages: (Debian, CentOS7, and CentOS8) >> http://download.cloudstack.org/testing/4.15.0.0-rc3/ >> >> 4.15 systemvmtemplate: >> http://download.cloudstack.org/systemvm/4.15/ >> >> Build from the master branch of >> https://github.com/apache/cloudstack-documentation (if/after voting >> passes, we'll update and publish the docs): >> http://docs.cloudstack.apache.org/en/master/upgrading/ >> >> Additional notes: >> * The new UI is bundled within the cloudstack-management package and >> is shipped as the default UI served at <host:8080>/client, old UI will be >> served via <host:8080>/client/legacy. Most users don't need to do any >> separate installation or perform an installation step. >> * We've added support for CentOS8 with 4.15 but CentOS8 will EOL in >> Dec 2021 (https://wiki.centos.org/About/Product). >> >> >> Regards. >> >> ________________________________ >> From: Daan Hoogland <daan.hoogl...@gmail.com> >> Sent: Wednesday, December 23, 2020 23:13 >> To: users <users@cloudstack.apache.org>; dev <d...@cloudstack.apache.org> >> Subject: [VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3] >> >> LS, >> After fixing another few blockers, we have an RC3, The changes (other than >> bundling) are mostly interesting for those working with templates and on >> vmware. >> >> We are voting for the new UI and the main code. >> >> The candidate release branch is 4.15.0.0-RC20201223T1632. The UI is still >> separate but as agreed upon before this will be merged in coming releases, >> at least from a version management point of view. >> I've created a 4.15.0.0 release candidate, with the following artifacts up >> for a vote:Git Branches: >> main code: >> >> https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;a=shortlog;h=refs/heads/4.15.0.0-RC20201223T1632 >> < >> https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;a=shortlog;h=refs/heads/4.15.0.0-RC20201214T1124 >> > >> ui code: >> < >> https://git-wip-us.apache.org/repos/asf?p=cloudstack-primate.git;a=shortlog;h=refs/tags/1.0 >> > >> >> https://git-wip-us.apache.org/repos/asf?p=cloudstack-primate.git;a=tag;h=refs/tags/1.0 >> and Commit SH: >> main code: 01b3e361c7bb81fd1ea822faddd6594e52bb00c1 >> ui code: 0593302dd53ac3203d3ab43b62d890605910f3e1 >> >> Source release (checksums and signatures are available at the same >> location): >> https://dist.apache.org/repos/dist/dev/cloudstack/4.15.0.0/ (rev. 45059) >> PGP release keys (signed using 7975062401944786): >> https://dist.apache.org/repos/dist/release/cloudstack/KEYSVote will be >> open >> for (at least) 72 hours.For sanity in tallying the vote, can PMC members >> please be sure to indicate "(binding)" with their vote?[ ] +1 approve >> [ ] +0 no opinion >> [ ] -1 disapprove (and reason why) >> >> I will work with community members to provide convenience packaging over >> the next few days. >> The documentation repo will be updated as we move along. >> >> >> >> -- >> Daan >> >> rohit.ya...@shapeblue.com >> www.shapeblue.com >> 3 London Bridge Street, 3rd floor, News Building, London SE1 9SGUK >> @shapeblue >> >> >> >> > > -- > Regards, > Hean Seng > -- Regards, Hean Seng
