> > [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... > > Please run > > http://git.fedorahosted.org/git/?p=spacewalk.git;a=blob_plain;f=sche > ma/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/001-add- > missing-cascade-on- > delete.sql.oracle;hb=d5ccd232dedff450db9d833532051c6f9a7bef2a > > against your database schema -- that will add the missing ON DELETE > CASCADE clauses and make your schema be like brand new. Then the channel > delete should not block on the constraint(s) where it blocked before and > hopefully proceed. > > Thank you for bringing this issue to our attention.
Thanks, Jan. That resolved the issue for me. -Andy _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
