Red Hat Bugzilla – Bug 828795
Channel deletion results in traceback with integrity constraint RHNSAT.RHN_EQUEUE_CID_FK or RHNSAT.RHN_ENQUEUE_CID_FK violation
Last modified: 2016-07-03 20:57:06 EDT
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.
[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
Always for the problematic channel(s).
Steps to Reproduce:
channel deletion fails with ORA-02292 error
channel deletion succeeds
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.