package mysql-server-8.0 8.0.22-0ubuntu0.20.04.3 failed to install/upgrade: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mysql-8.0 (Ubuntu) |
Expired
|
Undecided
|
Unassigned |
Bug Description
Upgrade not possible
ProblemType: Package
DistroRelease: Ubuntu 20.04
Package: mysql-server-8.0 8.0.22-
ProcVersionSign
Uname: Linux 5.4.0-54-generic x86_64
NonfreeKernelMo
ApportVersion: 2.20.11-
Architecture: amd64
CasperMD5CheckR
Date: Mon Nov 30 18:49:00 2020
ErrorMessage: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
InstallationDate: Installed on 2011-10-22 (3327 days ago)
InstallationMedia: Ubuntu 11.04 "Natty Narwhal" - Release amd64 (20110427.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.5, python3-minimal, 3.8.2-0ubuntu2
PythonDetails: /usr/bin/python2.7, Python 2.7.18, python-is-python2, 2.7.17-4
RelatedPackageV
dpkg 1.19.7ubuntu3
apt 2.0.2ubuntu0.1
SourcePackage: mysql-8.0
Title: package mysql-server-8.0 8.0.22-
UpgradeStatus: Upgraded to focal on 2020-11-27 (2 days ago)
tags: | removed: need-duplicate-check |
Thank you for taking the time to file a bug report.
Checking the attached logs I found this:
2020-11- 30T17:51: 13.420162Z 0 [ERROR] [MY-000067] [Server] unknown variable 'query_ cache_limit= 1M'. 30T17:51: 13.420930Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-11-
From https:/ /dev.mysql. com/doc/ refman/ 8.0/en/ added-deprecate d-removed. html, we can see that the config option query_cache_limit was removed in 8.0.3:
"""
query_cache_limit: Do not cache results that are bigger than this. Removed in MySQL 8.0.3.
"""
If you remove this option from your config file mysql will work again.
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: www.ubuntu. com/support/ community
http://