[Spacewalk-list] error on channel deletion

[Bill Gunter]

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
tulanian at gmail.com
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20090713/83c1e9b4/attachment.htm>