connection pool exceptions

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)

4 answers

1 accepted

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.

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.

Which JIRA version, and which database?

0 vote

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.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Sunday in Agility

You asked for it, so we delivered: images on issues have arrived

A picture tells a thousand words. And agility boards have just released their latest feature: cover images on issues – so now your board can tell a story at first glance. Upload attachmen...

891 views 3 12
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you