Public bug reported: Mysql is left in an unfinished upgrade state after some upgrade and it's been like that for some time. Also, there are this messages spamming journalctl:
.... Apr 15 10:03:35 maldita systemd[1]: Starting MySQL Community Server... Apr 15 10:03:37 maldita systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE Apr 15 10:04:05 maldita systemd[1]: Failed to start MySQL Community Server. Apr 15 10:04:05 maldita systemd[1]: mysql.service: Unit entered failed state. Apr 15 10:04:05 maldita systemd[1]: mysql.service: Failed with result 'exit-code'. Apr 15 10:04:05 maldita systemd[1]: mysql.service: Service hold-off time over, scheduling restart. Apr 15 10:04:05 maldita systemd[1]: Stopped MySQL Community Server. Apr 15 10:04:05 maldita systemd[1]: Starting MySQL Community Server... Apr 15 10:04:07 maldita systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE Apr 15 10:04:36 maldita systemd[1]: Failed to start MySQL Community Server. Apr 15 10:04:36 maldita systemd[1]: mysql.service: Unit entered failed state. Apr 15 10:04:36 maldita systemd[1]: mysql.service: Failed with result 'exit-code'. Apr 15 10:04:36 maldita systemd[1]: mysql.service: Service hold-off time over, scheduling restart. Apr 15 10:04:36 maldita systemd[1]: Stopped MySQL Community Server. Apr 15 10:04:36 maldita systemd[1]: Starting MySQL Community Server... Apr 15 10:04:38 maldita systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE Apr 15 10:05:06 maldita systemd[1]: Failed to start MySQL Community Server. Apr 15 10:05:06 maldita systemd[1]: mysql.service: Unit entered failed state. Apr 15 10:05:06 maldita systemd[1]: mysql.service: Failed with result 'exit-code'. Apr 15 10:05:06 maldita systemd[1]: mysql.service: Service hold-off time over, scheduling restart. Apr 15 10:05:06 maldita systemd[1]: Stopped MySQL Community Server. ..... ProblemType: Package DistroRelease: Ubuntu 16.04 Package: mysql-server-5.7 5.7.11-0ubuntu6 ProcVersionSignature: Ubuntu 4.4.0-18.34-generic 4.4.6 Uname: Linux 4.4.0-18-generic x86_64 ApportVersion: 2.20.1-0ubuntu2 Architecture: amd64 Date: Fri Apr 15 09:56:38 2016 ErrorMessage: subprocess installed post-installation script returned error exit status 1 InstallationDate: Installed on 2012-11-25 (1236 days ago) InstallationMedia: Ubuntu 12.10 "Quantal Quetzal" - Alpha amd64 (20120627) 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.5.flag', 'spidey', 'mysql', 'ib_buffer_pool', 'mysql_upgrade_info', 'listedplan', 'debian-5.7.flag', 'ib_logfile0', 'performance_schema', 'debian-5.6.flag', 'test', 'auto.cnf', 'maldita-slow.log', 'socialads', 'ib_logfile1', 'ibdata1', 'phpmyadmin'] ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-4.4.0-18-generic root=UUID=c5e8db97-be79-41c7-a2d8-be5fa7b409a8 ro quiet splash vt.handoff=7 RelatedPackageVersions: dpkg 1.18.4ubuntu1 apt 1.2.10ubuntu1 SourcePackage: mysql-5.7 Title: package mysql-server-5.7 5.7.11-0ubuntu6 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1 UpgradeStatus: Upgraded to xenial on 2015-03-14 (397 days ago) ** Affects: mysql-5.7 (Ubuntu) Importance: Undecided Status: New ** Tags: amd64 apport-package xenial -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1570673 Title: package mysql-server-5.7 5.7.11-0ubuntu6 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1570673/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs