[Spacewalk-list] spacewalk-dobby problem

Jan Pazdziora jpazdziora at redhat.com
Thu Aug 2 08:35:17 UTC 2012


On Wed, Aug 01, 2012 at 09:20:53PM +0200, spacewalk at aukes.com wrote:
> Hi Jan,
> 
> >>>(1 row)ERROR:  relation "rhn_appinst_instance_id_seq" does not existLINE 1:
> >>select pg_catalog.setval('rhn_appinst_instance_id_seq', 1,
> >>f...                                 ^
> >>
> >
> >This means the schema that you've dumped is of version 1.6, or your
> >original upgrade from 1.6 to 1.7 failed. In any case, if loading the
> >dump failed this way, your database is in inconsistent state and I
> >don't recomment proceeding with using it.
> 
> Actually, before dumping the database that I was trying to restore, I did a
> 'yum update' on the Spacewalk server and a spacewalk-schema-upgrade. I can't
> imagine it really is a version 1.6 database.

Did the spacewalk-schema-upgrade run without errors? Do you have a
file 065-rhnAppInstallInstance-drop.sql on your filesystem? That
should have dropped the sequence for good ...

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




More information about the Spacewalk-list mailing list