[Spacewalk-list] Spacewalk .6 oracle constraint violation

[Matt Carey]

I've setup a fresh Spacewalk .6 instance.  While trying to populate a Centos 5.3 x86_64 channel I'm getting the following error:
[root at spacewalk src]# rhnpush -vvv --channel=centos5-x86_64-base --server=http://localhost/APP --dir=/var/www/html/centos/5/os/x86_64/CentOS
Uploading files from directory /var/www/html/centos/5/os/x86_64/CentOS
Connecting to http://localhost/APP
url is http://localhost/PACKAGE-PUSH
Result codes: 200 OK
Computing md5sum and package Info .This may take sometime ...
Package /var/www/html/centos/5/os/x86_64/CentOS/libXdamage-devel-1.0.3-2.1.i386.rpm already exists on the RHN Server-- Skipping Upload....
**snip**
Package /var/www/html/centos/5/os/x86_64/CentOS/glibc-devel-2.5-34.x86_64.rpm already exists on the RHN Server-- Skipping Upload....
Package /var/www/html/centos/5/os/x86_64/CentOS/dbus-libs-1.1.2-12.el5.x86_64.rpm already exists on the RHN Server-- Skipping Upload....

Error Message:
    ORA-00001: unique constraint (SPACEWALK.RHN_CNP_CID_NID_UQ) violated
ORA-06512: at "SPACEWALK.RHN_CHANNEL", line 1131
ORA-06512: at line 1
Error Class Code: 23
Error Class Info: Could not update database entry.

The given channel is configured as follows:
Channel Name:      CentOS 5 x86_64 - Base
Channel Label:     centos5-x86_64-base
Parent Channel:    (none)
Architecture:    x86_64
Summary:    CentOS 5 x86_64 - Base
Description:    CentOS 5 x86_64 - Base
Channel Entitlement Name:    Private Channel Family 1
Last Modified:    2009-08-20 08:03:27.0
Last Repo Build:    2009-08-20 07:47:40
Repo Cache Status:    Completed
Packages:    2647

When trying to use the spacewalk-repo-sync command to populate that same channel it just hangs:
[root at spacewalk src]# /usr/bin/spacewalk-repo-sync -u file:///var/www/html/centos/5/os/x86_64/ -c "centos5-x86_64-base" -t yum -l "centos5-x86_64-base"
Repo file:///var/www/html/centos/5/os/x86_64/ has 3272 packages.
1/625 : compat-libstdc++-33-3.2.3-61-0.i386
**snip**
624/625 : sblim-gather-provider-2.1.2-31.el5_2.1-0.i386
625/625 : urw-fonts-2.3-6.1.1-0.noarch
<hangs here>

The child channels that are dependent on the Base channel have no problem with being populated with updates:
Channel Name    Packages
Parent Channel Button  CentOS 5 x86_64 - Base      2647
Child Channel CentOS 5 x86_64 - CentOSPlus     93
Child Channel CentOS 5 x86_64 - Extras     278
Child Channel CentOS 5 x86_64 - Updates     620 

The contents of /var/www/html/centos are taken directly from the CentOS rsync servers with the following command:
rsync -aqzH --delete --exclude="*.iso" us-msync.centos.org::CentOS /var/www/html/centos


Anyone have any idea on what would be violating the unique Oracle constraint?

Regards,
Matt


      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20090820/a708a66b/attachment.htm>