[Spacewalk-list] Channel Deletion Problem - v1.4

[Jan Pazdziora]

On Mon, Aug 01, 2011 at 10:50:14AM -0500, Speagle, Andy wrote:
> 
> I seem to be unable to delete a software channel.  The traceback seems to suggest that this channel has a child... but it's actually this other way around.  This channel IS a child channel for another.  I made sure to manually remove this channel from any activation keys.  I even manually unsubscribed all systems from this channel, but I still cannot remove it.
> 

Nope, the traceback talks about database constraint RHN_ENQUEUE_CID_FK
which says there are records in the rhnErrataNotificationQueue table
for this channels -- it's not about channel being child or having
children.

> I've included the traceback.  Can someone give me a hint on this one?

Tomáš,

looking at the spacewalk-remove-channel, we remove child records from
rhnErrataNotificationQueue in that script. Can I assume we might want
to do the same in the WebUI delete (== procs/delete_channel.sql)?

Maybe it would be good to cross-check those two lists of tables that
are being deleted -- for example, I can see rhnErrataFileChannel and
other tables listed in spacewalk-remove-channel but not in the
delete_channel, and I can see at least rhnServerProfilePackage in the
delete_channel but not in the spacewalk-remove-channel.

-- 
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat