| << Back to previous view |
|
[QB-1659] Key violation when updating changes database
|
|
| Status: | Resolved |
| Project: | QuickBuild |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 5.0.24 |
| Type: | Bug | Priority: | Major |
| Reporter: | Steve Luo | Assigned To: | Unassigned |
| Resolution: | Fixed | Votes: | 0 |
| Remaining Estimate: | Unknown | Time Spent: | Unknown |
| Original Estimate: | Unknown | ||
| Description |
|
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 |