See forum post:
http://forum.pmease.com/viewtopic.php?f=1&t=2657


Ever since upgrading to QB5.0.23, every now and then, we get a QB database error trying to insert into the changesets table. Perhaps a bug?? It seems to fix itself on the next build.

10:57:38,894 ERROR - Step 'master>checkout' is failed.
com.pmease.quickbuild.plugin.report.engine.exception.DatabaseException: Failed executing update sql [INSERT INTO changesets(buildid, changeid, repository, commitdate, comment, additional, modifications, committer, userid, added, modified, deleted) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] on database /Developer/QuickBuild/storage/builds/138/reports/scm_activity/DEFAULT/scm_activity.h2.db
at com.pmease.quickbuild.plugin.report.engine.datastore.DbStore.update(DbStore.java:203)
at com.pmease.quickbuild.plugin.report.engine.datastore.DbStore.update(DbStore.java:209)
at com.pmease.quickbuild.plugin.report.engine.metadata.CategoryDb.insertRow(CategoryDb.java:155)
at com.pmease.quickbuild.plugin.report.engine.metadata.CategoryDb.persistRow(CategoryDb.java:197)
at com.pmease.quickbuild.plugin.report.engine.metadata.CategoryDb.persistRow(CategoryDb.java:192)
at com.pmease.quickbuild.plugin.report.changes.generator.DefaultChangesRecorder.saveChanges(DefaultChangesRecorder.java:174)
at com.pmease.quickbuild.plugin.report.changes.generator.DefaultChangesRecorder.write(DefaultChangesRecorder.java:112)
at com.pmease.quickbuild.ServerServiceImpl.writeChanges(ServerServiceImpl.java:260)
at com.pmease.quickbuild.plugin.basis.checkout.CheckoutStep.run(CheckoutStep.java:74)
at com.pmease.quickbuild.plugin.basis.checkout.CheckoutStep$$EnhancerByCGLIB$$f9e1f87d.CGLIB$run$0(<generated>)
at com.pmease.quickbuild.plugin.basis.checkout.CheckoutStep$$EnhancerByCGLIB$$f9e1f87d$$FastClassByCGLIB$$23ba3d5e.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:215)
at com.pmease.quickbuild.DefaultScriptEngine$Interpolator.intercept(DefaultScriptEngine.java:269)
at com.pmease.quickbuild.plugin.basis.checkout.CheckoutStep$$EnhancerByCGLIB$$f9e1f87d.run(<generated>)
at com.pmease.quickbuild.stepsupport.Step.execute(Step.java:501)
at com.pmease.quickbuild.stepsupport.StepExecutionJob.executeStepAwareJob(StepExecutionJob.java:30)
at com.pmease.quickbuild.stepsupport.StepAwareJob.executeBuildAwareJob(StepAwareJob.java:47)
at com.pmease.quickbuild.BuildAwareJob.execute(BuildAwareJob.java:61)
at com.pmease.quickbuild.grid.GridJob.run(GridJob.java:78)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:680)
Caused by: java.sql.SQLException: Unique index or primary key violation: "CONSTRAINT_INDEX_9 ON PUBLIC.CHANGESETS(BUILDID, CHANGEID, REPOSITORY)"; SQL statement:
INSERT INTO changesets(buildid, changeid, repository, commitdate, comment, additional, modifications, committer, userid, added, modified, deleted) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [23505-159] Query: INSERT INTO changesets(buildid, changeid, repository, commitdate, comment, additional, modifications, committer, userid, added, modified, deleted) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [138, 98104, TFS, 2013-06-07 10:56:21.0, Unit test BorderVisibility; modify GetHashCode()., null, 1, IHS\GXB45009, 0, 1, 0, 0]
at org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:542)
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:599)
at com.pmease.quickbuild.plugin.report.engine.datastore.DbStore.update(DbStore.java:201)
... 24 more