Bug 543507
Summary: | unique constraint (RHNSAT.RHN_CNP_CID_NID_UQ) violated | ||
---|---|---|---|
Product: | Red Hat Satellite 5 | Reporter: | Jan Hutař <jhutar> |
Component: | Satellite Synchronization | Assignee: | Miroslav Suchý <msuchy> |
Status: | CLOSED DUPLICATE | QA Contact: | Red Hat Satellite QA List <satqe-list> |
Severity: | low | Docs Contact: | |
Priority: | low | ||
Version: | 530 | CC: | cperry |
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: | 2009-12-02 16:21: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: |
Description
Jan Hutař
2009-12-02 14:54:12 UTC
ALTER TABLE rhnChannelNewestPackage ADD CONSTRAINT rhn_cnp_cid_nid_uq UNIQUE (channel_id, name_id, package_arch_id); CREATE TABLE rhnChannelNewestPackage ( channel_id NUMBER NOT NULL CONSTRAINT rhn_cnp_cid_fk REFERENCES rhnChannel (id) ON DELETE CASCADE, name_id NUMBER NOT NULL CONSTRAINT rhn_cnp_nid_fk REFERENCES rhnPackageName (id), evr_id NUMBER NOT NULL CONSTRAINT rhn_cnp_eid_fk REFERENCES rhnPackageEVR (id), package_arch_id NUMBER NOT NULL CONSTRAINT rhn_cnp_paid_fk REFERENCES rhnPackageArch (id), package_id NUMBER NOT NULL CONSTRAINT rhn_cnp_pid_fk REFERENCES rhnPackage (id) ON DELETE CASCADE ) ENABLE ROW MOVEMENT ; So when 'moving' a channel from one org to another org using the steps outlined, we hit this constraint. This bug would have been within 530 GA code as well, in fact, searching BZ, I found a bug we punted off 530 near the end of testing cycles. right now, it seems only QE has used Satellite in this manner to encounter the error. I propose to close this out as a dupe, and then for us to keep tracking proposed for future Satellite release beyond 5.3.1. Cliff. *** This bug has been marked as a duplicate of bug 517173 *** |