Arik Hadas has uploaded a new change for review. Change subject: core: do not remove execution jobs with ongoing tasks ......................................................................
core: do not remove execution jobs with ongoing tasks In I5973c a mechanism that removes execution jobs that cannot be tracked after engine restart was added. A check whether there are ongoing tasks which are related to the jobs was missing, since if there are such async tasks then the operation can be tracked and resumed. Change-Id: I95b1066ca6fc015fd31101e7b551b4fae1d66904 Bug-Url: https://bugzilla.redhat.com/1099505 Signed-off-by: Arik Hadas <[email protected]> --- M packaging/dbscripts/job_sp.sql 1 file changed, 2 insertions(+), 1 deletion(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/91/31491/1 diff --git a/packaging/dbscripts/job_sp.sql b/packaging/dbscripts/job_sp.sql index 142c742..9856d77 100644 --- a/packaging/dbscripts/job_sp.sql +++ b/packaging/dbscripts/job_sp.sql @@ -477,7 +477,8 @@ BEGIN DELETE FROM job WHERE (status = 'STARTED' - AND action_type IN ('MigrateVm', 'MigrateVmToServer', 'RunVm', 'RunVmOnce')); + AND action_type IN ('MigrateVm', 'MigrateVmToServer', 'RunVm', 'RunVmOnce')) + AND job_id not in (select job_id from step where step_id in (select step_id from async_tasks)); DELETE FROM job WHERE job_id IN -- To view, visit http://gerrit.ovirt.org/31491 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I95b1066ca6fc015fd31101e7b551b4fae1d66904 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: ovirt-engine-3.4 Gerrit-Owner: Arik Hadas <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
