Public bug reported: Error logged is:
ERROR: Unable to start MySQL server: 2021-05-24T16:08:16.466930Z 0 [ERROR] [MY-000077] [Server] /usr/sbin/mysqld: Error while setting value 'NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'. 2021-05-24T16:08:16.473387Z 0 [ERROR] [MY-010119] [Server] Aborting As of MySQL 8.0.11, NO_AUTO_CREATE_USER has been removed as a valid SQL mode. (See https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-11.html) ProblemType: Package DistroRelease: Ubuntu 20.04 Package: mysql-server-8.0 8.0.25-0ubuntu0.20.04.1 ProcVersionSignature: Ubuntu 4.15.0-143.147-generic 4.15.18 Uname: Linux 4.15.0-143-generic x86_64 ApportVersion: 2.20.11-0ubuntu27.17 Architecture: amd64 CasperMD5CheckResult: skip Date: Mon May 24 09:08:16 2021 ErrorMessage: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1 InstallationDate: Installed on 2018-05-18 (1101 days ago) InstallationMedia: Ubuntu-Server 18.04 LTS "Bionic Beaver" - Release amd64 (20180426) Logs.var.log.daemon.log: MySQLConf.etc.mysql.conf.d.mysql.cnf: [mysql] MySQLConf.etc.mysql.conf.d.mysqldump.cnf: [mysqldump] quick quote-names max_allowed_packet = 16M MySQLConf.etc.mysql.mysql.conf.d.mysqld_safe_syslog.cnf: [mysqld_safe] syslog MySQLVarLibDirListing: ['server-key.pem', 'ib_buffer_pool', 'public_key.pem', 'ca.pem', 'mysql', 'ib_logfile0', 'server-cert.pem', 'cpdb', 'sys', 'client-key.pem', 'auto.cnf', 'ca-key.pem', 'performance_schema', 'private_key.pem', 'ib_logfile1', 'debian-5.7.flag', 'mysql_upgrade_info', 'ibdata1', 'client-cert.pem'] ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-4.15.0-143-generic root=/dev/sda ro console=ttyS0,19200n8 net.ifnames=0 Python3Details: /usr/bin/python3.8, Python 3.8.5, python3-minimal, 3.8.2-0ubuntu2 PythonDetails: /usr/bin/python2.7, Python 2.7.18, python-is-python2, 2.7.17-4 RelatedPackageVersions: dpkg 1.19.7ubuntu3 apt 2.0.5 SourcePackage: mysql-8.0 Title: package mysql-server-8.0 8.0.25-0ubuntu0.20.04.1 failed to install/upgrade: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1 UpgradeStatus: Upgraded to focal on 2021-05-24 (0 days ago) modified.conffile..etc.mysql.mysql.cnf: [modified] mtime.conffile..etc.mysql.mysql.cnf: 2018-07-17T19:45:06.978060 ** Affects: mysql-8.0 (Ubuntu) Importance: Undecided Status: New ** Tags: amd64 apport-package focal third-party-packages -- 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
