com.atlassian.crowd.embedded.ofbiz.db.DataAccessException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • When attempting several concurrent logins with the same username we get this error in MySQL 5.0: {noformat} 2011-11-28 20:34:30,245 http-8080-36 ERROR [500ErrorPage.jsp] Exception caught in 500 page org.ofbiz.core.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByAnd (SQL Exception while executing the following:DELETE FROM cwd_user_attributes WHERE user_id=? AND attribute_name=? (Deadlock found when trying to get lock; try restarting transaction)) com.atlassian.crowd.embedded.ofbiz.db.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByAnd (SQL Exception while executing the following:DELETE FROM cwd_user_attributes WHERE user_id=? AND attribute_name=? (Deadlock found when trying to get lock; try restarting transaction)) at com.atlassian.crowd.embedded.ofbiz.db.OfBizHelper.removeByAnd(OfBizHelper.java:130) at com.atlassian.crowd.embedded.ofbiz.OfBizUserDao.removeAttribute(OfBizUserDao.java:335) at com.atlassian.crowd.embedded.ofbiz.OfBizUserDao.storeAttributes(OfBizUserDao.java:248) at com.atlassian.crowd.directory.AbstractInternalDirectory.storeUserAttributes(AbstractInternalDirectory.java:536) at com.atlassian.crowd.manager.directory.DirectoryManagerGeneric.storeUserAttributes(DirectoryManagerGeneric.java:388) at com.atlassian.crowd.manager.application.ApplicationServiceGeneric.storeUserAttributes(ApplicationServiceGeneric.java:529) at com.atlassian.crowd.embedded.core.CrowdServiceImpl.setUserAttribute(CrowdServiceImpl.java:375) at com.atlassian.crowd.embedded.core.CrowdServiceImpl.setUserAttribute(CrowdServiceImpl.java:363) at com.atlassian.crowd.embedded.core.DelegatingCrowdService.setUserAttribute(DelegatingCrowdService.java:100) at com.atlassian.crowd.embedded.core.FilteredCrowdServiceImpl.setUserAttribute(FilteredCrowdServiceImpl.java:43) at com.atlassian.jira.security.login.LoginStoreImpl.setLong(LoginStoreImpl.java:136) at com.atlassian.jira.security.login.LoginStoreImpl.recordLoginAttempt(LoginStoreImpl.java:64) at com.atlassian.jira.security.login.LoginManagerImpl.recordLoginAttempt(LoginManagerImpl.java:321) at com.atlassian.jira.security.login.LoginManagerImpl.onLoginAttempt(LoginManagerImpl.java:203) at com.atlassian.jira.security.login.JiraElevatedSecurityGuard.onSuccessfulLoginAttempt(JiraElevatedSecurityGuard.java:34) at com.atlassian.seraph.filter.PasswordBasedLoginFilter.runAuthentication(PasswordBasedLoginFilter.java:136) at com.atlassian.seraph.filter.PasswordBasedLoginFilter.login(PasswordBasedLoginFilter.java:72) at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:130) at com.atlassian.jira.web.filters.JiraLoginFilter.doFilter(JiraLoginFilter.java:70) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter(OAuthFilter.java:71) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.atlassian.plugins.rest.module.servlet.RestSeraphFilter.doFilter(RestSeraphFilter.java:40) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:71) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:81) at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.atlassian.jira.dev.backdoor.SlowMotionFilter.doFilter(SlowMotionFilter.java:54) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.sysbliss.jira.plugins.workflow.servlet.JWDSendRedirectFilter.doFilter(JWDSendRedirectFilter.java:25) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:78) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.cache.AbstractCachingFilter.doFilter(AbstractCachingFilter.java:33) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:41) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at com.atlassian.jira.web.filters.PathMatchingEncodingFilter.doFilter(PathMatchingEncodingFilter.java:45) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.monitor.ActiveRequestsFilter$PassToChainFilterFunc.doFilter(ActiveRequestsFilter.java:346) at com.atlassian.jira.web.monitor.ActiveRequestsFilter$DebugLogFilterFunc.doFilter(ActiveRequestsFilter.java:463) at com.atlassian.jira.web.monitor.ActiveRequestsFilter.doFilter(ActiveRequestsFilter.java:173) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.startup.JiraStartupChecklistFilter.doFilter(JiraStartupChecklistFilter.java:75) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.multitenant.servlet.MultiTenantServletFilter.doFilter(MultiTenantServletFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:78) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:554) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) Caused by: org.ofbiz.core.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByAnd (SQL Exception while executing the following:DELETE FROM cwd_user_attributes WHERE user_id=? AND attribute_name=? (Deadlock found when trying to get lock; try restarting transaction)) at org.ofbiz.core.entity.GenericDAO.deleteByAnd(GenericDAO.java:1218) at org.ofbiz.core.entity.GenericHelperDAO.removeByAnd(GenericHelperDAO.java:193) at org.ofbiz.core.entity.GenericDelegator.removeByAnd(GenericDelegator.java:1101) at org.ofbiz.core.entity.GenericDelegator.removeByAnd(GenericDelegator.java:1076) at sun.reflect.GeneratedMethodAccessor179.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.atlassian.multitenant.impl.MultiTenantComponentFactoryImpl$AbstractMultiTenantAwareInvocationHandler.invokeInternal(MultiTenantComponentFactoryImpl.java:181) at com.atlassian.multitenant.impl.MultiTenantComponentFactoryImpl$MultiTenantAwareMethodInterceptor.intercept(MultiTenantComponentFactoryImpl.java:230) at org.ofbiz.core.entity.GenericDelegator$$EnhancerByCGLIB$$33278696.removeByAnd(<generated>) at com.atlassian.crowd.embedded.ofbiz.db.OfBizHelper.removeByAnd(OfBizHelper.java:126) ... 95 more {noformat} This could potentially happen in other databases as well. There's actually 2 stacktraces that get thrown in the log. First it will throw this: {noformat}2012-07-26 11:02:02,297 http-8080-22 WARN anonymous 662x119619x6 - 127.0.0.1 /rest/api/latest/search [NoModule] org.ofbiz.core.entity.jdbc.SQLProcessor com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Can't call rollback when autocommit=true at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source){noformat} Followed by the stacktrace above.
    via by Luis Miranda,
  • When attempting several concurrent logins with the same username we get this error in MySQL 5.0: {noformat} 2011-11-28 20:34:30,245 http-8080-36 ERROR [500ErrorPage.jsp] Exception caught in 500 page org.ofbiz.core.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByAnd (SQL Exception while executing the following:DELETE FROM cwd_user_attributes WHERE user_id=? AND attribute_name=? (Deadlock found when trying to get lock; try restarting transaction)) com.atlassian.crowd.embedded.ofbiz.db.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByAnd (SQL Exception while executing the following:DELETE FROM cwd_user_attributes WHERE user_id=? AND attribute_name=? (Deadlock found when trying to get lock; try restarting transaction)) at com.atlassian.crowd.embedded.ofbiz.db.OfBizHelper.removeByAnd(OfBizHelper.java:130) at com.atlassian.crowd.embedded.ofbiz.OfBizUserDao.removeAttribute(OfBizUserDao.java:335) at com.atlassian.crowd.embedded.ofbiz.OfBizUserDao.storeAttributes(OfBizUserDao.java:248) at com.atlassian.crowd.directory.AbstractInternalDirectory.storeUserAttributes(AbstractInternalDirectory.java:536) at com.atlassian.crowd.manager.directory.DirectoryManagerGeneric.storeUserAttributes(DirectoryManagerGeneric.java:388) at com.atlassian.crowd.manager.application.ApplicationServiceGeneric.storeUserAttributes(ApplicationServiceGeneric.java:529) at com.atlassian.crowd.embedded.core.CrowdServiceImpl.setUserAttribute(CrowdServiceImpl.java:375) at com.atlassian.crowd.embedded.core.CrowdServiceImpl.setUserAttribute(CrowdServiceImpl.java:363) at com.atlassian.crowd.embedded.core.DelegatingCrowdService.setUserAttribute(DelegatingCrowdService.java:100) at com.atlassian.crowd.embedded.core.FilteredCrowdServiceImpl.setUserAttribute(FilteredCrowdServiceImpl.java:43) at com.atlassian.jira.security.login.LoginStoreImpl.setLong(LoginStoreImpl.java:136) at com.atlassian.jira.security.login.LoginStoreImpl.recordLoginAttempt(LoginStoreImpl.java:64) at com.atlassian.jira.security.login.LoginManagerImpl.recordLoginAttempt(LoginManagerImpl.java:321) at com.atlassian.jira.security.login.LoginManagerImpl.onLoginAttempt(LoginManagerImpl.java:203) at com.atlassian.jira.security.login.JiraElevatedSecurityGuard.onSuccessfulLoginAttempt(JiraElevatedSecurityGuard.java:34) at com.atlassian.seraph.filter.PasswordBasedLoginFilter.runAuthentication(PasswordBasedLoginFilter.java:136) at com.atlassian.seraph.filter.PasswordBasedLoginFilter.login(PasswordBasedLoginFilter.java:72) at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:130) at com.atlassian.jira.web.filters.JiraLoginFilter.doFilter(JiraLoginFilter.java:70) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter(OAuthFilter.java:71) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.atlassian.plugins.rest.module.servlet.RestSeraphFilter.doFilter(RestSeraphFilter.java:40) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:71) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:81) at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.atlassian.jira.dev.backdoor.SlowMotionFilter.doFilter(SlowMotionFilter.java:54) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.sysbliss.jira.plugins.workflow.servlet.JWDSendRedirectFilter.doFilter(JWDSendRedirectFilter.java:25) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:78) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.cache.AbstractCachingFilter.doFilter(AbstractCachingFilter.java:33) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:41) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at com.atlassian.jira.web.filters.PathMatchingEncodingFilter.doFilter(PathMatchingEncodingFilter.java:45) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.monitor.ActiveRequestsFilter$PassToChainFilterFunc.doFilter(ActiveRequestsFilter.java:346) at com.atlassian.jira.web.monitor.ActiveRequestsFilter$DebugLogFilterFunc.doFilter(ActiveRequestsFilter.java:463) at com.atlassian.jira.web.monitor.ActiveRequestsFilter.doFilter(ActiveRequestsFilter.java:173) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.startup.JiraStartupChecklistFilter.doFilter(JiraStartupChecklistFilter.java:75) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.multitenant.servlet.MultiTenantServletFilter.doFilter(MultiTenantServletFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:78) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:554) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) Caused by: org.ofbiz.core.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByAnd (SQL Exception while executing the following:DELETE FROM cwd_user_attributes WHERE user_id=? AND attribute_name=? (Deadlock found when trying to get lock; try restarting transaction)) at org.ofbiz.core.entity.GenericDAO.deleteByAnd(GenericDAO.java:1218) at org.ofbiz.core.entity.GenericHelperDAO.removeByAnd(GenericHelperDAO.java:193) at org.ofbiz.core.entity.GenericDelegator.removeByAnd(GenericDelegator.java:1101) at org.ofbiz.core.entity.GenericDelegator.removeByAnd(GenericDelegator.java:1076) at sun.reflect.GeneratedMethodAccessor179.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.atlassian.multitenant.impl.MultiTenantComponentFactoryImpl$AbstractMultiTenantAwareInvocationHandler.invokeInternal(MultiTenantComponentFactoryImpl.java:181) at com.atlassian.multitenant.impl.MultiTenantComponentFactoryImpl$MultiTenantAwareMethodInterceptor.intercept(MultiTenantComponentFactoryImpl.java:230) at org.ofbiz.core.entity.GenericDelegator$$EnhancerByCGLIB$$33278696.removeByAnd(<generated>) at com.atlassian.crowd.embedded.ofbiz.db.OfBizHelper.removeByAnd(OfBizHelper.java:126) ... 95 more {noformat} This could potentially happen in other databases as well. There's actually 2 stacktraces that get thrown in the log. First it will throw this: {noformat}2012-07-26 11:02:02,297 http-8080-22 WARN anonymous 662x119619x6 - 127.0.0.1 /rest/api/latest/search [NoModule] org.ofbiz.core.entity.jdbc.SQLProcessor com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Can't call rollback when autocommit=true at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source){noformat} Followed by the stacktrace above.
    via by Luis Miranda,
  • Just try to assign a label to a bug in JIRA and you'll get: System Error A system error has occurred. If this problem persists - please notify your JIRA administrator of this problem. Otherwise, please create a support issue on our support system at http://support.atlassian.com with the following information: a description of your problem cut & paste the error and system information found below Cause: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByAnd (SQL Exception while executing the following:DELETE FROM label WHERE FIELDID IS NULL AND ISSUE=? (Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT')) Stack Trace: [hide] com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByAnd (SQL Exception while executing the following:DELETE FROM label WHERE FIELDID IS NULL AND ISSUE=? (Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT')) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.removeByAnd(DefaultOfBizDelegator.java:294) at com.atlassian.jira.issue.label.OfBizLabelStore.setLabels(OfBizLabelStore.java:68) at com.atlassian.jira.issue.label.CachingLabelStore$2.get(CachingLabelStore.java:71) at com.atlassian.jira.issue.label.CachingLabelStore$2.get(CachingLabelStore.java:68) at com.atlassian.util.concurrent.ManagedLocks$ManagedLockImpl.withLock(ManagedLocks.java:304) at com.atlassian.jira.issue.label.CachingLabelStore.setLabels(CachingLabelStore.java:67) at com.atlassian.jira.issue.label.DefaultLabelManager.setIfNotEqual(DefaultLabelManager.java:132) at com.atlassian.jira.issue.label.DefaultLabelManager.setLabels(DefaultLabelManager.java:83) at com.atlassian.jira.bc.issue.label.DefaultLabelService.setLabels(DefaultLabelService.java:128) at com.atlassian.jira.web.action.issue.EditLabels.doExecute(EditLabels.java:152) at webwork.action.ActionSupport.execute(ActionSupport.java:165) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:54) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:139) at com.atlassian.jira.web.dispatcher.JiraWebworkActionDispatcher.service(JiraWebworkActionDispatcher.java:168) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.JiraLastFilter.doFilter(JiraLastFilter.java:69) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.HeaderSanitisingFilter.doFilter(HeaderSanitisingFilter.java:44) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.accesslog.AccessLogFilter.executeRequest(AccessLogFilter.java:102) at com.atlassian.jira.web.filters.accesslog.AccessLogFilter.doFilter(AccessLogFilter.java:86) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.security.xsrf.XsrfTokenAdditionRequestFilter.doFilter(XsrfTokenAdditionRequestFilter.java:50) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55) at com.atlassian.jira.web.filters.PathExclusionFilter.doFilter(PathExclusionFilter.java:118) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:213) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:142) at com.atlassian.jira.web.filters.JiraLoginFilter.doFilter(JiraLoginFilter.java:70) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter(OAuthFilter.java:69) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:99) at com.atlassian.jira.web.filters.JIRAProfilingFilter.doFilter(JIRAProfilingFilter.java:16) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:59) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.RequestCleanupFilter.doFilter(RequestCleanupFilter.java:53) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:81) at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.cache.AbstractCachingFilter.doFilter(AbstractCachingFilter.java:33) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:41) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at com.atlassian.jira.web.filters.PathMatchingEncodingFilter.doFilter(PathMatchingEncodingFilter.java:49) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.startup.JiraStartupChecklistFilter.doFilter(JiraStartupChecklistFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.JiraFirstFilter.doFilter(JiraFirstFilter.java:65) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:567) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454) at java.lang.Thread.run(Thread.java:662) Caused by: org.ofbiz.core.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByAnd (SQL Exception while executing the following:DELETE FROM label WHERE FIELDID IS NULL AND ISSUE=? (Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT')) at org.ofbiz.core.entity.GenericDAO.deleteByAnd(GenericDAO.java:1242) at org.ofbiz.core.entity.GenericHelperDAO.removeByAnd(GenericHelperDAO.java:196) at org.ofbiz.core.entity.GenericDelegator.removeByAnd(GenericDelegator.java:1107) at org.ofbiz.core.entity.GenericDelegator.removeByAnd(GenericDelegator.java:1082) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.removeByAnd(DefaultOfBizDelegator.java:290) ... 118 more Referer URL: https://issues.jenkins-ci.org/browse/JENKINS-9241 Build Information: Uptime : N/A Edition : enterprise Version : 4.2.2-b589 Build Number : 589 Build Date : Wed Dec 22 00:00:00 UTC 2010 Atlassian Partner : null Installation Type : Standalone Server ID : Contact your Administrator to discover this property value. Last Upgrade : 28/Jan/11 7:51 AM (v4.0.0-rc1#439) Server Information: Application Server: Apache Tomcat/6.0.20 Servlet Version: 2.5 File Paths: Contact your System Administrator to discover file path information. Memory Information: Total Memory: 455 MB Free Memory: 136 MB Used Memory: 319 MB Total PermGen Memory: 192 MB Free PermGen Memory: 78 MB Used PermGen Memory: 113 MB System Information: System Date : Monday, 04 Apr 2011 System Time : 13:20:43 +0000 Current Working Directory : Contact your System Administrator to discover this property value. Java Version : 1.6.0_24 Java Vendor : Sun Microsystems Inc. JVM Version : 1.0 JVM Vendor : Sun Microsystems Inc. JVM Implementation Version : 19.1-b02 Java Runtime : Java(TM) SE Runtime Environment Java VM : Java HotSpot(TM) 64-Bit Server VM User Name : jira User Timezone : Etc/UTC User Locale : English (United States) System Encoding : UTF-8 Operating System : Linux 2.6.35-24-virtual OS Architecture : amd64 Application Server Container : Database type : mysql Database JNDI address : java:comp/env/jdbc/JiraDS Database URL : Hidden Database version : 5.1.50-MariaDB-log Database driver : MySQL-AB JDBC Driver mysql-connector-java-5.1.10 ( Revision: ${svn.Revision} ) External user management : OFF Crowd integration : OFF JVM Input Arguments : Contact your System Administrator to discover this property value. Language Info: Installed languages: Catalan (Spain) Chinese (China) Chinese (Taiwan) Czech (Czech Republic) Danish (Denmark) Dutch (Belgium) English (UK) English (United States) French (France) German (Germany) German (Switzerland) Hungarian (Hungary) Italian (Italy) Japanese (Japan) Norwegian (Norway) Polish (Poland) Portuguese (Brazil) Russian (Russia) Slovak (Slovakia) Spanish (Spain) Turkish (Turkey) Default language: English (United States) - System Default Request Information: - Request URL: https://issues.jenkins-ci.org/500page.jsp - Scheme: https - Server: issues.jenkins-ci.org - Port: 443 - URI: /500page.jsp - Context Path: - - Servlet Path: /500page.jsp - - Path Info: null - - Query String: atl_token=3c3d3cc5d359da2d1147bac3a838f8bb9785c3d8 Request Attributes - javax.servlet.forward.request_uri : /secure/EditLabels.jspa - javax.servlet.forward.context_path : - javax.servlet.forward.servlet_path : /secure/EditLabels.jspa - javax.servlet.forward.path_info : /500page.jsp - javax.servlet.forward.query_string : atl_token=3c3d3cc5d359da2d1147bac3a838f8bb9785c3d8 - os_securityfilter_already_filtered : true - jira.session.max.inactive.interval : 18000 - jira.request.time.micros : 0 - atlassian.core.seraph.original.url : /secure/EditLabels.jspa?atl_token=3c3d3cc5d359da2d1147bac3a838f8bb9785c3d8 - com.atlassian.jira.web.filters.JiraLastFilter_already_filtered : true - javax.servlet.error.servlet_name : action - com.atlassian.gzipfilter.GzipFilter_already_filtered : true - com.atlassian.jira.web.filters.JiraFirstFilter_already_filtered : true - loginfilter.already.filtered : true - com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true - jira.webwork.generic.dispatcher : webwork.dispatcher.GenericDispatcher@445f3802 - com.atlassian.jira.web.filters.accesslog.AccessLogFilter_already_filtered : true - javax.servlet.error.message : - jira.session.last.accessed.time : 1301923239853 - webwork.result : Value stack =========== =========== - jira.request.username : ssbarnea - com.atlassian.jira.web.filters.RequestCleanupFilter_already_filtered : true - javax.servlet.error.request_uri : /secure/EditLabels.jspa - com.atlassian.jira.security.xsrf.XsrfTokenAdditionRequestFilter_already_filtered : true - com.atlassian.seraph.auth.LoginReason : OK - jira.webwork.cleanup : false - jira.request.id : 800x56288x1 - javax.servlet.error.status_code : 500 - jira.request.start.millis : 1301923242983 - com.atlassian.jira.web.filters.ActionCleanupDelayFilter : true - com.atlassian.jira.web.filters.accesslog.AccessLogRequestInfoexit.called : true - com.atlassian.core.filters.HeaderSanitisingFilter_already_filtered : true - jira.request.assession.id : 1waaxyq - __sitemesh__filterapplied : true - javax.servlet.error.exception : javax.servlet.ServletException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByAnd (SQL Exception while executing the following:DELETE FROM label WHERE FIELDID IS NULL AND ISSUE=? (Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT')) Request Logging 0 log statements generated by this request: Listeners - Issue Cache Listener (com.atlassian.jira.event.listeners.cache.IssueCacheListener) - Issue Index Listener (com.atlassian.jira.event.listeners.search.IssueIndexListener) - Mail Listener (com.atlassian.jira.event.listeners.mail.MailListener) Services - Backup Service (com.atlassian.jira.service.services.export.ExportService) - Delay: 720 minutes - Mail Queue Service (com.atlassian.jira.service.services.mail.MailQueueService) - Delay: 1 minutes - Service Provider Token Remover (com.atlassian.sal.jira.scheduling.JiraPluginSchedulerService) - Delay: 480 minutes Plugins - Admin Menu Sections 1.0 - Plugin by Atlassian - Enabled - Apache HttpClient OSGi bundle 4.0 - Plugin by Apache Software Foundation - Enabled - Apache HttpCore OSGi bundle 4.0 - Plugin by Apache Software Foundation - Enabled - Atlassian Gadgets OAuth Service Provider Plugin 1.1.5.6 - Plugin by Atlassian - Enabled - Atlassian OAuth Admin Plugin 1.0.12 - Plugin by Atlassian - Enabled - Atlassian OAuth Consumer Plugin 1.0.12 - Plugin by Atlassian - Enabled - Atlassian OAuth Consumer SPI 1.0.12 - Plugin by Atlassian - Enabled - Atlassian OAuth Service Provider Plugin 1.0.12 - Plugin by Atlassian - Enabled - Atlassian OAuth Service Provider SPI 1.0.12 - Plugin by Atlassian - Enabled - Atlassian REST - Module Types 2.1.0 - Plugin by Atlassian - Enabled - Atlassian Template Renderer API 1.1.1 - Plugin by Atlassian - Enabled - Atlassian Template Renderer Velocity 1.6 Plugin 1.1.1 - Plugin by Atlassian - Enabled - Atlassian UI Plugin 3.0.9 - Plugin by Atlassian Pty Ltd - Enabled - BND Library 0.0.255 - Plugin by aQute SARL http://www.aQute.biz - Enabled - Content Link Resolvers Plugin 1.0 - Plugin by Atlassian - Enabled - Custom Field Types & Searchers 1.0 - Plugin by Atlassian - Enabled - Embedded Gadgets Plugin 1.1.5.6 - Plugin by Atlassian - Enabled - FishEye Plugin 3.0.22 - Plugin by Atlassian Software Systems - Enabled - Gadget Dashboard Plugin 1.1.5.6 - Plugin by Atlassian - Enabled - Gadget Directory Plugin 1.1.5.6 - Plugin by Atlassian - Enabled - Gadget Renderer Plugin 1.1.5.6 - Plugin by Atlassian - Enabled - Gadget Spec Publisher Plugin 1.1.5.6 - Plugin by Atlassian - Enabled - ICU4J 3.8.0.1 - Plugin by Atlassian Pty Ltd - Enabled - Issue Operations Plugin 1.0 - Plugin by Atlassian - Enabled - Issue Tab Panels Plugin 1.0 - Plugin by Atlassian - Enabled - Issue Views Plugin 1.0 - Plugin by Atlassian - Enabled - JDOM DOM Processor 1.0.0 - Plugin by SpringSource - Enabled - JIRA Activity Stream Plugin 3.0.21 - Plugin by Atlassian - Enabled - JIRA Bamboo Plugin 4.1.3 - Plugin by Atlassian Software Systems Pty Ltd - Enabled - JIRA Footer 1.0 - Plugin by Atlassian - Enabled - JIRA Gadgets Plugin 4.2.2-b589 - Plugin by Atlassian - Enabled - JIRA Importers Plugin (JIM) 1.4 - Plugin by Atlassian - Enabled - JIRA OAuth Consumer SPI Plugin 4.2.2-b589 - Plugin by Atlassian - Enabled - JIRA OAuth Service Provider SPI Plugin 4.2.2-b589 - Plugin by Atlassian - Enabled - JIRA REST Plugin 4.2.2-b589 - Plugin by Atlassian - Enabled - JIRA Shared Application Access Layer (SAL) Plugin 4.2.2-b589 - Plugin by Atlassian Software Systems - Enabled - JIRA Usage Hints 1.0 - Plugin by Atlassian - Enabled - JQL Functions 1.0 - Plugin by Atlassian - Enabled - JSON Library 20070829.0.0.1 - Plugin by Atlassian Pty Ltd - Enabled - Joda-Time 1.6 - Plugin by - Enabled - Keyboard Shortcuts Plugin 1.0 - Plugin by Atlassian - Enabled - Neko HTML 1.9.12.1 - Plugin by Atlassian Pty Ltd - Enabled - Portlets Plugin 1.0 - Plugin by Atlassian - Enabled - Preset Filters Sections 1.0 - Plugin by Atlassian - Enabled - Project Panels Plugin 1.0 - Plugin by Atlassian - Enabled - Project Role Actors Plugin 1.0 - Plugin by Atlassian - Enabled - ROME, RSS and atOM utilitiEs for Java 1.0 - Plugin by Sun Microsystems - Enabled - ROME: RSS/Atom syndication and publishing tools 0.9.0 - Plugin by SpringSource - Enabled - RPC JIRA Plugin 4.2.2-b589 - Plugin by Atlassian - Enabled - Renderer Component Factories Plugin 1.0 - Plugin by Atlassian - Enabled - Renderer Plugin 1.0 - Plugin by Atlassian - Enabled - Reports Plugin 1.0 - Plugin by Atlassian - Enabled - Shared Application Access Layer API 2.1.0 - Plugin by Atlassian - Enabled - Top Navigation Bar 1.0 - Plugin by Atlassian - Enabled - User Format 1.0 - Plugin by Atlassian - Enabled - User Navigation Bar Sections 1.0 - Plugin by Atlassian - Enabled - User Profile Links 1.0 - Plugin by Atlassian - Enabled - User Profile Panels 1.0 - Plugin by Atlassian - Enabled - View Project Operations Sections 1.0 - Plugin by Atlassian - Enabled - Web Resources Plugin 1.0 - Plugin by Atlassian - Enabled - Webwork Plugin 1.0 - Plugin by Atlassian - Enabled - Wiki Renderer Macros Plugin 1.0 - Plugin by Atlassian - Enabled - Workflow Plugin 1.0 - Plugin by Atlassian - Enabled
    via by Sorin Sbarnea,
  • Just try to assign a label to a bug in JIRA and you'll get: System Error A system error has occurred. If this problem persists - please notify your JIRA administrator of this problem. Otherwise, please create a support issue on our support system at http://support.atlassian.com with the following information: a description of your problem cut & paste the error and system information found below Cause: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByAnd (SQL Exception while executing the following:DELETE FROM label WHERE FIELDID IS NULL AND ISSUE=? (Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT')) Stack Trace: [hide] com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByAnd (SQL Exception while executing the following:DELETE FROM label WHERE FIELDID IS NULL AND ISSUE=? (Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT')) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.removeByAnd(DefaultOfBizDelegator.java:294) at com.atlassian.jira.issue.label.OfBizLabelStore.setLabels(OfBizLabelStore.java:68) at com.atlassian.jira.issue.label.CachingLabelStore$2.get(CachingLabelStore.java:71) at com.atlassian.jira.issue.label.CachingLabelStore$2.get(CachingLabelStore.java:68) at com.atlassian.util.concurrent.ManagedLocks$ManagedLockImpl.withLock(ManagedLocks.java:304) at com.atlassian.jira.issue.label.CachingLabelStore.setLabels(CachingLabelStore.java:67) at com.atlassian.jira.issue.label.DefaultLabelManager.setIfNotEqual(DefaultLabelManager.java:132) at com.atlassian.jira.issue.label.DefaultLabelManager.setLabels(DefaultLabelManager.java:83) at com.atlassian.jira.bc.issue.label.DefaultLabelService.setLabels(DefaultLabelService.java:128) at com.atlassian.jira.web.action.issue.EditLabels.doExecute(EditLabels.java:152) at webwork.action.ActionSupport.execute(ActionSupport.java:165) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:54) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:139) at com.atlassian.jira.web.dispatcher.JiraWebworkActionDispatcher.service(JiraWebworkActionDispatcher.java:168) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.JiraLastFilter.doFilter(JiraLastFilter.java:69) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.HeaderSanitisingFilter.doFilter(HeaderSanitisingFilter.java:44) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.accesslog.AccessLogFilter.executeRequest(AccessLogFilter.java:102) at com.atlassian.jira.web.filters.accesslog.AccessLogFilter.doFilter(AccessLogFilter.java:86) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.security.xsrf.XsrfTokenAdditionRequestFilter.doFilter(XsrfTokenAdditionRequestFilter.java:50) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55) at com.atlassian.jira.web.filters.PathExclusionFilter.doFilter(PathExclusionFilter.java:118) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:213) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:142) at com.atlassian.jira.web.filters.JiraLoginFilter.doFilter(JiraLoginFilter.java:70) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter(OAuthFilter.java:69) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:99) at com.atlassian.jira.web.filters.JIRAProfilingFilter.doFilter(JIRAProfilingFilter.java:16) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:59) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.RequestCleanupFilter.doFilter(RequestCleanupFilter.java:53) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:81) at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.cache.AbstractCachingFilter.doFilter(AbstractCachingFilter.java:33) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:41) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at com.atlassian.jira.web.filters.PathMatchingEncodingFilter.doFilter(PathMatchingEncodingFilter.java:49) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.startup.JiraStartupChecklistFilter.doFilter(JiraStartupChecklistFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.JiraFirstFilter.doFilter(JiraFirstFilter.java:65) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:567) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454) at java.lang.Thread.run(Thread.java:662) Caused by: org.ofbiz.core.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByAnd (SQL Exception while executing the following:DELETE FROM label WHERE FIELDID IS NULL AND ISSUE=? (Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT')) at org.ofbiz.core.entity.GenericDAO.deleteByAnd(GenericDAO.java:1242) at org.ofbiz.core.entity.GenericHelperDAO.removeByAnd(GenericHelperDAO.java:196) at org.ofbiz.core.entity.GenericDelegator.removeByAnd(GenericDelegator.java:1107) at org.ofbiz.core.entity.GenericDelegator.removeByAnd(GenericDelegator.java:1082) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.removeByAnd(DefaultOfBizDelegator.java:290) ... 118 more Referer URL: https://issues.jenkins-ci.org/browse/JENKINS-9241 Build Information: Uptime : N/A Edition : enterprise Version : 4.2.2-b589 Build Number : 589 Build Date : Wed Dec 22 00:00:00 UTC 2010 Atlassian Partner : null Installation Type : Standalone Server ID : Contact your Administrator to discover this property value. Last Upgrade : 28/Jan/11 7:51 AM (v4.0.0-rc1#439) Server Information: Application Server: Apache Tomcat/6.0.20 Servlet Version: 2.5 File Paths: Contact your System Administrator to discover file path information. Memory Information: Total Memory: 455 MB Free Memory: 136 MB Used Memory: 319 MB Total PermGen Memory: 192 MB Free PermGen Memory: 78 MB Used PermGen Memory: 113 MB System Information: System Date : Monday, 04 Apr 2011 System Time : 13:20:43 +0000 Current Working Directory : Contact your System Administrator to discover this property value. Java Version : 1.6.0_24 Java Vendor : Sun Microsystems Inc. JVM Version : 1.0 JVM Vendor : Sun Microsystems Inc. JVM Implementation Version : 19.1-b02 Java Runtime : Java(TM) SE Runtime Environment Java VM : Java HotSpot(TM) 64-Bit Server VM User Name : jira User Timezone : Etc/UTC User Locale : English (United States) System Encoding : UTF-8 Operating System : Linux 2.6.35-24-virtual OS Architecture : amd64 Application Server Container : Database type : mysql Database JNDI address : java:comp/env/jdbc/JiraDS Database URL : Hidden Database version : 5.1.50-MariaDB-log Database driver : MySQL-AB JDBC Driver mysql-connector-java-5.1.10 ( Revision: ${svn.Revision} ) External user management : OFF Crowd integration : OFF JVM Input Arguments : Contact your System Administrator to discover this property value. Language Info: Installed languages: Catalan (Spain) Chinese (China) Chinese (Taiwan) Czech (Czech Republic) Danish (Denmark) Dutch (Belgium) English (UK) English (United States) French (France) German (Germany) German (Switzerland) Hungarian (Hungary) Italian (Italy) Japanese (Japan) Norwegian (Norway) Polish (Poland) Portuguese (Brazil) Russian (Russia) Slovak (Slovakia) Spanish (Spain) Turkish (Turkey) Default language: English (United States) - System Default Request Information: - Request URL: https://issues.jenkins-ci.org/500page.jsp - Scheme: https - Server: issues.jenkins-ci.org - Port: 443 - URI: /500page.jsp - Context Path: - - Servlet Path: /500page.jsp - - Path Info: null - - Query String: atl_token=3c3d3cc5d359da2d1147bac3a838f8bb9785c3d8 Request Attributes - javax.servlet.forward.request_uri : /secure/EditLabels.jspa - javax.servlet.forward.context_path : - javax.servlet.forward.servlet_path : /secure/EditLabels.jspa - javax.servlet.forward.path_info : /500page.jsp - javax.servlet.forward.query_string : atl_token=3c3d3cc5d359da2d1147bac3a838f8bb9785c3d8 - os_securityfilter_already_filtered : true - jira.session.max.inactive.interval : 18000 - jira.request.time.micros : 0 - atlassian.core.seraph.original.url : /secure/EditLabels.jspa?atl_token=3c3d3cc5d359da2d1147bac3a838f8bb9785c3d8 - com.atlassian.jira.web.filters.JiraLastFilter_already_filtered : true - javax.servlet.error.servlet_name : action - com.atlassian.gzipfilter.GzipFilter_already_filtered : true - com.atlassian.jira.web.filters.JiraFirstFilter_already_filtered : true - loginfilter.already.filtered : true - com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true - jira.webwork.generic.dispatcher : webwork.dispatcher.GenericDispatcher@445f3802 - com.atlassian.jira.web.filters.accesslog.AccessLogFilter_already_filtered : true - javax.servlet.error.message : - jira.session.last.accessed.time : 1301923239853 - webwork.result : Value stack =========== =========== - jira.request.username : ssbarnea - com.atlassian.jira.web.filters.RequestCleanupFilter_already_filtered : true - javax.servlet.error.request_uri : /secure/EditLabels.jspa - com.atlassian.jira.security.xsrf.XsrfTokenAdditionRequestFilter_already_filtered : true - com.atlassian.seraph.auth.LoginReason : OK - jira.webwork.cleanup : false - jira.request.id : 800x56288x1 - javax.servlet.error.status_code : 500 - jira.request.start.millis : 1301923242983 - com.atlassian.jira.web.filters.ActionCleanupDelayFilter : true - com.atlassian.jira.web.filters.accesslog.AccessLogRequestInfoexit.called : true - com.atlassian.core.filters.HeaderSanitisingFilter_already_filtered : true - jira.request.assession.id : 1waaxyq - __sitemesh__filterapplied : true - javax.servlet.error.exception : javax.servlet.ServletException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByAnd (SQL Exception while executing the following:DELETE FROM label WHERE FIELDID IS NULL AND ISSUE=? (Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT')) Request Logging 0 log statements generated by this request: Listeners - Issue Cache Listener (com.atlassian.jira.event.listeners.cache.IssueCacheListener) - Issue Index Listener (com.atlassian.jira.event.listeners.search.IssueIndexListener) - Mail Listener (com.atlassian.jira.event.listeners.mail.MailListener) Services - Backup Service (com.atlassian.jira.service.services.export.ExportService) - Delay: 720 minutes - Mail Queue Service (com.atlassian.jira.service.services.mail.MailQueueService) - Delay: 1 minutes - Service Provider Token Remover (com.atlassian.sal.jira.scheduling.JiraPluginSchedulerService) - Delay: 480 minutes Plugins - Admin Menu Sections 1.0 - Plugin by Atlassian - Enabled - Apache HttpClient OSGi bundle 4.0 - Plugin by Apache Software Foundation - Enabled - Apache HttpCore OSGi bundle 4.0 - Plugin by Apache Software Foundation - Enabled - Atlassian Gadgets OAuth Service Provider Plugin 1.1.5.6 - Plugin by Atlassian - Enabled - Atlassian OAuth Admin Plugin 1.0.12 - Plugin by Atlassian - Enabled - Atlassian OAuth Consumer Plugin 1.0.12 - Plugin by Atlassian - Enabled - Atlassian OAuth Consumer SPI 1.0.12 - Plugin by Atlassian - Enabled - Atlassian OAuth Service Provider Plugin 1.0.12 - Plugin by Atlassian - Enabled - Atlassian OAuth Service Provider SPI 1.0.12 - Plugin by Atlassian - Enabled - Atlassian REST - Module Types 2.1.0 - Plugin by Atlassian - Enabled - Atlassian Template Renderer API 1.1.1 - Plugin by Atlassian - Enabled - Atlassian Template Renderer Velocity 1.6 Plugin 1.1.1 - Plugin by Atlassian - Enabled - Atlassian UI Plugin 3.0.9 - Plugin by Atlassian Pty Ltd - Enabled - BND Library 0.0.255 - Plugin by aQute SARL http://www.aQute.biz - Enabled - Content Link Resolvers Plugin 1.0 - Plugin by Atlassian - Enabled - Custom Field Types & Searchers 1.0 - Plugin by Atlassian - Enabled - Embedded Gadgets Plugin 1.1.5.6 - Plugin by Atlassian - Enabled - FishEye Plugin 3.0.22 - Plugin by Atlassian Software Systems - Enabled - Gadget Dashboard Plugin 1.1.5.6 - Plugin by Atlassian - Enabled - Gadget Directory Plugin 1.1.5.6 - Plugin by Atlassian - Enabled - Gadget Renderer Plugin 1.1.5.6 - Plugin by Atlassian - Enabled - Gadget Spec Publisher Plugin 1.1.5.6 - Plugin by Atlassian - Enabled - ICU4J 3.8.0.1 - Plugin by Atlassian Pty Ltd - Enabled - Issue Operations Plugin 1.0 - Plugin by Atlassian - Enabled - Issue Tab Panels Plugin 1.0 - Plugin by Atlassian - Enabled - Issue Views Plugin 1.0 - Plugin by Atlassian - Enabled - JDOM DOM Processor 1.0.0 - Plugin by SpringSource - Enabled - JIRA Activity Stream Plugin 3.0.21 - Plugin by Atlassian - Enabled - JIRA Bamboo Plugin 4.1.3 - Plugin by Atlassian Software Systems Pty Ltd - Enabled - JIRA Footer 1.0 - Plugin by Atlassian - Enabled - JIRA Gadgets Plugin 4.2.2-b589 - Plugin by Atlassian - Enabled - JIRA Importers Plugin (JIM) 1.4 - Plugin by Atlassian - Enabled - JIRA OAuth Consumer SPI Plugin 4.2.2-b589 - Plugin by Atlassian - Enabled - JIRA OAuth Service Provider SPI Plugin 4.2.2-b589 - Plugin by Atlassian - Enabled - JIRA REST Plugin 4.2.2-b589 - Plugin by Atlassian - Enabled - JIRA Shared Application Access Layer (SAL) Plugin 4.2.2-b589 - Plugin by Atlassian Software Systems - Enabled - JIRA Usage Hints 1.0 - Plugin by Atlassian - Enabled - JQL Functions 1.0 - Plugin by Atlassian - Enabled - JSON Library 20070829.0.0.1 - Plugin by Atlassian Pty Ltd - Enabled - Joda-Time 1.6 - Plugin by - Enabled - Keyboard Shortcuts Plugin 1.0 - Plugin by Atlassian - Enabled - Neko HTML 1.9.12.1 - Plugin by Atlassian Pty Ltd - Enabled - Portlets Plugin 1.0 - Plugin by Atlassian - Enabled - Preset Filters Sections 1.0 - Plugin by Atlassian - Enabled - Project Panels Plugin 1.0 - Plugin by Atlassian - Enabled - Project Role Actors Plugin 1.0 - Plugin by Atlassian - Enabled - ROME, RSS and atOM utilitiEs for Java 1.0 - Plugin by Sun Microsystems - Enabled - ROME: RSS/Atom syndication and publishing tools 0.9.0 - Plugin by SpringSource - Enabled - RPC JIRA Plugin 4.2.2-b589 - Plugin by Atlassian - Enabled - Renderer Component Factories Plugin 1.0 - Plugin by Atlassian - Enabled - Renderer Plugin 1.0 - Plugin by Atlassian - Enabled - Reports Plugin 1.0 - Plugin by Atlassian - Enabled - Shared Application Access Layer API 2.1.0 - Plugin by Atlassian - Enabled - Top Navigation Bar 1.0 - Plugin by Atlassian - Enabled - User Format 1.0 - Plugin by Atlassian - Enabled - User Navigation Bar Sections 1.0 - Plugin by Atlassian - Enabled - User Profile Links 1.0 - Plugin by Atlassian - Enabled - User Profile Panels 1.0 - Plugin by Atlassian - Enabled - View Project Operations Sections 1.0 - Plugin by Atlassian - Enabled - Web Resources Plugin 1.0 - Plugin by Atlassian - Enabled - Webwork Plugin 1.0 - Plugin by Atlassian - Enabled - Wiki Renderer Macros Plugin 1.0 - Plugin by Atlassian - Enabled - Workflow Plugin 1.0 - Plugin by Atlassian - Enabled
    via by Sorin Sbarnea,
    • com.atlassian.crowd.embedded.ofbiz.db.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByAnd (SQL Exception while executing the following:DELETE FROM cwd_user_attributes WHERE user_id=? AND attribute_name=? (Deadlock found when trying to get lock; try restarting transaction)) at com.atlassian.crowd.embedded.ofbiz.db.OfBizHelper.removeByAnd(OfBizHelper.java:130) at com.atlassian.crowd.embedded.ofbiz.OfBizUserDao.removeAttribute(OfBizUserDao.java:335) at com.atlassian.crowd.embedded.ofbiz.OfBizUserDao.storeAttributes(OfBizUserDao.java:248) at com.atlassian.crowd.directory.AbstractInternalDirectory.storeUserAttributes(AbstractInternalDirectory.java:536) at com.atlassian.crowd.manager.directory.DirectoryManagerGeneric.storeUserAttributes(DirectoryManagerGeneric.java:388) at com.atlassian.crowd.manager.application.ApplicationServiceGeneric.storeUserAttributes(ApplicationServiceGeneric.java:529) at com.atlassian.crowd.embedded.core.CrowdServiceImpl.setUserAttribute(CrowdServiceImpl.java:375) at com.atlassian.crowd.embedded.core.CrowdServiceImpl.setUserAttribute(CrowdServiceImpl.java:363) at com.atlassian.crowd.embedded.core.DelegatingCrowdService.setUserAttribute(DelegatingCrowdService.java:100) at com.atlassian.crowd.embedded.core.FilteredCrowdServiceImpl.setUserAttribute(FilteredCrowdServiceImpl.java:43) at com.atlassian.jira.security.login.LoginStoreImpl.setLong(LoginStoreImpl.java:136) at com.atlassian.jira.security.login.LoginStoreImpl.recordLoginAttempt(LoginStoreImpl.java:64) at com.atlassian.jira.security.login.LoginManagerImpl.recordLoginAttempt(LoginManagerImpl.java:321) at com.atlassian.jira.security.login.LoginManagerImpl.onLoginAttempt(LoginManagerImpl.java:203) at com.atlassian.jira.security.login.JiraElevatedSecurityGuard.onSuccessfulLoginAttempt(JiraElevatedSecurityGuard.java:34) at com.atlassian.seraph.filter.PasswordBasedLoginFilter.runAuthentication(PasswordBasedLoginFilter.java:136) at com.atlassian.seraph.filter.PasswordBasedLoginFilter.login(PasswordBasedLoginFilter.java:72) at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:130) at com.atlassian.jira.web.filters.JiraLoginFilter.doFilter(JiraLoginFilter.java:70) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter(OAuthFilter.java:71) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.atlassian.plugins.rest.module.servlet.RestSeraphFilter.doFilter(RestSeraphFilter.java:40) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:71) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:81) at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.atlassian.jira.dev.backdoor.SlowMotionFilter.doFilter(SlowMotionFilter.java:54) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.sysbliss.jira.plugins.workflow.servlet.JWDSendRedirectFilter.doFilter(JWDSendRedirectFilter.java:25) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:78) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.cache.AbstractCachingFilter.doFilter(AbstractCachingFilter.java:33) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:41) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at com.atlassian.jira.web.filters.PathMatchingEncodingFilter.doFilter(PathMatchingEncodingFilter.java:45) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.monitor.ActiveRequestsFilter$PassToChainFilterFunc.doFilter(ActiveRequestsFilter.java:346) at com.atlassian.jira.web.monitor.ActiveRequestsFilter$DebugLogFilterFunc.doFilter(ActiveRequestsFilter.java:463) at com.atlassian.jira.web.monitor.ActiveRequestsFilter.doFilter(ActiveRequestsFilter.java:173) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.startup.JiraStartupChecklistFilter.doFilter(JiraStartupChecklistFilter.java:75) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.multitenant.servlet.MultiTenantServletFilter.doFilter(MultiTenantServletFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:78) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:554) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) Caused by: org.ofbiz.core.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByAnd (SQL Exception while executing the following:DELETE FROM cwd_user_attributes WHERE user_id=? AND attribute_name=? (Deadlock found when trying to get lock; try restarting transaction)) at org.ofbiz.core.entity.GenericDAO.deleteByAnd(GenericDAO.java:1218) at org.ofbiz.core.entity.GenericHelperDAO.removeByAnd(GenericHelperDAO.java:193) at org.ofbiz.core.entity.GenericDelegator.removeByAnd(GenericDelegator.java:1101) at org.ofbiz.core.entity.GenericDelegator.removeByAnd(GenericDelegator.java:1076) at sun.reflect.GeneratedMethodAccessor179.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.atlassian.multitenant.impl.MultiTenantComponentFactoryImpl$AbstractMultiTenantAwareInvocationHandler.invokeInternal(MultiTenantComponentFactoryImpl.java:181) at com.atlassian.multitenant.impl.MultiTenantComponentFactoryImpl$MultiTenantAwareMethodInterceptor.intercept(MultiTenantComponentFactoryImpl.java:230) at org.ofbiz.core.entity.GenericDelegator$$EnhancerByCGLIB$$33278696.removeByAnd(<generated>) at com.atlassian.crowd.embedded.ofbiz.db.OfBizHelper.removeByAnd(OfBizHelper.java:126) ... 95 more
    No Bugmate found.