I'm getting this traceback when I try to delete a specific channel. The channel had two children but I've already deleted them. A prior deletion attempt for a different base channel worked fine. Running spacewalk 0.5 on RHEL5U3.<br>

<br>Error message:<br>  RHN::Exception: DBD::Oracle::st execute failed: ORA-02292: integrity constraint (SPACEWALK.RHN_KSTREE_CID_FK) violated - child record found<br>ORA-06512: at "SPACEWALK.DELETE_CHANNEL", line 15<br>

ORA-06512: at line 2 (DBD ERROR: OCIStmtExecute) [for Statement "BEGIN<br>  delete_channel(:p1);<br>END;" with ParamValues: :p1='102']<br>  RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 233 RHN::Exception::DB::throw<br>

  RHN::DB::db /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 469 RHN::DB::handle_error<br>  RHN::DB::ChannelEditor /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/ChannelEditor.pm 227 RHN::DB::db::call_procedure<br>  Sniglets::ChannelEditor /usr/lib/perl5/vendor_perl/5.8.8/Sniglets/ChannelEditor.pm 131 RHN::DB::ChannelEditor::delete_channel<br>

  PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 625 Sniglets::ChannelEditor::channel_delete_cb<br>  PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 124 PXT::ApacheHandler::pxt_parse_data<br>

  PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 124 (eval)<br>  main -e 0 PXT::ApacheHandler::handler<br>  main -e 0 (eval)<br><br>Offending Query: BEGIN<br>  delete_channel(:p1);<br>END;<br clear="all">

<br>-- <br>Bill Gunter<br><a href="mailto:tulanian@gmail.com">tulanian@gmail.com</a><br><a href="http://irishyear.blogspot.com">http://irishyear.blogspot.com</a><br><br>"I think we delight to praise what we enjoy because the praise not merely expresses but completes the enjoyment; it is its appointed consummation." Reflections on the Psalms, C.S. Lewis<br>

<br>Spread Firefox!<br><a href="http://www.spreadfirefox.com/?q=affiliates&id=22494&t=1">http://www.spreadfirefox.com/?q=affiliates&id=22494&t=1</a><br><br>