Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Product Q&A
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

Unable to obtain a connection from the underlying connection pool

Lokesh D2
Lokesh D
Contributor
February 19, 2012

Jira(4.4.3) instance keeps losing connectiont to database (oracle 10g (10.2.4)), with errors as below

This is observed every monday at the same time (8-9am which is the busiest period of the week). DBAs say no active sessions during that outage period. Not sure if Thread dumps can reveal anything ...!!

2012-02-20 08:41:39,126 TP-Processor620 ERROR jsmith63 516x255496x21 1fjn1it 166.15.148.121 /secure/IssueNavigator.jspa [NoModule] There was an error         getting a DBCP datasource.
  52930 java.lang.RuntimeException: Unable to obtain a connection from the underlying connection pool
  52931         at org.ofbiz.core.entity.jdbc.interceptors.connection.ConnectionTracker.trackConnection(ConnectionTracker.java:59)
  52932         at org.ofbiz.core.entity.transaction.DBCPConnectionFactory.trackConnection(DBCPConnectionFactory.java:149)
  52933         at org.ofbiz.core.entity.transaction.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:69)
  52934         at org.ofbiz.core.entity.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:69)
  52935         at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:146)
  52936         at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:101)
  52937         at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:59)
  52938         at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:367)
  52939         at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:515)
  52940         at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1034)
  52941         at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:605)
  52942         at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:131)
  52943         at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:790)
  52944         at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:775)
  52945         at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:752)
  52946         at sun.reflect.GeneratedMethodAccessor32.invoke(Unknown Source)
  52947         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  52948         at java.lang.reflect.Method.invoke(Method.java:597)
  52949         at com.atlassian.multitenant.impl.MultiTenantComponentFactoryImpl$AbstractMultiTenantAwareInvocationHandler.invokeInternal(MultiTenantCompone        ntFactoryImpl.java:181)
  52950         at com.atlassian.multitenant.impl.MultiTenantComponentFactoryImpl$MultiTenantAwareMethodInterceptor.intercept(MultiTenantComponentFactoryImpl        .java:230)
  52951         at org.ofbiz.core.entity.GenericDelegator$$EnhancerByCGLIB$$77976a1f.findByAnd(<generated>)
  52952         at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByAnd(DefaultOfBizDelegator.java:92)
  52953         at com.atlassian.jira.user.OfBizUserHistoryStore.updateHistoryItemNoChecks(OfBizUserHistoryStore.java:123)
  52954         at com.atlassian.jira.user.CachingUserHistoryStore$2.run(CachingUserHistoryStore.java:124)
  52955         at com.atlassian.util.concurrent.ManagedLocks$ManagedLockImpl.withLock(ManagedLocks.java:333)
  52956         at com.atlassian.jira.user.CachingUserHistoryStore.addHistoryItem(CachingUserHistoryStore.java:93)
  52957         at com.atlassian.jira.user.SessionBasedAnonymousUserHistoryStore$2.run(SessionBasedAnonymousUserHistoryStore.java:101)
  52958         at com.atlassian.util.concurrent.ManagedLocks$ManagedLockImpl.withLock(ManagedLocks.java:333)
  52959         at com.atlassian.jira.user.SessionBasedAnonymousUserHistoryStore.addHistoryItem(SessionBasedAnonymousUserHistoryStore.java:83)
  52960         at com.atlassian.jira.user.DefaultUserHistoryManager.addItemToHistory(DefaultUserHistoryManager.java:41)
  52961         at com.atlassian.jira.user.DefaultUserHistoryManager.addItemToHistory(DefaultUserHistoryManager.java:29)
  52962         at com.atlassian.jira.user.DefaultUserProjectHistoryManager.addProjectToHistory(DefaultUserProjectHistoryManager.java:36)
  52963         at com.atlassian.jira.user.DefaultUserProjectHistoryManager.addProjectToHistory(DefaultUserProjectHistoryManager.java:42)
  52964         at com.atlassian.jira.issue.search.searchers.transformer.ProjectSearchInputTransformer.setProjectIdInSession(ProjectSearchInputTransformer.ja        va:173)
  52965         at com.atlassian.jira.issue.search.searchers.transformer.ProjectSearchInputTransformer.populateFromQuery(ProjectSearchInputTransformer.java:8        0)
  52966         at com.atlassian.jira.web.action.issue.SearchDescriptionEnabledAction.populateFieldValuesHolderFromQuery(SearchDescriptionEnabledAction.java:        68)
  52967         at com.atlassian.jira.web.action.issue.IssueNavigator.validateAndGetRedirectForQuery(IssueNavigator.java:756)
  52968         at com.atlassian.jira.web.action.issue.IssueNavigator._doExecutePopulateFromSearchRequest(IssueNavigator.java:317)
  52969         at com.atlassian.jira.web.action.issue.IssueNavigator.doExecute(IssueNavigator.java:221)
  52970         at webwork.action.ActionSupport.execute(ActionSupport.java:165)
  52971         at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:76)
  52972         at webwork.interceptor.DefaultInterceptorChain.proceed(DefaultInterceptorChain.java:39)
  52973         at webwork.interceptor.NestedInterceptorChain.proceed(NestedInterceptorChain.java:31)
  52974         at webwork.interceptor.ChainedInterceptor.intercept(ChainedInterceptor.java:16)
  52975         at webwork.interceptor.DefaultInterceptorChain.proceed(DefaultInterceptorChain.java:35)
  52976         at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:205)
  
  53098 Caused by: java.sql.SQLException: IO Error: Connection reset
  53099         at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:421)
  53100         at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)
  53101         at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)
  53102         at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
  53103         at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
  53104         at java.sql.DriverManager.getConnection(DriverManager.java:582)
  53105         at java.sql.DriverManager.getConnection(DriverManager.java:154)
  53106         at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:97)
  53107         at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300)
  53108         at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816)
  53109         at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:140)
  53110         at org.ofbiz.core.entity.transaction.DBCPConnectionFactory$1.call(DBCPConnectionFactory.java:153)
  53111         at org.ofbiz.core.entity.transaction.DBCPConnectionFactory$1.call(DBCPConnectionFactory.java:150)
  53112         at org.ofbiz.core.entity.jdbc.interceptors.connection.ConnectionTracker.trackConnection(ConnectionTracker.java:53)
  53113         ... 166 more
  53114 Caused by: java.net.SocketException: Connection reset
  53115         at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:96)
  53116         at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
  53117         at oracle.net.ns.Packet.send(Packet.java:385)
  53118         at oracle.net.ns.ConnectPacket.send(ConnectPacket.java:173)
  53119         at oracle.net.ns.NSProtocol.connect(NSProtocol.java:283)
  53120         at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042)
  53121         at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301)
  53122         ... 179 more

