Re: [Resin-interest] Db Pool freezes waiting on _pool (3.1.3)

2012-07-10 Thread Steven Cassidy
Just to close this out, switching the mysql driver to com.mysql.jdbc.Driver does appear to have fixed the problem. Thanks very much. On 6 July 2012 16:26, Scott Ferguson wrote: > On 07/06/2012 12:45 PM, Steven Cassidy wrote: > > Hi, Thanks for the replies. I don't think there's a leak unless it

Re: [Resin-interest] Db Pool freezes waiting on _pool (3.1.3)

2012-07-06 Thread Scott Ferguson
On 07/06/2012 12:45 PM, Steven Cassidy wrote: > Hi, Thanks for the replies. I don't think there's a leak unless it > manifests itself only very occasionally. The stats now are Active 6, > Idle 133, Created 0.02% (757 / 3.3M), Failed 0, max-connections 256, > idle time 3. The active count is not

Re: [Resin-interest] Db Pool freezes waiting on _pool (3.1.3)

2012-07-06 Thread Steven Cassidy
Hi, Thanks for the replies. I don't think there's a leak unless it manifests itself only very occasionally. The stats now are Active 6, Idle 133, Created 0.02% (757 / 3.3M), Failed 0, max-connections 256, idle time 3. The active count is not increasing. The driver type in the pool definition i

Re: [Resin-interest] Db Pool freezes waiting on _pool (3.1.3)

2012-07-06 Thread Scott Ferguson
On 07/06/2012 11:47 AM, Knut Forkalsrud wrote: You may want to keep track of the DB pool statistics. Active versus maximum allocation counts. If this is a connection leak you would notice the number of active connection creeping upwards until it reaches max and your freezing symptoms appear.

Re: [Resin-interest] Db Pool freezes waiting on _pool (3.1.3)

2012-07-06 Thread Knut Forkalsrud
You may want to keep track of the DB pool statistics. Active versus maximum allocation counts. If this is a connection leak you would notice the number of active connection creeping upwards until it reaches max and your freezing symptoms appear. Knut Forkalsrud On Fri, Jul 6, 2012 at 5:51 AM,

[Resin-interest] Db Pool freezes waiting on _pool (3.1.3)

2012-07-06 Thread Steven Cassidy
Hi, I'm using resin-3.1.3 on a busy site. Periodically the site freezes. A jstack on the server shows most threads in this state: java.lang.Thread.State: TIMED_WAITING (on object monitor) at java.lang.Object.wait(Native Method) at com.caucho.jca.ConnectionPool.create(ConnectionPool.java:897) - loc