[Bug 1915734] Re: The db-sync command fails with MySQL 8
This bug was fixed in the package magnum - 10.0.0-0ubuntu0.20.04.2~cloud0 --- magnum (10.0.0-0ubuntu0.20.04.2~cloud0) bionic-ussuri; urgency=medium . * New update for the Ubuntu Cloud Archive. . magnum (10.0.0-0ubuntu0.20.04.2) focal; urgency=medium . * d/control: Update VCS paths for move to lp:~ubuntu-openstack-dev. * d/p/mysql8-support.patch: Picked from upstream stable/ussuri review https://review.opendev.org/c/openstack/magnum/+/781510 for mysql 8 support (LP: #1915734). * d/rules: Add OS_STDOUT_CAPTURE/OS_STDERR_CAPTURE to test execution inline with upstream. ** Changed in: cloud-archive/ussuri Status: Fix Committed => Fix Released -- 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
[Bug 1915734] Re: The db-sync command fails with MySQL 8
This bug was fixed in the package magnum - 11.0.0-0ubuntu1.1~cloud0 --- magnum (11.0.0-0ubuntu1.1~cloud0) focal-victoria; urgency=medium . * New update for the Ubuntu Cloud Archive. . magnum (11.0.0-0ubuntu1.1) groovy; urgency=medium . [ Corey Bryant ] * d/gbp.conf: Create stable/victoria branch. . [ Chris MacNaughton ] * d/p/mysql8-support.patch: Picked from upstream stable/victoria review https://review.opendev.org/c/openstack/magnum/+/777910 for mysql 8 support (LP: #1915734). ** Changed in: cloud-archive/victoria Status: Fix Committed => Fix Released -- 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
[Bug 1915734] Re: The db-sync command fails with MySQL 8
This bug was fixed in the package magnum - 10.0.0-0ubuntu0.20.04.2 --- magnum (10.0.0-0ubuntu0.20.04.2) focal; urgency=medium * d/control: Update VCS paths for move to lp:~ubuntu-openstack-dev. * d/p/mysql8-support.patch: Picked from upstream stable/ussuri review https://review.opendev.org/c/openstack/magnum/+/781510 for mysql 8 support (LP: #1915734). * d/rules: Add OS_STDOUT_CAPTURE/OS_STDERR_CAPTURE to test execution inline with upstream. -- Chris MacNaughton Mon, 26 Apr 2021 14:13:36 + ** Changed in: magnum (Ubuntu Focal) Status: Fix Committed => Fix Released -- 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
[Bug 1915734] Re: The db-sync command fails with MySQL 8
I have deployed magnum on focal with the proposed Victoria cloud archive and confirmed that it can setup successfully on mysql8. ** Tags removed: verification-victoria-needed ** Tags added: verification-victoria-done -- 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
[Bug 1915734] Re: The db-sync command fails with MySQL 8
I have deployed magnum on bionic with the proposed Ussuri cloud archive and confirmed that it can setup on percona-cluster as well ** Tags removed: verification-ussuri-needed ** Tags added: verification-ussuri-done -- 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
[Bug 1915734] Re: The db-sync command fails with MySQL 8
I have deployed Magnum from Focal-proposed and confirmed that it can run it's db-manage successfully on mysql8. ** Tags removed: verification-needed verification-needed-focal ** Tags added: verification-done verification-done-focal -- 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
[Bug 1915734] Re: The db-sync command fails with MySQL 8
The Groovy Gorilla has reached end of life, so this bug will not be fixed for that release ** Changed in: magnum (Ubuntu Groovy) Status: Fix Committed => Won't Fix -- 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
[Bug 1915734] Re: The db-sync command fails with MySQL 8
Hello Ionut-Madalin, or anyone else affected, Accepted magnum into groovy-proposed. The package will build now and be available at https://launchpad.net/ubuntu/+source/magnum/11.0.0-0ubuntu1.1 in a few hours, and then in the -proposed repository. Please help us by testing this new package. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation on how to enable and use -proposed. Your feedback will aid us getting this update out to other Ubuntu users. If this package fixes the bug for you, please add a comment to this bug, mentioning the version of the package you tested, what testing has been performed on the package and change the tag from verification-needed- groovy to verification-done-groovy. If it does not fix the bug for you, please add a comment stating that, and change the tag to verification- failed-groovy. In either case, without details of your testing we will not be able to proceed. Further information regarding the verification process can be found at https://wiki.ubuntu.com/QATeam/PerformingSRUVerification . Thank you in advance for helping! N.B. The updated package will be released to -updates after the bug(s) fixed by this package have been verified and the package has been in -proposed for a minimum of 7 days. ** Changed in: magnum (Ubuntu Groovy) Status: Triaged => Fix Committed ** Tags added: verification-needed verification-needed-groovy -- 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
[Bug 1915734] Re: The db-sync command fails with MySQL 8
** 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
[Bug 1915734] Re: The db-sync command fails with MySQL 8
** Changed in: cloud-archive/victoria Status: New => Triaged ** Changed in: cloud-archive/ussuri Status: New => Triaged ** Changed in: magnum (Ubuntu Focal) Status: New => Triaged ** Changed in: magnum (Ubuntu Groovy) Status: New => Triaged ** Changed in: magnum (Ubuntu Groovy) Importance: Undecided => High ** Changed in: magnum (Ubuntu Focal) Importance: Undecided => High ** Changed in: cloud-archive/ussuri Importance: Undecided => High ** Changed in: cloud-archive/victoria Importance: Undecided => High ** Changed in: magnum (Ubuntu) Status: New => Fix Released ** Changed in: cloud-archive Status: New => Fix Released ** Changed in: cloud-archive Importance: Undecided => High ** Changed in: magnum (Ubuntu) Importance: Undecided => High -- 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
[Bug 1915734] Re: The db-sync command fails with MySQL 8
Quick update on this one. Corey did separate PPAs for Ussuri and Victoria Magnum packages with builds from latest upstream stable branch: https://launchpad.net/~openstack-charmers/+archive/ubuntu/magnum-ussuri https://launchpad.net/~openstack-charmers/+archive/ubuntu/magnum-victoria Both Ussuri and Victoria Magnum packages from Corey's PPAs include the fix for this MySQL 8 DB migration issue. -- 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
[Bug 1915734] Re: The db-sync command fails with MySQL 8
** Also affects: magnum (Ubuntu Focal) Importance: Undecided Status: New ** Also affects: magnum (Ubuntu Groovy) Importance: Undecided Status: New ** Also affects: cloud-archive Importance: Undecided Status: New ** Also affects: cloud-archive/victoria Importance: Undecided Status: New ** Also affects: cloud-archive/ussuri Importance: Undecided Status: New -- 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