Opened 17 years ago
Last modified 16 years ago
#1208 assigned defect
dettool -revertresidexp fails on foreign key constraint
| Reported by: | eugene | Owned by: | eugene |
|---|---|---|---|
| Priority: | low | Milestone: | |
| Component: | ippTools | Version: | |
| Severity: | minor | Keywords: | |
| Cc: |
Description
this revert fails because other steps (detreject) have already moved ahead. this suggests a problem with the constraints
ipp004: dettool -dbname gpc1 -revertresidexp -det_id 100
p_psDBRunQuery (psDB.c:812) : Failed to execute SQL query. Error: Cannot delete or update a parent row: a foreign key constraint fails (
gpc1/detRunSummary, CONSTRAINTdetRunSummary_ibfk_2FOREIGN KEY (det_id,iteration) REFERENCESdetResidExp(det_id,iteration))
revertresidexpMode (dettool_residexp.c:291) : database error
-> p_psDBRunQuery (psDB.c:812): Database error generated by the server
Failed to execute SQL query. Error: Cannot delete or update a parent row: a foreign key constraint fails (
gpc1/detRunSummary, CONSTRAINTdetRunSummary_ibfk_2FOREIGN KEY (det_id,iteration) REFERENCESdetResidExp(det_id,iteration))
-> revertresidexpMode (dettool_residexp.c:291): unknown psLib error
database error
Change History (2)
comment:1 by , 16 years ago
| Priority: | highest → low |
|---|---|
| Severity: | blocker → minor |
comment:2 by , 16 years ago
| Component: | DVO → ippTools |
|---|---|
| Status: | new → assigned |
this is annoying but only an impact while creating detrends. does not block science processing, or even detrends generally.