Ubuntu
mysql-8.0 package

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

Bug #1906290 reported by Stefan Meister on 2020-11-30

This bug affects 2 people

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-0ubuntu0.20.04.3
ProcVersionSignature: Ubuntu 5.4.0-54.60-generic 5.4.65
Uname: Linux 5.4.0-54-generic x86_64
NonfreeKernelModules: nvidia_modeset nvidia
ApportVersion: 2.20.11-0ubuntu27.13
Architecture: amd64
CasperMD5CheckResult: skip
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.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
ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-5.4.0-54-generic root=UUID=8c3b02be-7598-4639-bbd0-bea8a990d173 ro quiet splash vt.handoff=7
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.3 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-27 (2 days ago)

Tags:

Revision history for this message

Stefan Meister (stefan-meister-m) wrote on 2020-11-30:

.etc.apparmor.d.usr.sbin.mysqld.txt Edit (2.0 KiB, text/plain; charset="utf-8")
AptOrdering.txt Edit (964 bytes, text/plain; charset="utf-8")
Dependencies.txt Edit (2.4 KiB, text/plain; charset="utf-8")
Df.txt Edit (551 bytes, text/plain; charset="utf-8")
Dmesg.txt Edit (68.3 KiB, text/plain; charset="utf-8")
DpkgHistoryLog.txt Edit (22.0 KiB, text/plain; charset="utf-8")
DpkgTerminalLog.txt Edit (6.3 KiB, text/plain; charset="utf-8")
DuplicateSignature.txt Edit (2.1 KiB, text/plain; charset="utf-8")
KernLog.txt Edit (4.2 KiB, text/plain; charset="utf-8")
Logs.var.log.mysql.error.log.txt Edit (118.2 KiB, text/plain; charset="utf-8")
MySQLConf.etc.mysql.my.cnf.txt Edit (4.3 KiB, text/plain; charset="utf-8")
MySQLConf.etc.mysql.mysql.cnf.txt Edit (682 bytes, text/plain; charset="utf-8")
MySQLConf.etc.mysql.mysql.conf.d.mysql.cnf.txt Edit (132 bytes, text/plain; charset="utf-8")
MySQLConf.etc.mysql.mysql.conf.d.mysqld.cnf.txt Edit (2.2 KiB, text/plain; charset="utf-8")
MySQLVarLibDirListing.txt Edit (194.0 KiB, text/plain; charset="utf-8")
ProcCpuinfoMinimal.txt Edit (1.2 KiB, text/plain; charset="utf-8")

Apport retracing service (apport) on 2020-11-30

tags:

removed: need-duplicate-check

Revision history for this message

Lucas Kanashiro (lucaskanashiro) wrote on 2020-12-07:

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'.
2020-11-30T17:51:13.420930Z 0 [ERROR] [MY-010119] [Server] Aborting

From https://dev.mysql.com/doc/refman/8.0/en/added-deprecated-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:
http://www.ubuntu.com/support/community

Changed in mysql-8.0 (Ubuntu):
status:	New → Incomplete

Revision history for this message

Launchpad Janitor (janitor) wrote on 2021-02-06:

[Expired for mysql-8.0 (Ubuntu) because there has been no activity for 60 days.]

Changed in mysql-8.0 (Ubuntu):
status:	Incomplete → Expired

Report a bug

This report contains Public information

Everyone can see this information.

You are

Subscribing...

Edit bug mail

Other bug subscribers

Bug attachments

Add attachment

Remote bug watches

Bug watches keep track of this bug in other bug trackers.

Ubuntumysql-8.0 package

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

Bug Description

Other bug subscribers

Bug attachments

Remote bug watches

Ubuntu
mysql-8.0 package