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
