Details
-
Bug
-
Resolution: Cannot Reproduce
-
Medium
-
None
-
1.0.2
-
None
-
None
-
Standalone, sun-jdk-1.5.0_10, Gentoo GNU/Linux 2.6.19-gentoo-r5.
Description
Deleted a build, then got this error on every subsequent build:
(org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: com.atlassian.bamboo.resultsummary.BuildResultsSummaryImpl#786433; SQL []; Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_52 in statement [insert into BUILDRESULTSUMMARY (CREATED_DATE, UPDATED_DATE, BUILD_KEY, BUILD_NUMBER, BUILD_STATE, SUCCESSFUL_TEST_COUNT, FAILED_TEST_COUNT, BUILD_DATE, BUILD_COMPLETED_DATE, DURATION, TIME_TO_FIX, REASON_FOR_BUILD, DELTA_STATE, BUILDRESULTSUMMARY_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_52 in statement [insert into BUILDRESULTSUMMARY (CREATED_DATE, UPDATED_DATE, BUILD_KEY, BUILD_NUMBER, BUILD_STATE, SUCCESSFUL_TEST_COUNT, FAILED_TEST_COUNT, BUILD_DATE, BUILD_COMPLETED_DATE, DURATION, TIME_TO_FIX, REASON_FOR_BUILD, DELTA_STATE, BUILDRESULTSUMMARY_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)])
Strack Trace
org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: com.atlassian.bamboo.resultsummary.BuildResultsSummaryImpl#786433; SQL []; Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_52 in statement [insert into BUILDRESULTSUMMARY (CREATED_DATE, UPDATED_DATE, BUILD_KEY, BUILD_NUMBER, BUILD_STATE, SUCCESSFUL_TEST_COUNT, FAILED_TEST_COUNT, BUILD_DATE, BUILD_COMPLETED_DATE, DURATION, TIME_TO_FIX, REASON_FOR_BUILD, DELTA_STATE, BUILDRESULTSUMMARY_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_52 in statement [insert into BUILDRESULTSUMMARY (CREATED_DATE, UPDATED_DATE, BUILD_KEY, BUILD_NUMBER, BUILD_STATE, SUCCESSFUL_TEST_COUNT, FAILED_TEST_COUNT, BUILD_DATE, BUILD_COMPLETED_DATE, DURATION, TIME_TO_FIX, REASON_FOR_BUILD, DELTA_STATE, BUILDRESULTSUMMARY_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
java.sql.SQLException: Violation of unique constraint $$: duplicate value(s) for column(s) $$: SYS_PK_52 in statement [insert into BUILDRESULTSUMMARY (CREATED_DATE, UPDATED_DATE, BUILD_KEY, BUILD_NUMBER, BUILD_STATE, SUCCESSFUL_TEST_COUNT, FAILED_TEST_COUNT, BUILD_DATE, BUILD_COMPLETED_DATE, DURATION, TIME_TO_FIX, REASON_FOR_BUILD, DELTA_STATE, BUILDRESULTSUMMARY_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:436)
at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2449)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2435)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2392)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2261)
at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)
at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:490)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:500)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:473)
at org.springframework.transaction.interceptor.TransactionAspectSupport.doCommitTransactionAfterReturning(TransactionAspectSupport.java:267)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
at $Proxy9.saveBuildResultsSummary(Unknown Source)
at com.atlassian.bamboo.build.DefaultBuild.addBuildResultSummary(DefaultBuild.java:342)
at com.atlassian.bamboo.build.pipeline.tasks.SaveBuildTask.call(SaveBuildTask.java:67)
at edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)
at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:987)
at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:528)
at edu.emory.mathcs.backport.java.util.concurrent.helpers.ThreadHelpers$1.run(ThreadHelpers.java:34)
at java.lang.Thread.run(Thread.java:595)