Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 641931

Summary: spacewalk-create-channel, unique constraint for rhel6 channel
Product: Red Hat Satellite 5 Reporter: Petr Sklenar <psklenar>
Component: UsabilityAssignee: Justin Sherrill <jsherril>
Status: CLOSED CURRENTRELEASE QA Contact: Pavel Novotny <pnovotny>
Severity: medium Docs Contact:
Priority: high    
Version: 540CC: cperry, pnovotny, tlestach
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: spacewalk-schema-1.2.21-7 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-03-13 03:23:59 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:

Description Petr Sklenar 2010-10-11 14:53:05 UTC
Description of problem:
there is unique constraint when trying to create rhel6 channel with spacewalk-create-channel

Version-Release number of selected component (if applicable):
spacewalk-remote-utils-1.0.2-3.el5sat
sat540 = Satellite-5.4.0-RHEL5-re20101001.1

How reproducible:
always

Steps to Reproduce:
[root@smqe-sat02 ~]# spacewalk-create-channel --password=admin  --user=admin --server=<fqdn_of_satellite> --version=6 --update=GOLD --release=Server --arch=x86_64   --destChannel=my-stable-channel-rhel6
You have not specified a source channel, we will try to determine it from inputs
Trying with source channel: rhel-x86_64-server-6
Reusing my-stable-channel-rhel6 as destination channel
3431 packages in source file to push.
Pushing 3390 packages, please wait.
0 of 3390
Traceback (most recent call last):
  File "/usr/bin/spacewalk-create-channel", line 438, in ?
    main()
  File "/usr/bin/spacewalk-create-channel", line 181, in main
    populate(client, auth, srcChanLabel, newChannelLabel, newChannelName, filename, parent, clear, skiplist=skiplist)
  File "/usr/bin/spacewalk-create-channel", line 255, in populate
    client.channel.software.addPackages(auth, newChannel, ids_to_add[:bundleSize])
  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-00001: unique constraint (SMQE_SAT02.RHN_CNP_CID_NID_UQ) violated\nORA-06512: at "SMQE_SAT02.RHN_CHANNEL", line 1091\nORA-06512: at line 1\n'>

Actual results:
traceback

Expected results:
rhel6 channel is created

Additional info:
satellite uses external oracle10g

Comment 1 Tomas Lestach 2010-10-13 09:11:54 UTC
*** Bug 642220 has been marked as a duplicate of this bug. ***

Comment 2 Tomas Lestach 2010-10-13 09:15:25 UTC
The problem was fixed by BZ#642287.
Note: The fix shall already be included in the galactica iso.

Needs to be verified.