Bug #5413
large run deletion via the WRM with hsql provenance store takes a very long time and no gui feedback
0%
Description
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
History
#1 Updated by Derik Barseghian about 10 years ago
Some progress on this with r27791, the wait cursor will now display over WRM during deletion. Everything still blocks during deletion, this could be improved -- only WRM or particular run-rows should block.
#2 Updated by Derik Barseghian about 10 years ago
No longer blocking during run-delete, just showing the wait cursor at r27799.
#3 Updated by Derik Barseghian over 9 years ago
The wait cursor is there now. Performance should still be improved, but retargeting to reporting-2.x.y.
#4 Updated by Redmine Admin over 8 years ago
Original Bugzilla ID was 5413