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

[Speagle, Andy]

> On Mon, Aug 08, 2011 at 03:52:23PM -0500, Speagle, Andy wrote:
> > > > 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.
> > > >
> > >
> > > Jan is correct here.
> > >
> > > But when you check:
> > >
> > > CREATE TABLE rhnErrataNotificationQueue (
> > >     errata_id    NUMBER NOT NULL
> > >                      CONSTRAINT rhn_enqueue_eid_fk
> > >                          REFERENCES rhnErrata (id)
> > >                          ON DELETE CASCADE,
> > >     org_id       NUMBER NOT NULL
> > >                      CONSTRAINT rhn_enqueue_oid_fk
> > >                          REFERENCES web_customer (id)
> > >                          ON DELETE CASCADE,
> > >     next_action  DATE
> > >                      DEFAULT (sysdate),
> > >     channel_id   NUMBER NOT NULL
> > >                      CONSTRAINT rhn_enqueue_cid_fk
> > >                          REFERENCES rhnChannel(id)
> > >                          ON DELETE cascade,
> > >     created      DATE
> > >                      DEFAULT (sysdate) NOT NULL,
> > >     modified     DATE
> > >                      DEFAULT (sysdate) NOT NULL
> > > )
> > > ENABLE ROW MOVEMENT
> > > ;
> > >
> > > the 'CONSTRAINT rhn_enqueue_cid_fk REFERENCES rhnChannel(id) ON
> > > DELETE cascade' shall ensure the all the rows from
> > > rhnErrataNotificationQueue get deleted together the associated
> channel.
> > > >From my point the table definition look good.
> > >
> > > So, the question is, how did you manage to delete the channel
> > > without deleting appropriate rhnErrataNotificationQueue entries?
> >
> > Actually, I haven't been able to delete the channel.  "spacewalk-remove-
> channel" only handles base-channels seemingly (unless I'm missing some
> magic).  And the WebUI is apprarently unable to do the work at present due
> to things previously mentioned in this thread.
> >
> 
> What does
> 
> 	select delete_rule from user_constraints where constraint_name =
> 'RHN_ENQUEUE_CID_FK' ;
> 
> when run from
> 
> 	sqlplus
> 
> or from
> 
> 	spacewalk-sql --select-mode -
> 
> return?

[root at spacewalk ~]# echo "select delete_rule from user_constraints where constraint_name = 'RHN_ENQUEUE_CID_FK';" | spacewalk-sql --select-mode -

DELETE_RU
---------
NO ACTION

> Is this a fresh Spacewalk 1.4 installation or upgraded system?

This is a long-upgraded 1.4 installation... from 0.5 or so... 

-Andy