[Spacewalk-list] Configuration Management broken when upgrading to v1.5

[Josh.Mullis at cox.com]

Thanks for the response Jan.

We had moved from 10g to 11g before doing the upgrade which seemed to be the root of the problem.
We did get some errors when upgrading schema from 1.1->1.2, but those were thought to be resolved from a fix given in a mailing list thread.
Maybe this is where the issue started.


However, performing the upgrade on 10g first, then moving to 11g solved our issues.



-----Original Message-----
From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Jan Pazdziora
Sent: Monday, November 21, 2011 7:33 AM
To: spacewalk-list at redhat.com
Subject: Re: [Spacewalk-list] Configuration Management broken when upgrading to v1.5

On Sun, Nov 06, 2011 at 05:00:33PM -0500, Josh.Mullis at cox.com wrote:
> Hello list...
> 
> After upgrading from v0.8 to v1.5,  adding or modifying configuration files fails with an "Internal Server Error" message.
> However downloading config files still works.
> Tomcat traceback is below...
> 
> Can anyone help?

[...]


> 2011-11-04 13:11:03,457 [TP-Processor8] ERROR
> com.redhat.rhn.frontend.servlets.SessionFilter - Error during transaction.
> Rolling back
> javax.servlet.ServletException: ORA-00001: unique constraint
> (SPACEWALK.RHNCHECKSUM_PK) violated
> ORA-06512: at "SPACEWALK.LOOKUP_CHECKSUM", line 21
> ORA-01403: no data found
> ORA-06512: at line 1

The constraint RHNCHECKSUM_PK is on table rhnChecksum, column id.
In the lookup_checksum procedure, it is being populated from database
sequence rhnChecksum_seq.

So it looks like your rhnChecksum_seq is giving out lower values than
there are already stored in the rhnChecksum table.

Can you run

	select max(id) from rhnChecksum;
	select rhnChecksum_seq.nextval from dual;

Did you perhaps drop and recreate that sequence? Anything else in the
history of this Spacewalk server installation worth noting?

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

_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list