[Bug 621509] [NEW] mysqld randomly causes system to not respond to commands

[Luke J Militello]

Public bug reported:

Binary package hint: mysql-server

Once in a great while, my system becomes unresponsive to basic commands.
This includes background commands such as anything run under cron and
even syslog.  I can still ssh to the machine, however any "system level"
commands fail to run, even reboot.  A hard reboot is the only why to
recover.  I have narrowed it down to this process which I cannot even
kill with init or kill -9.

mysql     4589  1.3  0.6 134960 26744 ?        Sl   Aug13 133:16
/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking
--port=3306 --socket=/var/run/mysqld/mysqld.sock

Some of the things that stop running are...

 * Postfix will no longer send email.
 * Nagios logs will not update.
 * Cacti stops polling SNMP queries.
 * Cron jobs stop running.
 * Syslog stops logging.
 * Reboot fails to reboot the machine.
 * Init fails to start/restart/stop any binary.

Due to the nature of this "partial" hang, I cannot supply any further
information in part to the fact syslog stops logging.

I am unsure if this is in fact an SQL issue, but so far all signs point
me there.

My system is a Sun Enterprise 420R running Hardy 8.04.4; 4 UltraSparc II
(BlackBird) CPU's; 4GB of RAM; and kernel version 2.6.24-28.73 (pending
a reload to 2.6.24-28.75 via usn-974-1).  Any help in figuring out what
happens and why it happens so few, far, and in between is greatly
appreciated.

** Affects: mysql-5.1 (Ubuntu)
     Importance: Undecided
         Status: New

-- 
mysqld randomly causes system to not respond to commands
https://bugs.launchpad.net/bugs/621509
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-5.1 in ubuntu.