I think the main issue is the first time not recognize the systemvm , although already install they SystemVM
I do bare new installation on 4.15, CentOS7,KVM, , and it works On Sun, Dec 27, 2020 at 12:31 AM Sergey Levitskiy <serg...@hotmail.com> wrote: > You can try this. Restore your DB backup, register SSVM template and run > the following against your MySQL DB before starting the upgrade. > > ALTER TABLE `cloud`.`project_account` > ADD CONSTRAINT `fk_project_account__account_id` FOREIGN KEY(`account_id`) > REFERENCES `account`(`id`) ON DELETE CASCADE , > ADD CONSTRAINT `uc_project_account__project_id_account_id_user_id` UNIQUE > (`project_id`, `account_id`, `user_id`) ; > > > If it still fails capture and post full management server log. > > > Thanks, > Sergey > > On 12/26/20, 2:27 AM, "Hean Seng" <heans...@gmail.com> wrote: > > 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 > > -- Regards, Hean Seng
