Eli Mesika has posted comments on this change. Change subject: core:Add a script that displays async ...(#868672) ......................................................................
Patch Set 2: (2 inline comments) .................................................... File backend/manager/dbscripts/common_sp.sql Line 447: dc_id UUID, Line 448: dc_name CHARACTER VARYING, Line 449: spm_host_id UUID, Line 450: spm_host_name CHARACTER VARYING, Line 451: task_count integer); Done Line 452: Line 453: OPEN v_tasks_cursor; Line 454: FETCH v_tasks_cursor into v_dc_id; Line 455: WHILE FOUND LOOP Line 465: -- get tasks count for this DC Line 466: v_count := count(*) from async_tasks where position (cast(v_dc_id as varchar) in action_parameters) > 0; Line 467: -- insert a record to the temporary table Line 468: insert into tt_async_tasks_info(dc_id,dc_name,spm_host_id,spm_host_name,task_count) Line 469: values(v_dc_id,v_dc_name,v_spm_host_id,v_spm_host_name,v_count); Done Line 470: FETCH v_tasks_cursor into v_dc_id; Line 471: END LOOP; Line 472: CLOSE v_tasks_cursor; Line 473: RETURN QUERY select * from tt_async_tasks_info; -- To view, visit http://gerrit.ovirt.org/8736 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: comment Gerrit-Change-Id: Ia9f021279d761344c3d9fb3bedef80637d5a7855 Gerrit-PatchSet: 2 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Eli Mesika <emes...@redhat.com> Gerrit-Reviewer: Allon Mureinik <amure...@redhat.com> Gerrit-Reviewer: Eli Mesika <emes...@redhat.com> Gerrit-Reviewer: Michael Kublin <mkub...@redhat.com> Gerrit-Reviewer: Yair Zaslavsky <yzasl...@redhat.com> _______________________________________________ Engine-patches mailing list Engine-patches@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-patches
