Project

General

Profile

Bug #5413

large run deletion via the WRM with hsql provenance store takes a very long time and no gui feedback

Added by Derik Barseghian about 10 years ago. Updated over 9 years ago.

Status:
New
Priority:
Normal
Category:
workflow run manager
Target version:
Start date:
05/26/2011
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
5413

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

Also available in: Atom PDF