Answer
Watch
Like Brad Mace [ATS] likes this
1719 views

3 answers

1 vote
Stéphane Genin
Stéphane Genin
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
June 4, 2012

Hi,

I had this error and we increased the value of pool-size in dbconfig.xml.

We now have the problem less frequently.

Stéphane

View More Comments
Deleted user June 27, 2012

We have the same error in the log and Jira always crashes when this happens. I've increased the pool size in dbconfig.xml today. Is there anything else we can do to prevent Jira from crashing?

Like
Stéphane Genin
Stéphane Genin
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
June 27, 2012

Actually this solved our problems. At the same time, we also inactivated the antivirus. No we still experience slowness sometimes but no more crashes.

There may be also memory settings that may need to be tuned, but you would have specific errors for that.

Stéphane

Like
Reply
0 votes
Marc Jason Mutuc
Marc Jason Mutuc
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
May 22, 2014

We are also experiencing this error. We will try to increase pool size and also upgrade JIRA instance. Hopefully that helps. If not, what else can we look into?

View More Comments
Marc Jason Mutuc
Marc Jason Mutuc
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
May 26, 2014

We've increased pool size and upgraded to 6.2.5. This error still exists. We consulted with our DBAs and they said they found no errors. We already followed whats indicated in Confluence (https://confluence.atlassian.com/display/JIRA/Surviving+Connection+Closures). Is there something else we're missing?

Like
Reply
0 votes
Ivar
Ivar
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
February 19, 2012

Can you check the driver you have for the database? Ref step 3. here: http://confluence.atlassian.com/display/JIRA043/Connecting+JIRA+to+Oracle

View More Comments
JamieA
JamieA
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
February 19, 2012

The driver is correct, and the ping query is present too.

Like
Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira
TAGS
AUG Leaders

Atlassian Community Events

    See all events