Bug 673694
| Summary: | spacewalk-remove-channel fails to manage child custom channels. | |||
|---|---|---|---|---|
| Product: | Red Hat Satellite 5 | Reporter: | Dimitar Yordanov <dyordano> | |
| Component: | WebUI | Assignee: | Tomas Lestach <tlestach> | |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Martin Minar <mminar> | |
| Severity: | low | Docs Contact: | ||
| Priority: | low | |||
| Version: | 540 | CC: | cperry, jhutar, jmikulka, mkoci, mminar, mmraka, msuchy, pgervase | |
| Target Milestone: | --- | |||
| Target Release: | --- | |||
| Hardware: | Unspecified | |||
| OS: | Unspecified | |||
| Whiteboard: | ||||
| Fixed In Version: | spacewalk-backend-1.6.3-1 | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | ||
| Clone Of: | ||||
| : | 871399 (view as bug list) | Environment: | ||
| Last Closed: | 2012-09-21 09:18:18 UTC | Type: | --- | |
| Regression: | --- | Mount Type: | --- | |
| Documentation: | --- | CRM: | ||
| Verified Versions: | Category: | --- | ||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | ||
| Cloudforms Team: | --- | Target Upstream Version: | ||
| Embargoed: | ||||
| Bug Depends On: | ||||
| Bug Blocks: | 818987, 871399 | |||
|
Description
Dimitar Yordanov
2011-01-29 20:49:51 UTC
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 |