-
Bug
-
Resolution: Low Engagement
-
Medium
-
None
-
5.15.0.1
-
2
-
Severity 2 - Major
-
1
-
Happens on Oracle DB when heavily create/remove deployment projects/environments by several users
2017-05-22 04:12:14,606 ERROR [http-nio-127.0.0.1-8085-exec-210] [SqlExceptionHelper] ORA-00060: deadlock detected while waiting for resource 2017-05-22 04:12:14,606 WARN [http-nio-127.0.0.1-8085-exec-210] [SqlExceptionHelper] SQL Error: 60, SQLState: 61000 2017-05-22 04:12:14,606 ERROR [http-nio-127.0.0.1-8085-exec-210] [SqlExceptionHelper] ORA-00060: deadlock detected while waiting for resource 2017-05-22 04:12:14,606 ERROR [http-nio-127.0.0.1-8085-exec-210] [BatchingBatch] HHH000315: Exception executing batch [could not execute batch] 2017-05-22 04:12:14,606 INFO [http-nio-127.0.0.1-8085-exec-202] [AccessLogFilter] user GET https://bamboo.com/chain/result/viewChainCommits.action?planKey=QAT-H29&buildNumber=1 6153905kb 2017-05-22 04:12:14,607 INFO [http-nio-127.0.0.1-8085-exec-189] [AccessLogFilter] user GET https://bamboo.com/rest/menu/latest/appswitcher?_=1495440734241 6157024kb 2017-05-22 04:12:14,614 DEBUG [http-nio-127.0.0.1-8085-exec-210] [UtilTimerStack] [3271ms] - com.atlassian.bamboo.ww2.interceptors.PaginationAwareInterceptor.intercept [3271ms] - com.atlassian.bamboo.ww2.interceptors.BambooXsrfTokenInterceptor.intercept [3270ms] - com.atlassian.bamboo.ww2.interceptors.JSONValidationInterceptor.intercept [9ms] - delete from DEPLOYMENT_VERSION_COMMIT where DEP_VERSION_CHANGESET_ID in (select DEP_VERSION_CHANGESET_ID from DEPLOYMENT_VERSION_CHANGESET where DEPLOYMENT_VERSION_ID in (select DEPLOYMENT_VERSION_ID from DEPLOYMENT_VERSION where PROJECT_ID = 123830375)) [3ms] - delete from DEPLOYMENT_VERSION_CHANGESET where DEPLOYMENT_VERSION_ID in (select DEPLOYMENT_VERSION_ID from DEPLOYMENT_VERSION where PROJECT_ID = 123830375) [7ms] - delete from DEPLOYMENT_VERSION_STATUS where DEPLOYMENT_VERSION_ID in (select DEPLOYMENT_VERSION_ID from DEPLOYMENT_VERSION where PROJECT_ID = 123830375) [3ms] - delete from DEPLOYMENT_VERSION_JIRA_ISSUE where DEPLOYMENT_VERSION_ID in (select DEPLOYMENT_VERSION_ID from DEPLOYMENT_VERSION where PROJECT_ID = 123830375) [3ms] - update DEPLOYMENT_RESULT set VERSION_ID = ? where VERSION_ID in (select DEPLOYMENT_VERSION_ID from DEPLOYMENT_VERSION where PROJECT_ID = 123830375) [2ms] - delete from VARIABLE_DEFINITION where DEPLOYMENT_VERSION_ID in (select DEPLOYMENT_VERSION_ID from DEPLOYMENT_VERSION where PROJECT_ID = 123830375) [3ms] - delete from USER_COMMENT where ENTITY_ID in (select DEPLOYMENT_VERSION_ID from DEPLOYMENT_VERSION where PROJECT_ID = 123830375) [2ms] - delete from DEP_VERSION_PLANRESULTKEYS where DEPLOYMENT_VERSION_ID in (select DEPLOYMENT_VERSION_ID from DEPLOYMENT_VERSION where PROJECT_ID = 123830375) [10ms] - delete from DEPLOYMENT_VERSION_ITEM_BA where VERSION_BAM_ARTIFACT_ITEM_ID in ( select DEPLOYMENT_VERSION_ITEM_ID from DEPLOYMENT_VERSION_ITEM where DEPLOYMENT_VERSION_ID in (select DEPLOYMENT_VERSION_ID from DEPLOYMENT_VERSION where PROJECT_ID = 123830375)) [3ms] - delete from DEPLOYMENT_VERSION_ITEM where DEPLOYMENT_VERSION_ID in (select DEPLOYMENT_VERSION_ID from DEPLOYMENT_VERSION where PROJECT_ID = 123830375) [2ms] - delete from DEPLOYMENT_VERSION where PROJECT_ID = 123830375 2017-05-22 04:12:14,614 ERROR [http-nio-127.0.0.1-8085-exec-210] [ExceptionMappingInterceptor] could not execute batch; SQL [delete from ACL_OBJECT_IDENTITY where ID=?]; nested exception is org.hibernate.exception.LockAcquisitionException: could not execute batch org.springframework.dao.CannotAcquireLockException: could not execute batch; SQL [delete from ACL_OBJECT_IDENTITY where ID=?]; nested exception is org.hibernate.exception.LockAcquisitionException: could not execute batch at org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:154) at org.springframework.orm.hibernate4.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:730) at org.springframework.orm.hibernate4.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:592) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730) at sun.reflect.GeneratedMethodAccessor160.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at com.sun.proxy.$Proxy31.commit(Unknown Source) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:150) at com.atlassian.bamboo.persistence.BambooTransactionHibernateTemplate.execute(BambooTransactionHibernateTemplate.java:41) at com.atlassian.bamboo.persistence.BambooTransactionHibernateTemplate.execute(BambooTransactionHibernateTemplate.java:47) at com.atlassian.bamboo.deployments.projects.service.DeploymentProjectDeletionServiceImpl.deleteDeploymentProject(DeploymentProjectDeletionServiceImpl.java:84) at sun.reflect.GeneratedMethodAccessor2197.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at com.atlassian.bamboo.security.acegi.intercept.aopalliance.AuthorityOverrideMethodSecurityInterceptor.invoke(AuthorityOverrideMethodSecurityInterceptor.java:30) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208) at com.sun.proxy.$Proxy205.deleteDeploymentProject(Unknown Source) at com.atlassian.bamboo.deployments.projects.actions.DeleteDeploymentProject.delete(DeleteDeploymentProject.java:42) at sun.reflect.GeneratedMethodAccessor2196.invoke(Unknown Source)
- relates to
-
BAM-18502 Internal server error when multi login sessions performing actions
- Closed
-
BDEV-15662 Loading...
[BAM-18547] Database deadlock on Oracle when delete deployment project
Resolution | New: Low Engagement [ 10300 ] | |
Status | Original: Gathering Impact [ 12072 ] | New: Closed [ 6 ] |
Labels | New: cleanup-seos-fy25 |
UIS | Original: 8 | New: 1 |
Priority | Original: Low [ 4 ] | New: Medium [ 3 ] |
UIS | Original: 1 | New: 8 |
UIS | Original: 2 | New: 1 |
Assignee | Original: Marcin Gardias [ mgardias ] |
UIS | Original: 15 | New: 2 |
UIS | New: 15 |
Hi,
At Atlassian, our goal is to ensure we’re providing the best experience for our customers. With our new Data Center strategy, Atlassian's focus is on security, compliance, and performance and is a key driver in prioritizing bugs. Closing the bugs that do not fall into those categories will allow us to focus on the ones in the most current versions of our products.
This bug is being closed due to a lack of engagement in the last four years, including no new watchers, votes, or comments; this inactivity suggests a low impact.
Please note the comments on this thread are not being monitored.
You can read more about our bug fix policy here and how we prioritize bugs.
To learn more about our recent investments in Bamboo Data Center, please check our public roadmap.
Kind regards,
Bamboo Data Center