I restore the backup db, and reregister the system template using cloud-install-sys-tmplt , it sill getting error.
stemVm template not found. Ovm3 hypervisor is not used, so not failing upgrade 2020-12-26 10:11:37,713 DEBUG [c.c.u.d.Upgrade41400to41500] (main:null) (logid:) Updating KVM System Vms 2020-12-26 10:11:37,720 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) On Sat, Dec 26, 2020 at 5:48 PM Hean Seng <heans...@gmail.com> wrote: > 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 > -- Regards, Hean Seng