Looking for transaction manager code to show the current database connection pool

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Looking for transaction manager code to show the current database connection pool

Brett
I'm looking for the transaction manager code to check the current database
connection pool.  We are trying to troubleshoot a problem in production
where we randomly are unable to get a new connection.  We are not seeing a
connection leak (at least our munin charts don't show connections to the
database continuing to ramp up over time).  We may have a bad service that
continues to acquire new connections and then delays releasing them.

I'm looking through the the ofbiz transaction manager interface code but
can't see an easy way to check the current connection pool and how many are
active.  Does anyone have any suggestions on the best way to monitor the
connection pool?


Thanks,


Brett
Reply | Threaded
Open this post in threaded view
|

Re: Looking for transaction manager code to show the current database connection pool

David E. Jones-2

By default the connection pool is DBCP, so details about the pool and such would be available through the DBCP API, or they may have tools to get data remotely or something... (that would be nice).

There isn't anything in the OFBiz API to get into these sorts of details, just a few things to make configuration more convenient and get settings from OFBiz files to pass on to DBCP.

-David


On Dec 11, 2010, at 7:06 PM, Brett Palmer wrote:

> I'm looking for the transaction manager code to check the current database
> connection pool.  We are trying to troubleshoot a problem in production
> where we randomly are unable to get a new connection.  We are not seeing a
> connection leak (at least our munin charts don't show connections to the
> database continuing to ramp up over time).  We may have a bad service that
> continues to acquire new connections and then delays releasing them.
>
> I'm looking through the the ofbiz transaction manager interface code but
> can't see an easy way to check the current connection pool and how many are
> active.  Does anyone have any suggestions on the best way to monitor the
> connection pool?
>
>
> Thanks,
>
>
> Brett

Reply | Threaded
Open this post in threaded view
|

Re: Looking for transaction manager code to show the current database connection pool

Brett
David,

Thanks for the quick reply.  I'll take a look at that.


Brett

On Sat, Dec 11, 2010 at 8:11 PM, David E Jones <[hidden email]> wrote:

>
> By default the connection pool is DBCP, so details about the pool and such
> would be available through the DBCP API, or they may have tools to get data
> remotely or something... (that would be nice).
>
> There isn't anything in the OFBiz API to get into these sorts of details,
> just a few things to make configuration more convenient and get settings
> from OFBiz files to pass on to DBCP.
>
> -David
>
>
> On Dec 11, 2010, at 7:06 PM, Brett Palmer wrote:
>
> > I'm looking for the transaction manager code to check the current
> database
> > connection pool.  We are trying to troubleshoot a problem in production
> > where we randomly are unable to get a new connection.  We are not seeing
> a
> > connection leak (at least our munin charts don't show connections to the
> > database continuing to ramp up over time).  We may have a bad service
> that
> > continues to acquire new connections and then delays releasing them.
> >
> > I'm looking through the the ofbiz transaction manager interface code but
> > can't see an easy way to check the current connection pool and how many
> are
> > active.  Does anyone have any suggestions on the best way to monitor the
> > connection pool?
> >
> >
> > Thanks,
> >
> >
> > Brett
>
>