[Spacewalk-list] Oracle "unique constraint" error + spacewalk-repo-sync not updating packages

[Santi Saez]

Hi,

I'm getting this error when updating a child channel using rhnpush:

"ORA-00001: unique constraint (SPACEWALK.RHN_CNP_CID_NID_UQ) violated"

According to the previous messages on the list, [1] and [2], we have 
moved our scripts to use "spacewalk-repo-sync" instead of rhnpush:

# createrepo /var/repos/centos/4/i386/xxx

# ls -1 /var/repos/centos/4/i386/xxx
cfengine-2.2.10-1.el4.rf.i386.rpm
hobbit-client-4.2.0-1.el4.i386.rpm
htop-0.8.1-3.el4.i386.rpm
lua-5.0.3-1.el4.i386.rpm
mod_security-2.5.9-1.el4.i386.rpm
mpt-status-1.2.0_RC7-3.i386.rpm
perl-CGI-Session-4.20-1.el4.rf.noarch.rpm
repodata

# /usr/bin/spacewalk-repo-sync --channel=centos-4-i386-xxx --type=yum 
--label=redhat --url=file:///var/repos/centos/4/i386/xxx/
Repo file:///var/repos/centos/4/i386/xxx/ has 7 packages.
No new packages to download.
Sync complete

In this case "cfengine-2.2.10" package is correctly upload to the child 
channel but no systems appears as "Out of date" (all system are using 
cfengine-2.2.8), this appears as #496655 bug:

* Bug #496655 - Package List never gets refreshed
https://bugzilla.redhat.com/show_bug.cgi?id=496655

To solve this I need to unscribe and re-subcribe to a child channel as 
described in the bug description. Any ideas about this, perhaps bug 
#496655 appears again?

System information:

# rpm -qa spacewalk centos-release
centos-release-5-3.el5.centos.1
spacewalk-0.6.4-1.el5

Thanks!

[1] http://tr.im/znDd
[2] http://tr.im/znDi

-- 
Santi Saez
http://woop.es