Hello, I'm getting an error while trying to delete a software channel from the root organization in spacewalk. It was originally a base channel for Fedora called fedora-9-x86_64 (which I've since moved into it's own org). All of the packages have been deleted. The menu path is:
Channels->Manage Software Channels->Fedora 9 64-bit->delete software Channels->channel *confirm* On the web interface I get a 500 error. The error the system sends me is: ===================== <snip> ====================== The following exception occurred while executing this request: POST /network/software/channels/manage/delete_confirm.pxt HTTP/1.1 (from browser) /network/software/channels/manage/delete_confirm.pxt (from Apache) Date: Mon Nov 10 03:17:53 2008 Headers: Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7 Accept-Encoding: gzip,deflate Accept-Language: en-us,en;q=0.5 Connection: keep-alive Content-Length: 275 Content-Type: application/x-www-form-urlencoded Cookie: pxt-session-cookie=20441x8321fbbec400e65a444397948625e9b3 Host: spacewalk.cucbc.com Keep-Alive: 300 Referer: https://spacewalk.cucbc.com/network/software/channels/manage/delete_confirm.pxt?cid=101 User-Agent: Mozilla/5.0 (X11; U; Linux i686 (x86_64); en-US; rv:1.9.0.3) Gecko/2008092416 Firefox/3.0.3 Form variables: cid => 101 confirm_delete => Delete Channel orphaned_packages_redirect => /rhn/software/manage/packages/PackageList.do pxt:trap => rhn:channel_delete_cb redirect_to => /network/software/channels/manage/index.pxt servers_link => /rhn/channels/ChannelSubscribers.do User Information: User cucbc (id 1, org_id 1) Error notes: (none) Initial Request: Yes 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='101'] RHN::DB /usr/lib/perl5/site_perl/5.8.8/RHN/DB.pm 233 RHN::Exception::DB::throw RHN::DB::db /usr/lib/perl5/site_perl/5.8.8/RHN/DB.pm 469 RHN::DB::handle_error RHN::DB::ChannelEditor /usr/lib/perl5/site_perl/5.8.8/RHN/DB/ChannelEditor.pm 217 RHN::DB::db::call_procedure Sniglets::ChannelEditor /usr/lib/perl5/site_perl/5.8.8/Sniglets/ChannelEditor.pm 123 RHN::DB::ChannelEditor::delete_channel PXT::ApacheHandler /usr/lib/perl5/site_perl/5.8.8/PXT/ApacheHandler.pm 625 Sniglets::ChannelEditor::channel_delete_cb PXT::ApacheHandler /usr/lib/perl5/site_perl/5.8.8/PXT/ApacheHandler.pm 123 PXT::ApacheHandler::pxt_parse_data PXT::ApacheHandler /usr/lib/perl5/site_perl/5.8.8/PXT/ApacheHandler.pm 123 (eval) main -e 0 PXT::ApacheHandler::handler main -e 0 (eval) Offending Query: BEGIN delete_channel(:p1); END; ====================== </snip> ====================== I've written a little python program that tries to do the same thing via the xmlrpc api. Here's the output from that: ====================== <snip> ======================== [EMAIL PROTECTED] ~]$ ./delete_channel.py --host=localhost --label=fedora-9-x86_64 Traceback (most recent call last): File "./delete_channel.py", line 61, in ? main() File "./delete_channel.py", line 57, in main delete(key, options.label) File "./delete_channel.py", line 51, in delete return client.channel.software.delete(key, label) File "/usr/lib64/python2.4/xmlrpclib.py", line 1096, in __call__ return self.__send(self.__name, args) File "/usr/lib64/python2.4/xmlrpclib.py", line 1383, in __request verbose=self.__verbose File "/usr/lib64/python2.4/xmlrpclib.py", line 1147, in request return self._parse_response(h.getfile(), sock) File "/usr/lib64/python2.4/xmlrpclib.py", line 1286, in _parse_response return u.close() File "/usr/lib64/python2.4/xmlrpclib.py", line 744, in close raise Fault(**self._stack[0]) xmlrpclib.Fault: <Fault -1: 'redstone.xmlrpc.XmlRpcFault: unhandled internal exception: ORA-02292: integrity constraint (SPACEWALK.RHN_KSTREE_CID_FK) violated - child record found\nORA-06512: at "SPACEWALK.DELETE_CHANNEL", line 15\nORA-06512: at line 1\n'> ===================== </snip> ===================== Is this a known issue? Cheers, -Tyson _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
