<div><div dir="auto">Well, since the default rhn_check interval is 4 hours, you would have to wait that long. Even after a manual rhn_check, the change isn’t instantaneous because it takes a few minutes before the queued taskomatic task executes. But if you wait overnight, all your servers should update.</div></div><div dir="auto"><br></div><div dir="auto"><br></div><div><div class="gmail_quote"><div dir="ltr">On Sat, Dec 22, 2018 at 3:47 PM philippe bidault <<a href="mailto:philippe.bidault@gmail.com">philippe.bidault@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div>Bonjour Paul-André,</div><div><br></div><div>I did try your procedure and ...amazing !<br></div><div><br></div><div>Before applying the SP, I had to change the OWNER as it is rhnuser in my case :</div><div><br></div><div><span style="font-family:monospace,monospace">ALTER FUNCTION rpm.rpmstrcmp(string1 character varying, string2 character varying) OWNER TO <b>rhnuser</b>;</span><br></div><div><br></div><div>To apply the SP :<br></div><div><br></div><div><span style="font-family:monospace,monospace"># su - postgres<br>Last login: Sat Dec 22 16:20:46 CET 2018 on pts/1<br></span></div><div><span style="font-family:monospace,monospace">-bash-4.2$ psql rhnschema -f /var/tmp/rpm.rpmstrcmp.sql<br>SET<br>CREATE FUNCTION<br>ALTER FUNCTION<br></span></div><br><div>And I did restart the satellite service.</div><div><br></div><div>However even after waiting and finally force the "rhn_check" on a registered Ubuntu 18.04 server, nothing occured. I did have to remove and register again the Ubuntu client server to see the difference, means no more packages flagged as upgradable appaearing on the Spacewalk server.<br></div><div><br></div><div>Will continue to keep an eye on this, will let you know if I notice something strange.<br></div><div><br></div><div>Thanks again !</div><div><br></div><div>Regards,</div><div>Philippe.<br></div></div></div></div></div></div><br><div class="gmail_quote"><div dir="ltr">On Sat, 22 Dec 2018 at 08:50, Paul-Andre Panon <<a href="mailto:paul-andre.panon@avigilon.com" target="_blank">paul-andre.panon@avigilon.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div class="gmail_default" style="font-family:times new roman,serif;font-size:large">Bonjour Phillipe,</div><div class="gmail_default" style="font-family:times new roman,serif;font-size:large"><br></div><div class="gmail_default" style="font-family:times new roman,serif;font-size:large">Robert can vouch that this issue's actually been bugging me since SW 2.8 came out, when I found out that this was still a problem despite PR500's improvements. I just haven't had enough time until this month to look at it and dig through all the layers to figure out the root cause. <br></div><div class="gmail_default" style="font-family:times new roman,serif;font-size:large"><br></div><div class="gmail_default" style="font-family:times new roman,serif;font-size:large">If you go to the bug, <a href="https://urldefense.proofpoint.com/v2/url?u=https-3A__bugzilla.redhat.com_show-5Fbug.cgi-3Fid-3D1661347&d=DwMFaQ&c=q3cDpHe1hF8lXU5EFjNM_A&r=2sQoWEMcncSKL5kWoc_nrZbhUyhuj8tJfA91_lDSglQ&m=9Td0Je5VLi1R4E4S0vJsnUBgKXfOqHEZmjYwV-Ul4cY&s=ebhTpxGQlekAIAnqOi_VHplD-WL6ouWR6qFoRRFyK-Y&e=" target="_blank">https://bugzilla.redhat.com/show_bug.cgi?id=1661347</a> , I had added an attachment there. You should be able to download the attachment and<br></div><div class="gmail_default" style="font-family:times new roman,serif;font-size:large">1) stop your Spacewalk service</div><div class="gmail_default" style="font-family:times new roman,serif;font-size:large">2) backup your database</div><div class="gmail_default" style="font-family:times new roman,serif;font-size:large">3) sudo su postgres or add your spaceuser/password to psql -i rpm.rpmstrcmp.sql<br></div><div class="gmail_default" style="font-family:times new roman,serif;font-size:large">4) exit psql if needed and restart your Spacewalk service<br></div><div class="gmail_default" style="font-family:times new roman,serif;font-size:large">and then wait for servers to run the next rhn_check to update their needed updates list.<br></div><div class="gmail_default" style="font-family:times new roman,serif;font-size:large"><br></div><div class="gmail_default" style="font-family:times new roman,serif;font-size:large">Cheers,<br></div><div class="gmail_default" style="font-family:times new roman,serif;font-size:large"><br clear="all"></div><div><div dir="ltr" class="m_7016655798347700481gmail-m_-7708739625561678839gmail-m_6872051904007702017gmail_signature"><div dir="ltr"><div><div dir="ltr"><font size="2"><font size="4">Paul-Andre Panon</font><br></font><div><font size="2">Senior Systems Administrator<br></font></div><div><br></div><font size="2"><b>Avigilon</b><br>A Motorola Solutions Company<br><br></font></div></div></div></div></div></div></div><br><div class="gmail_quote"><div dir="ltr">On Fri, 21 Dec 2018 at 04:00, philippe bidault <<a href="mailto:philippe.bidault@gmail.com" target="_blank">philippe.bidault@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>Indeed, really appreciated Paul-Andre, I did not expect somebody to work so fast to solve this issue !!</div><div>Not sure that I will be able to implement your new PostgreSQL SP in our current Spacewalk platform, I need to understand before the full implication of such modification and the harmless way to do it.<br></div><div><br></div><div>Do you think that a patch, update or something will be delivered soon to allow an easy implementation of your work ?</div><div><br></div><div>Regards,</div><div>Philippe.<br></div><div><br></div><div><br></div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr">On Fri, 21 Dec 2018 at 07:27, Robert Paschedag <<a href="mailto:robert.paschedag@web.de" target="_blank">robert.paschedag@web.de</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Am 21. Dezember 2018 00:44:02 MEZ schrieb Paul-Andre Panon <<a href="mailto:paul-andre.panon@avigilon.com" target="_blank">paul-andre.panon@avigilon.com</a>>:<br> >I created Bugzilla Bug 1661347 regarding this issue<br> <br> Great job, Paul-Andre. Thanks.<br> <br> Robert<br> </blockquote></div> </blockquote></div></div> </blockquote></div> </blockquote></div></div>-- <br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><font size="2"><font size="4">Paul-Andre Panon</font><br></font><div><font size="2">Senior Systems Administrator<br></font></div><div><br></div><font size="2"><b>Avigilon</b><br>A Motorola Solutions Company<br>Office +1 604-629-5182 ext. 2341 | Mobile +1 604-679-1617<br>Support +1 888-281-5182 | <a href="http://avigilon.com" target="_blank">avigilon.com</a><br><a href="https://www.facebook.com/avigiloncorporation" target="_blank">Facebook</a> | <a href="https://www.linkedin.com/company/avigilon" target="_blank">LinkedIn</a> | <a href="https://twitter.com/Avigilon" target="_blank">Twitter </a> | <a href="https://www.youtube.com/user/Avigilon" target="_blank">YouTube</a><br><font size="1">This email, including any files attached hereto (the "email"), contains privileged and confidential information and is only for the intended addressee(s). If this email has been sent to you in error, such sending does not constitute waiver of privilege and we request that you kindly delete the email and notify the sender. Any unauthorized use or disclosure of this email is prohibited. Avigilon and certain other trade names used herein are the registered and/or unregistered trademarks of Avigilon Corporation and/or its affiliates in Canada and other jurisdictions worldwide.<br></font><br></font><div><font size="4"><font size="2"></font><br></font></div></div></div></div></div>