Uploaded image for project: 'Bamboo Data Center'
  1. Bamboo Data Center
  2. BAM-1076

Unable to save build results after deleting build.

    XMLWordPrintable

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)

      Attachments

        Activity

          People

            edwin@atlassian.com edwin
            f05b95cfe4ab Paudi Moriarty
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: