[kepler-dev] [Bug 4952] New: Error recording workflow structure on workflow after deleting run

[bugzilla-daemon at ecoinformatics.org]

http://bugzilla.ecoinformatics.org/show_bug.cgi?id=4952

           Summary: Error recording workflow structure on workflow after
                    deleting run
           Product: Kepler
           Version: 1.x dev
          Platform: Other
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: P2
         Component: provenance
        AssignedTo: crawl at sdsc.edu
        ReportedBy: barseghian at nceas.ucsb.edu
         QAContact: kepler-dev at kepler-project.org


If create a workflow, run it, delete the run, then try to run the workflow
again, you'll currently get an error (below).  Maybe this is related to r23714
"adding method to delete provenance for workflows without runs"? 

ptolemy.kernel.util.IllegalActionException: Error recording workflow structure:
Error adding to workflow_change: Integrity constraint violation - no parent
WORKFLOW_CHANGE_WF_ID_FK table: WORKFLOW in statement [INSERT INTO
WORKFLOW_CHANGE (user, time, wf_id, host_id) VALUES (?, ?, ?, ?)]
  in .Unnamed1.TOP Provenance Recorder
Because:
Error adding to workflow_change: Integrity constraint violation - no parent
WORKFLOW_CHANGE_WF_ID_FK table: WORKFLOW in statement [INSERT INTO
WORKFLOW_CHANGE (user, time, wf_id, host_id) VALUES (?, ?, ?, ?)]
    at
org.kepler.provenance.ProvenanceRecorder._recordWorkflowContents(ProvenanceRecorder.java:2266)
    at
org.kepler.provenance.ProvenanceRecorder.preinitialize(ProvenanceRecorder.java:473)
    at ptolemy.actor.CompositeActor.preinitialize(CompositeActor.java:1424)
    at ptolemy.actor.Manager.preinitializeAndResolveTypes(Manager.java:983)
    at ptolemy.actor.Manager.initialize(Manager.java:643)
    at ptolemy.actor.Manager.execute(Manager.java:340)
    at ptolemy.actor.Manager.run(Manager.java:1162)
    at ptolemy.actor.Manager$3.run(Manager.java:1215)
Caused by: org.kepler.provenance.RecordingException: Error adding to
workflow_change: Integrity constraint violation - no parent
WORKFLOW_CHANGE_WF_ID_FK table: WORKFLOW in statement [INSERT INTO
WORKFLOW_CHANGE (user, time, wf_id, host_id) VALUES (?, ?, ?, ?)]
    at
org.kepler.provenance.sql.SQLRecordingV8._addWorkflowChange(SQLRecordingV8.java:1344)
    at
org.kepler.provenance.sql.SQLRecordingV8._addEntity(SQLRecordingV8.java:1242)
    at
org.kepler.provenance.sql.SQLRecording._checkEntity(SQLRecording.java:1370)
    at
org.kepler.provenance.sql.SQLRecording._regActorDirector(SQLRecording.java:1524)
    at org.kepler.provenance.sql.SQLRecording.regActor(SQLRecording.java:140)
    at
org.kepler.provenance.ProvenanceRecorder._recordContainerContents(ProvenanceRecorder.java:1771)
    at
org.kepler.provenance.ProvenanceRecorder._recordWorkflowContents(ProvenanceRecorder.java:2252)
    ... 7 more
Caused by: java.sql.SQLException: Integrity constraint violation - no parent
WORKFLOW_CHANGE_WF_ID_FK table: WORKFLOW in statement [INSERT INTO
WORKFLOW_CHANGE (user, time, wf_id, host_id) VALUES (?, ?, ?, ?)]
    at org.hsqldb.jdbc.Util.throwError(Unknown Source)
    at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
    at org.kepler.util.sql.DatabaseType.insert(DatabaseType.java:687)
    at
org.kepler.provenance.sql.SQLRecordingV8._addWorkflowChange(SQLRecordingV8.java:1331)
    ... 13 more
Caused by: org.kepler.provenance.RecordingException: Error adding to
workflow_change: Integrity constraint violation - no parent
WORKFLOW_CHANGE_WF_ID_FK table: WORKFLOW in statement [INSERT INTO
WORKFLOW_CHANGE (user, time, wf_id, host_id) VALUES (?, ?, ?, ?)]
    at
org.kepler.provenance.sql.SQLRecordingV8._addWorkflowChange(SQLRecordingV8.java:1344)
    at
org.kepler.provenance.sql.SQLRecordingV8._addEntity(SQLRecordingV8.java:1242)
    at
org.kepler.provenance.sql.SQLRecording._checkEntity(SQLRecording.java:1370)
    at
org.kepler.provenance.sql.SQLRecording._regActorDirector(SQLRecording.java:1524)
    at org.kepler.provenance.sql.SQLRecording.regActor(SQLRecording.java:140)
    at
org.kepler.provenance.ProvenanceRecorder._recordContainerContents(ProvenanceRecorder.java:1771)
    at
org.kepler.provenance.ProvenanceRecorder._recordWorkflowContents(ProvenanceRecorder.java:2252)
    at
org.kepler.provenance.ProvenanceRecorder.preinitialize(ProvenanceRecorder.java:473)
    at ptolemy.actor.CompositeActor.preinitialize(CompositeActor.java:1424)
    at ptolemy.actor.Manager.preinitializeAndResolveTypes(Manager.java:983)
    at ptolemy.actor.Manager.initialize(Manager.java:643)
    at ptolemy.actor.Manager.execute(Manager.java:340)
    at ptolemy.actor.Manager.run(Manager.java:1162)
    at ptolemy.actor.Manager$3.run(Manager.java:1215)
Caused by: java.sql.SQLException: Integrity constraint violation - no parent
WORKFLOW_CHANGE_WF_ID_FK table: WORKFLOW in statement [INSERT INTO
WORKFLOW_CHANGE (user, time, wf_id, host_id) VALUES (?, ?, ?, ?)]
    at org.hsqldb.jdbc.Util.throwError(Unknown Source)
    at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
    at org.kepler.util.sql.DatabaseType.insert(DatabaseType.java:687)
    at
org.kepler.provenance.sql.SQLRecordingV8._addWorkflowChange(SQLRecordingV8.java:1331)
    ... 13 more

-- 
Configure bugmail: http://bugzilla.ecoinformatics.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.