[opencms-dev] Cannot get a connection, pool error: Timeout waiting for idle object

[Kumar Annamalai]

Hi All,

I am facing this issue in my OpenCms servers, once in every week.
In that case, restarting the server is the only option, and the issue will
be fixed.

More details here,
Tomcat 5.x, MySQL,OpenCms 7.x
I have attached the  http://old.nabble.com/file/p26262970/Opencms.properties
Opencms.properties  file, and a brief overview below,

# the maximum number of objects that can be borrowed from the pool
db.pool.default.maxActive=25

# the maximum amount of time before throwing an exception when the pool is
exhausted
db.pool.default.maxWait=2000

# the minimum number of objects that will kept connected
db.pool.default.minIdle=3

# the maximum number of objects that can sit idled in the pool
db.pool.default.maxIdle=10

# action to take when the pool is exhausted {grow|block|fail}
db.pool.default.whenExhaustedAction=block

# connections will be validated before they are borrowed from the pool
db.pool.default.testOnBorrow=false

# connections will be validated by evictor thread
db.pool.default.testWhileIdle=true

# number of milliseconds to sleep between runs of the evictor thread
# -1 means no idle connection evictor thread will be run
db.pool.default.timeBetweenEvictionRuns=3600000

# number of connections tested in a run of the evictor thread
db.pool.default.numTestsPerEvictionRun=3

# minimum amount of time in milliseconds a connection may be idle in the
pool before it is eligable for eviction
db.pool.default.minEvictableIdleTime=1800000

# the query to validate connections
#db.pool.default.testQuery=SELECT STRUCTURE_ID FROM CMS_OFFLINE_STRUCTURE
WHERE RESOURCE_PATH = '/'
db.pool.default.testQuery=SELECT 1 

# number of attempts to connect to the database during startup (default =
10)
db.pool.default.connects=10

# sleep time between two attempts to connect to the database during startup
in ms (default = 5000)
db.pool.default.wait=5000

#
# Configuration for statement pooling
#################################################################################
db.statements.default.pooling=true
db.statements.default.maxActive=200
db.statements.default.maxWait=2000
db.statements.default.maxIdle=100
db.statements.default.whenExhaustedAction=block

Kindly help me in resolving this issue.

-- 
View this message in context: http://old.nabble.com/Cannot-get-a-connection%2C-pool-error%3A-Timeout-waiting-for-idle-object-tp26262970p26262970.html
Sent from the OpenCMS - Dev mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20091109/4680f675/attachment.htm>