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

[Jan Pazdziora]

On Tue, Aug 09, 2011 at 08:19:38AM -0500, Speagle, Andy wrote:
> 
> [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... 

Please run

	http://git.fedorahosted.org/git/?p=spacewalk.git;a=blob_plain;f=schema/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.

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