JIRA app is down with SQL exception

[Neena Rodricks]

Unable to access the JIRA app via the UI and found the following in the log:

2019-11-03 23:17:38,468 https-jsse-nio-8443-exec-3 ERROR anonymous 1397x49515x1 - 16.208.35.102 /rest/capabilities/navigation [o.o.core.entity.ConnectionFactory] ******* ERROR: No database connection found for helperName "defaultDS"
2019-11-03 23:17:38,468 https-jsse-nio-8443-exec-3 WARN anonymous 1397x49515x1 - 16.208.35.102 /rest/capabilities/navigation [c.a.p.n.p.navigation.services.LocalNavigationLinksImpl] Failed to gather navigation links
com.atlassian.cache.CacheException: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
null
null

java.sql.SQLException: Unable to create connection
at com.atlassian.cache.memory.DelegatingCachedReference.get(DelegatingCachedReference.java:91)
at com.atlassian.jira.plugins.dvcs.dao.impl.CachingOrganizationDaoImpl.getAllCachedOrgs(CachingOrganizationDaoImpl.java:211)
at com.atlassian.jira.plugins.dvcs.dao.impl.CachingOrganizationDaoImpl.getAllByType(CachingOrganizationDaoImpl.java:83)
at com.atlassian.jira.plugins.dvcs.service.OrganizationServiceImpl.getAll(OrganizationServiceImpl.java:113)
at com.atlassian.jira.plugins.dvcs.navlinks.BitbucketCloudAccountNavLinkRepository.matching(BitbucketCloudAccountNavLinkRepository.java:86)
at com.atlassian.jira.plugins.dvcs.navlinks.BitbucketCloudAccountNavLinkRepository.all(BitbucketCloudAccountNavLinkRepository.java:80)
at com.atlassian.plugins.navlink.producer.navigation.services.LocalNavigationLinksImpl$1.apply(LocalNavigationLinksImpl.java:44)
at com.atlassian.plugins.navlink.producer.navigation.services.LocalNavigationLinksImpl$1.apply(LocalNavigationLinksImpl.java:39)
at com.google.common.collect.Lists$TransformingRandomAccessList$1.transform(Lists.java:617)
at com.google.common.collect.TransformedIterator.next(TransformedIterator.java:48)
at com.google.common.collect.TransformedIterator.next(TransformedIterator.java:48)
at com.google.common.collect.Iterators$5.hasNext(Iterators.java:548)
at com.google.common.collect.Iterators.addAll(Iterators.java:361)
at com.google.common.collect.Sets.newHashSet(Sets.java:238)
at com.google.common.collect.Sets.newHashSet(Sets.java:218)
at com.atlassian.plugins.navlink.producer.navigation.services.LocalNavigationLinksImpl.all(LocalNavigationLinksImpl.java:34)
at com.atlassian.plugins.navlink.producer.navigation.services.LocalNavigationLinkServiceImpl.all(LocalNavigationLinkServiceImpl.java:40)
at com.atlassian.plugins.navlink.producer.navigation.rest.NavigationServlet.createContext(NavigationServlet.java:94)
at com.atlassian.plugins.navlink.producer.navigation.rest.NavigationServlet.doGet(NavigationServlet.java:78)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:635)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at com.atlassian.plugin.servlet.DelegatingPluginServlet.service(DelegatingPluginServlet.java:37)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at com.atlassian.plugin.servlet.ServletModuleContainerServlet.service(ServletModuleContainerServlet.java:45)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
... 44 filtered
at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)
... 41 filtered
at com.atlassian.jira.security.JiraSecurityFilter.lambda$doFilter$0(JiraSecurityFilter.java:66)
... 1 filtered
at com.atlassian.jira.security.JiraSecurityFilter.doFilter(JiraSecurityFilter.java:64)
... 24 filtered
at com.atlassian.jira.servermetrics.CorrelationIdPopulatorFilter.doFilter(CorrelationIdPopulatorFilter.java:30)
... 12 filtered
at com.atlassian.jira.servermetrics.MetricsCollectorFilter.doFilter(MetricsCollectorFilter.java:25)
... 7 filtered
at com.atlassian.plugins.navlink.producer.ForwardServletFilter.redirectToTarget(ForwardServletFilter.java:45)
at com.atlassian.plugins.navlink.producer.ForwardServletFilter.doFilter(ForwardServletFilter.java:35)
... 3 filtered
at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)
... 53 filtered
at com.atlassian.jira.security.JiraSecurityFilter.lambda$doFilter$0(JiraSecurityFilter.java:66)
... 1 filtered
at com.atlassian.jira.security.JiraSecurityFilter.doFilter(JiraSecurityFilter.java:64)
... 16 filtered
at com.atlassian.plugins.rest.module.servlet.RestSeraphFilter.doFilter(RestSeraphFilter.java:37)
... 23 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)
... 24 filtered
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

Any suggestions as what could possibly be the issue. 

Thanks.

[Mehmet Şirin Usanmaz]

Hi Neena,

You can follow the steps below.

• Shutdown JIRA, backup your database, and open up your MS-SQL Query console
• Perform the below query on your database, please substitute JIRA-DATABASE for your database name. If your database is large this process may take some time.
  

  ALTER DATABASE [JIRA-DATABASE] SET READ_COMMITTED_SNAPSHOT ON

• Test to see that the above query returns a 1 to confirm the settings change:   

  SELECT is_read_committed_snapshot_on FROM sys.databases WHERE name= 'JIRA-DATABASE'

• Start JIRA

Thanks,

Mehmet Sirin