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 over 8 years ago. Updated about 8 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 over 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 over 8 years ago

No longer blocking during run-delete, just showing the wait cursor at r27799.

#3 Updated by Derik Barseghian about 8 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 6 years ago

Original Bugzilla ID was 5413

Also available in: Atom PDF