<html><body bgcolor="#FFFFFF"><div>I can give some pointers to help you identify the issue. </div><div> </div><div>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. </div><div>If comfortable with python, add print statements to see what's happening.</div><div> Sorry I can't be more specific as I don't have the issue to reproduce.</div><div> </div><div>Regards</div><div>Ilya</div><div> On Jun 25, 2012, at 12:34 PM, "Boyd, Robert" <<a href="mailto:Robert.Boyd@peoplefluent.com">Robert.Boyd@peoplefluent.com</a>> wrote: </div><div></div><blockquote type="cite"><div><div class="WordSection1">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.<o:p></o:p><o:p> </o:p>Here’s the way I invoked the program:<o:p></o:p><o:p> </o:p>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<o:p></o:p><o:p> </o:p>The output I’m seeing is this:<o:p></o:p>RHBA-2012:1016<o:p></o:p> Errata already exists. RHBA-2012:1016:R5-64<o:p></o:p>RHSA-2012:0745<o:p></o:p> Errata already exists. RHSA-2012:0745:R5-64<o:p></o:p>RHSA-2012:0731<o:p></o:p> Errata already exists. RHSA-2012:0731:R5-64<o:p></o:p>RHSA-2012:0730<o:p></o:p> Errata already exists. RHSA-2012:0730:R5-64<o:p></o:p>RHSA-2012:0721<o:p></o:p> Errata already exists. RHSA-2012:0721:R5-64<o:p></o:p>RHSA-2012:0716<o:p></o:p> Errata already exists. RHSA-2012:0716:R5-64<o:p></o:p>RHSA-2012:0717<o:p></o:p> Errata already exists. RHSA-2012:0717:R5-64<o:p></o:p>RHBA-2012:0714<o:p></o:p> Errata already exists. RHBA-2012:0714:R5-64<o:p></o:p>RHSA-2012:0710<o:p></o:p> Errata already exists. RHSA-2012:0710:R5-64<o:p></o:p>RHSA-2012:0690<o:p></o:p> Errata already exists. RHSA-2012:0690:R5-64<o:p></o:p>RHSA-2012:0699<o:p></o:p> Errata already exists. RHSA-2012:0699:R5-64<o:p></o:p>RHEA-2012:0689<o:p></o:p> Errata already exists. RHEA-2012:0689:R5-64<o:p></o:p>RHBA-2012:0684<o:p></o:p> Errata already exists. RHBA-2012:0684:R5-64<o:p></o:p>RHSA-2012:0678<o:p></o:p> Errata already exists. RHSA-2012:0678:R5-64<o:p></o:p>RHSA-2012:0677<o:p></o:p> Errata already exists. RHSA-2012:0677:R5-64<o:p></o:p>RHBA-2012:0674<o:p></o:p> Errata already exists. RHBA-2012:0674:R5-64<o:p></o:p>RHEA-2010:0252<o:p></o:p> Errata already exists. RHEA-2010:0252:R5-64<o:p></o:p>RHEA-2012:0286<o:p></o:p> Errata already exists. RHEA-2012:0286:R5-64<o:p></o:p>RHBA-2012:0672<o:p></o:p> Errata already exists. RHBA-2012:0672:R5-64<o:p></o:p>RHBA-2012:0580<o:p></o:p> Errata already exists. RHBA-2012:0580:R5-64<o:p></o:p>RHBA-2012:0574<o:p></o:p> Errata already exists. RHBA-2012:0574:R5-64<o:p></o:p>RHEA-2011:1812<o:p></o:p> Errata already exists. RHEA-2011:1812:R5-64<o:p></o:p>RHBA-2012:0527<o:p></o:p> Errata already exists. RHBA-2012:0527:R5-64<o:p></o:p>RHBA-2012:0558<o:p></o:p> Errata already exists. RHBA-2012:0558:R5-64<o:p></o:p>RHBA-2012:0560<o:p></o:p> Errata already exists. RHBA-2012:0560:R5-64<o:p></o:p>RHBA-2012:0553<o:p></o:p> Errata already exists. RHBA-2012:0553:R5-64<o:p></o:p>RHSA-2012:0546<o:p></o:p> Errata already exists. RHSA-2012:0546:R5-64<o:p></o:p>RHSA-2012:0547<o:p></o:p> Errata already exists. RHSA-2012:0547:R5-64<o:p></o:p>RHSA-2012:0545<o:p></o:p> Errata already exists. RHSA-2012:0545:R5-64<o:p></o:p>RHBA-2012:0537<o:p></o:p> Errata already exists. RHBA-2012:0537:R5-64<o:p></o:p>RHSA-2012:0533<o:p></o:p> Errata already exists. RHSA-2012:0533:R5-64<o:p></o:p>RHSA-2012:0523<o:p></o:p> Errata already exists. RHSA-2012:0523:R5-64<o:p></o:p>RHSA-2012:0518<o:p></o:p> Errata already exists. RHSA-2012:0518:R5-64<o:p></o:p>RHSA-2012:0515<o:p></o:p> Errata already exists. RHSA-2012:0515:R5-64<o:p></o:p>RHBA-2012:0506<o:p></o:p> Errata already exists. RHBA-2012:0506:R5-64<o:p></o:p>RHBA-2012:0505<o:p></o:p> Errata already exists. RHBA-2012:0505:R5-64<o:p></o:p>RHBA-2012:0499<o:p></o:p> Errata already exists. RHBA-2012:0499:R5-64<o:p></o:p>RHBA-2012:0498<o:p></o:p> Errata already exists. RHBA-2012:0498:R5-64<o:p></o:p>RHBA-2012:0497<o:p></o:p> Errata already exists. RHBA-2012:0497:R5-64<o:p></o:p>RHSA-2012:0480<o:p></o:p> Errata already exists. RHSA-2012:0480:R5-64<o:p></o:p>RHEA-2012:0484<o:p></o:p> Errata already exists. RHEA-2012:0484:R5-64<o:p></o:p>RHSA-2012:0474<o:p></o:p> Errata already exists. RHSA-2012:0474:R5-64<o:p></o:p>RHBA-2012:0471<o:p></o:p> Errata already exists. RHBA-2012:0471:R5-64<o:p></o:p>RHSA-2012:0465<o:p></o:p> Errata already exists. RHSA-2012:0465:R5-64<o:p></o:p>RHSA-2012:0466<o:p></o:p> Errata already exists. RHSA-2012:0466:R5-64<o:p></o:p>RHSA-2012:0468<o:p></o:p> Errata already exists. RHSA-2012:0468:R5-64<o:p></o:p>RHSA-2012:0467<o:p></o:p> Errata already exists. RHSA-2012:0467:R5-64<o:p></o:p>RHBA-2010:0252<o:p></o:p> Errata already exists. RHBA-2010:0252:R5-64<o:p></o:p>RHSA-2012:0451<o:p></o:p> Errata already exists. RHSA-2012:0451:R5-64<o:p></o:p>RHBA-2012:0440<o:p></o:p> Errata already exists. RHBA-2012:0440:R5-64<o:p></o:p>RHBA-2012:0437<o:p></o:p> Errata already exists. RHBA-2012:0437:R5-64<o:p></o:p>RHBA-2012:0438<o:p></o:p> Errata already exists. RHBA-2012:0438:R5-64<o:p></o:p>RHBA-2012:0432<o:p></o:p> Errata already exists. RHBA-2012:0432:R5-64<o:p></o:p>RHSA-2012:0426<o:p></o:p> Errata already exists. RHSA-2012:0426:R5-64<o:p></o:p>RHSA-2012:0428<o:p></o:p> Errata already exists. RHSA-2012:0428:R5-64<o:p></o:p>RHEA-2012:0412<o:p></o:p> Errata already exists. RHEA-2012:0412:R5-64<o:p></o:p>RHBA-2012:0408<o:p></o:p> Errata already exists. RHBA-2012:0408:R5-64<o:p></o:p>RHSA-2012:0407<o:p></o:p> Errata already exists. RHSA-2012:0407:R5-64<o:p></o:p>RHEA-2012:0356<o:p></o:p> Errata already exists. RHEA-2012:0356:R5-64<o:p></o:p>RHSA-2012:0397<o:p></o:p> Errata already exists. RHSA-2012:0397:R5-64<o:p></o:p>RHBA-2012:0395<o:p></o:p> Errata already exists. RHBA-2012:0395:R5-64<o:p></o:p>RHSA-2012:0387<o:p></o:p> Errata already exists. RHSA-2012:0387:R5-64<o:p></o:p>RHBA-2012:0379<o:p></o:p> Errata already exists. RHBA-2012:0379:R5-64<o:p></o:p>RHSA-2012:0376<o:p></o:p> Errata already exists. RHSA-2012:0376:R5-64<o:p></o:p>RHSA-2012:0370<o:p></o:p> Errata already exists. RHSA-2012:0370:R5-64<o:p></o:p>RHBA-2012:0363<o:p></o:p> Errata already exists. RHBA-2012:0363:R5-64<o:p></o:p>RHBA-2012:0361<o:p></o:p> Errata already exists. RHBA-2012:0361:R5-64<o:p></o:p>RHBA-2012:0344<o:p></o:p> Errata already exists. RHBA-2012:0344:R5-64<o:p></o:p>RHEA-2012:0327<o:p></o:p> Errata already exists. RHEA-2012:0327:R5-64<o:p></o:p>RHBA-2012:0337<o:p></o:p> Errata already exists. RHBA-2012:0337:R5-64<o:p></o:p>RHSA-2012:0332<o:p></o:p> Errata already exists. RHSA-2012:0332:R5-64<o:p></o:p>RHBA-2012:0326<o:p></o:p> Errata already exists. RHBA-2012:0326:R5-64<o:p></o:p>RHSA-2012:0324<o:p></o:p> Errata already exists. RHSA-2012:0324:R5-64<o:p></o:p>RHSA-2012:0322<o:p></o:p> Errata already exists. RHSA-2012:0322:R5-64<o:p></o:p>RHSA-2012:0323<o:p></o:p> Errata already exists. RHSA-2012:0323:R5-64<o:p></o:p>RHSA-2012:0321<o:p></o:p> Errata already exists. RHSA-2012:0321:R5-64<o:p></o:p>RHBA-2012:0146<o:p></o:p> Errata already exists. RHBA-2012:0146:R5-64<o:p></o:p>RHBA-2012:0319<o:p></o:p> Errata already exists. RHBA-2012:0319:R5-64<o:p></o:p>RHBA-2012:0148<o:p></o:p>Fault Code: -208 Fault String: redstone.xmlrpc.XmlRpcFault: The errata RHBA-2012:0148:R5-64 cannot be found.<o:p></o:p>Errata RHBA-2012:0148:R5-64 Doesn't Exist on spacewalkserver ...<o:p></o:p> 2/21/12 - subscription-manager bug fix update<o:p></o:p> Errata Created: 158<o:p></o:p> Errata Published!<o:p></o:p>RHBA-2011:1352<o:p></o:p>Fault Code: -208 Fault String: redstone.xmlrpc.XmlRpcFault: The errata RHBA-2011:1352:R5-64 cannot be found.<o:p></o:p>Errata RHBA-2011:1352:R5-64 Doesn't Exist on spacewalkserver ...<o:p></o:p> 2/20/12 - OpenIPMI bug fix update<o:p></o:p> Errata Created: 160<o:p></o:p>Fault Code: -1 - redstone.xmlrpc.XmlRpcFault: unhandled internal exception: ERROR: duplicate key value violates unique constraint "rhn_cnp_cid_nid_uq"<o:p></o:p>Traceback (most recent call last):<o:p></o:p> File "/usr/local/sbin/rhn-clone-errata.py", line 643, in ?<o:p></o:p> main()<o:p></o:p> File "/usr/local/sbin/rhn-clone-errata.py", line 633, in main<o:p></o:p> spwPublish = mySPW.errataPublish (spwErrataName, [chanMap[options.src_channel]], 0)<o:p></o:p> File "/usr/local/sbin/rhn-clone-errata.py", line 384, in errataPublish<o:p></o:p> return self.server.errata.publish(self.rhnSession,name,channels)<o:p></o:p> File "/usr/lib64/python2.4/xmlrpclib.py", line 1096, in __call__<o:p></o:p> return self.__send(self.__name, args)<o:p></o:p> File "/usr/lib64/python2.4/xmlrpclib.py", line 1383, in __request<o:p></o:p> verbose=self.__verbose<o:p></o:p> File "/usr/lib64/python2.4/xmlrpclib.py", line 1147, in request<o:p></o:p> return self._parse_response(h.getfile(), sock)<o:p></o:p> File "/usr/lib64/python2.4/xmlrpclib.py", line 1286, in _parse_response<o:p></o:p> return u.close()<o:p></o:p> File "/usr/lib64/python2.4/xmlrpclib.py", line 744, in close<o:p></o:p> raise Fault(**self._stack[0])<o:p></o:p>xmlrpclib.Fault: <Fault -1: 'redstone.xmlrpc.XmlRpcFault: unhandled internal exception: ERROR: duplicate key value violates unique constraint "rhn_cnp_cid_nid_uq"'><o:p></o:p><o:p> </o:p>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.<o:p></o:p><o:p> </o:p>Thanks,<o:p></o:p>Robert <o:p></o:p><o:p> </o:p> Robert Boyd Senior Systems Engineer Phone: 919-645-2972<o:p></o:p>Mobile: 919-306-4681<o:p></o:p>Peoplefluent<o:p></o:p>434 Fayetteville Street <o:p></o:p>Raleigh, NC 27601<o:p></o:p> <a href="mailto:michael.dileonardo@peoplefluent.com"><a href="mailto:robert.boyd@peoplefluent.com">robert.boyd@peoplefluent.com</a></a><o:p></o:p><o:p> </o:p><table class="MsoNormalTable" border="0" cellspacing="8" cellpadding="0"><tbody><tr><td style="padding:0in 0in 0in 0in"><image001.png><o:p></o:p></td><td style="padding:0in 0in 0in 0in"><o:p> </o:p></td></tr></tbody></table>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.<o:p></o:p><o:p> </o:p></div></div></blockquote><blockquote type="cite"><div>_______________________________________________ Spacewalk-list mailing list <a href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a> <a href="https://www.redhat.com/mailman/listinfo/spacewalk-list">https://www.redhat.com/mailman/listinfo/spacewalk-list</a></div></blockquote></body></html>