Just trying to upgrade Ubuntu 18.04 to 20.04 on an Amazon AWS EC2 instance.
ProblemType: Package
DistroRelease: Ubuntu 20.04
Package: mysql-server-8.0 8.0.22-0ubuntu0.20.04.2
ProcVersionSignature: Ubuntu 5.4.0-52.57~18.04.1-generic 5.4.65
Uname: Linux 5.4.0-52-generic x86_64
ApportVersion: 2.20.11-0ubuntu27.11
Architecture: amd64
CasperMD5CheckResult: skip
Date: Sat Nov 7 23:08:10 2020
Ec2AMI: ami-3d50120d
Ec2AMIManifest: (unknown)
Ec2AvailabilityZone: us-west-2a
Ec2InstanceType: t2.medium
Ec2Kernel: unavailable
Ec2Ramdisk: unavailable
ErrorMessage: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
Logs.var.log.daemon.log:
MySQLConf.etc.mysql.conf.d.mysql.cnf: [mysql]
MySQLConf.etc.mysql.conf.d.mysqld_safe_syslog.cnf:
[mysqld_safe]
syslog
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: ['ppp_hoa_email', 'ib_buffer_pool', 'ppp_qb', 'marketing', 'ppp_pppv3', 'client-key.pem', 'ibdata1', 'mysql_upgrade_info', 'ppp_hoa', 'debian-5.5.flag', 'sys', 'hoaminfowp', 'hoampage2_staging', 'ppp_wp', 'hoampage_v2', 'ca.pem', 'auto.cnf', 'server-cert.pem', 'mysql', 'ppp_webdata', 'debian-5.7.flag', 'ib_logfile1', 'hoampagewp', 'ib_logfile0', 'phpmyadmin', 'taylor', 'ca-key.pem', 'public_key.pem', 'client-cert.pem', 'private_key.pem', 'performance_schema', 'server-key.pem', 'hoampage_wp']
ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-5.4.0-52-generic root=UUID=d36a9e2f-dae9-477f-8aea-29f1bdd1c04e ro console=tty1 console=ttyS0
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.22-0ubuntu0.20.04.2 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-11-08 (0 days ago)
modified.conffile..etc.mysql.mysql.cnf: [modified]
mtime.conffile..etc.mysql.mysql.cnf: 2018-08-20T07:14:09.454425
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-
2020-11-
Please take a look at https:/
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:/
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://