Martin Sivák has uploaded a new change for review.
Change subject: Remove UpdatePartialVdsDynamicCalc stored procedure
......................................................................
Remove UpdatePartialVdsDynamicCalc stored procedure
This procedure is no longer needed and was removed from the VdsDAO
when the new pending resource tracking mechanism was introduced.
Change-Id: I2b61d7465c3a7182fef398a6b65ea5555a68aa94
Signed-off-by: Martin Sivak <msi...@redhat.com>
---
M packaging/dbscripts/vds_sp.sql
1 file changed, 0 insertions(+), 30 deletions(-)
git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/21/41821/1
diff --git a/packaging/dbscripts/vds_sp.sql b/packaging/dbscripts/vds_sp.sql
index 0caa770..1269d2d 100644
--- a/packaging/dbscripts/vds_sp.sql
+++ b/packaging/dbscripts/vds_sp.sql
@@ -910,36 +910,6 @@
END; $procedure$
LANGUAGE plpgsql;
-Create or replace FUNCTION UpdatePartialVdsDynamicCalc(
- v_vds_guid UUID,
- v_vmCount INTEGER,
- v_pendingVcpusCount INTEGER,
- v_pendingVmemSize INTEGER,
- v_memCommited INTEGER,
- v_vmsCoresCount INTEGER)
-RETURNS VOID
- AS $procedure$
-DECLARE
- sign int;
-BEGIN
- IF (v_memCommited = 0 ) THEN
- sign = 0;
- ELSEIF (v_memCommited > 0) THEN
- sign = 1;
- ELSE
- sign = -1;
- END IF;
-
- UPDATE vds_dynamic
- SET
- vm_count = GREATEST(vm_count + v_vmCount, 0),
- pending_vcpus_count = GREATEST(pending_vcpus_count +
v_pendingVcpusCount, 0),
- pending_vmem_size = GREATEST(pending_vmem_size + v_pendingVmemSize, 0),
- mem_commited = GREATEST(mem_commited + sign * (abs(v_memCommited) +
guest_overhead), 0),
- vms_cores_count = GREATEST(vms_cores_count + v_vmsCoresCount, 0)
- WHERE vds_id = v_vds_guid;
-END; $procedure$
-LANGUAGE plpgsql;
Create or replace FUNCTION GetVdsByNetworkId(v_network_id UUID) RETURNS SETOF
vds STABLE
AS $procedure$
--
To view, visit https://gerrit.ovirt.org/41821
To unsubscribe, visit https://gerrit.ovirt.org/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I2b61d7465c3a7182fef398a6b65ea5555a68aa94
Gerrit-PatchSet: 1
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: Martin Sivák <msi...@redhat.com>
_______________________________________________
Engine-patches mailing list
Engine-patches@ovirt.org
http://lists.ovirt.org/mailman/listinfo/engine-patches
