DB-backed storage service: testing database pool status?

[Wessel, Keith]

I was planning on adding some validation parameters. Right now, my setup is truly minimal.

As for what type of pooling, I'm not sure exactly what you're asking there. Let me try to answer that: it's  a container resource that looks like:
<Resource name="jdbc/idp"
Auth="Container"
Type="javax.sql.DataSource"
. />
In addition, it has my Oracle driver, connection params, and a maxWait of 10,000 ms.

I'm planning to add a validation query. I suspect that'll do the trick, but it'd certainly be good to monitor it somehow. Maybe Scott's right and we should just have the SLBs and service monitoring perform a full login.

Keith

From: users-bounces at shibboleth.net [mailto:users-bounces at shibboleth.net] On Behalf Of Paul Hethmon
Sent: Thursday, August 28, 2014 10:44 AM
To: Shibboleth Users
Subject: Re: DB-backed storage service: testing database pool status?

On Aug 28, 2014, at 11:33 AM, Wessel, Keith <kwessel at illinois.edu> wrote:


FWIW, the error in the log is "Cannot get a connection, pool error timeout waiting for idle object

Any suggestions on how I can monitor this from our service monitoring and our  SLB health checks?

What type of pooling are you using? Typically the pooling service provides options for validating the pool and connections coming out of it.

Paul

Paul Hethmon
Chief Software Architect
paul.hethmon at clareitysecurity.com