package mysql-server-8.0 8.0.34-0ubuntu0.23.04.1 failed to install/upgrade: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1

[Gaele Strootman]

Happened while updating using Software Updater

ProblemType: Package
DistroRelease: Ubuntu 23.04
Package: mysql-server-8.0 8.0.34-0ubuntu0.23.04.1
ProcVersionSignature: Ubuntu 6.2.0-26.26-generic 6.2.13
Uname: Linux 6.2.0-26-generic x86_64
NonfreeKernelModules: wl
ApportVersion: 2.26.1-0ubuntu2
Architecture: amd64
CasperMD5CheckResult: pass
Date: Sat Sep 16 20:00:13 2023
ErrorMessage: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
InstallationDate: Installed on 2023-07-05 (73 days ago)
InstallationMedia: Ubuntu 23.04 "Lunar Lobster" - Release amd64 (20230418)
Logs.var.log.daemon.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.my.cnf: my.cnf links to /etc/mysql/mysql.cnf
MySQLVarLibDirListing: ['private_key.pem', 'sys', 'mysql_upgrade_info', '#ib_16384_1.dblwr', 'performance_schema', 'auto.cnf', 'mysql', 'ca.pem', 'client-cert.pem', 'public_key.pem', '#innodb_redo', 'server-key.pem', 'undo_002', '#ib_16384_0.dblwr', 'mysql.ibd', '#innodb_temp', 'client-key.pem', 'undo_001', 'binlog.000011', 'binlog.index', 'ca-key.pem', 'ib_buffer_pool', 'debian-5.7.flag', 'ibdata1', 'server-cert.pem', 'phpmyadmin', 'binlog.000010']
ProcCmdline: BOOT_IMAGE=/vmlinuz-6.2.0-26-generic root=/dev/mapper/ubuntu--vg-ubuntu--lv ro quiet splash vt.handoff=7
Python3Details: /usr/bin/python3.11, Python 3.11.4, python3-minimal, 3.11.2-1
PythonDetails: N/A
RebootRequiredPkgs: Error: path contained symlinks.
RelatedPackageVersions:
 dpkg 1.21.21ubuntu1
 apt 2.6.0ubuntu0.1
SourcePackage: mysql-8.0
Title: package mysql-server-8.0 8.0.34-0ubuntu0.23.04.1 failed to install/upgrade: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
UpgradeStatus: No upgrade log present (probably fresh install)

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[Athos Ribeiro (athos-ribeiro)]

Hi Gaele or anyone else affected.

I am wondering if this could be a duplicate/regression of LP: #1899248. Would you mind providing more details on the hardware and on the failure? Does it usually take a while from the moment the new mysql package setup starts to the point the installation fails?

Once you provide more information, please, set this bug status back to new so we can keep investigating this one.

[Gaele Strootman (gaele)]

- Last Friday I upgraded to Mantic. During the upgrade the problem happened again. I managed to finish the upgrade by removing mysql-server-8.0
- After the upgrade I tried to install mysql-server, resulting in the same error. The error appeared after less that a minute, though, so this does not seem to be related to #1899248
- However, today, with Ubuntu fully updated, I tried to install mysql-server again. This time the install succeeded. The install took 28 seconds.

So I'm afraid I cannot help with testing any more.

[Bryce Harrington (bryce)]

Thanks for getting back to us Gaele!

Looking at the collected info, the only error message I spot is the "Unable to shut down" error, which like Athos points out, seems similar to LP: #1899248. That bug's fix was more of a tuning than a root cause fix, so the issue can still crop up if an installation takes longer than 3 min. You mention that you saw it pop up after less than a minute, on your second installation attempt, which I agree does seem to not match the symptoms, however perhaps apport was reporting the error from the first attempt?

The mysql error log can be used to analyze what actually happened, and indeed it does indicate shutting down mysqld took >slightly< over 3 min:

2023-09-16T17:06:19.994942Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.33-0ubuntu0.23.04.4).
2023-09-16T17:06:23.303243Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.33-0ubuntu0.23.04.4) (Ubuntu).

2023-09-16T17:56:25.259329Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.34-0ubuntu0.23.04.1).
2023-09-16T18:00:12.586424Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.34-0ubuntu0.23.04.1) (Ubuntu).

I don't know if this matches to your attempt #1 or #2, but perhaps based on the timestamps you can determine that?

So, I think Athos may be correct this is indeed related to #1899248, and simply lies outside the tuning window. I'm not sure if that suggests an adjustment to the tuning or suppression of apport error reporting or something else; I'll flag for Lena to see if there's anything useful to glean.