Between Feb 8th and last night we have experienced 4 lockups by the mysql
server. Once locked up the safe_mysql and 1 mysqld process are still
running but you can not connect to the server.
A ps shows this:
USER PID %CPU %MEM SZ RSS TT S START TIME COMMAND
<user> 17001 0.0 0.2 868 240 ? S Mar 09 0:00 /bin/sh
<user> 17012 0.0 9.31925617712 ? S Mar 09 45:12
Each of the lockups occurred at about 1:20am after at least a week of
mysql uptime. Nothing is croned for that time. It also happened on a
different weekday each time. Other server information did not show anything
out of the ordinary at this time.
3 of the 4 lockups were while running the prebuilt 3.21.33b Solaris
2.6 binary. The 4th was a mysql 3.22.19b I build w/ --with-debug and
-ggdb. A gcore followed by gdb didn't show anything useful. The machine is a
If any more information is needed please contact me.
Thanks in advanced for any help with this.
Biomedical Computing Group
University of Wisconsin-Madison
Phone: (608) 265-3712