Bug 464700
| Summary: | API Errata addition violates constraint SPACEWALK.RHN_ERRATAFILE_EID_FILE_UQ | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Product: | [Community] Spacewalk | Reporter: | Jeremy Mueller <jmueller> | ||||||
| Component: | API | Assignee: | Devan Goodwin <dgoodwin> | ||||||
| Status: | CLOSED DUPLICATE | QA Contact: | Red Hat Satellite QA List <satqe-list> | ||||||
| Severity: | medium | Docs Contact: | |||||||
| Priority: | medium | ||||||||
| Version: | 0.2 | CC: | jsherril | ||||||
| Target Milestone: | --- | ||||||||
| Target Release: | --- | ||||||||
| Hardware: | All | ||||||||
| OS: | Linux | ||||||||
| Whiteboard: | |||||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||||
| Doc Text: | Story Points: | --- | |||||||
| Clone Of: | Environment: | ||||||||
| Last Closed: | 2008-11-03 22:14:19 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: | 456551 | ||||||||
| Attachments: |
|
||||||||
Created attachment 318017 [details]
The relevant catalina.out for this.
*** This bug has been marked as a duplicate of bug 455034 *** |
Created attachment 318015 [details] Perl script to recreate the constraint error. Description of problem: If you have multiple archs of an RPM in Spacewalk and try to add an errata through the API for them, you receive a SPACEWALK.RHN_ERRATAFILE_EID_FILE_UQ constraint violation error. Version-Release number of selected component (if applicable): How reproducible: Always. Steps to Reproduce: 1. Upload two variations of the same RPM (for my example I was testing kexec-tools-1.102pre-21.el5_2.2.i386.rpm and kexec-tools-1.102pre-21.el5_2.2.x86_64.rpm). 2. Locate the package IDs for these two packages. 3. Use the XMLAPI to upload an errata for these packages (see the attached test script errata_test_case.pl). Actual results: "500 Internal Server Error" on command line and "ORA-00001: unique constraint (SPACEWALK.RHN_ERRATAFILE_EID_FILE_UQ) violated" message in catalina.out. Expected results: An errata added to the database that refers to both packages. Additional info: To verify that the problem is the constraint violation, you can disable the constraint in Oracle (alter table RHNERRATAFILE disable constraint RHN_ERRATAFILE_EID_FILE_UQ;) and re-run the test script.