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

[Matt Beall]

Upgrading from Ubuntu 14.04 to Ubuntu 16.04

ProblemType: Package
DistroRelease: Ubuntu 16.04
Package: mysql-server-5.7 5.7.27-0ubuntu0.16.04.1
ProcVersionSignature: Ubuntu 3.13.0-71.114-generic 3.13.11-ckt29
Uname: Linux 3.13.0-71-generic x86_64
ApportVersion: 2.20.1-0ubuntu2.21
Architecture: amd64
Date: Sat Nov 9 10:25:09 2019
ErrorMessage: subprocess installed post-installation script returned error exit status 1
InstallationDate: Installed on 2014-04-18 (2031 days ago)
InstallationMedia:

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: ['debian-5.7.flag', 'debian-5.5.flag', 'ib_logfile1', 'ib_logfile0', 'auto.cnf', 'performance_schema', 'ibdata1', 'ib_buffer_pool', 'mysql_upgrade_info', 'mysql']
ProcCmdline: root=LABEL=DOROOT ro
RelatedPackageVersions:
 dpkg 1.18.4ubuntu1.6
 apt 1.2.32
SourcePackage: mysql-5.7
Title: package mysql-server-5.7 5.7.27-0ubuntu0.16.04.1 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1
UpgradeStatus: Upgraded to xenial on 2019-11-09 (0 days ago)
modified.conffile..etc.apparmor.d.usr.sbin.mysqld: [modified]
mtime.conffile..etc.apparmor.d.usr.sbin.mysqld: 2016-10-25T22:27:57.392668

[Rafael David Tinoco (rafaeldtinoco)]

Hello Matt,

The only error message your logs provide is:

invoke-rc.d: release upgrade in progress, error is not fatal
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

And some apparmor errors as well.

Can you confirm if you could restart the service after the upgrade, if it was a configuration problem or there is any other reason why the service wasn't able to start ?

I'm marking this bug as incomplete for now, but feel free to mark it as "new" again if you're able to provide us more information about it.

Thank you very much

Rafael