[Nss-mysql-devel] [ 101725 ] MySQL connections hanging?

[nobody]

Support Request #101725, was updated on 2003-Jan-10 23:42
You can respond by visiting: 
http://savannah.nongnu.org/support/?func=detailsupport&support_id=101725&group_id=443

Category: None
Status: Open
Priority: 5
Summary: MySQL connections hanging?

By: kveton
Date: 2003-Jan-31 19:41
Logged In: YES 
user_id=14541
Browser: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.3a) Gecko/20021207 
Phoenix/0.5

Sure, it probably works great for small environments. 
However, if you have a process that is doing lots of chown's
nscd doesn't seem to realize it has connections open so it
just opens more and more until the SQL server runs out of
threads.

I'll recompile with debug and test it on one of our servers
and get you the output.  I just sent you the patch for the
select fixes.

----------------------------------------------------------------------

By: gmorin
Date: 2003-Jan-31 16:11
Logged In: YES 
user_id=230
Browser: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.2.1) Gecko/20021226 
Debian/1.2.1-9

I've been trying to reproduce the problem. Nscd seems to
work just fine on my box.

If you could try to find out which processes holds the open
connection that would be very helpful. Normally it should be
nscd. If so, could you send me the excerpts of your auth log
(you'll need a module compiled with debug mode) which are
related to nscd threads ?

TIA.

Guillaume.

----------------------------------------------------------------------
You can respond by visiting: 
http://savannah.nongnu.org/support/?func=detailsupport&support_id=101725&group_id=443