Yair Zaslavsky has posted comments on this change. Change subject: core:Async Tasks cleaner utility... ......................................................................
Patch Set 3: (1 inline comment) Eli, the former utility had the ability also to show all tasks (not just zombies) and erase them. .................................................... File backend/manager/dbscripts/async_tasks_sp.sql Line 142: zombie_task_life = option_value FROM vdc_options WHERE option_name = 'AsyncTaskZombieTaskLifeInMinutes'; Line 143: EXECUTE 'SELECT now() - interval ''' || zombie_task_life || ' minute''' INTO zombie_date; Line 144: Line 145: RETURN QUERY SELECT * Line 146: FROM async_tasks Please order by the command ID of the task. Line 147: WHERE started_at < zombie_date; Line 148: Line 149: END; $procedure$ Line 150: LANGUAGE plpgsql; -- To view, visit http://gerrit.ovirt.org/11005 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: comment Gerrit-Change-Id: Idffc35eb5fca0e72c9e4c9e3a08c5b9799569fca Gerrit-PatchSet: 3 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Eli Mesika <[email protected]> Gerrit-Reviewer: Eli Mesika <[email protected]> Gerrit-Reviewer: Yair Zaslavsky <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
