Attachment 576813 Details for Bug 811646 – Postgresql log

Postgresql log

postgresql-Wed.log (text/plain), 30.03 KB, created by James Hogarth on 2012-04-11 15:34:33 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: James Hogarth

Created: 2012-04-11 15:34:33 UTC

Size: 30.03 KB

patch

obsolete

>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
>STATEMENT:  SELECT rhn_entitlements.repoll_virt_guest_entitlements(1000010002)
>ERROR:  current transaction is aborted, commands ignored until end of transaction block
>STATEMENT:  
>	            SELECT
>	                rvi.id                as rvi_id,
>	                rvi.host_system_id    as host_system_id,
>	                rvi.virtual_system_id as virtual_system_id,
>	                rvi.confirmed         as confirmed,
>	                rvii.name             as name,
>	                rvit.label            as instance_type,
>	                rvii.memory_size_k    as memory_size_k,
>	                rvii.instance_id      as instance_id,
>	                rvii.vcpus            as vcpus,
>	                rvis.label            as state
>	            FROM
>	                rhnVirtualInstanceInfo rvii,
>	                rhnVirtualInstanceType rvit,
>	                rhnVirtualInstanceState rvis,
>	                rhnVirtualInstance rvi
>	            WHERE
>	                ((rvi.uuid=E'fdf1591ed7e09ce95507364a39f17de4' and
>	                  NOT EXISTS (SELECT 1
>	                                FROM rhnServer host_system,
>	                                     rhnServer matching_uuid_system
>	                               WHERE matching_uuid_system.id = rvi.virtual_system_id
>	                                 AND host_system.id = 1000010002
>	                                 AND host_system.org_id != matching_uuid_system.org_id)) or
>	                 (E'fdf1591ed7e09ce95507364a39f17de4' is null and 
>	                      rvi.uuid is null and 
>	                      rvi.host_system_id=1000010002)) and
>	                rvi.id = rvii.instance_id and
>	                rvit.id = rvii.instance_type and
>	                rvis.id = rvii.state
>	        
>ERROR:  -20287 : (invalid_entitlement) - The server can not be entitled to the specified level
>CONTEXT:  SQL statement "SELECT  rhn_exception.raise_exception ('invalid_entitlement')"
>	PL/pgSQL function "entitle_server" line 49 at PERFORM
>STATEMENT:  SELECT rhn_entitlements.entitle_server(1000010003, E'provisioning_entitled')
>ERROR:  current transaction is aborted, commands ignored until end of transaction block
>STATEMENT:  
>	        select ca.label arch,
>	               c.id,
>	               c.parent_channel,
>	               c.org_id,
>	               c.label,
>	               c.name,
>	               c.summary,
>	               c.description,
>	               to_char(c.last_modified, 'YYYYMMDDHH24MISS') last_modified,
>	               rhn_channel.available_chan_subscriptions(c.id, E'1') available_subscriptions
>	          from rhnChannel c,
>	               rhnChannelArch ca
>	        where c.channel_arch_id = ca.id
>	          and c.id = rhn_channel.base_channel_for_release_arch(
>	                E'6', E'x86_64', E'1', 2)
>	    
>ERROR:  -20287 : (invalid_entitlement) - The server can not be entitled to the specified level
>CONTEXT:  SQL statement "SELECT  rhn_exception.raise_exception ('invalid_entitlement')"
>	PL/pgSQL function "entitle_server" line 49 at PERFORM
>STATEMENT:  SELECT rhn_entitlements.entitle_server(1000010004, E'provisioning_entitled')
>ERROR:  current transaction is aborted, commands ignored until end of transaction block
>STATEMENT:  
>	        select ca.label arch,
>	               c.id,
>	               c.parent_channel,
>	               c.org_id,
>	               c.label,
>	               c.name,
>	               c.summary,
>	               c.description,
>	               to_char(c.last_modified, 'YYYYMMDDHH24MISS') last_modified,
>	               rhn_channel.available_chan_subscriptions(c.id, E'1') available_subscriptions
>	          from rhnChannel c,
>	               rhnChannelArch ca
>	        where c.channel_arch_id = ca.id
>	          and c.id = rhn_channel.base_channel_for_release_arch(
>	                E'6', E'x86_64', E'1', 2)
>	    
>ERROR:  -20287 : (invalid_entitlement) - The server can not be entitled to the specified level
>CONTEXT:  SQL statement "SELECT  rhn_exception.raise_exception ('invalid_entitlement')"
>	PL/pgSQL function "entitle_server" line 49 at PERFORM
>STATEMENT:  SELECT rhn_entitlements.entitle_server(1000010005, E'provisioning_entitled')
>ERROR:  current transaction is aborted, commands ignored until end of transaction block
>STATEMENT:  
>	        select ca.label arch,
>	               c.id,
>	               c.parent_channel,
>	               c.org_id,
>	               c.label,
>	               c.name,
>	               c.summary,
>	               c.description,
>	               to_char(c.last_modified, 'YYYYMMDDHH24MISS') last_modified,
>	               rhn_channel.available_chan_subscriptions(c.id, E'1') available_subscriptions
>	          from rhnChannel c,
>	               rhnChannelArch ca
>	        where c.channel_arch_id = ca.id
>	          and c.id = rhn_channel.base_channel_for_release_arch(
>	                E'6', E'x86_64', E'1', 1)
>	    
>ERROR:  -20287 : (invalid_entitlement) - The server can not be entitled to the specified level
>CONTEXT:  SQL statement "SELECT  rhn_exception.raise_exception ('invalid_entitlement')"
>	PL/pgSQL function "entitle_server" line 49 at PERFORM
>STATEMENT:  SELECT rhn_entitlements.entitle_server(1000010006, E'provisioning_entitled')
>ERROR:  current transaction is aborted, commands ignored until end of transaction block
>STATEMENT:  
>	        select ca.label arch,
>	               c.id,
>	               c.parent_channel,
>	               c.org_id,
>	               c.label,
>	               c.name,
>	               c.summary,
>	               c.description,
>	               to_char(c.last_modified, 'YYYYMMDDHH24MISS') last_modified,
>	               rhn_channel.available_chan_subscriptions(c.id, E'1') available_subscriptions
>	          from rhnChannel c,
>	               rhnChannelArch ca
>	        where c.channel_arch_id = ca.id
>	          and c.id = rhn_channel.base_channel_for_release_arch(
>	                E'6', E'x86_64', E'1', 2)
>	    
>ERROR:  -20287 : (invalid_entitlement) - The server can not be entitled to the specified level
>CONTEXT:  SQL statement "SELECT  rhn_exception.raise_exception ('invalid_entitlement')"
>	PL/pgSQL function "entitle_server" line 49 at PERFORM
>STATEMENT:  SELECT rhn_entitlements.entitle_server(1000010007, E'provisioning_entitled')
>ERROR:  current transaction is aborted, commands ignored until end of transaction block
>STATEMENT:  
>	        select ca.label arch,
>	               c.id,
>	               c.parent_channel,
>	               c.org_id,
>	               c.label,
>	               c.name,
>	               c.summary,
>	               c.description,
>	               to_char(c.last_modified, 'YYYYMMDDHH24MISS') last_modified,
>	               rhn_channel.available_chan_subscriptions(c.id, E'1') available_subscriptions
>	          from rhnChannel c,
>	               rhnChannelArch ca
>	        where c.channel_arch_id = ca.id
>	          and c.id = rhn_channel.base_channel_for_release_arch(
>	                E'6', E'x86_64', E'1', 2)
>	    
>ERROR:  -20287 : (invalid_entitlement) - The server can not be entitled to the specified level
>CONTEXT:  SQL statement "SELECT  rhn_exception.raise_exception ('invalid_entitlement')"
>	PL/pgSQL function "entitle_server" line 49 at PERFORM
>STATEMENT:  SELECT rhn_entitlements.entitle_server(1000010008, E'provisioning_entitled')
>ERROR:  current transaction is aborted, commands ignored until end of transaction block
>STATEMENT:  
>	        select ca.label arch,
>	               c.id,
>	               c.parent_channel,
>	               c.org_id,
>	               c.label,
>	               c.name,
>	               c.summary,
>	               c.description,
>	               to_char(c.last_modified, 'YYYYMMDDHH24MISS') last_modified,
>	               rhn_channel.available_chan_subscriptions(c.id, E'1') available_subscriptions
>	          from rhnChannel c,
>	               rhnChannelArch ca
>	        where c.channel_arch_id = ca.id
>	          and c.id = rhn_channel.base_channel_for_release_arch(
>	                E'6', E'x86_64', E'1', 2)
>	    
>ERROR:  -20287 : (invalid_entitlement) - The server can not be entitled to the specified level
>CONTEXT:  SQL statement "SELECT  rhn_exception.raise_exception ('invalid_entitlement')"
>	PL/pgSQL function "entitle_server" line 49 at PERFORM
>STATEMENT:  SELECT rhn_entitlements.entitle_server(1000010009, E'provisioning_entitled')
>ERROR:  current transaction is aborted, commands ignored until end of transaction block
>STATEMENT:  
>	        select ca.label arch,
>	               c.id,
>	               c.parent_channel,
>	               c.org_id,
>	               c.label,
>	               c.name,
>	               c.summary,
>	               c.description,
>	               to_char(c.last_modified, 'YYYYMMDDHH24MISS') last_modified,
>	               rhn_channel.available_chan_subscriptions(c.id, E'1') available_subscriptions
>	          from rhnChannel c,
>	               rhnChannelArch ca
>	        where c.channel_arch_id = ca.id
>	          and c.id = rhn_channel.base_channel_for_release_arch(
>	                E'6', E'x86_64', E'1', 2)
>	    
>ERROR:  -20287 : (invalid_entitlement) - The server can not be entitled to the specified level
>CONTEXT:  SQL statement "SELECT  rhn_exception.raise_exception ('invalid_entitlement')"
>	PL/pgSQL function "entitle_server" line 49 at PERFORM
>STATEMENT:  SELECT rhn_entitlements.entitle_server(1000010010, E'provisioning_entitled')
>ERROR:  current transaction is aborted, commands ignored until end of transaction block
>STATEMENT:  
>	        select ca.label arch,
>	               c.id,
>	               c.parent_channel,
>	               c.org_id,
>	               c.label,
>	               c.name,
>	               c.summary,
>	               c.description,
>	               to_char(c.last_modified, 'YYYYMMDDHH24MISS') last_modified,
>	               rhn_channel.available_chan_subscriptions(c.id, E'1') available_subscriptions
>	          from rhnChannel c,
>	               rhnChannelArch ca
>	        where c.channel_arch_id = ca.id
>	          and c.id = rhn_channel.base_channel_for_release_arch(
>	                E'6', E'x86_64', E'1', 2)
>	    
>ERROR:  -20287 : (invalid_entitlement) - The server can not be entitled to the specified level
>CONTEXT:  SQL statement "SELECT  rhn_exception.raise_exception ('invalid_entitlement')"
>	PL/pgSQL function "entitle_server" line 49 at PERFORM
>STATEMENT:  SELECT rhn_entitlements.entitle_server(1000010011, E'provisioning_entitled')
>ERROR:  current transaction is aborted, commands ignored until end of transaction block
>STATEMENT:  
>	        select ca.label arch,
>	               c.id,
>	               c.parent_channel,
>	               c.org_id,
>	               c.label,
>	               c.name,
>	               c.summary,
>	               c.description,
>	               to_char(c.last_modified, 'YYYYMMDDHH24MISS') last_modified,
>	               rhn_channel.available_chan_subscriptions(c.id, E'1') available_subscriptions
>	          from rhnChannel c,
>	               rhnChannelArch ca
>	        where c.channel_arch_id = ca.id
>	          and c.id = rhn_channel.base_channel_for_release_arch(
>	                E'6', E'x86_64', E'1', 2)
>	    
>ERROR:  -20287 : (invalid_entitlement) - The server can not be entitled to the specified level
>CONTEXT:  SQL statement "SELECT  rhn_exception.raise_exception ('invalid_entitlement')"
>	PL/pgSQL function "entitle_server" line 49 at PERFORM
>STATEMENT:  SELECT rhn_entitlements.entitle_server(1000010012, E'provisioning_entitled')
>ERROR:  current transaction is aborted, commands ignored until end of transaction block
>STATEMENT:  
>	        select ca.label arch,
>	               c.id,
>	               c.parent_channel,
>	               c.org_id,
>	               c.label,
>	               c.name,
>	               c.summary,
>	               c.description,
>	               to_char(c.last_modified, 'YYYYMMDDHH24MISS') last_modified,
>	               rhn_channel.available_chan_subscriptions(c.id, E'1') available_subscriptions
>	          from rhnChannel c,
>	               rhnChannelArch ca
>	        where c.channel_arch_id = ca.id
>	          and c.id = rhn_channel.base_channel_for_release_arch(
>	                E'6', E'x86_64', E'1', 2)
>	    
>ERROR:  -20287 : (invalid_entitlement) - The server can not be entitled to the specified level
>CONTEXT:  SQL statement "SELECT  rhn_exception.raise_exception ('invalid_entitlement')"
>	PL/pgSQL function "entitle_server" line 49 at PERFORM
>STATEMENT:  SELECT rhn_entitlements.entitle_server(1000010013, E'provisioning_entitled')
>ERROR:  current transaction is aborted, commands ignored until end of transaction block
>STATEMENT:  
>	        select ca.label arch,
>	               c.id,
>	               c.parent_channel,
>	               c.org_id,
>	               c.label,
>	               c.name,
>	               c.summary,
>	               c.description,
>	               to_char(c.last_modified, 'YYYYMMDDHH24MISS') last_modified,
>	               rhn_channel.available_chan_subscriptions(c.id, E'1') available_subscriptions
>	          from rhnChannel c,
>	               rhnChannelArch ca
>	        where c.channel_arch_id = ca.id
>	          and c.id = rhn_channel.base_channel_for_release_arch(
>	                E'6', E'x86_64', E'1', 2)
>	    
>ERROR:  -20287 : (invalid_entitlement) - The server can not be entitled to the specified level
>CONTEXT:  SQL statement "SELECT  rhn_exception.raise_exception ('invalid_entitlement')"
>	PL/pgSQL function "entitle_server" line 49 at PERFORM
>STATEMENT:  SELECT rhn_entitlements.entitle_server(1000010014, E'provisioning_entitled')
>ERROR:  current transaction is aborted, commands ignored until end of transaction block
>STATEMENT:  
>	        select ca.label arch,
>	               c.id,
>	               c.parent_channel,
>	               c.org_id,
>	               c.label,
>	               c.name,
>	               c.summary,
>	               c.description,
>	               to_char(c.last_modified, 'YYYYMMDDHH24MISS') last_modified,
>	               rhn_channel.available_chan_subscriptions(c.id, E'1') available_subscriptions
>	          from rhnChannel c,
>	               rhnChannelArch ca
>	        where c.channel_arch_id = ca.id
>	          and c.id = rhn_channel.base_channel_for_release_arch(
>	                E'6', E'x86_64', E'1', 2)
>	    
>ERROR:  -20287 : (invalid_entitlement) - The server can not be entitled to the specified level
>CONTEXT:  SQL statement "SELECT  rhn_exception.raise_exception ('invalid_entitlement')"
>	PL/pgSQL function "entitle_server" line 49 at PERFORM
>STATEMENT:  SELECT rhn_entitlements.entitle_server(1000010015, E'provisioning_entitled')
>ERROR:  current transaction is aborted, commands ignored until end of transaction block
>STATEMENT:  
>	        select ca.label arch,
>	               c.id,
>	               c.parent_channel,
>	               c.org_id,
>	               c.label,
>	               c.name,
>	               c.summary,
>	               c.description,
>	               to_char(c.last_modified, 'YYYYMMDDHH24MISS') last_modified,
>	               rhn_channel.available_chan_subscriptions(c.id, E'1') available_subscriptions
>	          from rhnChannel c,
>	               rhnChannelArch ca
>	        where c.channel_arch_id = ca.id
>	          and c.id = rhn_channel.base_channel_for_release_arch(
>	                E'6', E'x86_64', E'1', 2)
>	    
>ERROR:  -20287 : (invalid_entitlement) - The server can not be entitled to the specified level
>CONTEXT:  SQL statement "SELECT  rhn_exception.raise_exception ('invalid_entitlement')"
>	PL/pgSQL function "entitle_server" line 49 at PERFORM
>STATEMENT:  SELECT rhn_entitlements.entitle_server(1000010016, E'provisioning_entitled')
>ERROR:  current transaction is aborted, commands ignored until end of transaction block
>STATEMENT:  
>	        select ca.label arch,
>	               c.id,
>	               c.parent_channel,
>	               c.org_id,
>	               c.label,
>	               c.name,
>	               c.summary,
>	               c.description,
>	               to_char(c.last_modified, 'YYYYMMDDHH24MISS') last_modified,
>	               rhn_channel.available_chan_subscriptions(c.id, E'1') available_subscriptions
>	          from rhnChannel c,
>	               rhnChannelArch ca
>	        where c.channel_arch_id = ca.id
>	          and c.id = rhn_channel.base_channel_for_release_arch(
>	                E'6', E'x86_64', E'1', 2)
>	    
>ERROR:  -20287 : (invalid_entitlement) - The server can not be entitled to the specified level
>CONTEXT:  SQL statement "SELECT  rhn_exception.raise_exception ('invalid_entitlement')"
>	PL/pgSQL function "entitle_server" line 49 at PERFORM
>STATEMENT:  SELECT rhn_entitlements.entitle_server(1000010017, E'provisioning_entitled')
>ERROR:  current transaction is aborted, commands ignored until end of transaction block
>STATEMENT:  
>	        select ca.label arch,
>	               c.id,
>	               c.parent_channel,
>	               c.org_id,
>	               c.label,
>	               c.name,
>	               c.summary,
>	               c.description,
>	               to_char(c.last_modified, 'YYYYMMDDHH24MISS') last_modified,
>	               rhn_channel.available_chan_subscriptions(c.id, E'1') available_subscriptions
>	          from rhnChannel c,
>	               rhnChannelArch ca
>	        where c.channel_arch_id = ca.id
>	          and c.id = rhn_channel.base_channel_for_release_arch(
>	                E'6', E'x86_64', E'1', 2)
>	    
>ERROR:  -20287 : (invalid_entitlement) - The server can not be entitled to the specified level
>CONTEXT:  SQL statement "SELECT  rhn_exception.raise_exception ('invalid_entitlement')"
>	PL/pgSQL function "entitle_server" line 49 at PERFORM
>STATEMENT:  SELECT rhn_entitlements.entitle_server(1000010018, E'provisioning_entitled')
>ERROR:  current transaction is aborted, commands ignored until end of transaction block
>STATEMENT:  
>	        select ca.label arch,
>	               c.id,
>	               c.parent_channel,
>	               c.org_id,
>	               c.label,
>	               c.name,
>	               c.summary,
>	               c.description,
>	               to_char(c.last_modified, 'YYYYMMDDHH24MISS') last_modified,
>	               rhn_channel.available_chan_subscriptions(c.id, E'1') available_subscriptions
>	          from rhnChannel c,
>	               rhnChannelArch ca
>	        where c.channel_arch_id = ca.id
>	          and c.id = rhn_channel.base_channel_for_release_arch(
>	                E'6', E'x86_64', E'1', 1)
>	    
>ERROR:  -20287 : (invalid_entitlement) - The server can not be entitled to the specified level
>CONTEXT:  SQL statement "SELECT  rhn_exception.raise_exception ('invalid_entitlement')"
>	PL/pgSQL function "entitle_server" line 49 at PERFORM
>STATEMENT:  SELECT rhn_entitlements.entitle_server(1000010019, E'provisioning_entitled')
>ERROR:  current transaction is aborted, commands ignored until end of transaction block
>STATEMENT:  
>	        select ca.label arch,
>	               c.id,
>	               c.parent_channel,
>	               c.org_id,
>	               c.label,
>	               c.name,
>	               c.summary,
>	               c.description,
>	               to_char(c.last_modified, 'YYYYMMDDHH24MISS') last_modified,
>	               rhn_channel.available_chan_subscriptions(c.id, E'1') available_subscriptions
>	          from rhnChannel c,
>	               rhnChannelArch ca
>	        where c.channel_arch_id = ca.id
>	          and c.id = rhn_channel.base_channel_for_release_arch(
>	                E'6', E'x86_64', E'1', 1)
>	    
>ERROR:  -20287 : (invalid_entitlement) - The server can not be entitled to the specified level
>CONTEXT:  SQL statement "SELECT  rhn_exception.raise_exception ('invalid_entitlement')"
>	PL/pgSQL function "entitle_server" line 49 at PERFORM
>STATEMENT:  SELECT rhn_entitlements.entitle_server(1000010020, E'provisioning_entitled')
>ERROR:  current transaction is aborted, commands ignored until end of transaction block
>STATEMENT:  
>	        select ca.label arch,
>	               c.id,
>	               c.parent_channel,
>	               c.org_id,
>	               c.label,
>	               c.name,
>	               c.summary,
>	               c.description,
>	               to_char(c.last_modified, 'YYYYMMDDHH24MISS') last_modified,
>	               rhn_channel.available_chan_subscriptions(c.id, E'1') available_subscriptions
>	          from rhnChannel c,
>	               rhnChannelArch ca
>	        where c.channel_arch_id = ca.id
>	          and c.id = rhn_channel.base_channel_for_release_arch(
>	                E'6', E'x86_64', E'1', 2)
>	    
>LOG:  unexpected EOF on client connection
>LOG:  unexpected EOF on client connection
>LOG:  unexpected EOF on client connection
>LOG:  unexpected EOF on client connection
>LOG:  unexpected EOF on client connection
>LOG:  unexpected EOF on client connection
>LOG:  unexpected EOF on client connection
>LOG:  unexpected EOF on client connection
>LOG:  unexpected EOF on client connection
>LOG:  unexpected EOF on client connection
>LOG:  unexpected EOF on client connection
>LOG:  unexpected EOF on client connection
>LOG:  unexpected EOF on client connection
>LOG:  unexpected EOF on client connection
>LOG:  unexpected EOF on client connection
>LOG:  unexpected EOF on client connection
>LOG:  unexpected EOF on client connection
>LOG:  unexpected EOF on client connection
>LOG:  unexpected EOF on client connection
>LOG:  unexpected EOF on client connection
>LOG:  unexpected EOF on client connection
>LOG:  unexpected EOF on client connection
>LOG:  unexpected EOF on client connection
>LOG:  unexpected EOF on client connection
>LOG:  unexpected EOF on client connection
>LOG:  unexpected EOF on client connection
>LOG:  unexpected EOF on client connection
>LOG:  unexpected EOF on client connection
>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
>STATEMENT:  SELECT rhn_entitlements.repoll_virt_guest_entitlements(1000010023)
>ERROR:  current transaction is aborted, commands ignored until end of transaction block
>STATEMENT:  
>	            SELECT
>	                rvi.id                as rvi_id,
>	                rvi.host_system_id    as host_system_id,
>	                rvi.virtual_system_id as virtual_system_id,
>	                rvi.confirmed         as confirmed,
>	                rvii.name             as name,
>	                rvit.label            as instance_type,
>	                rvii.memory_size_k    as memory_size_k,
>	                rvii.instance_id      as instance_id,
>	                rvii.vcpus            as vcpus,
>	                rvis.label            as state
>	            FROM
>	                rhnVirtualInstanceInfo rvii,
>	                rhnVirtualInstanceType rvit,
>	                rhnVirtualInstanceState rvis,
>	                rhnVirtualInstance rvi
>	            WHERE
>	                ((rvi.uuid=E'cf621ad0107841c9e5e980d2b0854107' and
>	                  NOT EXISTS (SELECT 1
>	                                FROM rhnServer host_system,
>	                                     rhnServer matching_uuid_system
>	                               WHERE matching_uuid_system.id = rvi.virtual_system_id
>	                                 AND host_system.id = 1000010023
>	                                 AND host_system.org_id != matching_uuid_system.org_id)) or
>	                 (E'cf621ad0107841c9e5e980d2b0854107' is null and 
>	                      rvi.uuid is null and 
>	                      rvi.host_system_id=1000010023)) and
>	                rvi.id = rvii.instance_id and
>	                rvit.id = rvii.instance_type and
>	                rvis.id = rvii.state
>	        
>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
>STATEMENT:  SELECT rhn_entitlements.repoll_virt_guest_entitlements(1000010023)
>ERROR:  current transaction is aborted, commands ignored until end of transaction block
>STATEMENT:  
>	            SELECT
>	                rvi.id                as rvi_id,
>	                rvi.host_system_id    as host_system_id,
>	                rvi.virtual_system_id as virtual_system_id,
>	                rvi.confirmed         as confirmed,
>	                rvii.name             as name,
>	                rvit.label            as instance_type,
>	                rvii.memory_size_k    as memory_size_k,
>	                rvii.instance_id      as instance_id,
>	                rvii.vcpus            as vcpus,
>	                rvis.label            as state
>	            FROM
>	                rhnVirtualInstanceInfo rvii,
>	                rhnVirtualInstanceType rvit,
>	                rhnVirtualInstanceState rvis,
>	                rhnVirtualInstance rvi
>	            WHERE
>	                ((rvi.uuid=E'cf621ad0107841c9e5e980d2b0854107' and
>	                  NOT EXISTS (SELECT 1
>	                                FROM rhnServer host_system,
>	                                     rhnServer matching_uuid_system
>	                               WHERE matching_uuid_system.id = rvi.virtual_system_id
>	                                 AND host_system.id = 1000010023
>	                                 AND host_system.org_id != matching_uuid_system.org_id)) or
>	                 (E'cf621ad0107841c9e5e980d2b0854107' is null and 
>	                      rvi.uuid is null and 
>	                      rvi.host_system_id=1000010023)) and
>	                rvi.id = rvii.instance_id and
>	                rvit.id = rvii.instance_type and
>	                rvis.id = rvii.state
>	        
>ERROR:  -20287 : (invalid_entitlement) - The server can not be entitled to the specified level
>CONTEXT:  SQL statement "SELECT  rhn_exception.raise_exception ('invalid_entitlement')"
>	PL/pgSQL function "entitle_server" line 49 at PERFORM
>STATEMENT:  SELECT rhn_entitlements.entitle_server(1000010024, E'provisioning_entitled')
>ERROR:  current transaction is aborted, commands ignored until end of transaction block
>STATEMENT:  
>	        select ca.label arch,
>	               c.id,
>	               c.parent_channel,
>	               c.org_id,
>	               c.label,
>	               c.name,
>	               c.summary,
>	               c.description,
>	               to_char(c.last_modified, 'YYYYMMDDHH24MISS') last_modified,
>	               rhn_channel.available_chan_subscriptions(c.id, E'1') available_subscriptions
>	          from rhnChannel c,
>	               rhnChannelArch ca
>	        where c.channel_arch_id = ca.id
>	          and c.id = rhn_channel.base_channel_for_release_arch(
>	                E'6', E'x86_64', E'1', 1)
>	    
>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
>STATEMENT:  SELECT rhn_entitlements.repoll_virt_guest_entitlements(1000010023)
>ERROR:  current transaction is aborted, commands ignored until end of transaction block
>STATEMENT:  
>	            SELECT
>	                rvi.id                as rvi_id,
>	                rvi.host_system_id    as host_system_id,
>	                rvi.virtual_system_id as virtual_system_id,
>	                rvi.confirmed         as confirmed,
>	                rvii.name             as name,
>	                rvit.label            as instance_type,
>	                rvii.memory_size_k    as memory_size_k,
>	                rvii.instance_id      as instance_id,
>	                rvii.vcpus            as vcpus,
>	                rvis.label            as state
>	            FROM
>	                rhnVirtualInstanceInfo rvii,
>	                rhnVirtualInstanceType rvit,
>	                rhnVirtualInstanceState rvis,
>	                rhnVirtualInstance rvi
>	            WHERE
>	                ((rvi.uuid=E'c9eccaa5a6649fc1564399cc4c731a78' and
>	                  NOT EXISTS (SELECT 1
>	                                FROM rhnServer host_system,
>	                                     rhnServer matching_uuid_system
>	                               WHERE matching_uuid_system.id = rvi.virtual_system_id
>	                                 AND host_system.id = 1000010023
>	                                 AND host_system.org_id != matching_uuid_system.org_id)) or
>	                 (E'c9eccaa5a6649fc1564399cc4c731a78' is null and 
>	                      rvi.uuid is null and 
>	                      rvi.host_system_id=1000010023)) and
>	                rvi.id = rvii.instance_id and
>	                rvit.id = rvii.instance_type and
>	                rvis.id = rvii.state
>	        
>ERROR:  -20287 : (invalid_entitlement) - The server can not be entitled to the specified level
>CONTEXT:  SQL statement "SELECT  rhn_exception.raise_exception ('invalid_entitlement')"
>	PL/pgSQL function "entitle_server" line 49 at PERFORM
>STATEMENT:  SELECT rhn_entitlements.entitle_server(1000010025, E'provisioning_entitled')
>ERROR:  current transaction is aborted, commands ignored until end of transaction block
>STATEMENT:  
>	        select ca.label arch,
>	               c.id,
>	               c.parent_channel,
>	               c.org_id,
>	               c.label,
>	               c.name,
>	               c.summary,
>	               c.description,
>	               to_char(c.last_modified, 'YYYYMMDDHH24MISS') last_modified,
>	               rhn_channel.available_chan_subscriptions(c.id, E'1') available_subscriptions
>	          from rhnChannel c,
>	               rhnChannelArch ca
>	        where c.channel_arch_id = ca.id
>	          and c.id = rhn_channel.base_channel_for_release_arch(
>	                E'6', E'x86_64', E'1', 1)
>

Actions: View

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