[Bug 526874] Re: MySQL Server 5.0 update crash

[Gary Krell]

Could you please provide the following information:

 * content of /var/log/daemon.log related to mysql processes:

    /var/log/daemon.log

Feb 26 10:49:46 rambler ntpd[4963]: kernel time sync status change 0001
Feb 26 11:40:58 rambler ntpd[4963]: kernel time sync status change 4001
Feb 26 13:23:24 rambler ntpd[4963]: kernel time sync status change 0001
Feb 26 14:48:48 rambler ntpd[4963]: kernel time sync status change 4001
Feb 26 15:05:53 rambler ntpd[4963]: kernel time sync status change 0001
Feb 26 15:40:02 rambler ntpd[4963]: kernel time sync status change 4001
Feb 26 15:57:08 rambler ntpd[4963]: kernel time sync status change 0001
Feb 26 16:31:17 rambler ntpd[4963]: kernel time sync status change 4001
Feb 26 16:48:22 rambler ntpd[4963]: kernel time sync status change 0001
Feb 26 17:39:36 rambler ntpd[4963]: kernel time sync status change 4001
Feb 26 18:30:08 rambler x-session-manager[16544]: WARNING: Unable to find provider 'gnome-wm' of required component 'windowmanager' 
Feb 26 18:30:19 rambler x-session-manager[16544]: WARNING: Application 'libcanberra-login-sound.desktop' failed to register before timeout 
Feb 26 18:30:19 rambler NetworkManager: <info>  Unmanaged Device found; state CONNECTED forced. (see http://bugs.launchpad.net/bugs/191889) 
Feb 26 18:47:56 rambler ntpd[4963]: kernel time sync status change 0001
Feb 26 18:56:55 rambler acpid: client 5718[0:0] has disconnected 
Feb 26 18:56:55 rambler acpid: client connected from 17940[0:0] 
Feb 26 18:56:57 rambler gdmgreeter[17953]: Gtk-WARNING: Unable to locate theme engine in module_path: "ubuntulooks", 
Feb 26 19:56:12 rambler ntpd[4963]: kernel time sync status change 4001
Feb 26 20:13:16 rambler ntpd[4963]: no servers reachable
Feb 26 21:04:32 rambler ntpd[4963]: synchronized to 192.168.1.2, stratum 2
Feb 26 23:04:07 rambler ntpd[4963]: kernel time sync status change 0001
Feb 26 23:38:17 rambler ntpd[4963]: kernel time sync status change 4001
Feb 26 23:55:21 rambler ntpd[4963]: kernel time sync status change 0001
Feb 27 01:20:42 rambler ntpd[4963]: kernel time sync status change 4001
Feb 27 01:37:45 rambler ntpd[4963]: kernel time sync status change 0001
Feb 27 04:45:33 rambler ntpd[4963]: kernel time sync status change 4001
Feb 27 05:02:36 rambler ntpd[4963]: kernel time sync status change 0001


 * apparmor audit messages related to mysqld. The output of the command:

   egrep 'audit\(|apparmor|selinux|security' /var/log/kern.log

gary at rambler:~$ egrep 'audit\(|apparmor|selinux|security' /var/log/kern.log
gary at rambler:~$


 * mysqld apparmor profile:

    /etc/apparmor.d/usr.sbin.mysqld

# 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>

  capability dac_override,
  capability setgid,
  capability setuid,

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

  /etc/mysql/*.pem r,
  /etc/mysql/conf.d/ r,
  /etc/mysql/conf.d/* r,
  /etc/mysql/my.cnf r,
  /usr/sbin/mysqld mr,
  /usr/share/mysql/** r,
  /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,
}


 * list of mysqld apparmor profiles:

    ls -l /etc/apparmor.d/usr.sbin.mysqld*

gary at rambler:~$ ls -l /etc/apparmor.d/usr.sbin.mysqld*
-rw-r--r-- 1 root root 661 2008-09-19 08:21 /etc/apparmor.d/usr.sbin.mysqld

 * mysql configuration stripped of private information (such as
password):

    /etc/mysql/my.cnf

 * extra mysql configuration from the conf.d directory:

    /etc/mysql/conf.d/

 * directory listing of mysql datadir (by default /var/lib/mysql):

    ls -l /var/lib/mysql

gary at rambler:~$ ls -l /var/lib/mysql
total 94332
-rw-r--r-- 1 root  root         0 2009-02-12 20:52 debian-5.0.flag
-rw-rw---- 1 mysql mysql 85983232 2010-03-02 08:45 ibdata1
-rw-rw---- 1 mysql mysql  5242880 2010-03-02 08:45 ib_logfile0
-rw-rw---- 1 mysql mysql  5242880 2010-03-02 08:45 ib_logfile1
drwxr-xr-x 2 mysql root      4096 2009-04-29 15:12 mysql
-rw------- 1 root  root         6 2009-02-12 21:00 mysql_upgrade_info
drwx------ 2 mysql mysql     4096 2009-06-24 15:12 orderentry


** Attachment added: "my.cnf"
   http://launchpadlibrarian.net/39961707/my.cnf

-- 
MySQL Server 5.0 update crash
https://bugs.launchpad.net/bugs/526874
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.