[Spacewalk-list] SQL errors after upgrade 1.2 -> 1.3

[Jan Pazdziora]

On Wed, Mar 23, 2011 at 08:02:07PM +1100, Nat N wrote:
> > ...
> > % SQL Error generated: ('syntax error at or near "with id" at character
> > % 143\n', 0, '\n    select sa.action_id, sa.status\n      from
> > % rhnServerAction sa,\n         (\n          select id\n            from
> > % rhnAction\n           start with id = %(action_id)s\n
> > % connect by prior id = prerequisite\n         ) a\n     where
> > % sa.server_id = %(server_id)s\n       and sa.action_id = a.id\n')
> >
> > Hi Nathan,
> >
> > This error has been fixed in nightly repo (package
> > spacewalk-backend-1.4.20-1). Unfortunately the change is a bit complex
> > (commits f752cc6680932cf1245f3260347367030b49e8ca to
> > 25263f4c806c5eda910b4b5f26eb4030a92118df) so at the moment we are not
> > planning to backport it.
> 
> Thanks for the heads up,
> 
> Since it is only a testing system currently, would it possible to
> migrate to the 1.4 branch
> (using roughly the same steps as the 1.2 ->1.3 migration)?

Yes, just point your Spacewalk installation to the nightly yum repo
and do upgrade steps the same way you'd do when going from 1.2 to 1.3.

Beware however! You will very likely not be able to then upgrade
the "nightly" Spacewalk (namely, it's database schema) to 1.4 once it
is released, without manual hacking.

-- 
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat