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; } } }

Jira Server Keeps Crashing

Holly Parrish

I think it might be because we have a LOT of tickets. Is there a max amount of tickets?

I read other questions about running out of memory, but they don't really say if it causes the crash or how to solve it.

Jira will come back up once I restart Jira and Apache

Accepted answers

All comments

Nic Brough -Adaptavist-

We've seen Jira instances with millions of issues, but they're mostly all now on Data Centre installs.

The reason "they don't really say if it causes the crash or how to solve it" is because there are many reasons it might be crashing, and there's no way to say that it is "too many issues" without looking at it.

What you need to do is look through the logs to find out why Jira is crashing. Start with <jira home>/logs/atlassian-jira.log and <jira install>/log/catalina.out

Holly Parrish

So the error I'm seeing is

2017-10-08 05:20:03,299 http-nio-8080-exec-979 ERROR anonymous 319x260738x52 - 10.128.0.111 /rest/api/2/issue [NoModule] There was an error getting a DBCP datasource.

java.lang.RuntimeException: Unable to obtain a connection from the underlying connection pool

at org.ofbiz.core.entity.jdbc.interceptors.connection.ConnectionTracker.trackConnection(ConnectionTracker.java:52)

at org.ofbiz.core.entity.transaction.DBCPConnectionFactory.trackConnection(DBCPConnectionFactory.java:283)

at org.ofbiz.core.entity.transaction.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:80)

at org.ofbiz.core.entity.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:69)

at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:173)

at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:114)

at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:59)

at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:340)

at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:456)

at org.ofbiz.core.entity.GenericDAO.createEntityListIterator(GenericDAO.java:870)

at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:857)

at org.ofbiz.core.entity.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:216)

at org.ofbiz.core.entity.GenericDelegator.findListIteratorByCondition(GenericDelegator.java:1243)

at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findListIteratorByCondition(DefaultOfBizDelegator.java:398)

at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.findListIteratorByCondition(WrappingOfBizDelegator.java:278)

at com.atlassian.jira.entity.SelectQueryImpl$ExecutionContextImpl.forEach(SelectQueryImpl.java:227)

at com.atlassian.jira.entity.SelectQueryImpl$ExecutionContextImpl.consumeWith(SelectQueryImpl.java:214)

at com.atlassian.jira.entity.SelectQueryImpl$ExecutionContextImpl.singleValue(SelectQueryImpl.java:191)

at com.atlassian.jira.crowd.embedded.ofbiz.OfBizUserDao.getCredential(OfBizUserDao.java:265)

at com.atlassian.jira.crowd.embedded.ofbiz.DelegatingUserDao.getCredential(DelegatingUserDao.java:83)

at com.atlassian.jira.crowd.embedded.ofbiz.IndexedUserDao.getCredential(IndexedUserDao.java:63)

at com.atlassian.jira.crowd.embedded.ofbiz.DelegatingUserDao.getCredential(DelegatingUserDao.java:83)

at com.atlassian.jira.crowd.embedded.ofbiz.SwitchingUserDao.getCredential(SwitchingUserDao.java:30)

at com.atlassian.crowd.directory.AbstractInternalDirectory.processAuthentication(AbstractInternalDirectory.java:254)

at com.atlassian.crowd.directory.AbstractInternalDirectory.authenticate(AbstractInternalDirectory.java:222)

at com.atlassian.crowd.manager.directory.DirectoryManagerGeneric.authenticateUser(DirectoryManagerGeneric.java:311)

at com.atlassian.crowd.manager.application.ApplicationServiceGeneric.authenticateUser(ApplicationServiceGeneric.java:198)

at com.atlassian.crowd.embedded.core.CrowdServiceImpl.authenticate(CrowdServiceImpl.java:75)

at com.atlassian.jira.security.login.JiraSeraphAuthenticator.crowdServiceAuthenticate(JiraSeraphAuthenticator.java:75)

at com.atlassian.jira.security.login.JiraSeraphAuthenticator.authenticate(JiraSeraphAuthenticator.java:49)

at com.atlassian.seraph.auth.DefaultAuthenticator.login(DefaultAuthenticator.java:88)

... 13 filtered

at com.atlassian.plugins.rest.module.servlet.RestSeraphFilter.doFilter(RestSeraphFilter.java:37)

... 19 filtered

at com.atlassian.jira.servermetrics.CorrelationIdPopulatorFilter.doFilter(CorrelationIdPopulatorFilter.java:30)

... 10 filtered

at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)

... 4 filtered

at com.atlassian.web.servlet.plugin.LocationCleanerFilter.doFilter(LocationCleanerFilter.java:36)

... 26 filtered

at com.atlassian.jira.servermetrics.MetricsCollectorFilter.doFilter(MetricsCollectorFilter.java:25)

... 23 filtered

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:745)

Caused by: java.sql.SQLException: Cannot get a connection, pool error Timeout waiting for idle object

at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:142)

at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533)

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

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

at org.ofbiz.core.entity.jdbc.interceptors.connection.ConnectionTracker.trackConnection(ConnectionTracker.java:48)

Caused by: java.util.NoSuchElementException: Timeout waiting for idle object

at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:449)

at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:363)

at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134)

... 138 more

2017-10-08 05:20:11,260 Caesium-1-1 ERROR ServiceRunner [NoModule] There was an error getting a DBCP datasource.