occurred during do-release-upgrade
ProblemType: Package
DistroRelease: Ubuntu 20.04
Package: mysql-server-8.0 8.0.21-0ubuntu0.20.04.4
ProcVersionSignature: Ubuntu 4.15.0-121.123-generic 4.15.18
Uname: Linux 4.15.0-121-generic x86_64
ApportVersion: 2.20.11-0ubuntu27.9
Architecture: amd64
CasperMD5CheckResult: skip
Date: Mon Oct 19 14:21:58 2020
ErrorMessage: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
InstallationDate: Installed on 2019-03-07 (591 days ago)
InstallationMedia: Ubuntu-Server 16.04.5 LTS "Xenial Xerus" - Release amd64 (20180731)
Logs.var.log.daemon.log:
Logs.var.log.mysql.error.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: ['auto.cnf', 'private_key.pem', 'ib_logfile0', 'ib_logfile1', 'performance_schema', 'dcim', 'ibdata1', 'ib_buffer_pool', 'sys', 'network_reference', 'wordpress', 'phpmyadmin', 'mysql', 'powerdnsadmin', 'mysql_upgrade_info', 'public_key.pem', 'powerdns', 'debian-5.7.flag']
ProcCmdline: BOOT_IMAGE=/vmlinuz-4.15.0-121-generic root=/dev/mapper/cacti--vg-root ro
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.2ubuntu0.1
SourcePackage: mysql-8.0
Title: package mysql-server-8.0 8.0.21-0ubuntu0.20.04.4 failed to install/upgrade: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
UpgradeStatus: Upgraded to focal on 2020-10-19 (0 days ago)
modified.conffile..etc.apparmor.d.usr.sbin.mysqld: [modified]
modified.conffile..etc.mysql.mysql.cnf: [modified]
modified.conffile..etc.mysql.mysql.conf.d.mysqld.cnf: [modified]
mtime.conffile..etc.apparmor.d.usr.sbin.mysqld: 2019-04-24T13:08:53.291324
mtime.conffile..etc.mysql.mysql.cnf: 2019-03-07T15:54:02.661389
mtime.conffile..etc.mysql.mysql.conf.d.mysqld.cnf: 2020-10-19T14:21:56.668535
Thanks for taking the time to report this bug and trying to make Ubuntu better.
From the logs I can see this error:
ERROR: Unable to start MySQL server:
2020-10-
2020-10-
Please take a look at https:/
In your config file you are setting some deprecated options to the 'sql_mode'. If you check this upstream deprecation page:
https:/
and search for 'AUTO_CREATE_USER', you will notice this is deprecated and it is not supposed to work with MySQL >= 8.0.3 (in Ubuntu Focal we have 8.0.21). Removing it from your config file should fix your issue.
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://