users@glassfish.java.net

Re: COnnection Pool Datasource from Glassfish

From: <glassfish_at_javadesktop.org>
Date: Tue, 11 Mar 2008 07:26:11 PST

Let say if connections were abrupted before close was called on them is there a way that Glassfish closes them puts it back to pool ?

Here is the stack trace for now we are not reclaiming the leaked connection in order to monitor conn leaks but even then that would 'nt have much of a difference as these many connections are left abandonded which I suspect are the culprit.

com.sun.enterprise.web.connector.grizzly.ssl.SSLWorkerThread.run(SSLWorkerThread.java:106)

Monitoring Statistics :
PoolCounters:
 maxNumConnUsed = 222
 minNumConnUsed = 0
 currNumConnUsed = 222
 maxNumConnFree = = 10
 minNumConnFree = 0
 currNumConnFree = 0
 numConnCreated = 313
 numConnDestroyed = 91
 numConnFailedValidation = 0
 numConnTimedOut = 13
 numConnAcquired = 7539
 numConnReleased = 7317
 currConnectionRequestWait = 80
 minConnectionRequestWait = 0
 maxConnectionRequestWait = 59996
 totalConnectionRequestWait = 217041
 numConnSuccessfullyMatched = 0
 numConnNotSuccessfullyMatched = 0
 numPotentialConnLeak = 65|#]

[#|2008-02-29T17:23:57.580-0500|WARNING|sun-appserver9.1|javax.enterprise.resource.resourceadapter|_ThreadID=23;_ThreadName=Timer-11;ConnectionPoolName=AIP_TEST;_RequestID=e3f61220-87ed-4ef2-9971-7dc77ef320cf;|A
potential connection leak detected for connection pool AIP_TEST. The
 stack trace
of the thread is provided below :
com.sun.enterprise.resource.AbstractResourcePool.startConnectionLeakTracing(AbstractResourcePool.java:310)
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.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:235)
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)
org.aip.busys.common.Connect.getTESTConnection(Connect.java:147)
org.aip.busys.common.Connect.getANSPConnection(Connect.java:84)
org.aip.busys.common.Effort_diff_flex.Effort_diff_flex(Effort_diff_flex.java:106)
org.apache.jsp.g_005finfo_jsp._jspService(g_005finfo_jsp.java:441)
[Message sent by forum member 'md7777' (md7777)]

http://forums.java.net/jive/thread.jspa?messageID=263362