Hi,
Where would I see this validate on checkout was enabled?
This tends to happen only when we have a high load which is understandable. For
example for the c3p0 settings we used to have:
p:initialPoolSize="25"
p:minPoolSize="25"
p:maxPoolSize="50"
p:maxIdleTimeExcessConnections="7200"
p:checkoutTimeout="14000"
p:acquireIncrement="5"
p:acquireRetryAttempts="5"
p:acquireRetryDelay="10"
p:idleConnectionTestPeriod="300"
So when we would have a large amount of concurrent users log in at once (over
25) they would be able to authenticate our ldap but when it would try to
connect to the oracle database they would be waiting for a connection to the DB
and eventually reach the checkouttimeout and see CAS Unavailable and in the
logs we see:
ERROR [org.hibernate.util.JDBCExceptionReporter] - <An attempt by a client to
checkout a Connection has timed out.>
Once the extra connections were built to the DB they would be able to login.
It was not so much the checkout it was the time taken to create the new
connections to the DB. So we have been adjusting the amount of open
connections based on the amount of concurrent users we have had. So my
question, has anyone else experienced something similar when using oracle and
the c3p0 connection pooling?
___________________
Juan Quintanilla
UTS - Enterprise Group
305-348-6573
[email protected]
________________________________________
From: Marvin S. Addison <[email protected]>
Sent: Monday, October 14, 2013 3:35 PM
To: [email protected]
Subject: Re: [cas-user] Question regarding CAS and db connections
> It seems that the time it takes to create the new connections and for
> the old connection to free up is taking longer than the set time of
> 20 seconds for the checkout time limit.
That sounds unusual. Do you have "validate on checkout" or similar
enabled? What's your validation query? Validation is the only reason I
could think of where checkout would take so long.
M
--
You are currently subscribed to [email protected] as: [email protected]
To unsubscribe, change settings or access archives, see
http://www.ja-sig.org/wiki/display/JSG/cas-user
--
You are currently subscribed to [email protected] as:
[email protected]
To unsubscribe, change settings or access archives, see
http://www.ja-sig.org/wiki/display/JSG/cas-user
