[Bug 1929443] Re: upgrade mysql 5.7 to 8.0 during release upgrade (18.04.5 to 20.04.2) fails due to unsupported SQL mode
I understand the rationale, and thank you for being nice about it. I probably wouldn't have filed the bug at all if the upgrade process had not explicitly prompted for it... For reference, in case anybody wants to know if they stumble across this in future, I avoided the error by reverting the server to a pre-upgrade state, stopping MySQL, removing NO_AUTO_CREATE_USER from the sql_mode option, and then immediately performing a clean upgrade again to 20.04.2 (which worked correctly now). As the release notes specify, you may indeed also need to revise applications which are using MySQL if they rely on this or any other missing SQL mode options. I was fortunate enough that I just had to revise MySQL's configuration, not any applications. Thank you again for your response, Lucas! -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1929443 Title: upgrade mysql 5.7 to 8.0 during release upgrade (18.04.5 to 20.04.2) fails due to unsupported SQL mode To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1929443/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1929443] Re: upgrade mysql 5.7 to 8.0 during release upgrade (18.04.5 to 20.04.2) fails due to unsupported SQL mode
Thanks for taking the time to file this bug. Your analysis seems right and there is nothing we can do as Ubuntu, upstream decided to remove that option and we cannot support it without upstream. What you need to do is to avoid the usage of the NO_AUTO_CREATE_USER sql_mode option if you want to upgrade to MySQL 8, from the release notes you linked in the bug description: "For MySQL 5.7 applications that use SQL modes removed in MySQL 8.0, statements may fail when replicated from a MySQL 5.7 master to a MySQL 8.0 slave, or may have different effects on master and slave. To avoid such problems, applications that use modes removed in MySQL 8.0 should be revised to avoid them." Since this is a local configuration problem, rather than a bug in Ubuntu, I am marking this bug as 'Invalid'. ** Changed in: mysql-8.0 (Ubuntu) Status: New => Invalid -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1929443 Title: upgrade mysql 5.7 to 8.0 during release upgrade (18.04.5 to 20.04.2) fails due to unsupported SQL mode To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1929443/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1929443] Re: upgrade mysql 5.7 to 8.0 during release upgrade (18.04.5 to 20.04.2) fails due to unsupported SQL mode
** Tags removed: need-duplicate-check -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1929443 Title: upgrade mysql 5.7 to 8.0 during release upgrade (18.04.5 to 20.04.2) fails due to unsupported SQL mode To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1929443/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
