Re: Server hanging once a week (Solaris 8)
Understandable. The state, command and info values from `show processlist` could shed some light on what is occurring. Paul Smith wrote: %% Victor Pendleton <[EMAIL PROTECTED]> writes: vp> What state are the queries in while they are hung? What command or vp> SQL are they executing? Unfortunately I lost the output of the processlist command. Whenever the server hangs it's always a crazy race to get it back up again. Next time it happens I'll be sure to stow the list somewhere before restarting the server. However, IIRC there were a mix of queries: some were Wait, some were Sleep. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Server hanging once a week (Solaris 8)
%% Victor Pendleton <[EMAIL PROTECTED]> writes: vp> What state are the queries in while they are hung? What command or vp> SQL are they executing? Unfortunately I lost the output of the processlist command. Whenever the server hangs it's always a crazy race to get it back up again. Next time it happens I'll be sure to stow the list somewhere before restarting the server. However, IIRC there were a mix of queries: some were Wait, some were Sleep. -- --- 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]
Re: Server hanging once a week (Solaris 8)
What state are the queries in while they are hung? What command or SQL are they executing? Paul Smith wrote: %% Victor Pendleton <[EMAIL PROTECTED]> writes: vp> When the database is in a `hung` state, is the file system where vp> the MYI, MYD and frm files accessible? Definitely. I can log in, see the files, run the mysqladmin commands, etc. The databases live on the local disk, not a remote server (I do backups every night to a remote server). Other operations and services on that server continue to work. Thanks for the response! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Server hanging once a week (Solaris 8)
%% Victor Pendleton <[EMAIL PROTECTED]> writes: vp> When the database is in a `hung` state, is the file system where vp> the MYI, MYD and frm files accessible? Definitely. I can log in, see the files, run the mysqladmin commands, etc. The databases live on the local disk, not a remote server (I do backups every night to a remote server). Other operations and services on that server continue to work. Thanks for the response! -- --- 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]
Re: Server hanging once a week (Solaris 8)
When the database is in a `hung` state, is the file system where the MYI, MYD and frm files accessible? Paul Smith wrote: %% Gleb Paharenko <[EMAIL PROTECTED]> writes: gp> Very often similar symptoms causes various lock problems. Do you gp> use InnoDB? Try log_slow_queries to find hung queries. I'm using MyISAM tables. When I wrote this application InnoDB wasn't even an option :-). I don't think it's hung queries, because even new queries that I know are very fast fail. Heck, I can't even attach to the DB except through the admin interface (mysqladmin). Unless you're saying that the hung queries are using up the processes/threads in the DB so that new queries can't get through? Thanks for the response... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Server hanging once a week (Solaris 8)
%% Gleb Paharenko <[EMAIL PROTECTED]> writes: gp> Very often similar symptoms causes various lock problems. Do you gp> use InnoDB? Try log_slow_queries to find hung queries. I'm using MyISAM tables. When I wrote this application InnoDB wasn't even an option :-). I don't think it's hung queries, because even new queries that I know are very fast fail. Heck, I can't even attach to the DB except through the admin interface (mysqladmin). Unless you're saying that the hung queries are using up the processes/threads in the DB so that new queries can't get through? Thanks for the response... -- --- 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]
Re: Server hanging once a week (Solaris 8)
Hello. Very often similar symptoms causes various lock problems. Do you use InnoDB? Try log_slow_queries to find hung queries. "Paul Smith" <[EMAIL PROTECTED]> wrote: > 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. > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]