users@glassfish.java.net

(Database lock) Re: Number of requests per second taken care by glassfish

From: Jeanfrancois Arcand <Jeanfrancois.Arcand_at_Sun.COM>
Date: Wed, 18 Jun 2008 13:48:19 -0400

Hi,

looks like a problem with connection pool:

> [#|2008-06-18T17:10:08.300+0000|WARNING|sun-appserver9.1|javax.enterprise.resource.resourceadapter|_ThreadID=52;_ThreadName=Timer-30;ConnectionPoolName=csp-pool;_RequestID=7b661f22-1076-4289-83be-d922c225e6ea;|A potential connection leak detected for connection pool csp-pool. The stack trace of the thread is provided below :
> com.sun.enterprise.resource.AbstractResourcePool.setResourceStateToBusy(AbstractResourcePool.java:301)
> com.sun.enterprise.resource.AbstractResourcePool.getResourceFromPool(AbstractResourcePool.java:778)
> com.sun.enterprise.resource.AbstractResourcePool.getUnenlistedResource(AbstractResourcePool.java:652)
> com.sun.enterprise.resource.AssocWithThreadResourcePool.getUnenlistedResource(AssocWithThreadResourcePool.java:136)
> com.sun.enterprise.resource.AbstractResourcePool.internalGetResource(AbstractResourcePool.java:594)
> com.sun.enterprise.resource.AbstractResourcePool.getResource(AbstractResourcePool.java:443)
> com.sun.enterprise.resource.PoolManagerImpl.getResourceFromPool(PoolManagerImpl.java:248)
> com.sun.enterprise.resource.PoolManagerImpl.getResource(PoolManagerImpl.java:176)
> com.sun.enterprise.connectors.ConnectionManagerImpl.internalGetConnection(ConnectionManagerImpl.java:327)
> com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:189)
> com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:165)
> com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:158)
> com.sun.gjc.spi.base.DataSource.getConnection(DataSource.java:108)

and all threads deadlock here:

> "httpSSLWorkerThread-8080-99" daemon prio=10 tid=0x08d1bc00 nid=0x30b3 waiting for monitor entry [0x436d9000..0x436db0b0]
> java.lang.Thread.State: BLOCKED (on object monitor)
> at com.sun.enterprise.resource.AbstractResourcePool.stopConnectionLeakTracing(AbstractResourcePool.java:325)
> - waiting to lock <0x68c8fe48> (a java.lang.Object)

> "httpSSLWorkerThread-8080-98" daemon prio=10 tid=0x08d1a800 nid=0x30b2 waiting for monitor entry [0x4371a000..0x4371c130]
> java.lang.Thread.State: BLOCKED (on object monitor)
> at com.sun.enterprise.resource.AbstractResourcePool.stopConnectionLeakTracing(AbstractResourcePool.java:325)
> - waiting to lock <0x68c8fe48> (a java.lang.Object)
> at com.sun.enterprise.resource.AbstractResourcePool.setResourceStateToFree(AbstractResourcePool.java:286)

> "httpSSLWorkerThread-8080-97" daemon prio=10 tid=0x08d19400 nid=0x30b1 waiting for monitor entry [0x4375b000..0x4375cdb0]
> java.lang.Thread.State: BLOCKED (on object monitor)
> at com.sun.enterprise.resource.AbstractResourcePool.getResourceFromPool(AbstractResourcePool.java:752)
> - waiting to lock <0x68c36b58> (a com.sun.enterprise.resource.AssocWithThreadResourcePool)
> at com.sun.enterprise.resource.AbstractResourcePool.getUnenlistedResource(AbstractResourcePool.java:652)
> at com.sun.enterprise.resource.AssocWithThreadResourcePool.getUnenlistedResource(AssocWithThreadResourcePool.java:136)
> at com.sun.enterprise.resource.AbstractResourcePool.internalGetResource(AbstractResourcePool.java:594)
> at com.sun.enterprise.resource.AbstractResourcePool.getResource(AbstractResourcePool.java:443)

Can you file an issue here (might not be a bug, but a configuration issue):

https://glassfish.dev.java.net/servlets/ProjectIssues

and assign it to Binod?

Thanks

-- Jeanfrancois

glassfish_at_javadesktop.org wrote:
> I got little delayed before capturing this final netstat. Please find it attached.
> So, by the time, I captured, some might've gotten closed already.
>
> All the *03* files are before setting the QuickStart and *04* files are after that setting.
>
> Thank you
> Kind Regards,
> Sanjeev
> [Message sent by forum member 'sanjeev_any' (sanjeev_any)]
>
> http://forums.java.net/jive/thread.jspa?messageID=281084
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>