Bug 828795 - Channel deletion results in traceback with integrity constraint RHNSAT.RHN_EQUEUE_CID_FK or RHNSAT.RHN_ENQUEUE_CID_FK violation
Summary: Channel deletion results in traceback with integrity constraint RHNSAT.RHN_EQ...
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Server
Version: 541
Hardware: All
OS: Linux
high
medium
Target Milestone: ---
Assignee: Jan Pazdziora (Red Hat)
QA Contact: Martin Minar
URL:
Whiteboard:
Depends On:
Blocks: sat541-triage
TreeView+ depends on / blocked
 
Reported: 2012-06-05 11:47 UTC by dipu
Modified: 2018-11-30 21:23 UTC (History)
8 users (show)

Fixed In Version: satellite-schema-5.4.0.20-1-sat
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2012-10-22 11:23:56 UTC
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 849006 1 None None None 2021-01-20 06:05:38 UTC
Red Hat Product Errata RHBA-2012:1395 0 normal SHIPPED_LIVE Red Hat Network Satellite server bug fix update 2013-01-10 14:42:40 UTC

Internal Links: 849006

Comment 8 Xixi 2012-09-12 04:30:24 UTC 
Public bug summary:

Description of problem:
Channel deletion (such as via spacewalk-remove-channel) fails with ORA-02292 constraint violation error for either RHNSAT.RHN_EQUEUE_CID_FK or RHNSAT.RHN_ENQUEUE_CID_FK.

Sample error:
---------------------
[root@rhnsat ~]# spacewalk-remove-channel -c rhel-ia64-ws-3-extras

ERROR: unhandled exception occurred: ((2292, 'ORA-02292: integrity constraint (RHNSAT.RHN_EQUEUE_CID_FK) violated - child record found\n', 'delete from rhnChannel where id = :channel_id')).
----------------------

Version-Release number of selected component (if applicable):
RHN Satellite v5.4

How reproducible:
Always for the problematic channel(s).

Steps to Reproduce:
(see above)

Actual results:
channel deletion fails with ORA-02292 error

Expected results:
channel deletion succeeds

Additional info:
Comment 11 errata-xmlrpc 2012-10-22 11:23:56 UTC 
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

http://rhn.redhat.com/errata/RHBA-2012-1395.html
Note You need to log in before you can comment on or make changes to this bug.