package mysql-server-5.5 5.5.55-0ubuntu0.14.04.1 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1

[mike figley]

This error surfaced during a normal package update...

ProblemType: Package
DistroRelease: Ubuntu 14.04
Package: mysql-server-5.5 5.5.55-0ubuntu0.14.04.1
ProcVersionSignature: Ubuntu 3.13.0-117.164-generic 3.13.11-ckt39
Uname: Linux 3.13.0-117-generic x86_64
NonfreeKernelModules: fglrx
ApportVersion: 2.14.1-0ubuntu3.23
Architecture: amd64
Date: Thu Apr 27 13:09:39 2017
DuplicateSignature: package:mysql-server-5.5:5.5.55-0ubuntu0.14.04.1:subprocess installed post-installation script returned error exit status 1
ErrorMessage: subprocess installed post-installation script returned error exit status 1
InstallationDate: Installed on 2014-12-21 (858 days ago)
InstallationMedia: Ubuntu 14.04.1 LTS "Trusty Tahr" - Release amd64 (20140722.2)
Logs.var.log.daemon.log:

MySQLConf.etc.mysql.conf.d..keepme:
MySQLConf.etc.mysql.conf.d.mysqld.safe.syslog.cnf:
 [mysqld_safe]
 syslog
MySQLVarLibDirListing: ['ospos', 'mysql_upgrade_info', 'ib_logfile0', 'ibdata1', 'ib_logfile1', 'performance_schema', 'db_pull', 'mysql', 'debian-5.5.flag', 'joomla', 'montanac_joom899']
ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-3.13.0-117-generic root=UUID=7fa61210-bfec-4f29-94a7-184912e1b961 ro noquiet nosplash enable_mtrr_cleanup mtrr_spare_reg_nr=1 mtrr_gran_size=64M mtrr_chunk_size=64M
RelatedPackageVersions:
 dpkg 1.17.5ubuntu5.7
 apt 1.0.1ubuntu2.17
SourcePackage: mysql-5.5
Title: package mysql-server-5.5 5.5.55-0ubuntu0.14.04.1 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1
UpgradeStatus: Upgraded to trusty on 2016-08-31 (239 days ago)
modified.conffile..etc.init.d.mysql: [modified]
mtime.conffile..etc.init.d.mysql: 2017-03-09T21:53:19.646544

[Launchpad Janitor (janitor)]

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

[Joshua Powers (powersj)]

From log:

ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1

[Joshua Powers (powersj)]

Thank you for taking the time to file a bug report.

The only error I quickly found was the one pasted above from the
mysql error log. I am not sure what would have caused the line to
apparently break off.

Since there is not enough information in your report to begin triage
or to differentiate between a local configuration problem and a bug in
Ubuntu, I am marking this bug as "Incomplete". We would be grateful if
you would: 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".

For local configuration issues, you can find assistance here:
http://www.ubuntu.com/support/community

[Launchpad Janitor (janitor)]

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