[Spacewalk-list] ISE after update to 2.1

[Jonathan Hoser]

On 03/07/2014 11:08 AM, Milan Zázrivec wrote:
>
> 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) |
Indeed I am missing the package_arch_id numeric column;
And I must have missed something,
I could have sworn, that the upgrade worked flawlessly (I did two
Spacewalks in parallel,
one I know failed, but I was sure the second upgrade did work just fine....)

So I'm off to fixing it, thanks for the pointers,

-Jonathan

--
Jonathan Hoser, M.Sc.
Institute of Bioinformatics and System Biology

WWW: http://mips.helmholtz-muenchen.de


Helmholtz Zentrum München
Deutsches Forschungszentrum für Gesundheit und Umwelt (GmbH)
Ingolstädter Landstr. 1
85764 Neuherberg
www.helmholtz-muenchen.de
Aufsichtsratsvorsitzende: MinDir´in Bärbel Brumme-Bothe
Geschäftsführer: Prof. Dr. Günther Wess, Dr. Nikolaus Blum, Dr. Alfons Enhsen
Registergericht: Amtsgericht München HRB 6466
USt-IdNr: DE 129521671