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.
Error message: RHN::Exception: DBD::Oracle::st execute failed: ORA-02292: integrity constraint (SPACEWALK.RHN_KSTREE_CID_FK) violated - child record found ORA-06512: at "SPACEWALK.DELETE_CHANNEL", line 15 ORA-06512: at line 2 (DBD ERROR: OCIStmtExecute) [for Statement "BEGIN delete_channel(:p1); END;" with ParamValues: :p1='102'] RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 233 RHN::Exception::DB::throw RHN::DB::db /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 469 RHN::DB::handle_error RHN::DB::ChannelEditor /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/ChannelEditor.pm 227 RHN::DB::db::call_procedure Sniglets::ChannelEditor /usr/lib/perl5/vendor_perl/5.8.8/Sniglets/ChannelEditor.pm 131 RHN::DB::ChannelEditor::delete_channel PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 625 Sniglets::ChannelEditor::channel_delete_cb PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 124 PXT::ApacheHandler::pxt_parse_data PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 124 (eval) main -e 0 PXT::ApacheHandler::handler main -e 0 (eval) Offending Query: BEGIN delete_channel(:p1); END; -- Bill Gunter [email protected] http://irishyear.blogspot.com "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 Spread Firefox! http://www.spreadfirefox.com/?q=affiliates&id=22494&t=1
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
