You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cloudstack.apache.org by Daan Hoogland <da...@gmail.com> on 2020/12/23 17:43:54 UTC
[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
Re: [VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
Posted by Abhishek Kumar <Ab...@shapeblue.com>.
+1
I may be late to vote but still :)
I did a fresh install test of RC3 for a VMware env:
- ACS management server on CentOS 7
- 2x ESXi 6.5 hosts
- Advanced networking zone
Performed the following tests:
- CRUD operations on templates and ISOs
- VM & volume lifecycle tests
- Live VM migration & storage migrations
- CKS lifecycle tests
- CRUD operations on offerings
- Import unmanaged instance and unmanage existing instance
I couldn't find any blockers during this.
Regards,
Abhishek
________________________________
From: Daan Hoogland <da...@gmail.com>
Sent: 01 January 2021 14:24
To: users <us...@cloudstack.apache.org>
Cc: dev <de...@cloudstack.apache.org>
Subject: Re: [VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
Happy New Year to all, I think we have a release but I'll wait to tally
votes until Monday. Enjoy your weekend and the coming year.
On Thu, 31 Dec 2020, 15:10 Boris Stoyanov, <bo...@shapeblue.com>
wrote:
> +1 (binding)
>
> In shared effort with Vladimir Petrov, we've done upgrade testing from
> latest of:
> 4.11
> 4.13
> 4.14
>
> Also did a basic lifecycle operations of:
> VMs, Networks, Storage, Infra(pod, cluster, zone, hosts).
>
> And we couldn't find any stopping issues with this RC.
>
> Thanks,
> Bobby.
>
> On 24.12.20, 5:14, "Rohit Yadav" <ro...@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 <da...@gmail.com>
> Sent: Wednesday, December 23, 2020 23:13
> To: users <us...@cloudstack.apache.org>; dev <
> dev@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.yadav@shapeblue.com
> www.shapeblue.com<http://www.shapeblue.com>
> 3 London Bridge Street, 3rd floor, News Building, London SE1 9SGUK
> @shapeblue
>
>
>
>
>
> boris.stoyanov@shapeblue.com
> www.shapeblue.com<http://www.shapeblue.com>
> 3 London Bridge Street, 3rd floor, News Building, London SE1 9SGUK
> @shapeblue
>
>
>
>
Abhishek.Kumar@shapeblue.com
www.shapeblue.com
3 London Bridge Street, 3rd floor, News Building, London SE1 9SGUK
@shapeblue
Re: [VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
Posted by Daan Hoogland <da...@gmail.com>.
Happy New Year to all, I think we have a release but I'll wait to tally
votes until Monday. Enjoy your weekend and the coming year.
On Thu, 31 Dec 2020, 15:10 Boris Stoyanov, <bo...@shapeblue.com>
wrote:
> +1 (binding)
>
> In shared effort with Vladimir Petrov, we've done upgrade testing from
> latest of:
> 4.11
> 4.13
> 4.14
>
> Also did a basic lifecycle operations of:
> VMs, Networks, Storage, Infra(pod, cluster, zone, hosts).
>
> And we couldn't find any stopping issues with this RC.
>
> Thanks,
> Bobby.
>
> On 24.12.20, 5:14, "Rohit Yadav" <ro...@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 <da...@gmail.com>
> Sent: Wednesday, December 23, 2020 23:13
> To: users <us...@cloudstack.apache.org>; dev <
> dev@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.yadav@shapeblue.com
> www.shapeblue.com
> 3 London Bridge Street, 3rd floor, News Building, London SE1 9SGUK
> @shapeblue
>
>
>
>
>
> boris.stoyanov@shapeblue.com
> www.shapeblue.com
> 3 London Bridge Street, 3rd floor, News Building, London SE1 9SGUK
> @shapeblue
>
>
>
>
Re: [VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
Posted by Daan Hoogland <da...@gmail.com>.
Happy New Year to all, I think we have a release but I'll wait to tally
votes until Monday. Enjoy your weekend and the coming year.
On Thu, 31 Dec 2020, 15:10 Boris Stoyanov, <bo...@shapeblue.com>
wrote:
> +1 (binding)
>
> In shared effort with Vladimir Petrov, we've done upgrade testing from
> latest of:
> 4.11
> 4.13
> 4.14
>
> Also did a basic lifecycle operations of:
> VMs, Networks, Storage, Infra(pod, cluster, zone, hosts).
>
> And we couldn't find any stopping issues with this RC.
>
> Thanks,
> Bobby.
>
> On 24.12.20, 5:14, "Rohit Yadav" <ro...@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 <da...@gmail.com>
> Sent: Wednesday, December 23, 2020 23:13
> To: users <us...@cloudstack.apache.org>; dev <
> dev@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.yadav@shapeblue.com
> www.shapeblue.com
> 3 London Bridge Street, 3rd floor, News Building, London SE1 9SGUK
> @shapeblue
>
>
>
>
>
> boris.stoyanov@shapeblue.com
> www.shapeblue.com
> 3 London Bridge Street, 3rd floor, News Building, London SE1 9SGUK
> @shapeblue
>
>
>
>
Re: [VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
Posted by Boris Stoyanov <bo...@shapeblue.com>.
+1 (binding)
In shared effort with Vladimir Petrov, we've done upgrade testing from latest of:
4.11
4.13
4.14
Also did a basic lifecycle operations of:
VMs, Networks, Storage, Infra(pod, cluster, zone, hosts).
And we couldn't find any stopping issues with this RC.
Thanks,
Bobby.
On 24.12.20, 5:14, "Rohit Yadav" <ro...@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 <da...@gmail.com>
Sent: Wednesday, December 23, 2020 23:13
To: users <us...@cloudstack.apache.org>; dev <de...@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.yadav@shapeblue.com
www.shapeblue.com
3 London Bridge Street, 3rd floor, News Building, London SE1 9SGUK
@shapeblue
boris.stoyanov@shapeblue.com
www.shapeblue.com
3 London Bridge Street, 3rd floor, News Building, London SE1 9SGUK
@shapeblue
Re: [VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
Posted by Boris Stoyanov <bo...@shapeblue.com>.
+1 (binding)
In shared effort with Vladimir Petrov, we've done upgrade testing from latest of:
4.11
4.13
4.14
Also did a basic lifecycle operations of:
VMs, Networks, Storage, Infra(pod, cluster, zone, hosts).
And we couldn't find any stopping issues with this RC.
Thanks,
Bobby.
On 24.12.20, 5:14, "Rohit Yadav" <ro...@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 <da...@gmail.com>
Sent: Wednesday, December 23, 2020 23:13
To: users <us...@cloudstack.apache.org>; dev <de...@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.yadav@shapeblue.com
www.shapeblue.com
3 London Bridge Street, 3rd floor, News Building, London SE1 9SGUK
@shapeblue
boris.stoyanov@shapeblue.com
www.shapeblue.com
3 London Bridge Street, 3rd floor, News Building, London SE1 9SGUK
@shapeblue
Re: [VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
Posted by Hean Seng <he...@gmail.com>.
Hi Rohit and Andrija,
Thanks for reply. I will try again drop mysql 5.7 and reinstall back
mysql8 , All is working now after revert to mysql 5.7 and restore the
backup .
On Mon, Dec 28, 2020 at 6:39 PM Rohit Yadav <ro...@shapeblue.com>
wrote:
> Hi Hean,
>
> I think you've figured out the first issue to be missing systemvmtemplate,
> the upgrade requires that the 4.15 systemvmtemplate is registered prior to
> the upgrade.
>
> MySQL8 should work with 4.15 RC3 (as Andrija notes), however, if you're
> doing an in-place upgrade you may want to backup the DB dumps, stop all old
> CloudStack services (mgmt and usage servers), and then try to upgrade MySQL
> 5.x to 8 and then follow the upgrade. You may also take DB backups and
> restore them in a new MySQL8 instance.
>
> The do-release-upgrade would perform an in-place upgrade of Ubuntu 18.04
> to 20.04 installation which may have issues of its own, can you try a fresh
> installation of Ubuntu 20.04 + MySQL8 and try again? Thanks.
>
>
> Regards.
>
> ________________________________
> From: Andrija Panic <an...@gmail.com>
> Sent: Monday, December 28, 2020 14:04
> To: users <us...@cloudstack.apache.org>
> Subject: Re: [VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
>
> MySQL 8 should work - support for it was introduced in 4.15, if not
> mistaken (5.7 is still a safe bet).
>
> Your issue seems to be an unclean restore of the DB, based on the input
> you've shared. You need to drop your cloud/cloud_usage DBs, create empty
> ones, restore them both from backup, start the old mgmt server, make sure
> that the proper systemVM template is registered with the EXACT name as
> specified in the upgrade guide (you have to use that name, otherwise later
> the DB upgrade will fail) and only then proceed with the upgrade to 4.15.
>
>
> rohit.yadav@shapeblue.com
> www.shapeblue.com
> 3 London Bridge Street, 3rd floor, News Building, London SE1 9SGUK
> @shapeblue
>
>
>
> On Mon, 28 Dec 2020 at 06:33, Hean Seng <he...@gmail.com> wrote:
>
> > Just for update, I tested on Ubuntu 18, and upgrade to ACS5.15, no
> issue .
> >
> > After that MGMT, do-release-upgrade to Ubuntu 20, and no issue on upgrade
> > to Ubuntu20, However MySQL need to downgrade to MySQL 5.7. and restore
> back
> > the DB . Not sure how to make it work on MySQL8 yet.
> >
> > Create VM, Snapshot, Delivete, those is no issue as well.
> >
> >
> >
> > On Sun, Dec 27, 2020 at 1:08 AM Hean Seng <he...@gmail.com> wrote:
> >
> > > 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 <serg38l@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" <he...@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 <he...@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 <he...@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.yadav@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 <da...@gmail.com>
> > >> >>> Sent: Wednesday, December 23, 2020 23:13
> > >> >>> To: users <us...@cloudstack.apache.org>; dev <
> > >> dev@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.yadav@shapeblue.com
> > >> >>> www.shapeblue.com<http://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
> > >
> >
> >
> > --
> > Regards,
> > Hean Seng
> >
>
>
> --
>
> Andrija Panić
>
--
Regards,
Hean Seng
Re: [VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
Posted by Rohit Yadav <ro...@shapeblue.com>.
Hi Hean,
I think you've figured out the first issue to be missing systemvmtemplate, the upgrade requires that the 4.15 systemvmtemplate is registered prior to the upgrade.
MySQL8 should work with 4.15 RC3 (as Andrija notes), however, if you're doing an in-place upgrade you may want to backup the DB dumps, stop all old CloudStack services (mgmt and usage servers), and then try to upgrade MySQL 5.x to 8 and then follow the upgrade. You may also take DB backups and restore them in a new MySQL8 instance.
The do-release-upgrade would perform an in-place upgrade of Ubuntu 18.04 to 20.04 installation which may have issues of its own, can you try a fresh installation of Ubuntu 20.04 + MySQL8 and try again? Thanks.
Regards.
________________________________
From: Andrija Panic <an...@gmail.com>
Sent: Monday, December 28, 2020 14:04
To: users <us...@cloudstack.apache.org>
Subject: Re: [VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
MySQL 8 should work - support for it was introduced in 4.15, if not
mistaken (5.7 is still a safe bet).
Your issue seems to be an unclean restore of the DB, based on the input
you've shared. You need to drop your cloud/cloud_usage DBs, create empty
ones, restore them both from backup, start the old mgmt server, make sure
that the proper systemVM template is registered with the EXACT name as
specified in the upgrade guide (you have to use that name, otherwise later
the DB upgrade will fail) and only then proceed with the upgrade to 4.15.
rohit.yadav@shapeblue.com
www.shapeblue.com
3 London Bridge Street, 3rd floor, News Building, London SE1 9SGUK
@shapeblue
On Mon, 28 Dec 2020 at 06:33, Hean Seng <he...@gmail.com> wrote:
> Just for update, I tested on Ubuntu 18, and upgrade to ACS5.15, no issue .
>
> After that MGMT, do-release-upgrade to Ubuntu 20, and no issue on upgrade
> to Ubuntu20, However MySQL need to downgrade to MySQL 5.7. and restore back
> the DB . Not sure how to make it work on MySQL8 yet.
>
> Create VM, Snapshot, Delivete, those is no issue as well.
>
>
>
> On Sun, Dec 27, 2020 at 1:08 AM Hean Seng <he...@gmail.com> wrote:
>
> > 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 <se...@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" <he...@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 <he...@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 <he...@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.yadav@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 <da...@gmail.com>
> >> >>> Sent: Wednesday, December 23, 2020 23:13
> >> >>> To: users <us...@cloudstack.apache.org>; dev <
> >> dev@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.yadav@shapeblue.com
> >> >>> www.shapeblue.com<http://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
> >
>
>
> --
> Regards,
> Hean Seng
>
--
Andrija Panić
Re: [VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
Posted by Andrija Panic <an...@gmail.com>.
MySQL 8 should work - support for it was introduced in 4.15, if not
mistaken (5.7 is still a safe bet).
Your issue seems to be an unclean restore of the DB, based on the input
you've shared. You need to drop your cloud/cloud_usage DBs, create empty
ones, restore them both from backup, start the old mgmt server, make sure
that the proper systemVM template is registered with the EXACT name as
specified in the upgrade guide (you have to use that name, otherwise later
the DB upgrade will fail) and only then proceed with the upgrade to 4.15.
On Mon, 28 Dec 2020 at 06:33, Hean Seng <he...@gmail.com> wrote:
> Just for update, I tested on Ubuntu 18, and upgrade to ACS5.15, no issue .
>
> After that MGMT, do-release-upgrade to Ubuntu 20, and no issue on upgrade
> to Ubuntu20, However MySQL need to downgrade to MySQL 5.7. and restore back
> the DB . Not sure how to make it work on MySQL8 yet.
>
> Create VM, Snapshot, Delivete, those is no issue as well.
>
>
>
> On Sun, Dec 27, 2020 at 1:08 AM Hean Seng <he...@gmail.com> wrote:
>
> > 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 <se...@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" <he...@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 <he...@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 <he...@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.yadav@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 <da...@gmail.com>
> >> >>> Sent: Wednesday, December 23, 2020 23:13
> >> >>> To: users <us...@cloudstack.apache.org>; dev <
> >> dev@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.yadav@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
> >
>
>
> --
> Regards,
> Hean Seng
>
--
Andrija Panić
Re: [VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
Posted by Hean Seng <he...@gmail.com>.
Just for update, I tested on Ubuntu 18, and upgrade to ACS5.15, no issue .
After that MGMT, do-release-upgrade to Ubuntu 20, and no issue on upgrade
to Ubuntu20, However MySQL need to downgrade to MySQL 5.7. and restore back
the DB . Not sure how to make it work on MySQL8 yet.
Create VM, Snapshot, Delivete, those is no issue as well.
On Sun, Dec 27, 2020 at 1:08 AM Hean Seng <he...@gmail.com> wrote:
> 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 <se...@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" <he...@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 <he...@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 <he...@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.yadav@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 <da...@gmail.com>
>> >>> Sent: Wednesday, December 23, 2020 23:13
>> >>> To: users <us...@cloudstack.apache.org>; dev <
>> dev@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.yadav@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
>
--
Regards,
Hean Seng
Re: [VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
Posted by Hean Seng <he...@gmail.com>.
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 <se...@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" <he...@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 <he...@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 <he...@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.yadav@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 <da...@gmail.com>
> >>> Sent: Wednesday, December 23, 2020 23:13
> >>> To: users <us...@cloudstack.apache.org>; dev <
> dev@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.yadav@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
Re: [VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
Posted by Sergey Levitskiy <se...@hotmail.com>.
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" <he...@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 <he...@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 <he...@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 <ro...@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 <da...@gmail.com>
>>> Sent: Wednesday, December 23, 2020 23:13
>>> To: users <us...@cloudstack.apache.org>; dev <de...@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.yadav@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
Re: [VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
Posted by Hean Seng <he...@gmail.com>.
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 <he...@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 <he...@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 <ro...@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 <da...@gmail.com>
>>> Sent: Wednesday, December 23, 2020 23:13
>>> To: users <us...@cloudstack.apache.org>; dev <de...@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.yadav@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
Re: [VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
Posted by Hean Seng <he...@gmail.com>.
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 <he...@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 <ro...@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 <da...@gmail.com>
>> Sent: Wednesday, December 23, 2020 23:13
>> To: users <us...@cloudstack.apache.org>; dev <de...@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.yadav@shapeblue.com
>> www.shapeblue.com
>> 3 London Bridge Street, 3rd floor, News Building, London SE1 9SGUK
>> @shapeblue
>>
>>
>>
>>
>
> --
> Regards,
> Hean Seng
>
--
Regards,
Hean Seng
Re: [VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
Posted by Hean Seng <he...@gmail.com>.
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 <ro...@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 <da...@gmail.com>
> Sent: Wednesday, December 23, 2020 23:13
> To: users <us...@cloudstack.apache.org>; dev <de...@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.yadav@shapeblue.com
> www.shapeblue.com
> 3 London Bridge Street, 3rd floor, News Building, London SE1 9SGUK
> @shapeblue
>
>
>
>
--
Regards,
Hean Seng
Re: [VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
Posted by Rohit Yadav <ro...@shapeblue.com>.
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 <da...@gmail.com>
Sent: Wednesday, December 23, 2020 23:13
To: users <us...@cloudstack.apache.org>; dev <de...@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.yadav@shapeblue.com
www.shapeblue.com
3 London Bridge Street, 3rd floor, News Building, London SE1 9SGUK
@shapeblue
Re: [VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
Posted by Daan Hoogland <da...@gmail.com>.
I agree on ceph testing, but I see all Jerry's questions/reports answered
by Rohit and Wido. Can you say what is the reason for your -1/what is the
blocker issue? I reopened the milestone for 4.15.0.0 which I had just
closed, so if you and/or Jerry can create an issue on github we can discuss
further steps there.
On Mon, Jan 4, 2021 at 12:29 PM Wei ZHOU <us...@gmail.com> wrote:
> Hi Daan,
>
> Could you please look at the issue Jerry mentioned in another thread ? It
> seems critical.
> It would be nice if more people test ceph storage on different ubuntu and
> centos versions. It is not covered by jenkins/travis/trillian tests.
>
> -Wei
>
> On Mon, 4 Jan 2021 at 13:18, Daan Hoogland <da...@gmail.com>
> wrote:
>
> > ok, can you expand Wei?
> >
> > On Mon, Jan 4, 2021 at 11:51 AM Wei ZHOU <us...@gmail.com> wrote:
> >
> > > Hi Daan and Rohit,
> > >
> > > Sorry I would like to recall my +1.
> > >
> > > I think the ceph issue is a blocker.
> > >
> > > -Wei
> > >
> > >
> > >
> > > On Mon, 4 Jan 2021 at 12:18, Daan Hoogland <da...@gmail.com>
> > > wrote:
> > >
> > > > Hi all,
> > > >
> > > > After 72 hours (+the holidays), the vote for CloudStack 4.15.0.0
> > *passes*
> > > > with
> > > > 4 PMC + 1 non-PMC votes.
> > > >
> > > > +1 (PMC / binding)
> > > > * Wei, Boris, Rohit, Gabriel
> > > >
> > > > +1 (non binding)
> > > > * Abhishek
> > > >
> > > > 0
> > > > none
> > > >
> > > > -1
> > > > none
> > > >
> > > > Thanks to everyone participating.
> > > >
> > > > I will now prepare the release announcement to go out after 24 hours
> > > > to give the mirrors time to catch up.
> > > >
> > > >
> > > > On Wed, Dec 23, 2020 at 5:43 PM Daan Hoogland <
> daan.hoogland@gmail.com
> > >
> > > > wrote:
> > > >
> > > > > 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
> > > > >
> > > >
> > > >
> > > > --
> > > > Daan
> > > >
> > >
> >
> >
> > --
> > Daan
> >
>
--
Daan
Re: [VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
Posted by Wei ZHOU <us...@gmail.com>.
Hi Daan,
Could you please look at the issue Jerry mentioned in another thread ? It
seems critical.
It would be nice if more people test ceph storage on different ubuntu and
centos versions. It is not covered by jenkins/travis/trillian tests.
-Wei
On Mon, 4 Jan 2021 at 13:18, Daan Hoogland <da...@gmail.com> wrote:
> ok, can you expand Wei?
>
> On Mon, Jan 4, 2021 at 11:51 AM Wei ZHOU <us...@gmail.com> wrote:
>
> > Hi Daan and Rohit,
> >
> > Sorry I would like to recall my +1.
> >
> > I think the ceph issue is a blocker.
> >
> > -Wei
> >
> >
> >
> > On Mon, 4 Jan 2021 at 12:18, Daan Hoogland <da...@gmail.com>
> > wrote:
> >
> > > Hi all,
> > >
> > > After 72 hours (+the holidays), the vote for CloudStack 4.15.0.0
> *passes*
> > > with
> > > 4 PMC + 1 non-PMC votes.
> > >
> > > +1 (PMC / binding)
> > > * Wei, Boris, Rohit, Gabriel
> > >
> > > +1 (non binding)
> > > * Abhishek
> > >
> > > 0
> > > none
> > >
> > > -1
> > > none
> > >
> > > Thanks to everyone participating.
> > >
> > > I will now prepare the release announcement to go out after 24 hours
> > > to give the mirrors time to catch up.
> > >
> > >
> > > On Wed, Dec 23, 2020 at 5:43 PM Daan Hoogland <daan.hoogland@gmail.com
> >
> > > wrote:
> > >
> > > > 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
> > > >
> > >
> > >
> > > --
> > > Daan
> > >
> >
>
>
> --
> Daan
>
Re: [VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
Posted by Daan Hoogland <da...@gmail.com>.
ok, can you expand Wei?
On Mon, Jan 4, 2021 at 11:51 AM Wei ZHOU <us...@gmail.com> wrote:
> Hi Daan and Rohit,
>
> Sorry I would like to recall my +1.
>
> I think the ceph issue is a blocker.
>
> -Wei
>
>
>
> On Mon, 4 Jan 2021 at 12:18, Daan Hoogland <da...@gmail.com>
> wrote:
>
> > Hi all,
> >
> > After 72 hours (+the holidays), the vote for CloudStack 4.15.0.0 *passes*
> > with
> > 4 PMC + 1 non-PMC votes.
> >
> > +1 (PMC / binding)
> > * Wei, Boris, Rohit, Gabriel
> >
> > +1 (non binding)
> > * Abhishek
> >
> > 0
> > none
> >
> > -1
> > none
> >
> > Thanks to everyone participating.
> >
> > I will now prepare the release announcement to go out after 24 hours
> > to give the mirrors time to catch up.
> >
> >
> > On Wed, Dec 23, 2020 at 5:43 PM Daan Hoogland <da...@gmail.com>
> > wrote:
> >
> > > 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
> > >
> >
> >
> > --
> > Daan
> >
>
--
Daan
Re: [VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
Posted by Wei ZHOU <us...@gmail.com>.
Hi Daan and Rohit,
Sorry I would like to recall my +1.
I think the ceph issue is a blocker.
-Wei
On Mon, 4 Jan 2021 at 12:18, Daan Hoogland <da...@gmail.com> wrote:
> Hi all,
>
> After 72 hours (+the holidays), the vote for CloudStack 4.15.0.0 *passes*
> with
> 4 PMC + 1 non-PMC votes.
>
> +1 (PMC / binding)
> * Wei, Boris, Rohit, Gabriel
>
> +1 (non binding)
> * Abhishek
>
> 0
> none
>
> -1
> none
>
> Thanks to everyone participating.
>
> I will now prepare the release announcement to go out after 24 hours
> to give the mirrors time to catch up.
>
>
> On Wed, Dec 23, 2020 at 5:43 PM Daan Hoogland <da...@gmail.com>
> wrote:
>
> > 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
> >
>
>
> --
> Daan
>
[RESULT][VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
Posted by Daan Hoogland <da...@gmail.com>.
I forgot to rename the thread so for archive purposes, this.
On Mon, Jan 4, 2021 at 11:18 AM Daan Hoogland <da...@gmail.com>
wrote:
> Hi all,
>
> After 72 hours (+the holidays), the vote for CloudStack 4.15.0.0 *passes* with
> 4 PMC + 1 non-PMC votes.
>
> +1 (PMC / binding)
> * Wei, Boris, Rohit, Gabriel
>
> +1 (non binding)
> * Abhishek
>
> 0
> none
>
> -1
> none
>
> Thanks to everyone participating.
>
> I will now prepare the release announcement to go out after 24 hours to give the mirrors time to catch up.
>
>
> On Wed, Dec 23, 2020 at 5:43 PM Daan Hoogland <da...@gmail.com>
> wrote:
>
>> 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
>>
>
>
> --
> Daan
>
--
Daan
[RESULT][VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
Posted by Daan Hoogland <da...@gmail.com>.
I forgot to rename the thread so for archive purposes, this.
On Mon, Jan 4, 2021 at 11:18 AM Daan Hoogland <da...@gmail.com>
wrote:
> Hi all,
>
> After 72 hours (+the holidays), the vote for CloudStack 4.15.0.0 *passes* with
> 4 PMC + 1 non-PMC votes.
>
> +1 (PMC / binding)
> * Wei, Boris, Rohit, Gabriel
>
> +1 (non binding)
> * Abhishek
>
> 0
> none
>
> -1
> none
>
> Thanks to everyone participating.
>
> I will now prepare the release announcement to go out after 24 hours to give the mirrors time to catch up.
>
>
> On Wed, Dec 23, 2020 at 5:43 PM Daan Hoogland <da...@gmail.com>
> wrote:
>
>> 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
>>
>
>
> --
> Daan
>
--
Daan
Re: [VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
Posted by Daan Hoogland <da...@gmail.com>.
Hi all,
After 72 hours (+the holidays), the vote for CloudStack 4.15.0.0 *passes* with
4 PMC + 1 non-PMC votes.
+1 (PMC / binding)
* Wei, Boris, Rohit, Gabriel
+1 (non binding)
* Abhishek
0
none
-1
none
Thanks to everyone participating.
I will now prepare the release announcement to go out after 24 hours
to give the mirrors time to catch up.
On Wed, Dec 23, 2020 at 5:43 PM Daan Hoogland <da...@gmail.com>
wrote:
> 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
>
--
Daan
Re: [VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
Posted by Gabriel Bräscher <ga...@gmail.com>.
+1 (binding)
I could not find any blocker issue neither on CloudStack nor
CloudStack-primate.
Details:
1. Environment:
- Apache CloudStack: Management server + DB (Ubuntu 18.04)
- Hosts: KVM (Ubuntu 18.04)
- Primary Storage: NFS, RBD, KVM Local- Secondary Storage: NFS
- Zone Network: Advanced network + Security Groups
- Tests were performed on both Primate UI and legacy UI
2. Tests:
- Build 4.15.0.0 from source
- Upgrade from 4.13.1.0 to 4.15.0.0
- Deploy SystemVMs
- create user VMs on different primary storages (local, NFS, RBD)
- Live Migrate VMs (tested with local, NFS, and RBD)
- Put host in maintenance
- Remove/add host
- Add/remove primary storage (local and NFS)
- Add secondary storage (NFS)
- Deploy new Zone
- Register template
- Configure Service Offerings
- Change VM's offering
- Enable OOBM (Redfish)
- Perform OOBM actions (Redfish)
Em qui., 31 de dez. de 2020 às 06:03, Rohit Yadav <ro...@shapeblue.com>
escreveu:
> +1 (binding)
>
> I ran smoketests with the following combination (fresh installation only)
> and all tests passed except for one case on KVM (see below), few cases
> known to fail intermittently were checked and ignored (test_01_scale_vm,
> test_04_rvpc_privategw_static_routes which passed in other environments):
>
> CentOS7 mgmt server + vmware-65u2 + adv zone
> CentOS7 mgmt server + kvm-centos7 + adv zone
> CentOS7 mgmt server + xenserver-71 + adv zone
>
> On the KVM CentOS7 env this failed:
> test_03_deploy_and_upgrade_kubernetes_cluster | `Failure` | 240.74 |
> test_kubernetes_clusters.py
>
> On manual investigation, the above turned out to be an intermittent issue
> (passed on manual attempt and already passed in other env). I've also
> manually tested the following:
> - Basic VM lifecycle tests using default built-in CentOS template on an
> isolated network
> - CKS cluster setup with v1.16.0 with CoreOS template, also tested upgrade
> CKS cluster to v1.16.3
> - Several basic views of the modern UI, and legacy UI on the
> <host:8080>/client/legacy to check basic VM lifecycle views and actions
> - The new novnc console both over unsecured and SSL-enabled environments
>
>
> Proposed a minor document change based on testing Kubernetes/CKS cluster:
>
> https://github.com/apache/cloudstack-documentation/pull/174/files
>
>
> Regards.
>
> ________________________________
> From: Daan Hoogland <da...@gmail.com>
> Sent: Wednesday, December 23, 2020 23:13
> To: users <us...@cloudstack.apache.org>; dev <de...@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.yadav@shapeblue.com
> www.shapeblue.com
> 3 London Bridge Street, 3rd floor, News Building, London SE1 9SGUK
> @shapeblue
>
>
>
>
Re: [VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
Posted by Gabriel Bräscher <ga...@gmail.com>.
+1 (binding)
I could not find any blocker issue neither on CloudStack nor
CloudStack-primate.
Details:
1. Environment:
- Apache CloudStack: Management server + DB (Ubuntu 18.04)
- Hosts: KVM (Ubuntu 18.04)
- Primary Storage: NFS, RBD, KVM Local- Secondary Storage: NFS
- Zone Network: Advanced network + Security Groups
- Tests were performed on both Primate UI and legacy UI
2. Tests:
- Build 4.15.0.0 from source
- Upgrade from 4.13.1.0 to 4.15.0.0
- Deploy SystemVMs
- create user VMs on different primary storages (local, NFS, RBD)
- Live Migrate VMs (tested with local, NFS, and RBD)
- Put host in maintenance
- Remove/add host
- Add/remove primary storage (local and NFS)
- Add secondary storage (NFS)
- Deploy new Zone
- Register template
- Configure Service Offerings
- Change VM's offering
- Enable OOBM (Redfish)
- Perform OOBM actions (Redfish)
Em qui., 31 de dez. de 2020 às 06:03, Rohit Yadav <ro...@shapeblue.com>
escreveu:
> +1 (binding)
>
> I ran smoketests with the following combination (fresh installation only)
> and all tests passed except for one case on KVM (see below), few cases
> known to fail intermittently were checked and ignored (test_01_scale_vm,
> test_04_rvpc_privategw_static_routes which passed in other environments):
>
> CentOS7 mgmt server + vmware-65u2 + adv zone
> CentOS7 mgmt server + kvm-centos7 + adv zone
> CentOS7 mgmt server + xenserver-71 + adv zone
>
> On the KVM CentOS7 env this failed:
> test_03_deploy_and_upgrade_kubernetes_cluster | `Failure` | 240.74 |
> test_kubernetes_clusters.py
>
> On manual investigation, the above turned out to be an intermittent issue
> (passed on manual attempt and already passed in other env). I've also
> manually tested the following:
> - Basic VM lifecycle tests using default built-in CentOS template on an
> isolated network
> - CKS cluster setup with v1.16.0 with CoreOS template, also tested upgrade
> CKS cluster to v1.16.3
> - Several basic views of the modern UI, and legacy UI on the
> <host:8080>/client/legacy to check basic VM lifecycle views and actions
> - The new novnc console both over unsecured and SSL-enabled environments
>
>
> Proposed a minor document change based on testing Kubernetes/CKS cluster:
>
> https://github.com/apache/cloudstack-documentation/pull/174/files
>
>
> Regards.
>
> ________________________________
> From: Daan Hoogland <da...@gmail.com>
> Sent: Wednesday, December 23, 2020 23:13
> To: users <us...@cloudstack.apache.org>; dev <de...@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.yadav@shapeblue.com
> www.shapeblue.com
> 3 London Bridge Street, 3rd floor, News Building, London SE1 9SGUK
> @shapeblue
>
>
>
>
Re: [VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
Posted by Rohit Yadav <ro...@shapeblue.com>.
+1 (binding)
I ran smoketests with the following combination (fresh installation only) and all tests passed except for one case on KVM (see below), few cases known to fail intermittently were checked and ignored (test_01_scale_vm, test_04_rvpc_privategw_static_routes which passed in other environments):
CentOS7 mgmt server + vmware-65u2 + adv zone
CentOS7 mgmt server + kvm-centos7 + adv zone
CentOS7 mgmt server + xenserver-71 + adv zone
On the KVM CentOS7 env this failed:
test_03_deploy_and_upgrade_kubernetes_cluster | `Failure` | 240.74 | test_kubernetes_clusters.py
On manual investigation, the above turned out to be an intermittent issue (passed on manual attempt and already passed in other env). I've also manually tested the following:
- Basic VM lifecycle tests using default built-in CentOS template on an isolated network
- CKS cluster setup with v1.16.0 with CoreOS template, also tested upgrade CKS cluster to v1.16.3
- Several basic views of the modern UI, and legacy UI on the <host:8080>/client/legacy to check basic VM lifecycle views and actions
- The new novnc console both over unsecured and SSL-enabled environments
Proposed a minor document change based on testing Kubernetes/CKS cluster:
https://github.com/apache/cloudstack-documentation/pull/174/files
Regards.
________________________________
From: Daan Hoogland <da...@gmail.com>
Sent: Wednesday, December 23, 2020 23:13
To: users <us...@cloudstack.apache.org>; dev <de...@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.yadav@shapeblue.com
www.shapeblue.com
3 London Bridge Street, 3rd floor, News Building, London SE1 9SGUK
@shapeblue
Re: [VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
Posted by Daan Hoogland <da...@gmail.com>.
Hi all,
After 72 hours (+the holidays), the vote for CloudStack 4.15.0.0 *passes* with
4 PMC + 1 non-PMC votes.
+1 (PMC / binding)
* Wei, Boris, Rohit, Gabriel
+1 (non binding)
* Abhishek
0
none
-1
none
Thanks to everyone participating.
I will now prepare the release announcement to go out after 24 hours
to give the mirrors time to catch up.
On Wed, Dec 23, 2020 at 5:43 PM Daan Hoogland <da...@gmail.com>
wrote:
> 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
>
--
Daan
Re: [VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
Posted by Rohit Yadav <ro...@shapeblue.com>.
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 <da...@gmail.com>
Sent: Wednesday, December 23, 2020 23:13
To: users <us...@cloudstack.apache.org>; dev <de...@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.yadav@shapeblue.com
www.shapeblue.com
3 London Bridge Street, 3rd floor, News Building, London SE1 9SGUK
@shapeblue
Re: [VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
Posted by Wei ZHOU <us...@gmail.com>.
+1.
Tested the following
(1) upgrade from 4.14 to 4.15
(2) tested vm,template,volume lifecycles.
The only issues I faced are
(1) https://github.com/apache/cloudstack/issues/4146
(2) marvin cannot be installed and executed on Ubuntu 20.04
I think they are not blockers.
-Wei
On Wed, 23 Dec 2020 at 18:44, Daan Hoogland <da...@gmail.com> wrote:
> 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
>
Re: [VOTE] Apache Cloudstack 4.15.0.0 and UI [RC3]
Posted by Rohit Yadav <ro...@shapeblue.com>.
+1 (binding)
I ran smoketests with the following combination (fresh installation only) and all tests passed except for one case on KVM (see below), few cases known to fail intermittently were checked and ignored (test_01_scale_vm, test_04_rvpc_privategw_static_routes which passed in other environments):
CentOS7 mgmt server + vmware-65u2 + adv zone
CentOS7 mgmt server + kvm-centos7 + adv zone
CentOS7 mgmt server + xenserver-71 + adv zone
On the KVM CentOS7 env this failed:
test_03_deploy_and_upgrade_kubernetes_cluster | `Failure` | 240.74 | test_kubernetes_clusters.py
On manual investigation, the above turned out to be an intermittent issue (passed on manual attempt and already passed in other env). I've also manually tested the following:
- Basic VM lifecycle tests using default built-in CentOS template on an isolated network
- CKS cluster setup with v1.16.0 with CoreOS template, also tested upgrade CKS cluster to v1.16.3
- Several basic views of the modern UI, and legacy UI on the <host:8080>/client/legacy to check basic VM lifecycle views and actions
- The new novnc console both over unsecured and SSL-enabled environments
Proposed a minor document change based on testing Kubernetes/CKS cluster:
https://github.com/apache/cloudstack-documentation/pull/174/files
Regards.
________________________________
From: Daan Hoogland <da...@gmail.com>
Sent: Wednesday, December 23, 2020 23:13
To: users <us...@cloudstack.apache.org>; dev <de...@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.yadav@shapeblue.com
www.shapeblue.com
3 London Bridge Street, 3rd floor, News Building, London SE1 9SGUK
@shapeblue