Failed to upgrade to mysql-server-8.0 when xenial-era config is present
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mysql-8.0 (Ubuntu) |
Triaged
|
High
|
Unassigned |
Bug Description
Failure attempting to upgrade to Ubuntu 20.10 from 16.xx (first upgraded to 18.xx)
1) The release of Ubuntu you are using, via 'lsb_release -rd' or System -> About Ubuntu
Description: Ubuntu 20.10
Release: 20.10
2) The version of the package you are using, via 'apt-cache policy pkgname' or by checking in Software Center
N: Unable to locate package pkgname
3) What you expected to happen
Upgrade is successful
4) What happened instead
I was presented with an error and the ability to submit a bug.
ProblemType: Package
DistroRelease: Ubuntu 20.10
Package: mysql-server-8.0 8.0.23-
ProcVersionSign
Uname: Linux 5.4.0-67-generic x86_64
ApportVersion: 2.20.11-0ubuntu50.5
Architecture: amd64
CasperMD5CheckR
Date: Fri Mar 19 10:23:11 2021
ErrorMessage: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
InstallationDate: Installed on 2016-03-12 (1832 days ago)
InstallationMedia: Ubuntu-Server 14.04.4 LTS "Trusty Tahr" - Release amd64 (20160217.1)
Logs.var.
MySQLConf.
MySQLConf.
[mysqld_safe]
syslog
MySQLConf.
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
MySQLConf.
[mysqld_safe]
syslog
ProcCmdline: BOOT_IMAGE=
Python3Details: /usr/bin/python3.8, Python 3.8.6, python3-minimal, 3.8.6-0ubuntu1
PythonDetails: /usr/bin/python2.7, Python 2.7.18, python-is-python2, 2.7.17-4
RelatedPackageV
dpkg 1.20.5ubuntu2
apt 2.1.10ubuntu0.2
SourcePackage: mysql-8.0
Title: package mysql-server-8.0 8.0.23-
UpgradeStatus: Upgraded to groovy on 2021-03-19 (0 days ago)
tags: | removed: need-duplicate-check |
After a few minutes with Google I determined I was not alone and the following:
https:/ /serverfault. com/questions/ 1042327/ after-an- upgrade- to-ubuntu- 20-04-lts- why-does- mysql-not- start
lead to to the solution of:
comment out the following two lines in /etc/mysql/my.cnf
query_cache_limit = 1M
query_cache_size = 16M
I seem to be up and going now.