Liran Zelkha has posted comments on this change.
Change subject: engine: Delete jobs that their steps have no async-tasks
......................................................................
Patch Set 4:
(2 comments)
....................................................
File packaging/dbscripts/job_sp.sql
Line 485: OR (end_time < v_failed_end_time
Line 486: AND status IN ('FAILED', 'ABORTED', 'UNKNOWN'))));
Line 487: DELETE FROM job
Line 488: WHERE job_id IN
Line 489: (SELECT job.job_id
Done
Line 490: FROM job,step
Line 491: WHERE NOT job.is_external
Line 492: AND job.job_id = step.job_id
Line 493: AND step.step_id NOT IN
Line 493: AND step.step_id NOT IN
Line 494: (SELECT async_tasks.step_id
Line 495: FROM async_tasks, step
Line 496: WHERE async_tasks.step_id = step.step_id));
Line 497:
Done
Line 498: END; $procedure$
Line 499: LANGUAGE plpgsql;
Line 500:
Line 501: -------------------------------------
--
To view, visit http://gerrit.ovirt.org/22474
To unsubscribe, visit http://gerrit.ovirt.org/settings
Gerrit-MessageType: comment
Gerrit-Change-Id: Iae00d615bff79f42d8428b867f1816d6e0aa9a72
Gerrit-PatchSet: 4
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: Liran Zelkha <lzel...@redhat.com>
Gerrit-Reviewer: Anonymous Coward #1000524
Gerrit-Reviewer: Barak Azulay <bazu...@redhat.com>
Gerrit-Reviewer: Eli Mesika <emes...@redhat.com>
Gerrit-Reviewer: Liran Zelkha <lzel...@redhat.com>
Gerrit-Reviewer: oVirt Jenkins CI Server
Gerrit-HasComments: Yes
_______________________________________________
Engine-patches mailing list
Engine-patches@ovirt.org
http://lists.ovirt.org/mailman/listinfo/engine-patches
