Jira showing internal server error and getting DBCP errors

[Srikanth Gogineni]

Hi All,

we are getting the below DBCP connection not closed error which causing the application down .

Could some one help on the issue ASAP as it is impacting the business highly.

Jira version: 6.2.7

error:

org.apache.commons.dbcp.AbandonedTrace$AbandonedObjectException: DBCP object created 2017-12-15 08:32:16 by the following code was never closed:
 at org.apache.commons.dbcp.AbandonedTrace.setStackTrace(AbandonedTrace.java:139)
 at org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:81)
 at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
 at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
 at org.ofbiz.core.entity.transaction.DBCPConnectionFactory$1.call(DBCPConnectionFactory.java:246)
 at org.ofbiz.core.entity.transaction.DBCPConnectionFactory$1.call(DBCPConnectionFactory.java:243)
 at org.ofbiz.core.entity.jdbc.interceptors.connection.ConnectionTracker.trackConnection(ConnectionTracker.java:53)
 at org.ofbiz.core.entity.transaction.DBCPConnectionFactory.trackConnection(DBCPConnectionFactory.java:242)
 at org.ofbiz.core.entity.transaction.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:73)
 at org.ofbiz.core.entity.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:69)
 at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:146)
 at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:101)
 at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:59)
 at org.ofbiz.core.entity.TransactionUtil.beginLocalTransaction(TransactionUtil.java:275)
 at com.atlassian.core.ofbiz.util.CoreTransactionUtil.begin(CoreTransactionUtil.java:36)
 at com.atlassian.jira.transaction.TransactionSupportImpl.beginTxn(TransactionSupportImpl.java:75)

Regards

SG

[MoroSystems Support]

Did you check connection to your database? Is your DB running and accessible from your JIRA server?

[Srikanth Gogineni]

Yes. Iam able to connect to database from application.

The application works fine when we restart the service,but it repeat s after some time.

[MoroSystems Support]

I'm sorry but I'm not admin and you're using really old version of JIRA. I only found this page which could help you to get furter:

https://confluence.atlassian.com/adminjiraserver073/surviving-connection-closures-861253055.html?_ga=2.253278793.1351747585.1513335815-168621461.1512160062