Bug 679484
| Summary: | rhnpush exits with ''ORA-00001: unique constraint violated" error | ||
|---|---|---|---|
| Product: | [Community] Spacewalk | Reporter: | pierce.ward |
| Component: | Server | Assignee: | Michael Mráka <mmraka> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Red Hat Satellite QA List <satqe-list> |
| Severity: | medium | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 1.3 | ||
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | x86_64 | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2011-09-02 12:09:11 UTC | Type: | --- |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
| Bug Depends On: | |||
| Bug Blocks: | 723481 | ||
Aligning under space16. 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. |
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: