package mysql-server-5.7 5.7.23-0ubuntu0.16.04.1 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1

[Won Chung]

I have not manually modified anything (directly) related to mysql.

ProblemType: Package
DistroRelease: Ubuntu 16.04
Package: mysql-server-5.7 5.7.23-0ubuntu0.16.04.1
ProcVersionSignature: Ubuntu 4.4.0-134.160-generic 4.4.140
Uname: Linux 4.4.0-134-generic x86_64
ApportVersion: 2.20.1-0ubuntu2.18
Architecture: amd64
Date: Mon Sep 3 11:34:45 2018
DpkgHistoryLog:
 Start-Date: 2018-09-03 11:34:17
 Commandline: /usr/bin/unattended-upgrade
 Upgrade: libopenjp2-7:amd64 (2.1.0-2.1ubuntu0.1, 2.1.2-1.1+deb9u2build0.1), poppler-utils:amd64 (0.41.0-0ubuntu1.7, 0.41.0-0ubuntu1.8), libpoppler-qt4-4:amd64 (0.41.0-0ubuntu1.7, 0.41.0-0ubuntu1.8), libpoppler-qt5-1:amd64 (0.41.0-0ubuntu1.7, 0.41.0-0ubuntu1.8), libx11-6:amd64 (2:1.6.3-1ubuntu2, 2:1.6.3-1ubuntu2.1), libx11-6:i386 (2:1.6.3-1ubuntu2, 2:1.6.3-1ubuntu2.1), libx11-data:amd64 (2:1.6.3-1ubuntu2, 2:1.6.3-1ubuntu2.1), libpoppler-glib8:amd64 (0.41.0-0ubuntu1.7, 0.41.0-0ubuntu1.8), libpoppler58:amd64 (0.41.0-0ubuntu1.7, 0.41.0-0ubuntu1.8), libx11-xcb1:amd64 (2:1.6.3-1ubuntu2, 2:1.6.3-1ubuntu2.1), libx11-xcb1:i386 (2:1.6.3-1ubuntu2, 2:1.6.3-1ubuntu2.1)
ErrorMessage: subprocess installed post-installation script returned error exit status 1
InstallationDate: Installed on 2015-01-26 (1316 days ago)
InstallationMedia: Ubuntu 14.04.1 LTS "Trusty Tahr" - Release amd64 (20140722.2)
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: ['glance', 'cinder', 'mysql', 'ib_logfile0', 'nova', 'auto.cnf', 'sys', 'quantum', 'ib_logfile1', 'keystone', 'ib_buffer_pool', 'debian-5.7.flag', 'debian-5.5.flag', 'ibdata1', 'mysql_upgrade_info', 'performance_schema']
ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-4.4.0-134-generic.efi.signed root=UUID=95dfcf49-2b54-4493-81b5-3ffa6cdcfa8b ro quiet splash vt.handoff=7
RelatedPackageVersions:
 dpkg 1.18.4ubuntu1.4
 apt 1.2.26
SourcePackage: mysql-5.7
Title: package mysql-server-5.7 5.7.23-0ubuntu0.16.04.1 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1
UpgradeStatus: Upgraded to xenial on 2017-08-15 (384 days ago)
modified.conffile..etc.init.mysql.conf: [modified]
mtime.conffile..etc.init.mysql.conf: 2018-06-01T15:02:06.231633
upstart.mysql.override: manual

[Andreas Hasenack (ahasenack)]

Thanks for filing this bug in Ubuntu.

It looks like mysql was shutdown when the upgrade script kicked in:
Setting up mysql-server-5.7 (5.7.23-0ubuntu0.16.04.1) ...
insserv: warning: script 'S03cinder-setup-backing-file' missing LSB tags and overrides
insserv: warning: current start runlevel(s) (empty) of script `mysql' overrides LSB defaults (2 3 4 5).
insserv: warning: current stop runlevel(s) (0 1 2 3 4 5 6) of script `mysql' overrides LSB defaults (0 1 6).
insserv: warning: script 'cinder-setup-backing-file' missing LSB tags and overrides
mysql_upgrade: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) while connecting to the MySQL server
Upgrade process encountered error and will not continue.
mysql_upgrade failed with exit status 11
dpkg: error processing package mysql-server-5.7 (--configure):
 subprocess installed post-installation script returned error exit status 1

The mysql logs just show a graceful shutdown:
...
2018-09-03T15:34:44.986625Z 0 [Note] Shutting down plugin 'binlog'
2018-09-03T15:34:44.986799Z 0 [Note] mysqld: Shutdown complete

There are also some apparmor denied messages:
[ 128.032366] audit: type=1400 audit(1535988878.713:40): apparmor="STATUS" operation="profile_replace" profile="unconfined" name="/usr/sbin/mysqld" pid=3975 comm="apparmor_parser"
[ 129.265245] audit: type=1400 audit(1535988879.945:41): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/3993/status" pid=3993 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
[ 129.265269] audit: type=1400 audit(1535988879.945:42): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=3993 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
[ 129.265298] audit: type=1400 audit(1535988879.945:43): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/3993/status" pid=3993 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
[ 129.591787] audit: type=1400 audit(1535988880.273:44): apparmor="STATUS" operation="profile_replace" profile="unconfined" name="/usr/sbin/mysqld" pid=4007 comm="apparmor_parser"
[ 131.337656] audit: type=1400 audit(1535988882.017:45): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/4086/status" pid=4086 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
[ 131.337684] audit: type=1400 audit(1535988882.021:46): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=4086 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
[ 131.337711] audit: type=1400 audit(1535988882.021:47): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/4086/status" pid=4086 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0

Could you please try the following:

sudo systemctl restart mysql
sudo systemctl status mysql

And then:
sudo apt update
sudo apt -f install

And keep an eye in the output of "dmesg -w" while doing that, to see if new apparmor DENIED messages appear.

Thanks!

[Launchpad Janitor (janitor)]

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