Hi all; I have a Mysql 3.2.58 server running on Solaris 8 (the latest 3.2 version downloaded from Mysql.com). The system is a Ultra-250 server with multiple CPUs and 2G RAM. There are many databases but they're not large and the load on the system is not high at all. We're using this older version because we developed the database with the 3.2.x release, years ago, and don't have the manpower to check to see if the newer version will work or fix issues we might run into--although we may have to find a way.
This version worked without problems for over a year. But, for the last 4-6 weeks we've seen a problem once every 8-10 days where the server hangs and will not come back. Attempts to attach "normally" hang; current operations hang; etc. Using processlist shows some processes which have existed for a long time; that may or may not be correct, I'm not sure. Almost all our queries are coming in through the Perl DBI/DBD interface. When I try to use mysqladmin kill they don't die; they do go to a state of "killed" though. When I try to myqladmin flush-tables, that hangs. Flush-logs works but there is nothing interesting in the logs. When I try to run mysqld stop, the server process doesn't stop, although most of the hung requests When I run strace on the PID, I get this: lwp_sema_wait(0x1bfe50 then it hangs until I ^C. I have to kill -9 the server PID to bring it down. Then I check my tables but so far (cross fingers) they've all been fine except they are not shut properly, so I fix that with myisamchk. Since I have not changed anything I suspect that the IS folks have installed some new patch on the Solaris system which is causing this problem to appear, but I have no proof of that. Does anyone have any advice or information for me: places to look, things to do, etc. etc.? While so far we haven't lost any data this is a problem since it seems like it will continue to happen. -- ------------------------------------------------------------------------------- Paul D. Smith <[EMAIL PROTECTED]> HASMAT--HA Software Mthds & Tools "Please remain calm...I may be mad, but I am a professional." --Mad Scientist ------------------------------------------------------------------------------- These are my opinions---Nortel Networks takes no responsibility for them. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]