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 almost 8 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 almost 8 years ago
No longer blocking during run-delete, just showing the wait cursor at r27799.
#3 Updated by Derik Barseghian over 7 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 about 6 years ago
Original Bugzilla ID was 5413