<< Back to previous view

[QB-1093] Referential integrity constraint violation when migrating changes
Created: 11/Oct/11  Updated: 12/Oct/11

Status: Closed
Project: QuickBuild
Component/s: None
Affects Version/s: 4.0.0, 4.0.1, 4.0.2, 4.0.3
Fix Version/s: 4.0.4

Type: Bug Priority: Major
Reporter: Steve Luo Assigned To: Steve Luo
Resolution: Fixed Votes: 0
Remaining Estimate: Unknown Time Spent: Unknown
Original Estimate: Unknown


 Description   
Below exception occurred when viewing build page or statistics page on occasion:

java.sql.SQLException: Referential integrity constraint violation: "CONSTRAINT_C8: PUBLIC.MODIFICATIONS FOREIGN KEY(BUILDID, CHANGEID, REPOSITORY) REFERENCES PUBLIC.CHANGESETS(BUILDID, CHANGEID, REPOSITORY)"; SQL statement:
INSERT INTO modifications(buildid, changeid, repository, filename, edition, previousedition, action, pathtype) VALUES (?, ?, ?, ?, ?, ?, ?, ?) [23506-159] Query: INSERT INTO modifications(buildid, changeid, repository, filename, edition, previousedition, action, pathtype) VALUES (?, ?, ?, ?, ?, ?, ?, ?) Parameters:
Generated at Thu May 16 12:48:11 UTC 2024 using JIRA 189.