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

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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)

Accepted answers

srinivasp

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.

All comments

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.

Eva8

Which JIRA version, and which database?

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.

srinivasp

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira-administration

performance

administration