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 [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
