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

[nobody]

Support Request #101725, was updated on 2003-Jan-11 00: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: gmorin
Date: 2003-Jan-31 20:54
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 have tried with a 3000 users. How many do you got in yours
? I've tried to chown 3000 files. It did work.

Anyway, it should not even matter. nscd should only use its
opened connections in all situations. There might be a race
somewhere.

I've just received the patch and will look at it soon. (BTW,
next time please provide an unified diff, I have a terrible
time parsing context diffs :-)

Guillaume.

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

By: kveton
Date: 2003-Jan-31 20: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.

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