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