Bug 679484 - rhnpush exits with ''ORA-00001: unique constraint violated" error
Summary: rhnpush exits with ''ORA-00001: unique constraint violated" error
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Spacewalk
Classification: Community
Component: Server
Version: 1.3
Hardware: x86_64
OS: Linux
unspecified
medium
Target Milestone: ---
Assignee: Michael Mráka
QA Contact: Red Hat Satellite QA List
URL:
Whiteboard:
Depends On:
Blocks: space16
TreeView+ depends on / blocked
 
Reported: 2011-02-22 17:14 UTC by pierce.ward
Modified: 2011-09-02 12:09 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2011-09-02 12:09:11 UTC
Embargoed:


Attachments (Terms of Use)

Description pierce.ward 2011-02-22 17:14:37 UTC
Description of problem:
Attempting to upload RPMs through 'rhnpush' results in an "ORA-00001: unique constraint" violation. 

Version-Release number of selected component (if applicable):
rhnpush-5.5.16-1.el5
spacewalk-backend-server-1.3.57-1.el5

How reproducible:
100% on this installation (including removing all channels and packages), but I have successfuly done this before on a VM without this issue. 

Steps to Reproduce:
1. Install Spacewalk 1.3 & Oracle XE 10g as described on the wiki. 
2. Create a new channel named 'rhel-x86_64-server-5'
3. Use rhnpush to upload RPMs from the 'Server' folder of the RHEL 5.5 DVD to the 'rhel-x86_64-server-5' channel. 
4. Use 'spacewalk-create-channel' to create a "5.5" update level channel from this one (spacewalk-create-channel --user=admin --server=server.local --version=5 --update=u5 --release=server --arch=x86_64 --destChannel=rhel-x86_64-server-5.5)
5. Use rhnpush to upload RPMs from the 'Server' folder of the RHEL 5.6 DVD to 'rhel-x86_64-server-5' channel. 
6. Exits after uploading a few packages with: Constraint violation. 
  
Actual results:
Package /mnt/iso/Server/zsh-4.2.6-5.el5.x86_64.rpm already exists on the RHN Server-- Skipping Upload....
Package /mnt/iso/Server/zsh-html-4.2.6-5.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 1087
ORA-06512: at line 1
Error Class Code: 23
Error Class Info: Could not update database entry.

Expected results:
RPMs are uploaded to the spacewalk server. 

Additional info:

Comment 1 Jan Pazdziora 2011-07-20 11:52:27 UTC
Aligning under space16.

Comment 2 Michael Mráka 2011-09-02 12:09:11 UTC
I can't reproduce this bug in Spacewalk nightly anymore:
 rhel-x86_64-server-5 	 3825 	 
 rhel-x86_64-server-5.5  3116
 rhel-x86_64-server-5.6  3048 	 
Everything pushed OK, no unique constraint violation.

rhnpush-5.5.32-1.el5
spacewalk-backend-server-1.6.15

I suspect it's been fixed in the meantime.
If you still encounter this bug, feel free to reopen it with new information.
Thanks.


Note You need to log in before you can comment on or make changes to this bug.