[Spacewalk-list] Database problems upgrading Spacewalk 1.7 -> 1.8

[Jan Pazdziora]

On Fri, Jan 18, 2013 at 02:46:58PM +0100, Jonathan Hoser wrote:
> 
> Yepp it does:
> -bash-4.2$ psql spaceschema
> psql (9.1.7)
> Type "help" for help.
> 
> spaceschema=# select * from dual;
> dummy
> -------
> X
> X
> (2 rows)
> 
> spaceschema=#
> And here I read that dual was just created for compatibility with Oracle...

Yes. And if it has two records it it, your Spacewalk is completely
broken.

You really should investigate how to second record got to that table.

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