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

[Kais El Arfaoui]

I've received this alert after updating GRUB from windows 10.

ProblemType: Package
DistroRelease: Ubuntu 17.04
Package: mysql-server-5.7 5.7.18-0ubuntu0.17.04.1
ProcVersionSignature: Ubuntu 4.10.0-21.23-generic 4.10.11
Uname: Linux 4.10.0-21-generic x86_64
ApportVersion: 2.20.4-0ubuntu4.1
Architecture: amd64
Date: Fri Jun 2 04:39:20 2017
ErrorMessage: subprocess installed post-installation script returned error exit status 1
InstallationDate: Installed on 2016-10-18 (273 days ago)
InstallationMedia: Ubuntu 16.10 "Yakkety Yak" - Release amd64 (20161012.2)
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.mysql.conf.d.mysqld_safe_syslog.cnf:
 [mysqld_safe]
 syslog
MySQLVarLibDirListing: ['ibdata1', 'mysql_upgrade_info', 'zonascon_zonasconti', 'ib_buffer_pool', 'ib_logfile1', 'sys', 'mysql', 'performance_schema', 'auto.cnf', 'ibtmp1', 'debian-5.7.flag', 'phpmyadmin', 'ib_logfile0']
ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-4.10.0-21-generic.efi.signed root=UUID=d5567409-f226-4066-9fd8-149c0fdda411 ro quiet splash vt.handoff=7
RelatedPackageVersions:
 dpkg 1.18.10ubuntu2
 apt 1.4
SourcePackage: mysql-5.7
Title: package mysql-server-5.7 5.7.18-0ubuntu0.17.04.1 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1
UpgradeStatus: Upgraded to zesty on 2017-06-02 (47 days ago)

[Christian Ehrhardt  (paelzer)]

Hi Kais,
Thank you for taking the time to report this bug and helping to make Ubuntu better.

this should have nothing to do with your other OS or grub.
It is "just" an upgrade of the mysql package that fails.

From the log:
Setting up mysql-server-5.7 (5.7.18-0ubuntu0.17.04.1) ...
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.
invoke-rc.d: initscript mysql, action "start" failed.

You'd need to check that on your own as the errors seems to be older.
Your upgrades were on "2017-06-02", but the snippet of the mysql server log that was reported was from today - and that no more contained a startup error.

If you happened to have a broken mysql config that prevented the server to start and fixed it up now, then the upgrade will work now.
Otherwise please get back here with details that is:
1. retry the mysql upgrade
2. after it fails check and report /var/log/mysql/error.log and "systemctl status mysql"

Since it seems likely to me that this is a local configuration problem, rather than a bug in Ubuntu, I'm marking this bug as Incomplete.

If indeed this is a local configuration problem, you can find pointers to get help for this sort of problem here: http://www.ubuntu.com/support/community

Or if you believe that this is really a bug, then you may find it helpful to read "How to report bugs effectively" http://www.chiark.greenend.org.uk/~sgtatham/bugs.html. We'd be grateful if you would then provide a more complete description of the problem, 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.

[Launchpad Janitor (janitor)]

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