failed to install mysql5.6

[Ajay Arjunan]

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

ProblemType: Package
DistroRelease: Ubuntu 14.04
Package: mysql-server-5.6 5.6.33-0ubuntu0.14.04.1
ProcVersionSignature: Ubuntu 3.13.0-93.140-generic 3.13.11-ckt39
Uname: Linux 3.13.0-93-generic x86_64
ApportVersion: 2.14.1-0ubuntu3.21
Architecture: amd64
Date: Fri Sep 23 12:25:57 2016
DuplicateSignature: package:mysql-server-5.6:5.6.33-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 2016-05-12 (134 days ago)
InstallationMedia: Ubuntu 14.04 LTS "Trusty Tahr" - Release amd64 (20140417)
RelatedPackageVersions:
 dpkg 1.17.5ubuntu5.7
 apt 1.0.1ubuntu2.14
SourcePackage: mysql-5.6
Title: package mysql-server-5.6 5.6.33-0ubuntu0.14.04.1 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1
UpgradeStatus: No upgrade log present (probably fresh install)

[Christian Ehrhardt  (paelzer)]

In the terminal log it only appears to be starting to then being shut down.
But the dmesg holds more hints at the root cause.

There I wonder about:
[ 17.758717] init: Failed to spawn php7.0-fpm main process: unable to execute: No such file or directory
[ 17.988212] init: Failed to spawn mysql main process: unable to execute: No such file or directory

Then further I see several apparmor denies:
[ 7844.489836] type=1400 audit(1474613743.811:67): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/etc/mysql/my.cnf.fallback" pid=29019 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
[ 7850.111433] type=1400 audit(1474613749.431:68): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/etc/mysql/my.cnf.fallback" pid=29061 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
[ 7852.177221] type=1400 audit(1474613751.499:69): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/etc/mysql/my.cnf.fallback" pid=29086 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
[ 7854.201312] type=1400 audit(1474613753.523:70): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/etc/mysql/my.cnf.fallback" pid=29111 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
[ 7856.265292] type=1400 audit(1474613755.587:71): apparmor="STATUS" operation="profile_replace" profile="unconfined" name="/usr/sbin/mysqld" pid=29171 comm="apparmor_parser"
[ 7856.268621] type=1400 audit(1474613755.591:72): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/etc/mysql/my.cnf.fallback" pid=29173 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
[ 7856.273266] type=1400 audit(1474613755.595:73): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/etc/mysql/my.cnf.fallback" pid=29182 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
[ 7856.449151] init: mysql main process (29182) terminated with status 1
[ 7856.449158] init: mysql main process ended, respawning

Only to further down giving up by:
[ 7858.506585] init: mysql respawning too fast, stopped

I wonder if your installation has any custom apparmor or other configuration changes to mysql that could affect this?

I have seen reports that this issue could be avoided by:
apt-get install mysql-community-client
before upgrading the server. I'd wonder but if you could try and verify/falsify that for your case that would be great.

For the sake of checking if that is bug 1421303 showing up again in some way please also share the output of "sudo aa-status"

[Ajay Arjunan (ajayarjunan)]

I installed 5.5 version and then removed it and installed 5.6 version and found it working

Output of "sudo aa-status"

apparmor module is loaded.
21 profiles are loaded.
21 profiles are in enforce mode.
   /sbin/dhclient
   /usr/bin/evince
   /usr/bin/evince-previewer
   /usr/bin/evince-previewer//sanitized_helper
   /usr/bin/evince-thumbnailer
   /usr/bin/evince-thumbnailer//sanitized_helper
   /usr/bin/evince//sanitized_helper
   /usr/lib/NetworkManager/nm-dhcp-client.action
   /usr/lib/connman/scripts/dhclient-script
   /usr/lib/cups/backend/cups-pdf
   /usr/lib/lightdm/lightdm-guest-session
   /usr/lib/lightdm/lightdm-guest-session//chromium
   /usr/lib/telepathy/mission-control-5
   /usr/lib/telepathy/telepathy-*
   /usr/lib/telepathy/telepathy-*//pxgsettings
   /usr/lib/telepathy/telepathy-*//sanitized_helper
   /usr/lib/telepathy/telepathy-ofono
   /usr/sbin/cups-browsed
   /usr/sbin/cupsd
   /usr/sbin/mysqld
   /usr/sbin/tcpdump
0 profiles are in complain mode.
6 processes have profiles defined.
6 processes are in enforce mode.
   /usr/bin/evince (26287)
   /usr/bin/evince (26688)
   /usr/lib/telepathy/mission-control-5 (2809)
   /usr/sbin/cups-browsed (1038)
   /usr/sbin/cupsd (2786)
   /usr/sbin/mysqld (1082)
0 processes are in complain mode.
0 processes are unconfined but have a profile defined.

[Launchpad Janitor (janitor)]

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