[Spacewalk-list] Oracle error - channel update

[Jan Pazdziora]

On Wed, Nov 03, 2010 at 11:14:38PM +0000, Tom Brown wrote:
> So have just started getting the following when pushing into a channel
> 
> Error Message:
>     ORA-00001: unique constraint (SPACEWALK.RHN_CNP_CID_NID_UQ) violated
> ORA-06512: at "SPACEWALK.RHN_CHANNEL", line 1147
> ORA-06512: at line 1
> Error Class Code: 23
> Error Class Info: Could not update database entry.
> 
> Its an externally hosted instance thats been fine for about 6 months -
> nothing had changed on the spacewalk server, we are on 1.0, so i
> wonder what i can do to resume being able to push packages?

Looking the the schema definitions, there have been fixes to the
rhnChannelNewestPackageView, so indeed Spacewalk 1.0 has some problems
there. In particular, I wonder if the patch from

	http://git.fedorahosted.org/git/?p=spacewalk.git;a=commitdiff;h=3ee019bf93bdd80315ab3f165f729272e284cde7

could fix the issue.

Please note thou that I did not investigate the exact state of the
code in 1.0 and just did a quick scan through the commit, so I might
be off base here.

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