[Spacewalk-list] Debugging problem with rhn-clone-errata.py
Musayev, Ilya
imusayev at webmd.net
Tue Jun 26 00:09:21 UTC 2012
I can give some pointers to help you identify the issue.
Enable query and debug logging for db (postgres or oracle) It will tell you what SQL operation and values causes constraint violation. Check against those that are fine and the one that is bad.
If comfortable with python, add print statements to see what's happening.
Sorry I can't be more specific as I don't have the issue to reproduce.
Regards
Ilya
On Jun 25, 2012, at 12:34 PM, "Boyd, Robert" <Robert.Boyd at peoplefluent.com<mailto:Robert.Boyd at peoplefluent.com>> wrote:
I’ve been working on getting spacewalk working for RHEL 5 and RHEL 4 the last few days. This morning I was trying to update the errata for RHEL5 and I got an error that I’m not sure what to do with.
Here’s the way I invoked the program:
python /usr/local/sbin/rhn-clone-errata.py --spw-server="spacewalkserver " --login="userid" --password="password" --src-channel="rhel-x86_64-server-5" --publish --verbose -v
The output I’m seeing is this:
RHBA-2012:1016
Errata already exists. RHBA-2012:1016:R5-64
RHSA-2012:0745
Errata already exists. RHSA-2012:0745:R5-64
RHSA-2012:0731
Errata already exists. RHSA-2012:0731:R5-64
RHSA-2012:0730
Errata already exists. RHSA-2012:0730:R5-64
RHSA-2012:0721
Errata already exists. RHSA-2012:0721:R5-64
RHSA-2012:0716
Errata already exists. RHSA-2012:0716:R5-64
RHSA-2012:0717
Errata already exists. RHSA-2012:0717:R5-64
RHBA-2012:0714
Errata already exists. RHBA-2012:0714:R5-64
RHSA-2012:0710
Errata already exists. RHSA-2012:0710:R5-64
RHSA-2012:0690
Errata already exists. RHSA-2012:0690:R5-64
RHSA-2012:0699
Errata already exists. RHSA-2012:0699:R5-64
RHEA-2012:0689
Errata already exists. RHEA-2012:0689:R5-64
RHBA-2012:0684
Errata already exists. RHBA-2012:0684:R5-64
RHSA-2012:0678
Errata already exists. RHSA-2012:0678:R5-64
RHSA-2012:0677
Errata already exists. RHSA-2012:0677:R5-64
RHBA-2012:0674
Errata already exists. RHBA-2012:0674:R5-64
RHEA-2010:0252
Errata already exists. RHEA-2010:0252:R5-64
RHEA-2012:0286
Errata already exists. RHEA-2012:0286:R5-64
RHBA-2012:0672
Errata already exists. RHBA-2012:0672:R5-64
RHBA-2012:0580
Errata already exists. RHBA-2012:0580:R5-64
RHBA-2012:0574
Errata already exists. RHBA-2012:0574:R5-64
RHEA-2011:1812
Errata already exists. RHEA-2011:1812:R5-64
RHBA-2012:0527
Errata already exists. RHBA-2012:0527:R5-64
RHBA-2012:0558
Errata already exists. RHBA-2012:0558:R5-64
RHBA-2012:0560
Errata already exists. RHBA-2012:0560:R5-64
RHBA-2012:0553
Errata already exists. RHBA-2012:0553:R5-64
RHSA-2012:0546
Errata already exists. RHSA-2012:0546:R5-64
RHSA-2012:0547
Errata already exists. RHSA-2012:0547:R5-64
RHSA-2012:0545
Errata already exists. RHSA-2012:0545:R5-64
RHBA-2012:0537
Errata already exists. RHBA-2012:0537:R5-64
RHSA-2012:0533
Errata already exists. RHSA-2012:0533:R5-64
RHSA-2012:0523
Errata already exists. RHSA-2012:0523:R5-64
RHSA-2012:0518
Errata already exists. RHSA-2012:0518:R5-64
RHSA-2012:0515
Errata already exists. RHSA-2012:0515:R5-64
RHBA-2012:0506
Errata already exists. RHBA-2012:0506:R5-64
RHBA-2012:0505
Errata already exists. RHBA-2012:0505:R5-64
RHBA-2012:0499
Errata already exists. RHBA-2012:0499:R5-64
RHBA-2012:0498
Errata already exists. RHBA-2012:0498:R5-64
RHBA-2012:0497
Errata already exists. RHBA-2012:0497:R5-64
RHSA-2012:0480
Errata already exists. RHSA-2012:0480:R5-64
RHEA-2012:0484
Errata already exists. RHEA-2012:0484:R5-64
RHSA-2012:0474
Errata already exists. RHSA-2012:0474:R5-64
RHBA-2012:0471
Errata already exists. RHBA-2012:0471:R5-64
RHSA-2012:0465
Errata already exists. RHSA-2012:0465:R5-64
RHSA-2012:0466
Errata already exists. RHSA-2012:0466:R5-64
RHSA-2012:0468
Errata already exists. RHSA-2012:0468:R5-64
RHSA-2012:0467
Errata already exists. RHSA-2012:0467:R5-64
RHBA-2010:0252
Errata already exists. RHBA-2010:0252:R5-64
RHSA-2012:0451
Errata already exists. RHSA-2012:0451:R5-64
RHBA-2012:0440
Errata already exists. RHBA-2012:0440:R5-64
RHBA-2012:0437
Errata already exists. RHBA-2012:0437:R5-64
RHBA-2012:0438
Errata already exists. RHBA-2012:0438:R5-64
RHBA-2012:0432
Errata already exists. RHBA-2012:0432:R5-64
RHSA-2012:0426
Errata already exists. RHSA-2012:0426:R5-64
RHSA-2012:0428
Errata already exists. RHSA-2012:0428:R5-64
RHEA-2012:0412
Errata already exists. RHEA-2012:0412:R5-64
RHBA-2012:0408
Errata already exists. RHBA-2012:0408:R5-64
RHSA-2012:0407
Errata already exists. RHSA-2012:0407:R5-64
RHEA-2012:0356
Errata already exists. RHEA-2012:0356:R5-64
RHSA-2012:0397
Errata already exists. RHSA-2012:0397:R5-64
RHBA-2012:0395
Errata already exists. RHBA-2012:0395:R5-64
RHSA-2012:0387
Errata already exists. RHSA-2012:0387:R5-64
RHBA-2012:0379
Errata already exists. RHBA-2012:0379:R5-64
RHSA-2012:0376
Errata already exists. RHSA-2012:0376:R5-64
RHSA-2012:0370
Errata already exists. RHSA-2012:0370:R5-64
RHBA-2012:0363
Errata already exists. RHBA-2012:0363:R5-64
RHBA-2012:0361
Errata already exists. RHBA-2012:0361:R5-64
RHBA-2012:0344
Errata already exists. RHBA-2012:0344:R5-64
RHEA-2012:0327
Errata already exists. RHEA-2012:0327:R5-64
RHBA-2012:0337
Errata already exists. RHBA-2012:0337:R5-64
RHSA-2012:0332
Errata already exists. RHSA-2012:0332:R5-64
RHBA-2012:0326
Errata already exists. RHBA-2012:0326:R5-64
RHSA-2012:0324
Errata already exists. RHSA-2012:0324:R5-64
RHSA-2012:0322
Errata already exists. RHSA-2012:0322:R5-64
RHSA-2012:0323
Errata already exists. RHSA-2012:0323:R5-64
RHSA-2012:0321
Errata already exists. RHSA-2012:0321:R5-64
RHBA-2012:0146
Errata already exists. RHBA-2012:0146:R5-64
RHBA-2012:0319
Errata already exists. RHBA-2012:0319:R5-64
RHBA-2012:0148
Fault Code: -208 Fault String: redstone.xmlrpc.XmlRpcFault: The errata RHBA-2012:0148:R5-64 cannot be found.
Errata RHBA-2012:0148:R5-64 Doesn't Exist on spacewalkserver ...
2/21/12 - subscription-manager bug fix update
Errata Created: 158
Errata Published!
RHBA-2011:1352
Fault Code: -208 Fault String: redstone.xmlrpc.XmlRpcFault: The errata RHBA-2011:1352:R5-64 cannot be found.
Errata RHBA-2011:1352:R5-64 Doesn't Exist on spacewalkserver ...
2/20/12 - OpenIPMI bug fix update
Errata Created: 160
Fault Code: -1 - redstone.xmlrpc.XmlRpcFault: unhandled internal exception: ERROR: duplicate key value violates unique constraint "rhn_cnp_cid_nid_uq"
Traceback (most recent call last):
File "/usr/local/sbin/rhn-clone-errata.py", line 643, in ?
main()
File "/usr/local/sbin/rhn-clone-errata.py", line 633, in main
spwPublish = mySPW.errataPublish (spwErrataName, [chanMap[options.src_channel]], 0)
File "/usr/local/sbin/rhn-clone-errata.py", line 384, in errataPublish
return self.server.errata.publish(self.rhnSession,name,channels)
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: ERROR: duplicate key value violates unique constraint "rhn_cnp_cid_nid_uq"'>
How do I find out what’s causing the duplicate key error? Are there log files I should look at to give me a clue? I’m not yet a python programmer, but it’s not too scary looking, so I’ve tried looking at the routines to see what I can tell, but haven’t sorted it out quite yet.
Thanks,
Robert
Robert Boyd
Senior Systems Engineer
Phone: 919-645-2972
Mobile: 919-306-4681
Peoplefluent
434 Fayetteville Street
Raleigh, NC 27601
<mailto:michael.dileonardo at peoplefluent.com>robert.boyd at peoplefluent.com<mailto:robert.boyd at peoplefluent.com>
<image001.png>
This email message is for the sole use of the intended recipient(s) and may contain confidential information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.
_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com<mailto:Spacewalk-list at redhat.com>
https://www.redhat.com/mailman/listinfo/spacewalk-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20120625/dc57e279/attachment.htm>
More information about the Spacewalk-list
mailing list