[Spacewalk-list] ISE after update to 2.1

[Milan Zázrivec]

On Friday 07 March 2014 10:51:41 Jonathan Hoser wrote:
> Dear all,
> does anyone else experience what I am encountering?:
> 
> What I'm seeing is on the systems-tab, clicking on the
> available-packages link, is throwing an instant ISE:
> 
> The ISEs seem to point to an issue with my spacewalk-schema,
> thought on *that* instance of spacewalk, the update from 2.0 to 2.1
> completed without failures (and without manual intervention whatsoever);
> (running spacewalk 2.1, updated from 2.0 (and earlier before that), on
> CentOS6.5, Postgres 8.4.20)
> 
> ==> tomcat6/catalina.out <==
> 2014-03-07 10:42:42,539 [TP-Processor15] ERROR
> com.redhat.rhn.common.db.datasource.CachedStatement - Error while
> processing cached statement sql: SELECT  n.id AS id,
>         n.id AS name_id,
>         lookup_evr(((latest.evr)).epoch, (latest.evr).version,
> (latest.evr).release) AS evr_id,
>         latest.package_arch_id AS arch_id,
>         (latest.evr).epoch AS epoch,
>         (latest.evr).version AS version,
>         (latest.evr).release AS release,
>         n.name AS name,
>         n.name ||'-'|| evr_t_as_vre_simple(latest.evr) || '.' ||
> latest_pa.label AS nvrea,
>         n.name ||'-'|| evr_t_as_vre_simple(spe.evr) || '.' || spa.label
> AS installed_package,
>         n.id || '|' || lookup_evr((latest.evr).epoch,
> (latest.evr).version, (latest.evr).release)|| '|' ||
> latest.package_arch_id AS id_combo
>   FROM
>        rhnServerPackage sp
>   join rhnPackageName n
>     on n.id = sp.name_id
>   join rhnPackageArch spa
>     on spa.id = sp.package_arch_id
>   join rhnPackageEvr spe
>     on spe.id = sp.evr_id
>   join (
>         select sop.package_name_id,
>                sop.package_arch_id,
>                max(PE.evr) evr
>           from rhnServerOutdatedPackages sop
>           join rhnPackageEVR pe
>             on sop.package_evr_id = pe.id
>          where sop.server_id = ?
>          group by sop.package_name_id, sop.package_arch_id) latest
>     on latest.package_name_id = sp.name_id
>   join rhnPackageArch latest_pa
>     on latest_pa.id = latest.package_arch_id
>   join rhnPackageUpgradeArchCompat puac
>     on puac.package_arch_id = sp.package_arch_id
>    and puac.package_upgrade_arch_id = latest.package_arch_id
>  where sp.server_id = ?
>  order by upper(n.name)
> com.redhat.rhn.common.db.WrappedSQLException: ERROR: column
> sop.package_arch_id does not exist

Did your schema upgrade to 2.1 went all right?

When you connect to your database:

    $ spacewalk-sql -i

Do you see the rhnServerOutdatedPackages view in place?

    yourschema# \d rhnServerOutdatedPackages
       View "public.rhnserveroutdatedpackages"
     Column      |          Type          | Modifiers 
-----------------+------------------------+-----------
 server_id       | numeric                | 
 package_name_id | numeric                | 
 package_evr_id  | numeric                | 
 package_arch_id | numeric                | 
 package_nvre    | text                   | 
 errata_id       | numeric                | 
 errata_advisory | character varying(100) | 


-MZ