-
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 
I can't reach https://servicedesk-bamboo.internal.atlassian.com/browse/SDMASTERAUX-SDMASTERAUXTPM-MYSQLS-295
Could you put it somewhere so it can be downloaded from Internet?
I would be happy with a MySQL (only) green version.
+1.
Jan 20 as an optimistic date seems to be unacceptable. Temporary fix or private build seems to be good.
Giovanni Renzi Brivio
added a comment - +1 for temporary fix 
Alexander Oberhauser (Inactive)
added a comment - I would also appreciate a temporary fix! Couldn't you just publish the corrected version of the jar (or any other files) causing this bu, so we can apply it to fix version 7.0.7 without having to downgrade or waiting for next release?
I understand that this bug is yet fixed.
Ruth Cheesley
added a comment - Extra note: Anyone who is migrating to Postgresql, make sure you re-index afterward. We had a problem whereby our customers were not seeing any previous issues in their 'My Requests' screens. Re-index fixed this.
Ruth Cheesley
added a comment - Extra note: Anyone who is migrating to Postgresql, make sure you re-index afterward. We had a problem whereby our customers were not seeing any previous issues in their 'My Requests' screens. Re-index fixed this. Hi fyodorov.spbu,
My current estimate is Wednesday next week (20th of January), if everything goes according to plan.
Regards,
Oswaldo Hernández.
JIRA Bugmaster.
[Atlassian].
Hi m.tempelmeier,
The downgrade procedure specified in the workaround does not imply any data loss, you would be pointing at the data you have on 7.0.7 right now.
Regards,
Oswaldo Hernández.
JIRA Bugmaster.
[Atlassian].
Paul Hunter
added a comment - I have successfully rolled-back 7.0.5 following the Workaround instructions above, without any significant issues. The system is now working as expected and no data lost in this process. For about an hours downtime it was worth it for the peace of mind.
Paul Hunter
added a comment - I have successfully rolled-back 7.0.5 following the Workaround instructions above, without any significant issues. The system is now working as expected and no data lost in this process. For about an hours downtime it was worth it for the peace of mind. @oswaldo
Any hint when? I would think this is hotfix worthy, because the possible loss of data on downgrading any production system ist really not doable here.
But we all should think about that we didn´t tested enough too, because this error is really easy detectable :o
Alexander Oberhauser (Inactive)
added a comment - Same here, MySQL 5.5.46 on Ubuntu 14.04.2 LTS. I experienced same situation like @paul hunter end of last week and see same problems like Alexey Fyodorov mentioned, also his workaround works.
Alexander Oberhauser (Inactive)
added a comment - Same here, MySQL 5.5.46 on Ubuntu 14.04.2 LTS. I experienced same situation like @paul hunter end of last week and see same problems like Alexey Fyodorov mentioned, also his workaround works. Hi all,
The fix to the issue described here will be included in JIRA 7.0.9. In the meantime, we suggest for you to rollback to JIRA 7.0.5 as per the Workaround instructions in this issue's description.
If you need help applying the workaround please do reach out to us at https://support.atlassian.com and we will be happy to help you.
We apologize for the inconvenience caused by this issue and we thank you for your patience as we roll out a new JIRA version that does not contain this defect.
Regards,
Oswaldo Hernández.
JIRA Bugmaster.
[Atlassian].
Any fix available for users with 7.0.7 not wishing to downgrade? Any scheduled date for next Jira (fixed) version?
Also, I wonder if there is any quality department working at Atlassian?
On 6 production releases, 2 have had to be rolled back. That's 33%. And version 7 is not a beta or release candidate, it's the official production version.
"JIRA Software is the #1 software development tool used by agile teams, and will enable your team to perform at their peak and build world-class software, faster than ever before." With a 33% failure rate, I am not sure that "world class software" applies to Jira, mister Jason Wong... I would expect more from Jira. To demonstrate a perfect development cycle, with low or no production rollback history. Shoemaker's son always goes barefoot?
Guys, please clarify the situation.
Is some fix going to be provided by Atlassian for customers who already migrated to JIRA 7.0.7?
I followed these tutorials (we're on a Centos server):
Install Postgres (make sure you use 9.3 per the docs showing compatibility with Jira) http://www.unixmen.com/postgresql-9-4-released-install-centos-7/ - assign your user to your database
Setting the config file to allow md5 encryption - see comment: https://confluence.atlassian.com/display/JIRAKB/JIRA+Unable+to+connect+to+database+with+'Ident+authentication+failed'+error
Download & install the appropriate driver if required & drop into your /lib folder: https://jdbc.postgresql.org/download.html
Addition: Re-index once you're done!
Hope that helps if anyone else is considering switching!
Ruth Cheesley
added a comment - - edited I followed these tutorials (we're on a Centos server):
Install Postgres (make sure you use 9.3 per the docs showing compatibility with Jira) http://www.unixmen.com/postgresql-9-4-released-install-centos-7/ - assign your user to your database
Setting the config file to allow md5 encryption - see comment: https://confluence.atlassian.com/display/JIRAKB/JIRA+Unable+to+connect+to+database+with+'Ident+authentication+failed'+error
Download & install the appropriate driver if required & drop into your /lib folder: https://jdbc.postgresql.org/download.html
Addition: Re-index once you're done!
Hope that helps if anyone else is considering switching! 
Vassilis Karampelas
added a comment - I am expecting a solution fix for an already installed v7.0.7 which will not require migration or rollback (both unaccepted).
Vassilis Karampelas
added a comment - I am expecting a solution fix for an already installed v7.0.7 which will not require migration or rollback (both unaccepted). Feeling encouraged by Ruth's experience, I went ahead and installed PostgreSQL 9.3 and the latest PostgreSQL JDBC 4.2 connector, and proceeded to switch databases from MySQL to PostgreSQL.
The XML backup from within JIRA Software 7.0.7 succeeded despite the other JIRA 7.0.7 errors I had under MySQL.
The Atlassian procedures for switching/configuring databases are not very clear about how to assign PostgreSQL database permissions to the 'jira' user, or the need to reconfigure pg_hba.conf so database connections can be established properly with user ID and password. But I finally got the TEST DATABASE CONNECTION (in the Setup Wizard) to succeed, and proceeded to import my XML backup into PostgreSQL without a hitch.
But I still couldn't create issues, without getting a Jimmy Page inspired "Communications Breakdown" dialog. Adding a comment to an existing issue results in an Error 500, though the comment does get saved.
With Atlassian Support's help, we determined that the Autowatch Jira plug-in was incompatible (it is only intended for Cloud installations, according to the Support Rep). So I uninstalled this plug-in. It then took a restart of JIRA before JIRA 7.0.7 would run properly with PostgreSQL 9.3.
Similar problem with the same stacktrace after upgrading from JIRA Core 7.0.4 to JIRA Core 7.0.7 and following licence update (JIRA -> JIRA Core).
Problem 1
When trying to change assignee in issue, I see a pop-up window "The JIRA server was contacted but has returned an error response. We are unsure of the result of this operation."
Problem 2
When trying to use username in comment (via "@Mom") — JIRA server can't find users and I see the notice "Found no matching users for Mom"
/rest/api/latest/user/assignable/search [c.a.j.rest.exception.ExceptionInterceptor]
Returning internal server error in response
java.lang.reflect.InvocationTargetException
...
Caused by: 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@7579a8ea 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.)
JIRA 7.0.7
MySQL Server 5.6.27
Ubuntu 14.04.3 LTS
Workaround: Restart JIRA every 1 hour:
sudo service jira stop
sudo service jira start
Steven Ireland
added a comment - Thanks Ruth ... I needed a warm and fuzzy today. Ruth Cheesley
added a comment - Folks I have just migrated to Postgresql following the instructions provided, and I can confirm that the bugs we were experiencing are now gone, and we can add issues, assign them to users etc.
It was a bit of grunt work to migrate, but the instructions were clear and once done, the whole instance started working again (and I stopped getting yelled at!) so might be an option. We went for v9.3 per the compatibility docs.
Rollback wasn't an option for us either because our team had been actively working on stuff since the backup was taken.
Ruth Cheesley
added a comment - Folks I have just migrated to Postgresql following the instructions provided, and I can confirm that the bugs we were experiencing are now gone, and we can add issues, assign them to users etc.
It was a bit of grunt work to migrate, but the instructions were clear and once done, the whole instance started working again (and I stopped getting yelled at!) so might be an option. We went for v9.3 per the compatibility docs.
Rollback wasn't an option for us either because our team had been actively working on stuff since the backup was taken. The Downgrade Instructions provided in this issue are not clear. Presently I am waiting for Atlassian Support to call me back for assistance, but if anyone can clarify the downgrade procedures in the meantime, that would assist me greatly, and help get bring my production system back online sooner.
Specifically, the "migration" of user-installed plug-ins, mentioned in Step 5.3, would require logging into JIRA 7.0.5 and installing the plug-ins via the add-on manager (otherwise they might not be compatible with 7.0.5). This, in turn, would require starting JIRA 7.0.5; however, the procedure above mentions starting 7.0.5 only at Step 7, and does not mention the need to stop JIRA 7.0.5 after migrating add-ons. And I do not know if it is OK to start JIRA 7.0.5 for the first time without the flag -Djira.downgrade.allowed=true.
So I am wondering: should add-ons be installed into 7.0.5 after Step 7? If not, the sub-steps within Step 5 need to be expanded to indicate (a) when to start JIRA 7.0.5, (b) whether to include flag -Djira.downgrade.allowed=true when starting, and (c) when to stop JIRA 7.0.5. If there is some other way to migrate the user-installed plug-ins without starting JIRA 7.0.5, please provide details.
Thanks.
Steven Ireland
added a comment - Unfortunately, I also upgraded to 7.0.7 this weekend, and we too started encountering this error. But so far the errors are sporadic. At this point It doesn't appear to be a showstopper for us, just very obnoxious. When it goes beyond obnoxious we will probably follow the instructions to switch to a new database platform, but until then we will hope for quick delivery of a new release that resolves the issue - AND that it will be something that we can upgrade to from 7.07.
Steven Ireland
added a comment - Unfortunately, I also upgraded to 7.0.7 this weekend, and we too started encountering this error. But so far the errors are sporadic. At this point It doesn't appear to be a showstopper for us, just very obnoxious. When it goes beyond obnoxious we will probably follow the instructions to switch to a new database platform, but until then we will hope for quick delivery of a new release that resolves the issue - AND that it will be something that we can upgrade to from 7.07. We performed an update towards the end of last week and everything seemed to be working all ok. Today I am received a few errors and investigated. The database has since been update with new information and restoring from a backup from 4 days ago (Friday Morning) is not practical solution. What options are available in this situation?
Paul Hunter
added a comment - - edited We performed an update towards the end of last week and everything seemed to be working all ok. Today I am received a few errors and investigated. The database has since been update with new information and restoring from a backup from 4 days ago (Friday Morning) is not practical solution. What options are available in this situation? Ruth Cheesley
added a comment - We're running on MySQL and while we have some weird behaviour it didn't make Jira fall over entirely, it's still mostly functional at present. Main bugs we are seeing is that we can't assign issues to users, which I've raised an issue including logs about. Happy to help with troubleshooting if that would be helpful.
Ruth Cheesley
added a comment - We're running on MySQL and while we have some weird behaviour it didn't make Jira fall over entirely, it's still mostly functional at present. Main bugs we are seeing is that we can't assign issues to users, which I've raised an issue including logs about. Happy to help with troubleshooting if that would be helpful. Vassilis Karampelas
added a comment - Affected also,
Can I just downgrade an already affected installation?
Vassilis Karampelas
added a comment - Affected also,
Can I just downgrade an already affected installation?
Hey michael.litwak,
Other MySQL versions will be affected by the bug, but you could follow steps in Switching databases to any other Supported platform to get around this issue.
At this stage, the issue reported is exclusive to MySQL database.
Edit I should add that we've pulled JIRA 7.0.7 for now from the available downloads and you should rollback or downgrade at this time.
The remedy for those like me who have upgraded to JIRA 7.0.7 is to either roll back the upgrade, or downgrade to JIRA 7.0.5.
I wonder if downgrading MySQL to 5.5 – or migration to PostGreSQL – would be an easier approach to take. I'll check with Atlassian Support, but if anyone knows whether these are valid remedies, please post here.
Thanks.
Same issue here.
I just upgraded Linux on my JIRA server (an AWS instance) to Amazon Linux AMI 2015.09, specifically so I could upgrade MySQL from 5.5 to 5.6. Both the Linux and MySQL 5.6 upgrades went well. Then I upgraded from JIRA 6.3 to JIRA Software 7.0.7. Now half my users cannot even login, because the Google SSO for JIRA add-on (from AppFusions, which lets users login to JIRA using their Google accounts) throws an error when attempting to login to JIRA, with a nearly identical stack trace (at least at the beginning):
--------------------------------------------------------------------------------------------------
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@38d857e8 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)
at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore$EntryLoader.load(CachingOfBizPropertyEntryStore.java:429)
at com.atlassian.cache.memory.MemoryCacheManager$3$1.load(MemoryCacheManager.java:132)
at com.atlassian.cache.memory.BlockingCacheLoader.load(BlockingCacheLoader.java:51)
. . .
Giovanni Renzi Brivio
added a comment - Same problem here:
trying to fresh install Jira on ubuntu 14.04 LTS, Mysql Server version: 5.5.46-0ubuntu0.14.04.2
[o.a.c.c.C.[.[localhost].[/].[action]] Servlet.service() for servlet [action] in context with path [] threw exception [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@2f95c7cc 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
Impossible to install
Giovanni Renzi Brivio
added a comment - Same problem here:
trying to fresh install Jira on ubuntu 14.04 LTS, Mysql Server version: 5.5.46-0ubuntu0.14.04.2
[o.a.c.c.C.[. [localhost] . [/] . [action] ] Servlet.service() for servlet [action] in context with path [] threw exception [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@2f95c7cc 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
Impossible to install andre@finalist.com, we would suggest you restore from a backup.
I have the same issue, can we downgrade from 7.0.7 to 7.0.4 (didn't have this issue), or should I restore from a backup ?
I can confirm this bug, too. I migrated from an older version of JIRA and now I am unable to browse the User Management and Applications admin sites. It throws the mentioned exception.
I have the same issue
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@2cbbb98f 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.)
This also happens when entering User management. So far only resetting the jira instance helped. If there are any other solutions which don't require restart i will be happy to hear about them.
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].