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

[Jan Pazdziora]

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