Description of problem: spacewalk-remove-channel fails to manage child custom channels. Version-Release number of selected component (if applicable): spacewalk-backend-tools-1.2.13-20.el5sat How reproducible: Always Steps to Reproduce: 1.Create custom channel. 2.Create child channel of the custom channel. 3.spacewalk-remove-channel --list Actual results: Only the parent custum channel is listed.The child channel is missing. Expected results: Both, parent and child channels are listed. Additional info: spacewalk-remove-channel fails to remove such channels as well. The problem is related only to custom channels.
bug within the spacewalk-remove-channel tool. *but* the WebUI should/would work fine. So we have a valid alternative solution. Lower priority bug to be fixed. Cliff
Taking.
spacewalk.git 220bb740f47ed96b51dd65a6434e86be1f0a9661
I tried to use this fix on Satellite package spacewalk-backend-tools-1.2.13-55.el6sat.noarch and it seems to be working well on Satellite. Tested on Satellite 5.4.1 on RHEL 6.2 Server s390x.
Hello, using spacewalk-remove-channel from spacewalk-backend-tools-1.2.13-61.el5sat I'm getting this: # spacewalk-remove-channel -c clone-my-channel Deleting package metadata (246): ________________________________________ Removing: ######################################## - complete ERROR: unhandled exception occurred: ((2292, 'ORA-02292: integrity constraint (RHNSAT.RHN_CHANNEL_PARENT_CH_FK) violated - child record found\n', 'delete from rhnChannel where id = :channel_id')). Traceback (most recent call last): File "/usr/bin/spacewalk-remove-channel", line 559, in ? sys.exit(main() or 0) File "/usr/bin/spacewalk-remove-channel", line 151, in main skip_channels=options.skip_channels) File "/usr/bin/spacewalk-remove-channel", line 378, in delete_channels h.executemany(channel_id=channel_ids) File "/usr/share/rhn/server/rhnSQL/sql_base.py", line 177, in executemany return apply(self._execute_wrapper, (self._executemany, ) + p, kw) File "/usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py", line 118, in _execute_wrapper raise apply(sql_base.SQLError, ret) SQLError: (2292, 'ORA-02292: integrity constraint (RHNSAT.RHN_CHANNEL_PARENT_CH_FK) violated - child record found\n', 'delete from rhnChannel where id = :channel_id') That is probably connected to this bug as on WebUI I can see that the channel have child: clone-my-channel +-- clone-my-child-channel But the utility do not see the child channel: # spacewalk-remove-channel -l clone-my-channel So adding the traceback here as I believe it is connected.
This traceback was described in bug 582646, comment 15. This traceback will go away after applying this bugfix. There will be an error message instead: Error: cannot remove channel clone-my-channel: subchannel(s) exist: child-of-clone-my-child-channel
This issue is resolved with the release of RHN Satellite 5.5. As of September 20th 2012, RHN Satellite 5.5 has been generally available. Release Notes and other 5.5 documentation can be found here: https://access.redhat.com/knowledge/docs/Red_Hat_Network_Satellite/ The associated Errata for the 5.5 release are: 5.5 Satellite GA Errata - http://rhn.redhat.com/errata/RHEA-2012-1296.html 5.5 Upgrade Errata - http://rhn.redhat.com/errata/RHEA-2012-1298.html 5.5 RHN Proxy GA Errata - http://rhn.redhat.com/errata/RHEA-2012-1297.html 5.5 RHN Tools GA Errata - http://rhn.redhat.com/errata/RHEA-2012-1299.html Regards, Clifford - Engineering Manager, Satellite