[Spacewalk-list] Issues viewing Solaris patches in Spacewalk

[Stephen Herr]

On 09/17/2012 06:36 PM, Kenny Van Alstyne wrote:
> I'm just curious if anyone else is having the below issue --
>
> When browsing to Systems -> Select a Solaris x86 box -> Software ->
> Patches, an ISE is reported.  The Tomcat and PostgreSQL logs are
> below.
>
> 2012-09-17 09:07:45,345 [TP-Processor5] ERROR
> com.redhat.rhn.common.db.datasource.CachedStatement - Error while
> processing cached statement sql: SELECT PN.id as ID,
>         PN.id || '|' || PE.id AS ID_COMBO,
>        PN.name || '-' || evr_t_as_vre_simple(PE.evr) AS NVRE,
>        PN.name AS name,
>        PE.version,
>        PE.release,
>        PE.epoch,
>        PN.id AS NAME_ID,
>        PE.id AS EVR_ID,
>          nvl( (select spt.name                 from rhnSolarisPatchType spt,
>                     rhnSolarisPatch RSP,
>                           rhnPackage p
>               where RSP.package_id = p.id
>           and P.name_id = SP.name_id
>                 and P.evr_id = SP.evr_id
>                 and P.package_arch_id = SP.package_arch_id
>                 and RSP.patch_type = spt.id),
>                 'unknown') as PATCH_TYPE
> FROM  rhnPackageName PN,
>          rhnPackageEVR PE,
>          rhnServerPackage SP
> WHERE SP.server_id = ?
>   AND  SP.name_id = PN.id
>   AND  SP.evr_id = PE.id
>   AND  EXISTS ( SELECT  1
>                   FROM  rhnPackageArch PA,
>                         rhnArchType AT
>                  WHERE  PA.id = SP.package_arch_id
>                    AND  AT.id = PA.arch_type_id
>                    AND  AT.label = 'solaris-patch' )
> ORDER BY UPPER(PN.name), UPPER(evr_t_as_vre_simple(PE.evr))
> com.redhat.rhn.common.db.WrappedSQLException: ERROR: more than one row
> returned by a subquery used as an expression
>

Hi Kenny,

Unfortunately I don't have a Solaris system I can register to try to 
reproduce this with, but it looks to me like this sub query is returning 
more than one row when it should be returning either one or zero rows:

select spt.name
from rhnSolarisPatchType spt,
rhnSolarisPatch RSP,
rhnPackage p
where RSP.package_id = p.id
and P.name_id = SP.name_id
and P.evr_id = SP.evr_id
and P.package_arch_id = SP.package_arch_id
and RSP.patch_type = spt.id


I don't know *why* that query is returning more than one row. I would 
think there should only be a single Solaris Patch that corresponds with 
a given package name / epoch / version / release / arch combination, right?

-Stephen Herr