<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=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Nur Text Zchn";
margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.NurTextZchn
{mso-style-name:"Nur Text Zchn";
mso-style-priority:99;
mso-style-link:"Nur Text";
font-family:Consolas;}
span.E-MailFormatvorlage19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
p.PlainText, li.PlainText, div.PlainText
{mso-style-name:"Plain Text";
mso-style-link:"Plain Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:"Calibri",sans-serif;}
span.E-MailFormatvorlage22
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="DE" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-US">Hey,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D;mso-fareast-language:EN-US">after a snapshot of the spacewalk-VM, I truncated the mentioned table and associated tables.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-US">rhnschema=# truncate rhnErrata CASCADE;;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-US">HINWEIS: Truncate-Vorgang leert ebenfalls Tabelle »rhnactionerrataupdate«<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-US">HINWEIS: Truncate-Vorgang leert ebenfalls Tabelle »rhnchannelerrata«<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-US">HINWEIS: Truncate-Vorgang leert ebenfalls Tabelle »rhnerratabuglist«<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-US">HINWEIS: Truncate-Vorgang leert ebenfalls Tabelle »rhnerratacve«<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-US">HINWEIS: Truncate-Vorgang leert ebenfalls Tabelle »rhnerratacloned«<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-US">HINWEIS: Truncate-Vorgang leert ebenfalls Tabelle »rhnerrataclonedtmp«<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-US">HINWEIS: Truncate-Vorgang leert ebenfalls Tabelle »rhnerratafile«<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-US">HINWEIS: Truncate-Vorgang leert ebenfalls Tabelle »rhnerratapackage«<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-US">HINWEIS: Truncate-Vorgang leert ebenfalls Tabelle »rhnerratakeyword«<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-US">HINWEIS: Truncate-Vorgang leert ebenfalls Tabelle »rhnerratanotificationqueue«<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-US">HINWEIS: Truncate-Vorgang leert ebenfalls Tabelle »rhnerrataqueue«<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-US">HINWEIS: Truncate-Vorgang leert ebenfalls Tabelle »rhnserverneededcache«<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-US">HINWEIS: Truncate-Vorgang leert ebenfalls Tabelle »rhnerratafilechannel«<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-US">HINWEIS: Truncate-Vorgang leert ebenfalls Tabelle »rhnerratafilepackage«<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D;mso-fareast-language:EN-US">HINWEIS: Truncate-Vorgang leert ebenfalls Tabelle »rhnerratafilepackagesource«<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D;mso-fareast-language:EN-US">TRUNCATE TABLE<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D;mso-fareast-language:EN-US">Then I synced my channels and it seems that all packages and erratas were imported. Last night I got the notification mails for SLES- und openSUSE-systems again.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D;mso-fareast-language:EN-US">The rhnErrata-table contains erratas for all my systems (SUSE and CentOS).
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D;mso-fareast-language:EN-US">But last night I also got some sql-errors about “duplicate key value violates” again.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D;mso-fareast-language:EN-US">Torsten<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> Robert Morrow [mailto:rmorrow@kumc.edu]
<br>
<b>Sent:</b> Monday, March 20, 2017 3:09 PM<br>
<b>To:</b> Haupt, Torsten <Torsten.Haupt@lhw.mlu.sachsen-anhalt.de><br>
<b>Subject:</b> Re: [Spacewalk-list] Errata not updating.<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">Forgive me, I think I just set myself up to get only the digest so I am not sure how to respond to the list serv. But no, I have not seen anyone respond and I am still having this issue. I have went as far as renaming
one of the entries in the database to see if it is just one that was messed up, but it moved on to the next one and gave me the same error.
<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">Date: Mon, 20 Mar 2017 09:50:32 +0000<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">From: "Haupt, Torsten" <<a href="mailto:Torsten.Haupt@lhw.mlu.sachsen-anhalt.de">Torsten.Haupt@lhw.mlu.sachsen-anhalt.de</a>><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">To: "<a href="mailto:spacewalk-list@redhat.com">spacewalk-list@redhat.com</a>" <<a href="mailto:spacewalk-list@redhat.com">spacewalk-list@redhat.com</a>><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">Subject: Re: [Spacewalk-list] Errata not updating.<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">Message-ID:<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"> <<a href="mailto:081a878bfb114f2ea2228651b5d6f65b@smdmail.lhw.mlu.lsa-net.de">081a878bfb114f2ea2228651b5d6f65b@smdmail.lhw.mlu.lsa-net.de</a>><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">Content-Type: text/plain; charset="us-ascii"<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">Hey,<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">is there a solution for this problem?<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">After upgrading to spacewalk 2.6, I get no erratas for SLES- and openSUSE-Channels, too. I have the same errors in the logs like below.<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">Torsten<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">From: <a href="mailto:spacewalk-list-bounces@redhat.com">
spacewalk-list-bounces@redhat.com</a> [<a href="mailto:spacewalk-list-bounces@redhat.com">mailto:spacewalk-list-bounces@redhat.com</a>] On Behalf Of Robert Morrow<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">Sent: Monday, March 06, 2017 11:10 PM<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">To: 'spacewalk-list@redhat.com' <<a href="mailto:spacewalk-list@redhat.com">spacewalk-list@redhat.com</a>><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">Subject: [Spacewalk-list] Errata not updating.<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">So I am a SuSE shop and use spacewalk to manage my servers. As of updating to 2.6 my errata will not update. I get 'ERROR: duplicate key value violates unique constraint "rhn_errata_advisory_uq"'<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">in the pg_log i get " CST ERROR: duplicate key value violates unique constraint "rhn_errata_advisory_uq" 2017-03-03 15:57:40.331 CST STATEMENT: insert into rhnErrata (advisory_name, advisory, product, description,
advisory_type, severity_id, notes, errata_from, org_id, solution, advisory_rel, topic, synopsis, last_modified, issue_date, update_date, locally_modified, id, refers_to) values (E'SUSE-SLE-SERVER-12-SP1-2016-1519', E'SUSE-SLE-SERVER-12-SP1-2016-1519-1',<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">Does anyone have an idea how to resolve this issue?<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">-------------- next part --------------<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">An HTML attachment was scrubbed...<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">URL: <<a href="https://www.redhat.com/archives/spacewalk-list/attachments/20170320/705bf2c4/attachment.html">https://www.redhat.com/archives/spacewalk-list/attachments/20170320/705bf2c4/attachment.html</a>><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">------------------------------<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
</div>
</body>
</html>