Attachment 578655 Details for Bug 811646 – free_slots fix

[patch] free_slots fix

0001-811646-assign-number-of-free-slots.patch (text/plain), 1.86 KB, created by Michael Mráka on 2012-04-19 13:53:52 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Michael Mráka

Created: 2012-04-19 13:53:52 UTC

Size: 1.86 KB

patch

obsolete

>From 682fbc397913e0e27aa4a410a691c6b92d5f37be Mon Sep 17 00:00:00 2001
>From: Michael Mraka <michael.mraka@redhat.com>
>Date: Thu, 19 Apr 2012 15:41:44 +0200
>Subject: [PATCH] 811646 - assign number of free slots
>
>fixing
>ERROR:  column "free_slots" does not exist at character 295
>QUERY:  UPDATE rhnServerChannel sc set is_fve = 'Y' where sc.server_id in (
>select vi.virtual_system_id from rhnServerFveCapable sfc inner join
>rhnVirtualInstance vi on vi.virtual_system_id = sfc.server_id where
>vi.host_system_id =  $1  and sfc.channel_family_id =  $2  order by vi.modified
>desc limit free_slots )
>CONTEXT:  PL/pgSQL function "repoll_virt_guest_entitlements" line 96 at SQL
>statement
>---
> .../postgres/packages/rhn_entitlements.pkb         |    5 +++++
> 1 files changed, 5 insertions(+), 0 deletions(-)
>
>diff --git a/schema/spacewalk/postgres/packages/rhn_entitlements.pkb b/schema/spacewalk/postgres/packages/rhn_entitlements.pkb
>index ca87089..2ed168a 100644
>--- a/schema/spacewalk/postgres/packages/rhn_entitlements.pkb
>+++ b/schema/spacewalk/postgres/packages/rhn_entitlements.pkb
>@@ -598,6 +598,7 @@ as $$
>         current_members_calc numeric;
>         sg_id numeric;
>         is_virt numeric := 0;
>+        free_slots numeric := 0;
>     begin
>           select 1 into is_virt
>                 from rhnServerEntitlementView
>@@ -619,6 +620,10 @@ as $$
>             -- if the host_server does not have virt
>             --- find all possible flex slots
>             -- and set each of the flex eligible guests to Y
>+                select sfc.max_members - sfc.current_members
>+                  into free_slots
>+                  from rhnServerFveCapable sfc
>+                 where sfc.channel_family_id = family.channel_family_id;
>                 UPDATE rhnServerChannel sc set is_fve = 'Y'
>                 where sc.server_id in (
>                             select vi.virtual_system_id
>-- 
>1.7.1
>

Actions: View | Diff

Attachments on bug 811646: 576812 | 576813 | 577018 | 577020 | 577396 | 578655