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 _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
