** Description changed:
+ [Impact]
+
+ New installations of OpenStack Magnum with Mysql8 fail with a traceback
+ when trying to initialize the database
+
+ [Test Case]
+
+ Use the OpenStack charms to deploy Mggnum on Ubuntu Focal. Using Focal
+ is expected to have a traceback and with this change is expected to
+ setup successfully.
+
+ [Regression Potential]
+
+ The regression potential for this is minimal as the package currently
+ does not work at all with mysql8 which ships with Ubuntu Focal.
+
+ The proposed change is a cherry-pick from upstream that resolves this
+ issue by updating the old migrations to not set constraints that break
+ on Mysql8. This only affects new deploys that would normally step
+ through all of the old migrations so shouldn't affect running deploys.
+
+ ----------------------------------------------
+
The command to do the Magnum DB sync ('magnum-db-manage upgrade') fails
when using MySQL 8 releases.
This issue is tracked in the upstream Magnum project at:
https://storyboard.openstack.org/#!/story/2008488.
There is a fix already merged on Magnum master branch to fix this:
https://review.opendev.org/c/openstack/magnum/+/774142
We need to have this fix included with Magnum distro packages that are
expected to use MySQL 8. For example, deployments on Ubuntu Focal (or
higher) are expected to be using MySQL 8 already.
** Description changed:
[Impact]
New installations of OpenStack Magnum with Mysql8 fail with a traceback
when trying to initialize the database
[Test Case]
Use the OpenStack charms to deploy Mggnum on Ubuntu Focal. Using Focal
is expected to have a traceback and with this change is expected to
setup successfully.
[Regression Potential]
The regression potential for this is minimal as the package currently
- does not work at all with mysql8 which ships with Ubuntu Focal.
+ does not work at all with mysql8 which ships with Ubuntu Focal and
+ above.
The proposed change is a cherry-pick from upstream that resolves this
issue by updating the old migrations to not set constraints that break
on Mysql8. This only affects new deploys that would normally step
through all of the old migrations so shouldn't affect running deploys.
----------------------------------------------
The command to do the Magnum DB sync ('magnum-db-manage upgrade') fails
when using MySQL 8 releases.
This issue is tracked in the upstream Magnum project at:
https://storyboard.openstack.org/#!/story/2008488.
There is a fix already merged on Magnum master branch to fix this:
https://review.opendev.org/c/openstack/magnum/+/774142
We need to have this fix included with Magnum distro packages that are
expected to use MySQL 8. For example, deployments on Ubuntu Focal (or
higher) are expected to be using MySQL 8 already.
** Description changed:
[Impact]
New installations of OpenStack Magnum with Mysql8 fail with a traceback
when trying to initialize the database
[Test Case]
Use the OpenStack charms to deploy Mggnum on Ubuntu Focal. Using Focal
is expected to have a traceback and with this change is expected to
setup successfully.
[Regression Potential]
The regression potential for this is minimal as the package currently
does not work at all with mysql8 which ships with Ubuntu Focal and
- above.
+ above. This change has already landed into the upstream project, both on
+ Master and in their stable branches.
The proposed change is a cherry-pick from upstream that resolves this
issue by updating the old migrations to not set constraints that break
on Mysql8. This only affects new deploys that would normally step
through all of the old migrations so shouldn't affect running deploys.
----------------------------------------------
The command to do the Magnum DB sync ('magnum-db-manage upgrade') fails
when using MySQL 8 releases.
This issue is tracked in the upstream Magnum project at:
https://storyboard.openstack.org/#!/story/2008488.
There is a fix already merged on Magnum master branch to fix this:
https://review.opendev.org/c/openstack/magnum/+/774142
We need to have this fix included with Magnum distro packages that are
expected to use MySQL 8. For example, deployments on Ubuntu Focal (or
higher) are expected to be using MySQL 8 already.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1915734
Title:
The db-sync command fails with MySQL 8
To manage notifications about this bug go to:
https://bugs.launchpad.net/cloud-archive/+bug/1915734/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
