Possible Threading problem with -CURRENT / MySQL?
julian at elischer.org
Tue Jun 15 23:19:20 GMT 2004
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.
More information about the freebsd-current