[opencms-dev] OpenCms hangs up when it gets too many requests

[Yuta Aoki]

Hello,

It seems like OpenCms (version 7.5.x) hangs up when it receives more
requests than the maxActive value. You'll get the error "Timeout
waiting for idle object "

The tricky part is that sometimes, it will be working again after
waiting a bit. But sometimes it will stop working.

[How to reproduce]

1. Set those values in opencms.properties.

-------
db.pool.default.maxActive=25
db.pool.default.maxWait=2000
db.pool.default.minIdle=10
db.pool.default.maxIdle=20
db.pool.default.whenExhaustedAction=block
db.pool.default.testOnBorrow=true
db.pool.default.testWhileIdle=true
db.pool.default.timeBetweenEvictionRuns=3600000
db.pool.default.numTestsPerEvictionRun=3
db.pool.default.minEvictableIdleTime=1800000
db.pool.default.testQuery=SELECT STRUCTURE_ID FROM
CMS_OFFLINE_STRUCTURE WHERE RESOURCE_PATH \= '/'
db.pool.default.connects=10
db.pool.default.wait=5000

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
--------

2. Send more than 25 simultaneous requests to the server.


I believe you can set some value to
"db.pool.default.whenExhaustedAction=block" so that OpenCms increases
the max amount when it gets more request, but it wouldn't be the ideal
solution when you actually want to limit the max connections.

Is there any way to solve this? Is it fixed in version 8.5?


Cheers,
Yuta Aoki