connection pool exceptions

[srinivasp]

Hi, We are frequently getting connection pool exceptions frequently.. The value of max threads is 150 and dbconnections value is 300. Any ideas about how to resolve this please???

"http-80-150" daemon prio=10 tid=0x00002aaac0944800 nid=0x1875 waiting for monitor entry [0x000000004f488000]

java.lang.Thread.State: BLOCKED (on object monitor)

at org.apache.commons.dbcp.PoolableConnectionFactory.validateObject(PoolableConnectionFactory.java:316)

- waiting to lock <0x000000059a5bf828> (a org.apache.commons.dbcp.PoolableConnectionFactory)

at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:833)

at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:140)

at org.ofbiz.core.entity.transaction.DBCPConnectionFactory$1.call(DBCPConnectionFactory.java:153)

at org.ofbiz.core.entity.transaction.DBCPConnectionFactory$1.call(DBCPConnectionFactory.java:150)

[srinivasp · Accepted solution]

HttpSession is found culprict. The new jira is having session time out configured as 300 minutes by default. Reduced to 30 and it never arised again.

[JamieA]

I don't think you're going to get a correct answer based on the information in your question.

But, if you install the java melody plugin, it will show you all the database connections, along with stacktraces from what created the connection. Using this, you can find out which plugin (it probably is a plugin) is creating them.

[Eva]

Which JIRA version, and which database?

[Dieter]

Could be a plugin that allocates db connections and does not release them either because the connections are not closed or something else locks up while the db connection is allocated.

please post a thread dump taken in the situation where you get the errors.