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

[Georgi Naplatanov]

Hi, the problem appears because of these parameters:


db.pool.default.maxActive=25
db.pool.default.whenExhaustedAction=block

You have to set db.pool.default.maxActive high enough according to 
maximum number of simultaneous requests or/and set 
db.pool.default.whenExhaustedAction to "grow" (the default value for 
OpenCms 8.x)

Best regards
Georgi

On 01/21/2013 11:50 AM, Yuta Aoki wrote:
> 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
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev
>
>
>