<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <meta name="Generator" content="Microsoft Word 14 (filtered medium)"> <style></style> </head> <body lang="FR" link="blue" vlink="purple"> <div class="WordSection1"> Hi,<o:p></o:p> I'm using Spacewalk 2.2, I have some issues getting all the current CentOS and Ubuntu Errata. I'm using the <a href="http://errata-import.pl" target="_blank">errata-import.pl</a> script provided by <a href="http://cefs.steve-meier.de/" target="_blank">http://cefs.steve-meier.de/</a> for centos and the <a href="https://github.com/philicious/spacewalk-scripts/blob/master/spacewalk-errata.sh" title="spacewalk-errata.sh">spacewalk-errata.sh</a> script provided by <a href="https://github.com/philicious/spacewalk-scripts">https://github.com/philicious/spacewalk-scripts</a> for Ubuntu.<o:p></o:p> Steve’s suggestion that there might be some database entries which are not “handled” by WebUI / Spacecmd. So I tried to delete all errata with the following command lines :<o:p></o:p> <![if !supportLists]>1) <![endif]>Using spacecmd tool delete all errata “spacecmd -u [youruser] -y "errata_delete *"<o:p></o:p> <![if !supportLists]>2) <![endif]>From the database “Select * from rhnerrata”<o:p></o:p> <![if !supportLists]>3) <![endif]>Delete all errata from the database “delete * from rhnerrata”<o:p></o:p> After that, I have run the two scripts but I have this error :<o:p></o:p> <![if !supportLists]>a) <![endif]>For Centos : There is no security errata listed on the WebUI I have only 160 bugfix errata but on the database I had some security, bugfix and enhancement there are about 8229 erratas. I didn’t understand what is the problem, maybe I missed something. See the attached file it is the output of the errata sync.<o:p></o:p> I have this error -> 500 read timeout and the script was interrupted.<o:p></o:p> <![if !supportLists]>b) <![endif]>For Ubuntu : I have error during creating errata :<o:p></o:p> Error creating errata: <Fault -1: 'redstone.xmlrpc.XmlRpcFault: unhandled internal exception: ERROR: deadlock detected\n Detail: Process 11749 waits for ShareLock on transaction 38954038; blocked by process 11679.\nProcess 11679 waits for ShareLock on transaction 38954037; blocked by process 11749.\n Hint: See server log for query details.\n Where: SQL statement "update rhnChannel set last_modified = greatest(current_timestamp, last_modified <o:p></o:p> Has anyone seen any similar issues? <o:p></o:p> <o:p> </o:p> I've had no issues downloading packages, just not getting the Errata imported. <o:p></o:p> Best Regards.<o:p></o:p> <o:p></o:p> Arij Khouildi Ing�nieur Syst�me Sagemcom Software & Technologies 34, Avenue de Paris M�grine 2033<o:p></o:p> Mobile: (+216) 58 58 25 56<o:p></o:p> Email: <a href="mailto:arij.khouildi@sagemcom.com">arij.khouildi@sagemcom.com</a><o:p></o:p> <o:p> </o:p> </div> <PRE>" Ce courriel et les documents qui lui sont joints peuvent contenir des informations confidentielles ou ayant un caract�re priv�. S'ils ne vous sont pas destin�s nous vous signalons qu'il est strictement interdit de les divulguer, de les reproduire ou d'en utiliser de quelque mani�re que ce soit le contenu. Si ce message vous a �t� transmis par erreur, merci d'en informer l'exp�diteur et de supprimer imm�diatement de votre syst�me informatique ce courriel ainsi que tous les documents qui y sont attach�s" ****** " This e-mail and any attached documents may contain confidential or proprietary information. If you are not the intended recipient, you are notified that any dissemination, copying of this e-mail and any attachments thereto or use of their contents by any means whatsoever is strictly prohibited. If you have received this e-mail in error, please advise the sender immediately and delete this e-mail and all attached documents from your computer system." # </PRE></body> </html>