RE: dbcp pool freezing

2009-02-04 Thread Caldarale, Charles R
> From: news [mailto:n...@ger.gmane.org] On Behalf Of Eric B. > Subject: Re: dbcp pool freezing > Has there ever been any thought to doing abandoned > connection tracking as a background thread, or was > the current implementation decided upon to save on > resources? Don

Re: dbcp pool freezing

2009-02-04 Thread Eric B.
"Christopher Schultz" wrote in message news:4989df6b.3030...@christopherschultz.net... > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Eric, > > Eric B. wrote: >> I'm happy to test out an validate that theory, but based on what I've >> seen >> so far, this isn't the case at all. > > Try de

Re: dbcp pool freezing

2009-02-04 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Eric, Eric B. wrote: > I'm happy to test out an validate that theory, but based on what I've seen > so far, this isn't the case at all. Try deploying nothing in your application but the following JSP. Browse to it, and intentionally leak a connectio

Re: dbcp pool freezing

2009-02-04 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Eric, Eric B. wrote: > I've been trying to figure out how to create a Wrapper of SqlConnection, but > am having trouble getting this to work. Would you mind giving me a couple > of pointers where to start? See the thread from last week with the su

RE: Re: dbcp pool freezing

2009-02-03 Thread Propes, Barry L
were still left open, and that can get ugly after a while, believe me. -Original Message- From: news [mailto:n...@ger.gmane.org] On Behalf Of Eric B. Sent: Tuesday, February 03, 2009 2:05 PM To: users@tomcat.apache.org Subject: Re: dbcp pool freezing > "Caldarale, Charles R"

Re: dbcp pool freezing

2009-02-03 Thread Eric B.
"Philippe Martinou" wrote in message news:49887d2f.3000...@sparkom.com... >Hi, > > The first thing to be checked is probably your application. If some method > does not properly close an SQL connection, you will have a leak that will > ultimately lead to this resource exhaustion. > To bette

Re: dbcp pool freezing

2009-02-03 Thread Eric B.
> "Caldarale, Charles R" wrote in message > news:0aae5ab84b013e45a7b61cb66943c17215b604a...@usea-exch7.na.uis.unisys.com... > > From: news [mailto:n...@ger.gmane.org] On Behalf Of Eric B. > > Subject: Re: dbcp pool freezing > > > > Then the question b

Re: dbcp pool freezing

2009-02-03 Thread Kees Jan Koster
Dear Eric, and see that all my threads are in the WAITING state from org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject (GenericObjectPool.java:810) I don't believe I have any connection leaks in my code Belief is not a substitute for evidence... Your webapp is clearly not re

RE: dbcp pool freezing

2009-02-03 Thread Caldarale, Charles R
> From: news [mailto:n...@ger.gmane.org] On Behalf Of Eric B. > Subject: Re: dbcp pool freezing > > Then the question becomes why aren't they being returned at > all? My timeout is 20secs; I would expect, if the Abandon > tracking was working properly for me, that the

Re: dbcp pool freezing

2009-02-03 Thread Eric B.
> "Caldarale, Charles R" wrote in message > news:0aae5ab84b013e45a7b61cb66943c17215b600c...@usea-exch7.na.uis.unisys.com... > > From: news [mailto:n...@ger.gmane.org] On Behalf Of Eric B. > > Subject: dbcp pool freezing > > > > and see that all

RE: dbcp pool freezing

2009-02-03 Thread Caldarale, Charles R
> From: news [mailto:n...@ger.gmane.org] On Behalf Of Eric B. > Subject: dbcp pool freezing > > and see that all my threads are in the WAITING state from > org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject > (GenericObjectPool.java:810) > > I don't believ

Re: dbcp pool freezing

2009-02-03 Thread David Boreham
Check that you don't have garbage collection problems. A heavy GC load will show up with these symptoms you are seeing (because GC stalls threads as they acquire or release locks). - To unsubscribe, e-mail: users-unsubscr...@to

Re: dbcp pool freezing

2009-02-03 Thread Eric B.
"Philippe Martinou" wrote in message news:49887d2f.3000...@sparkom.com... >Hi, > > The first thing to be checked is probably your application. If some method > does not properly close an SQL connection, you will have a leak that will > ultimately lead to this resource exhaustion. > To bett

Re: dbcp pool freezing

2009-02-03 Thread Philippe Martinou
that counts connection creation/close. Best regards /Philippe Eric B. a écrit : Hi, I'm having some trouble with my dbcp pool freezing up when running a load, and am having trouble figuring out why. I have enabled JMX on the server and connected via jConsole, and see that all my threads a

dbcp pool freezing

2009-02-03 Thread Eric B.
Hi, I'm having some trouble with my dbcp pool freezing up when running a load, and am having trouble figuring out why. I have enabled JMX on the server and connected via jConsole, and see that all my threads are in the WAITING state