RE: FW: mysqld in hung mode - Ilavajuthy Palanisamy - com.mysql.lists.win32

8 messages in com.mysql.lists.win32RE: FW: mysqld in hung mode

From	Sent On	Attachments
Ilavajuthy Palanisamy	05 Jun 2006 12:48
Ilavajuthy Palanisamy	05 Jun 2006 12:52
Daniel da Veiga	05 Jun 2006 13:29
Ilavajuthy Palanisamy	05 Jun 2006 13:45
Daniel da Veiga	05 Jun 2006 14:03
Ilavajuthy Palanisamy	05 Jun 2006 14:09
Daniel da Veiga	05 Jun 2006 14:37
Shane Bester	06 Jun 2006 01:46

Subject:	RE: FW: mysqld in hung mode
From:	Ilavajuthy Palanisamy (ipal...@consentry.com)
Date:	06/05/2006 02:09:07 PM
List:	com.mysql.lists.win32

The version that we are using is 'Server version 4.1.15-log'.

-----Original Message----- From: Daniel da Veiga [mailto:dani...@gmail.com] Sent: Monday, June 05, 2006 2:04 PM To: MySQL Win32 List Subject: Re: FW: mysqld in hung mode

On 6/5/06, Ilavajuthy Palanisamy <ipal...@consentry.com> wrote:

I have already verified the machine state. I have ample amount of disk space and memory. Looks like all the system resources are in good condition.

Surely if I restart mysql, it will start working fine. But, I need to find out how to recover from this state or what this state is so that I can avoid getting into this state.

Through mysqladmin kill command I have killed all the pending queries (these queries are executed due to mysqldump command and they were stuck up in 'Opening tables' state). After killing all the queries are in Killed state and they are not going away.

Any idea under which circumstances mysql will go into this kind of state?

I've only seen this kind of behavior when a memory corruption occured on my machine, and also once in an old version (<4.1.12), if that's your case, you should upgrade to the latest version of your brand.