Possible Threading problem with -CURRENT / MySQL?

[Julian Elischer]

On Mon, 14 Jun 2004, Lasse Laursen wrote:

> The server runs fine until a single thread/query suddenly locks up the
> entire MySQL daemon. After that all queries are just queued and a restart of
> the daemon is needed to unlock the system. The system itself is stable
> enough as far as I can see. 'top' reports a lot of locks (*Giant) so I
> assume that it's some weird problem with the threading? We used to use
> FreeBSD on non-SMP machines without any problems.
> 
> I have tried with linux threads as well but the same problem occurs.
> 
> Have anyone experienced any similar problems and found a solution to this
> rather weird problem?

When this happens you need to examine the state of each thread.
I have not seen teh result of a 'ps alxH' when this happens..

Also you should try 'ktrace' the process for a while when stopped as it
might be retrying something , which may show up.






julian