[Aplaws-patches] [ aplaws-Patches-1828052 ] Poller causes PooledConnectionSource to grow

[SourceForge.net <no...@so...>]

Patches item #1828052, was opened at 2007-11-08 11:55
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=531527&aid=1828052&group_id=71505

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Terry (terry_permeance)
Assigned to: Nobody/Anonymous (nobody)
Summary: Poller causes PooledConnectionSource to grow

Initial Comment:
When PooledConnectionSource$Poller checks whether connections are still alive, it takes all available connections offline so they cannot be used until they have been tested one-by-one. 

If by chance a new connection is required before any of the connections are returned to the pool, then a new connection will be created unconditionally as long as the pool size is not exceeded. 

In our production environment, this unlikely event happens up to 6 times per day. This means our pool size grows by about 6 connections per day (42 connections per week!) even though the load never justifies such a pool size.

This fix stops this from happening. When a connection is required but there are no connections available, it will wait() if there are connections being tested.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=531527&aid=1828052&group_id=71505