-
Bug
-
Resolution: Fixed
-
Highest (View bug fix roadmap)
-
7.0.7
-
7
-
Summary
Installing JIRA 7.0.7 with MySQL Server fails. After configuring an Admin user, accessing the instance reports a 500 Error:
com.opensymphony.module.propertyset.PropertyImplementationException: SQL Exception while executing the following:SELECT ID, propertytype FROM propertyentry WHERE ENTITY_NAME=? AND ENTITY_ID=? AND PROPERTY_KEY=? (Streaming result set com.mysql.jdbc.RowDataDynamic@30f0a1c5 is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries.) com.opensymphony.module.propertyset.PropertyImplementationException: SQL Exception while executing the following:SELECT ID, propertytype FROM propertyentry WHERE ENTITY_NAME=? AND ENTITY_ID=? AND PROPERTY_KEY=? (Streaming result set com.mysql.jdbc.RowDataDynamic@30f0a1c5 is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries.) at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore$EntryLoader.load(CachingOfBizPropertyEntryStore.java:440) [CachingOfBizPropertyEntryStore$EntryLoader.class:?] at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore$EntryLoader.load(CachingOfBizPropertyEntryStore.java:429) [CachingOfBizPropertyEntryStore$EntryLoader.class:?] at com.atlassian.cache.memory.MemoryCacheManager$3$1.load(MemoryCacheManager.java:132) [atlassian-cache-memory-2.8.3.jar:?] at com.atlassian.cache.memory.BlockingCacheLoader.load(BlockingCacheLoader.java:51) [atlassian-cache-memory-2.8.3.jar:?] at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527) [guava-18.0.jar:?] at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319) [guava-18.0.jar:?] at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282) [guava-18.0.jar:?] at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197) [guava-18.0.jar:?] at com.google.common.cache.LocalCache.get(LocalCache.java:3937) [guava-18.0.jar:?] at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941) [guava-18.0.jar:?] at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4824) [guava-18.0.jar:?] at com.atlassian.cache.memory.DelegatingCache$DelegatingLoadingCache.get(DelegatingCache.java:324) [atlassian-cache-memory-2.8.3.jar:?] at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.getEntry(CachingOfBizPropertyEntryStore.java:101) [CachingOfBizPropertyEntryStore.class:?] at com.atlassian.jira.propertyset.CachingOfBizPropertySet.exists(CachingOfBizPropertySet.java:139) [CachingOfBizPropertySet.class:?] at com.atlassian.jira.config.properties.ApplicationPropertiesStore.getOption(ApplicationPropertiesStore.java:149) [ApplicationPropertiesStore.class:?] at com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getOption(ApplicationPropertiesImpl.java:85) [ApplicationPropertiesImpl.class:?] at com.atlassian.jira.crowd.embedded.ofbiz.OfBizUserDao.useInternedUserValues(OfBizUserDao.java:155) [OfBizUserDao.class:?] at com.atlassian.jira.crowd.embedded.ofbiz.OfBizUserDao.lambda$search$55(OfBizUserDao.java:818) [OfBizUserDao.class:?] at com.atlassian.jira.crowd.embedded.ofbiz.OfBizUserDao$$Lambda$204/986884.accept(Unknown Source) [?:?] at com.atlassian.jira.crowd.embedded.ofbiz.db.DefaultOfBizTransaction.lambda$withTransaction$563(DefaultOfBizTransaction.java:57) [DefaultOfBizTransaction.class:?] at com.atlassian.jira.crowd.embedded.ofbiz.db.DefaultOfBizTransaction$$Lambda$205/675686500.apply(Unknown Source) [?:?] at com.atlassian.jira.crowd.embedded.ofbiz.db.DefaultOfBizTransaction.withTransaction(DefaultOfBizTransaction.java:37) [DefaultOfBizTransaction.class:?] at com.atlassian.jira.crowd.embedded.ofbiz.db.DefaultOfBizTransaction.withTransaction(DefaultOfBizTransaction.java:51) [DefaultOfBizTransaction.class:?] at com.atlassian.jira.crowd.embedded.ofbiz.db.DefaultOfBizTransaction.withTransaction(DefaultOfBizTransaction.java:55) [DefaultOfBizTransaction.class:?] at com.atlassian.jira.crowd.embedded.ofbiz.db.DefaultOfBizTransactionManager.withTransaction(DefaultOfBizTransactionManager.java:9) [DefaultOfBizTransactionManager.class:?] at com.atlassian.jira.crowd.embedded.ofbiz.OfBizUserDao.search(OfBizUserDao.java:811) [OfBizUserDao.class:?] at com.atlassian.crowd.directory.AbstractInternalDirectory.searchUsers(AbstractInternalDirectory.java:780) [crowd-persistence-2.8.3.jar:?] at com.atlassian.crowd.manager.directory.DirectoryManagerGeneric.searchUsers(DirectoryManagerGeneric.java:301) [crowd-core-2.8.3.jar:?] at com.atlassian.jira.user.util.DefaultUserManager.getAllUsersFromDirectory(DefaultUserManager.java:146) [DefaultUserManager.class:?] at com.atlassian.jira.user.util.DefaultUserManager.getAllUsersFromCrowd(DefaultUserManager.java:187) [DefaultUserManager.class:?] at com.atlassian.jira.user.util.DefaultUserManager.getTotalUserCount(DefaultUserManager.java:103) [DefaultUserManager.class:?] at com.atlassian.jira.bc.license.JiraLicenseServiceImpl.validate(JiraLicenseServiceImpl.java:73) [JiraLicenseServiceImpl.class:?] at com.atlassian.jira.bc.license.JiraLicenseServiceImpl.validate(JiraLicenseServiceImpl.java:139) [JiraLicenseServiceImpl.class:?] at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:351) [UpgradeManagerImpl.class:?] at com.atlassian.jira.web.action.setup.SetupComplete.doExecute(SetupComplete.java:87) [SetupComplete.class:?] at webwork.action.ActionSupport.execute(ActionSupport.java:165) [webwork-1.4-atlassian-30.jar:?] at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:63) [jira-api-7.0.7.jar:?] at webwork.interceptor.DefaultInterceptorChain.proceed(DefaultInterceptorChain.java:39) [webwork-1.4-atlassian-30.jar:?] at webwork.interceptor.NestedInterceptorChain.proceed(NestedInterceptorChain.java:31) [webwork-1.4-atlassian-30.jar:?] at webwork.interceptor.ChainedInterceptor.intercept(ChainedInterceptor.java:16) [webwork-1.4-atlassian-30.jar:?] at webwork.interceptor.DefaultInterceptorChain.proceed(DefaultInterceptorChain.java:35) [webwork-1.4-atlassian-30.jar:?] at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:225) [webwork-1.4-atlassian-30.jar:?] at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:189) [webwork-1.4-atlassian-30.jar:?] at com.atlassian.jira.web.dispatcher.JiraWebworkActionDispatcher.service(JiraWebworkActionDispatcher.java:141) [JiraWebworkActionDispatcher.class:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:725) [servlet-api.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291) [catalina.jar:8.0.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.17] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-websocket.jar:8.0.17] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.17] at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:74) [ChainedFilterStepRunner.class:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.17] at com.atlassian.jira.web.filters.XContentTypeOptionsNoSniffFilter.doFilter(XContentTypeOptionsNoSniffFilter.java:20) [XContentTypeOptionsNoSniffFilter.class:?] at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:32) [atlassian-core-5.0.4.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.17] at com.atlassian.core.filters.HeaderSanitisingFilter.doFilter(HeaderSanitisingFilter.java:37) [atlassian-core-5.0.4.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.17] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:70) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.jira.onboarding.postsetup.ui.PostSetupAnnouncementsFilter.doFilter(PostSetupAnnouncementsFilter.java:53) [?:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:78) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:70) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.jira.tzdetect.IncludeResourcesFilter.doFilter(IncludeResourcesFilter.java:85) [?:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:78) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:70) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.jira.baseurl.IncludeResourcesFilter.doFilter(IncludeResourcesFilter.java:38) [?:?] at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:32) [atlassian-core-5.0.4.jar:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:78) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:70) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:26) [?:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:78) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:70) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:26) [?:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:78) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:70) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:26) [?:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:78) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:70) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:26) [?:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:78) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:70) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:26) [?:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:78) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:70) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.greenhopper.jira.filters.ClassicBoardRouter.doFilter(ClassicBoardRouter.java:59) [?:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:78) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:70) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.mywork.client.filter.ServingRequestsFilter.doFilter(ServingRequestsFilter.java:37) [?:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:78) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:70) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.prettyurls.filter.PrettyUrlsSiteMeshFixupFilter.doFilter(PrettyUrlsSiteMeshFixupFilter.java:36) [?:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:78) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:70) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.prettyurls.filter.PrettyUrlsDispatcherFilter.doFilter(PrettyUrlsDispatcherFilter.java:60) [?:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:78) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:70) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.prettyurls.filter.PrettyUrlsSiteMeshFilter.doFilter(PrettyUrlsSiteMeshFilter.java:92) [?:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:78) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:70) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.prettyurls.filter.PrettyUrlsMatcherFilter.doFilter(PrettyUrlsMatcherFilter.java:56) [?:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:78) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:70) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.labs.botkiller.BotKillerFilter.doFilter(BotKillerFilter.java:36) [?:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:78) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) [atlassian-plugins-servlet-4.0.4.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.17] at com.atlassian.jira.web.filters.accesslog.AccessLogFilter.executeRequest(AccessLogFilter.java:92) [AccessLogFilter.class:?] at com.atlassian.jira.web.filters.accesslog.AccessLogFilter.doFilter(AccessLogFilter.java:78) [AccessLogFilter.class:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.17] at com.atlassian.jira.security.xsrf.XsrfTokenAdditionRequestFilter.doFilter(XsrfTokenAdditionRequestFilter.java:40) [XsrfTokenAdditionRequestFilter.class:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.17] at com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:181) [sitemesh-2.5-atlassian-11.jar:?] at com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:85) [sitemesh-2.5-atlassian-11.jar:?] at com.atlassian.jira.web.filters.SitemeshPageFilter.doFilter(SitemeshPageFilter.java:112) [SitemeshPageFilter.class:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.17] at com.atlassian.jira.web.filters.pagebuilder.PageBuilderFilter.doFilter(PageBuilderFilter.java:79) [PageBuilderFilter.class:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.17] at com.atlassian.jira.web.filters.CommittedResponseHtmlErrorRecoveryFilter.doFilter(CommittedResponseHtmlErrorRecoveryFilter.java:55) [CommittedResponseHtmlErrorRecoveryFilter.class:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.17] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:70) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.prettyurls.filter.PrettyUrlsCombinedMatchDispatcherFilter.doFilter(PrettyUrlsCombinedMatchDispatcherFilter.java:61) [?:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:78) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) [atlassian-plugins-servlet-4.0.4.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.17] at com.atlassian.jira.web.filters.MauEventFilter.doFilter(MauEventFilter.java:32) [MauEventFilter.class:?] at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:32) [atlassian-core-5.0.4.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.17] at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:242) [atlassian-seraph-3.0.3.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.17] at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:103) [atlassian-trusted-apps-core-4.1.0.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.17] at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:148) [atlassian-seraph-3.0.3.jar:?] at com.atlassian.jira.web.filters.JiraLoginFilter.doFilter(JiraLoginFilter.java:66) [JiraLoginFilter.class:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.17] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:70) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter(OAuthFilter.java:79) [?:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:78) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:70) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.prettyurls.filter.PrettyUrlsCombinedMatchDispatcherFilter.doFilter(PrettyUrlsCombinedMatchDispatcherFilter.java:61) [?:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:78) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) [atlassian-plugins-servlet-4.0.4.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.17] at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:99) [atlassian-profiling-1.9.jar:?] at com.atlassian.jira.web.filters.JIRAProfilingFilter.doFilter(JIRAProfilingFilter.java:16) [JIRAProfilingFilter.class:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.17] at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:59) [atlassian-johnson-core-3.0.0.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.17] at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176) [urlrewritefilter-4.0.3.jar:4.0.3] at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) [urlrewritefilter-4.0.3.jar:4.0.3] at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) [urlrewritefilter-4.0.3.jar:4.0.3] at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394) [urlrewritefilter-4.0.3.jar:4.0.3] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.17] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:70) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.analytics.client.filter.JiraAnalyticsFilter.doFilter(JiraAnalyticsFilter.java:41) [?:?] at com.atlassian.analytics.client.filter.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:32) [?:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:78) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:70) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.prettyurls.filter.PrettyUrlsCombinedMatchDispatcherFilter.doFilter(PrettyUrlsCombinedMatchDispatcherFilter.java:61) [?:?] at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:78) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) [atlassian-plugins-servlet-4.0.4.jar:?] at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) [atlassian-plugins-servlet-4.0.4.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.17] at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:74) [ChainedFilterStepRunner.class:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.17] at com.atlassian.core.filters.cache.AbstractCachingFilter.doFilter(AbstractCachingFilter.java:31) [atlassian-core-5.0.4.jar:?] at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:32) [atlassian-core-5.0.4.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.17] at com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:39) [atlassian-core-5.0.4.jar:?] at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:32) [atlassian-core-5.0.4.jar:?] at com.atlassian.jira.web.filters.PathMatchingEncodingFilter.doFilter(PathMatchingEncodingFilter.java:41) [PathMatchingEncodingFilter.class:?] at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:32) [atlassian-core-5.0.4.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.17] at com.atlassian.jira.startup.JiraStartupChecklistFilter.doFilter(JiraStartupChecklistFilter.java:65) [JiraStartupChecklistFilter.class:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.17] at com.atlassian.jira.web.filters.MultipartBoundaryCheckFilter.doFilter(MultipartBoundaryCheckFilter.java:36) [MultipartBoundaryCheckFilter.class:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.17] at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:74) [ChainedFilterStepRunner.class:?] at com.atlassian.jira.web.filters.JiraFirstFilter.doFilter(JiraFirstFilter.java:57) [JiraFirstFilter.class:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.17] at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:115) [atlassian-gzipfilter-3.0.0.jar:?] at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:92) [atlassian-gzipfilter-3.0.0.jar:?] at com.atlassian.jira.web.filters.gzip.JiraGzipFilter.doFilter(JiraGzipFilter.java:52) [JiraGzipFilter.class:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.17] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) [catalina.jar:8.0.17] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106) [catalina.jar:8.0.17] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142) [catalina.jar:8.0.17] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) [catalina.jar:8.0.17] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) [catalina.jar:8.0.17] at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610) [catalina.jar:8.0.17] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:516) [catalina.jar:8.0.17] at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1086) [tomcat-coyote.jar:8.0.17] at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:659) [tomcat-coyote.jar:8.0.17] at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:223) [tomcat-coyote.jar:8.0.17] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1558) [tomcat-coyote.jar:8.0.17] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1515) [tomcat-coyote.jar:8.0.17] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_25] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_25] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.0.17] at java.lang.Thread.run(Thread.java:745) [?:1.8.0_25]
The same behaviour occurs with an upgrade as well.
Environment
JIRA 7.0.7
Database Product Name is MySQL
Database Product Version is 5.6.22
Steps to Reproduce
Install JIRA 7.0.7 using a MySQL Server Database, follow the Wizard steps (up to setting up Mail ?Notifications) where the instance will fail)
Restarting the instance initially looks promising, but then continues to fail when accessing Administrative or User Management areas of the JIRA instance.
Expected Results
When Accessing JIRA for the first time, the instance should show the System Dashboard.
Actual Results
A 500 Error is displayed reporting a SQL Exception
Workaround
After experiencing the error, restart the JIRA instance.
- Install JIRA 7.0.5 Instead of JIRA 7.0.7 at this time,
- Avoid using MySQL with JIRA 7.0.7.
If you have upgraded to JIRA 7.0.7, you can:
- Roll back your Instance to a previous version as per: Roll back a JIRA application upgrade
- Upgrade to a newer version of JIRA.
- Downgrade your JIRA instance.
Downgrade your JIRA instance using the steps below:
- Make a full backup of your environment as in: Backing up data
- Ensure JIRA 7.0.7 instance is shutdown.
- Install JIRA 7.0.5 into this environment, but not into the same JIRA Install as your 7.0.7 as this will not work.
- Shutdown the JIRA 7.0.5 instance once it has started.
- Any customisations and data that you have in your JIRA 7.0.7 environment should be migrated to ensure that your JIRA 7.0.5 has these configurations.
- Copy over any configuration changes that you have made as per our Upgrading JIRA applications with a fallback method.
- Copy over Avatars and attachments to your new instance as in Upgrading JIRA applications with a fallback method.
- Migrate any installed-plugins that you would like to install into this JIRA 7.0.5 environment. Note: do not migrate the plugins from your 7.0.7 environment, as this will contain 7.0.7 Add-ons that you should not include.
- Set the flag -Djira.downgrade.allowed=true as per: Setting properties and options on startup
- Start JIRA 7.0.5
- When asked for connection information to the database, point to the 7.0.7 JIRA database (if you did not copy the dbconfig.xml file when copying configuration files.)
- The instance should now start and downgrade the JIRA database data. The JIRA version should be reported as 7.0.5.
If you have any questions or concerns regarding this issue or the workaround provided, please contact Atlassian Support.
- is related to
-
-
- Gathering Impact
-
- mentioned in
-
![[Atlassian Documentation] Page](/images/icons/generic_link_16.png "[Atlassian Documentation] Page")
Page
No Confluence page found with the given URL.
-
Page Loading...
-
-
-
![[Atlassian Documentation] Page](https://confluence.atlassian.com/images/icons/favicon.png "[Atlassian Documentation] Page"){kind=icon}
- relates to
-
-
- was cloned as
-
(4 mentioned in, 2 relates to, 1 was cloned as)
[JRASERVER-59299] JIRA 7.0.7 fails with SQL error when using MySQL Server
Alexander Oberhauser (Inactive)
added a comment - Like Cedric Simon mentioned, works also for us! Thank you guys, however, our team experienced troubles in the past two weeks. But for now, everything seems to work like expected.
Alexander Oberhauser (Inactive)
added a comment - Like Cedric Simon mentioned, works also for us! Thank you guys, however, our team experienced troubles in the past two weeks. But for now, everything seems to work like expected. That looks to be a different code path in the stacktrace, so it looks like a different issue. We will investigate further and get back to you.
Regards,
Oswaldo Hernández.
JIRA Bugmaster.
[Atlassian].
We're experiencing the same error with JIRA 7.0.9
@ohernandez Is this really fixed in 7.0.9 ?
2016-01-21 08:33:23,949 http-nio-8080-exec-6 ERROR [o.a.c.c.C.[.[localhost].[/].[action]] Servlet.service() for servlet [action] in context with path [] threw exception [com.atlassian.cache.CacheException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT lower_parent_name FROM cwd_membership WHERE (directory_id = ? ) AND (lower_child_name = ? ) AND (membership_type = ? ) (Streaming result set com.mysql.jdbc.RowDataDynamic@193e83f1 is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries.)] with root cause java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@193e83f1 is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:868) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:864) at com.mysql.jdbc.MysqlIO.checkForOutstandingStreamingData(MysqlIO.java:3142) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2397) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:633) at org.ofbiz.core.entity.GenericDAO.createEntityListIterator(GenericDAO.java:967) at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:883) at org.ofbiz.core.entity.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:194) at org.ofbiz.core.entity.GenericDelegator.findListIteratorByCondition(GenericDelegator.java:1237) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findListIteratorByCondition(DefaultOfBizDelegator.java:398) at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.findListIteratorByCondition(WrappingOfBizDelegator.java:278) at com.atlassian.jira.crowd.embedded.ofbiz.OfBizInternalMembershipDao.findParents(OfBizInternalMembershipDao.java:449) at com.atlassian.jira.crowd.embedded.ofbiz.OfBizInternalMembershipDao.access$200(OfBizInternalMembershipDao.java:52) at com.atlassian.jira.crowd.embedded.ofbiz.OfBizInternalMembershipDao$ParentsLoader.load(OfBizInternalMembershipDao.java:489) at com.atlassian.jira.crowd.embedded.ofbiz.OfBizInternalMembershipDao$ParentsLoader.load(OfBizInternalMembershipDao.java:485) at com.atlassian.cache.memory.MemoryCacheManager$3$1.load(MemoryCacheManager.java:132) at com.atlassian.cache.memory.BlockingCacheLoader.load(BlockingCacheLoader.java:51) at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527) at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319) at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282) at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197) at com.google.common.cache.LocalCache.get(LocalCache.java:3937) at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941) at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4824) at com.atlassian.cache.memory.DelegatingCache$DelegatingLoadingCache.get(DelegatingCache.java:324) at com.atlassian.jira.crowd.embedded.ofbiz.OfBizInternalMembershipDao.getParentsForMemberFromCache(OfBizInternalMembershipDao.java:370) at com.atlassian.jira.crowd.embedded.ofbiz.OfBizInternalMembershipDao.searchCache(OfBizInternalMembershipDao.java:355) at com.atlassian.jira.crowd.embedded.ofbiz.OfBizInternalMembershipDao.search(OfBizInternalMembershipDao.java:309) at com.atlassian.jira.crowd.embedded.ofbiz.OfBizDelegatingMembershipDao.search(OfBizDelegatingMembershipDao.java:116) at com.atlassian.crowd.directory.AbstractInternalDirectory.searchGroupRelationships(AbstractInternalDirectory.java:987) at com.atlassian.crowd.manager.directory.RemoteDirectorySearcher.searchDirectGroupRelationships(RemoteDirectorySearcher.java:78) at com.atlassian.crowd.manager.directory.RemoteDirectorySearcher.searchNestedGroupRelationships(RemoteDirectorySearcher.java:192) at com.atlassian.crowd.manager.directory.DirectoryManagerGeneric.searchNestedGroupRelationships(DirectoryManagerGeneric.java:868) at com.atlassian.crowd.manager.application.ApplicationServiceGeneric.doNestedDirectoryMembershipQuery(ApplicationServiceGeneric.java:3086) at com.atlassian.crowd.manager.application.ApplicationServiceGeneric.searchNestedGroupRelationships(ApplicationServiceGeneric.java:2496) at com.atlassian.crowd.embedded.core.CrowdServiceImpl.searchNestedGroupRelationships(CrowdServiceImpl.java:245) at com.atlassian.crowd.embedded.core.CrowdServiceImpl.search(CrowdServiceImpl.java:159) at com.atlassian.crowd.embedded.core.DelegatingCrowdService.search(DelegatingCrowdService.java:67) at com.atlassian.crowd.embedded.core.FilteredCrowdServiceImpl.search(FilteredCrowdServiceImpl.java:143) at com.atlassian.jira.security.groups.DefaultGroupManager.getGroupsForUser(DefaultGroupManager.java:382) at com.atlassian.jira.security.groups.RequestCachingGroupManager.lambda$new$303(RequestCachingGroupManager.java:43) at com.atlassian.jira.security.groups.RequestCachingGroupManager$$Lambda$55/1950223819.load(Unknown Source) at com.atlassian.jira.cache.request.RequestCacheImpl.get(RequestCacheImpl.java:42) at com.atlassian.jira.security.groups.RequestCachingGroupManager.getGroupsForUser(RequestCachingGroupManager.java:178) at com.atlassian.jira.application.DefaultApplicationRoleManager.isConnectUser(DefaultApplicationRoleManager.java:928) at com.atlassian.jira.application.DefaultApplicationRoleManager.lambda$null$281(DefaultApplicationRoleManager.java:867) at com.atlassian.jira.application.DefaultApplicationRoleManager$$Lambda$210/704063838.accept(Unknown Source) at com.atlassian.jira.crowd.embedded.ofbiz.OfBizUserDao.processUsers(OfBizUserDao.java:929) at com.atlassian.jira.application.DefaultApplicationRoleManager.lambda$readUsersInGroupsExcluding$282(DefaultApplicationRoleManager.java:849) at com.atlassian.jira.application.DefaultApplicationRoleManager$$Lambda$209/2040140253.accept(Unknown Source) at com.atlassian.jira.crowd.embedded.ofbiz.db.DefaultOfBizTransaction.lambda$withTransaction$563(DefaultOfBizTransaction.java:57) at com.atlassian.jira.crowd.embedded.ofbiz.db.DefaultOfBizTransaction$$Lambda$165/1741839865.apply(Unknown Source) at com.atlassian.jira.crowd.embedded.ofbiz.db.DefaultOfBizTransaction.withTransaction(DefaultOfBizTransaction.java:37) at com.atlassian.jira.crowd.embedded.ofbiz.db.DefaultOfBizTransaction.withTransaction(DefaultOfBizTransaction.java:51) at com.atlassian.jira.crowd.embedded.ofbiz.db.DefaultOfBizTransaction.withTransaction(DefaultOfBizTransaction.java:55) at com.atlassian.jira.crowd.embedded.ofbiz.db.DefaultOfBizTransactionManager.withTransaction(DefaultOfBizTransactionManager.java:9) at com.atlassian.jira.application.DefaultApplicationRoleManager.readUsersInGroupsExcluding(DefaultApplicationRoleManager.java:847) at com.atlassian.jira.application.DefaultApplicationRoleManager.readUsersInGroups(DefaultApplicationRoleManager.java:820) at com.atlassian.jira.application.DefaultApplicationRoleManager.countUsersInGroups(DefaultApplicationRoleManager.java:883) at com.atlassian.jira.application.DefaultApplicationRoleManager.access$800(DefaultApplicationRoleManager.java:96) at com.atlassian.jira.application.DefaultApplicationRoleManager$ActiveUserCountLoader.countApplicationRoleUsers(DefaultApplicationRoleManager.java:727) at com.atlassian.jira.application.DefaultApplicationRoleManager$ActiveUserCountLoader.countApplicationUsers(DefaultApplicationRoleManager.java:710) at com.atlassian.jira.application.DefaultApplicationRoleManager$ActiveUserCountLoader.lambda$load$278(DefaultApplicationRoleManager.java:700) at com.atlassian.jira.application.DefaultApplicationRoleManager$ActiveUserCountLoader$$Lambda$205/507235249.apply(Unknown Source) at com.atlassian.fugue.Option.map(Option.java:272) at com.atlassian.jira.application.DefaultApplicationRoleManager$ActiveUserCountLoader.load(DefaultApplicationRoleManager.java:700) at com.atlassian.jira.application.DefaultApplicationRoleManager$ActiveUserCountLoader.load(DefaultApplicationRoleManager.java:696) at com.atlassian.cache.memory.MemoryCacheManager$3$1.load(MemoryCacheManager.java:132) at com.atlassian.cache.memory.BlockingCacheLoader.load(BlockingCacheLoader.java:51) at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527) at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319) at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282) at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197) at com.google.common.cache.LocalCache.get(LocalCache.java:3937) at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941) at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4824) at com.atlassian.cache.memory.DelegatingCache$DelegatingLoadingCache.get(DelegatingCache.java:324) at com.atlassian.jira.application.DefaultApplicationRoleManager.getUserCount(DefaultApplicationRoleManager.java:404) at com.atlassian.jira.application.DefaultApplicationRoleManager.isRoleLimitExceeded(DefaultApplicationRoleManager.java:255) at com.atlassian.jira.application.ApplicationAuthorizationServiceImpl.getLicensingExactErrors(ApplicationAuthorizationServiceImpl.java:135) at com.atlassian.jira.application.ApplicationAuthorizationServiceImpl.getLicensingAccessErrors(ApplicationAuthorizationServiceImpl.java:78) ... 3 filtered at java.lang.reflect.Method.invoke(Method.java:497) at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:30) at com.sun.proxy.$Proxy542.getLicensingAccessErrors(Unknown Source) at com.atlassian.greenhopper.license.ApplicationAuthorizationServiceBridgeImpl.verifySoftwareLicense(ApplicationAuthorizationServiceBridgeImpl.java:46) at com.pyxis.greenhopper.jira.license.GreenHopperLicenseManagerImpl.verify(GreenHopperLicenseManagerImpl.java:73) at com.pyxis.greenhopper.jira.license.GreenHopperLicenseManagerImpl.isValid(GreenHopperLicenseManagerImpl.java:94) at com.atlassian.greenhopper.license.LicenseServiceImpl.getLicenseInfo(LicenseServiceImpl.java:45) at com.atlassian.greenhopper.license.LicenseServiceImpl.isLicensed(LicenseServiceImpl.java:65) at com.pyxis.greenhopper.jira.conditions.GreenHopperConditionEvaluatorImpl.isLicensed(GreenHopperConditionEvaluatorImpl.java:45) at com.pyxis.greenhopper.jira.conditions.GreenHopperConditionEvaluatorImpl.verifyLicense(GreenHopperConditionEvaluatorImpl.java:34) at com.pyxis.greenhopper.jira.conditions.GreenHopperConditionEvaluatorImpl.shouldDisplay(GreenHopperConditionEvaluatorImpl.java:24) at com.pyxis.greenhopper.jira.conditions.UrlReadingIsLicensedCondition.addToUrl(UrlReadingIsLicensedCondition.java:40) at com.atlassian.plugin.webresource.condition.DecoratingUrlReadingCondition.addToUrl(DecoratingUrlReadingCondition.java:32) at com.atlassian.plugin.webresource.condition.DecoratingUrlReadingCondition.shouldDisplayImmediate(DecoratingUrlReadingCondition.java:45) at com.atlassian.plugin.webresource.condition.ConditionsCache.shouldDisplayImmediate(ConditionsCache.java:25) at com.atlassian.plugin.webresource.WebResourceModuleDescriptor.shouldDisplayImmediate(WebResourceModuleDescriptor.java:255) at com.atlassian.plugin.webresource.DefaultResourceDependencyResolver.resolveDependencies(DefaultResourceDependencyResolver.java:227) at com.atlassian.plugin.webresource.DefaultResourceDependencyResolver.getDependenciesInContext(DefaultResourceDependencyResolver.java:107) at com.atlassian.plugin.webresource.ContextBatchBuilder$WebResourceKeysToContextBatches.create(ContextBatchBuilder.java:307) at com.atlassian.plugin.webresource.ContextBatchBuilder.buildBatched(ContextBatchBuilder.java:99) at com.atlassian.plugin.webresource.ContextBatchBuilder.build(ContextBatchBuilder.java:73) at com.atlassian.plugin.webresource.assembler.DefaultWebResourceAssembler$ResourceRequirer.addContextBatchDependencies(DefaultWebResourceAssembler.java:342) at com.atlassian.plugin.webresource.assembler.DefaultWebResourceAssembler$ResourceRequirer.includeResources(DefaultWebResourceAssembler.java:302) at com.atlassian.plugin.webresource.assembler.DefaultWebResourceAssembler$ResourceRequirer.access$1200(DefaultWebResourceAssembler.java:234) at com.atlassian.plugin.webresource.assembler.DefaultWebResourceAssembler$DefaultAssembledResources.drainIncludedResources(DefaultWebResourceAssembler.java:215) at com.atlassian.jira.plugin.navigation.HeaderFooterRendering.includeResources(HeaderFooterRendering.java:95) at jsp.decorators.general_002dhead_002dpre_jsp._jspService(general_002dhead_002dpre_jsp.java:123) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:725) ... 25 filtered at com.atlassian.jira.web.pagebuilder.AbstractJspDecorator.writeTemplate(AbstractJspDecorator.java:93) at com.atlassian.jira.web.pagebuilder.AbstractJspDecorator.writePreHead(AbstractJspDecorator.java:53) at com.atlassian.jira.web.pagebuilder.GeneralJspDecorator.writePreHead(GeneralJspDecorator.java:32) at com.atlassian.jira.web.pagebuilder.DefaultPageBuilder.flush(DefaultPageBuilder.java:78) at com.atlassian.jira.web.action.Dashboard.doExecute(Dashboard.java:188) ... 1 filtered at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:63) ... 7 filtered at javax.servlet.http.HttpServlet.service(HttpServlet.java:725) ... 50 filtered at com.atlassian.greenhopper.jira.filters.ClassicBoardRouter.doFilter(ClassicBoardRouter.java:59) ... 163 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)
Hi all,
JIRA 7.0.9 has been published to www.atlassian.com
You should be able to download the new release now.
Regards,
Oswaldo Hernández.
JIRA Bugmaster.
[Atlassian].
Upgrade from 7.0.5 to 7.0.9 done and everything is OK so far.
But in the future I'll wait 2 weeks after prod release before upgrading Jira to a new version. Just to give enough time to other production end users to perform the QA, since it look Atlassian does not have a QA department :S
Not available via GUI, but hacked the link for Linux 64 bits : https://downloads.atlassian.com/software/jira/downloads/atlassian-jira-software-7.0.9-jira-7.0.9-x64.bin
@Oswaldo: Thank you for your efforts.
Now its marked as resolved, when will it be available for download?
I see release note for version 7.0.9 is published. Hopefully binaries will follow soon 
Hi boris.georgiev,
We have confirmed it is a different issue, if you could please file it as a new JRA ticket with the full information of the circumstances where see this error in the logs and its effects it would help us greatly with the investigation.
Once you create that ticket could you please comment here with a link to it so I can review it? Thanks again for reporting it.
Regards,
Oswaldo Hernández.
JIRA Bugmaster.
[Atlassian].