RE: FW: mysqld in hung mode

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



-----Original Message-----
From: Daniel da Veiga [mailto:[email protected]] 
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 <[email protected]> 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.

-- 
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:
http://lists.mysql.com/[email protected]


-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]