Please check if you application is leaking connections. You could turn
on the connection leak tracing to observe any leaked connections in the
server.log and reclaim those connections when you turn on the connection
leak reclaim flag.
Sun, an Oracle Company
On Sunday 17 April 2011 03:17 AM, Steve Black wrote:
> I have an application that has just recently moved to a distributed
> environment. Since this has happened the application has been
> experiencing connection pool issues.
>
> I have gone through every DAO and verified the connection is closed,
> and have tried the autoReconnectForPools option to attempt resolve the
> issue, but with no result.
>
> Below is a piece of the log from a point in time where one of the
> boxes got into an error state.
>
> Thank you in advance.
>
> Steve
>
> [#|2011-04-16T09:36:28.536-0500|WARNING|glassfish3.0.1|javax.enterprise.resource.resourceadapter.com.sun.enterprise.connectors|_ThreadID=99;_ThreadName=Thread-1;|RAR5117
> : Failed to obt
> ain/create connection from connection pool [ WowponMySQLPool ]. Reason
> : com.sun.appserv.connectors.internal.api.PoolingException: In-use
> connections equal max-pool-size and expired max
> -wait-time. Cannot allocate more connections.|#]
>
> [#|2011-04-16T09:36:28.536-0500|WARNING|glassfish3.0.1|javax.enterprise.resource.resourceadapter.com.sun.gjc.spi|_ThreadID=99;_ThreadName=Thread-1;|RAR5114
> : Error allocating connection
> : [Error in allocating a connection. Cause: In-use connections equal
> max-pool-size and expired max-wait-time. Cannot allocate more
> connections.]|#]
> [#|2011-04-16T09:36:30.131-0500|WARNING|glassfish3.0.1|javax.enterprise.resource.resourceadapter.com.sun.enterprise.connectors|_ThreadID=98;_ThreadName=Thread-1;|RAR5117
> : Failed to obt
> ain/create connection from connection pool [ WowponMySQLPool ]. Reason
> : com.sun.appserv.connectors.internal.api.PoolingException: In-use
> connections equal max-pool-size and expired max
> -wait-time. Cannot allocate more connections.|#]
> [#|2011-04-16T09:36:30.131-0500|WARNING|glassfish3.0.1|javax.enterprise.resource.resourceadapter.com.sun.gjc.spi|_ThreadID=98;_ThreadName=Thread-1;|RAR5114
> : Error allocating connection
> : [Error in allocating a connection. Cause: In-use connections equal
> max-pool-size and expired max-wait-time. Cannot allocate more
> connections.]|#]