[kepler-dev] [Bug 5413] New: large run deletion via the WRM with hsql provenance store takes a very long time and no gui feedback

[bugzilla-daemon at ecoinformatics.org]

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

           Summary: large run deletion via the WRM with hsql provenance
                    store takes a very long time and no gui feedback
           Product: Kepler
           Version: 2.1.0
          Platform: Other
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: P2
         Component: workflow run manager
        AssignedTo: barseghian at nceas.ucsb.edu
        ReportedBy: barseghian at nceas.ucsb.edu
         QAContact: kepler-dev at kepler-project.org
   Estimated Hours: 0.0


Deleting workflow executions that processed a lot of data via the Workflow Run
Manager takes far too long - often longer than the execution took. Also there's
no gui feedback, kepler just appears locked up.  A significant part of the time
is likely file i/o -- hsql is deleting each token from the port_event table
individually, and for each delete it writes a line the provenanceDB.log file
like:
DELETE FROM PORT_EVENT WHERE ID=102490

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