Thank you for taking the time to file a bug report. >From the logs we can find this:
ERROR: Unable to start MySQL server: 2020-11-08T06:08:10.291853Z 0 [ERROR] [MY-000077] [Server] /usr/sbin/mysqld: Error while setting value 'NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER' to 'sql_mode'. 2020-11-08T06:08:10.299556Z 0 [ERROR] [MY-010119] [Server] Aborting Please take a look at https://wiki.debian.org/Teams/MySQL/FAQ for tips on fixing common upgrade issues. As you can see this is an upgrade issue, you are updating from mysql 5.7 (bionic) to 8.0 (focal). In your my.cnf config file you have set the sql_mode variable, most of the values there are already set by default now, check the upstream doc: https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html Update the sql_mode variable in the config file accordingly, restart the mysql service and your issue should be fixed. Since it seems likely to me that this is a local configuration problem, rather than a bug in Ubuntu, I am marking this bug as 'Incomplete'. However, if you believe that this is really a bug in Ubuntu, then we would be grateful if you would provide a more complete description of the problem with steps to reproduce, explain why you believe this is a bug in Ubuntu rather than a problem specific to your system, and then change the bug status back to "New". For local configuration issues, you can find assistance here: http://www.ubuntu.com/support/community ** Changed in: mysql-8.0 (Ubuntu) Status: New => Incomplete -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1903431 Title: package mysql-server-8.0 8.0.22-0ubuntu0.20.04.2 failed to install/upgrade: installed mysql-server-8.0 package post-installation script subpr To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1903431/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
