Ubuntu
mysql-5.5 package

mysql fails to start

Bug #978995 reported by Martin Vysny on 2012-04-11

This bug report is a duplicate of: Bug #986892: mysql-server postrm breaks apparmor profile for later versions on purge. Edit Remove

This bug affects 13 people

Affects		Status	Importance	Assigned to	Milestone
	mysql-5.5 (Ubuntu)	Confirmed	Undecided	Unassigned

Bug Description

mysql no longer starts (I cannot confirm when this started to occur). sudo /etc/init.d/mysql start prints only:
start: Job failed to start
I have newest precise Linux rei 3.2.0-23-generic-pae #36-Ubuntu SMP Tue Apr 10 22:19:09 UTC 2012 i686 i686 i386 GNU/Linux, mysql version is 5.5.22-0ubuntu1

Revision history for this message

Martin Vysny (vyzivus) wrote on 2012-04-11:

There is nothing in /var/log/mysql/
/var/log/upstart/mysql.log:

AppArmor parser error for /etc/apparmor.d/usr.sbin.mysqld in /etc/apparmor.d/usr.sbin.mysqld at line 44: Could not open 'local/usr.sbin.mysqld'
AppArmor parser error for /etc/apparmor.d/usr.sbin.mysqld in /etc/apparmor.d/usr.sbin.mysqld at line 44: Could not open 'local/usr.sbin.mysqld'
AppArmor parser error for /etc/apparmor.d/usr.sbin.mysqld in /etc/apparmor.d/usr.sbin.mysqld at line 44: Could not open 'local/usr.sbin.mysqld'
AppArmor parser error for /etc/apparmor.d/usr.sbin.mysqld in /etc/apparmor.d/usr.sbin.mysqld at line 44: Could not open 'local/usr.sbin.mysqld'
AppArmor parser error for /etc/apparmor.d/usr.sbin.mysqld in /etc/apparmor.d/usr.sbin.mysqld at line 44: Could not open 'local/usr.sbin.mysqld'
AppArmor parser error for /etc/apparmor.d/usr.sbin.mysqld in /etc/apparmor.d/usr.sbin.mysqld at line 44: Could not open 'local/usr.sbin.mysqld'
AppArmor parser error for /etc/apparmor.d/usr.sbin.mysqld in /etc/apparmor.d/usr.sbin.mysqld at line 44: Could not open 'local/usr.sbin.mysqld'
AppArmor parser error for /etc/apparmor.d/usr.sbin.mysqld in /etc/apparmor.d/usr.sbin.mysqld at line 44: Could not open 'local/usr.sbin.mysqld'

Revision history for this message

Martin Vysny (vyzivus) wrote on 2012-04-11:

my /etc/apparmor.d/usr.sbin.mysqld file:

# vim:syntax=apparmor
# Last Modified: Tue Jun 19 17:37:30 2007
#include <tunables/global>

/usr/sbin/mysqld {
  #include <abstractions/base>
  #include <abstractions/nameservice>
  #include <abstractions/user-tmp>
  #include <abstractions/mysql>
  #include <abstractions/winbind>

  capability dac_override,
  capability sys_resource,
  capability setgid,
  capability setuid,

network tcp,

/etc/hosts.allow r,
/etc/hosts.deny r,

  /etc/mysql/*.pem r,
  /etc/mysql/conf.d/ r,
  /etc/mysql/conf.d/* r,
  /etc/mysql/*.cnf r,
  /usr/lib/mysql/plugin/ r,
  /usr/lib/mysql/plugin/*.so* mr,
  /usr/sbin/mysqld mr,
  /usr/share/mysql/** r,
  /var/log/mysql.log rw,
  /var/log/mysql.err rw,
  /var/lib/mysql/ r,
  /var/lib/mysql/** rwk,
  /var/log/mysql/ r,
  /var/log/mysql/* rw,
  /var/run/mysqld/mysqld.pid w,
  /var/run/mysqld/mysqld.sock w,
  /run/mysqld/mysqld.pid w,
  /run/mysqld/mysqld.sock w,

/sys/devices/system/cpu/ r,

# Site-specific additions and overrides. See local/README for details.
#include <local/usr.sbin.mysqld>
}

Revision history for this message

Martin Vysny (vyzivus) wrote on 2012-04-11:

After deleting the problematic line #include <local/usr.sbin.mysqld>, mysql now starts.

Revision history for this message

Launchpad Janitor (janitor) wrote on 2012-04-17:

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

Changed in mysql-5.5 (Ubuntu):
status:	New → Confirmed

Revision history for this message

e-frog (e-frog) wrote on 2012-05-01:

After upgrading from oneiric to precise mysql was initially working. I then purged the 'old' mysql-5.1 packages and suddenly mysql could not be started anymore. It seems 'purge' removes the file /etc/apparmor.d/local/usr.sbin.mysqld which is still needed for mysql-5.5 however.