Date: Tue, 15 Jun 2004 16:19:07 -0700 (PDT) From: Julian Elischer <julian@elischer.org> To: Lasse Laursen <laursen@netgroup.dk> Cc: freebsd-threads@freebsd.org Subject: Re: Possible Threading problem with -CURRENT / MySQL? Message-ID: <Pine.BSF.4.21.0406151616520.50415-100000@InterJet.elischer.org> In-Reply-To: <01c301c45239$940781f0$6401a8c0@animal>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.4.21.0406151616520.50415-100000>