JDBC Adapter Pool Error

, ,
1

Hello,

I am getting the following error at inconsistent intervals of time

Adapter Runtime (Adapter Service): Unable to run adapter service. Error occured when connecting to resource
[ART.118.5053] Adapter Runtime (Connection): Unable to get a connection to resource
The pool doesn’t have a connection available for the request).

The Adapter settings are

The adapter settings are
Enable Connection Pooling:True
Minimum Pool Size : 0
Maximum Pool Size : 10
Pool Increment Size : 1
Block Timeout(msec) : 1000
Expire Timeout(msec) : 1000
Startup Retry Count : 0
Stratup backoff Timeout(sec) : 10

Please advise on what can be the issue here

2

Looks like your connection pool ran out of connections and your adapter service was unable to retrieve a connection within the “Block Timeout” timeframe. Try increasing the Block Timeout setting or even better increase the Max Pool Size to an approriate value.

Cheers,

Alex

3

You might want to also increase your block and expire timeouts. 1 second for those is pretty short. Especially the expire timeout–depending on the level of activity in your IS you may be destroying and recreating DB connections far more often than is practical.

4

I agree with reamon, as well check the ART and JDBC fixes as the connection pools management faces some issues.