[Spacewalk-list] Errata not updating.

[Haupt, Torsten]

Hey,

after a snapshot of the spacewalk-VM, I truncated the mentioned table and associated tables.
rhnschema=# truncate rhnErrata CASCADE;;
HINWEIS:  Truncate-Vorgang leert ebenfalls Tabelle >rhnactionerrataupdate<
HINWEIS:  Truncate-Vorgang leert ebenfalls Tabelle >rhnchannelerrata<
HINWEIS:  Truncate-Vorgang leert ebenfalls Tabelle >rhnerratabuglist<
HINWEIS:  Truncate-Vorgang leert ebenfalls Tabelle >rhnerratacve<
HINWEIS:  Truncate-Vorgang leert ebenfalls Tabelle >rhnerratacloned<
HINWEIS:  Truncate-Vorgang leert ebenfalls Tabelle >rhnerrataclonedtmp<
HINWEIS:  Truncate-Vorgang leert ebenfalls Tabelle >rhnerratafile<
HINWEIS:  Truncate-Vorgang leert ebenfalls Tabelle >rhnerratapackage<
HINWEIS:  Truncate-Vorgang leert ebenfalls Tabelle >rhnerratakeyword<
HINWEIS:  Truncate-Vorgang leert ebenfalls Tabelle >rhnerratanotificationqueue<
HINWEIS:  Truncate-Vorgang leert ebenfalls Tabelle >rhnerrataqueue<
HINWEIS:  Truncate-Vorgang leert ebenfalls Tabelle >rhnserverneededcache<
HINWEIS:  Truncate-Vorgang leert ebenfalls Tabelle >rhnerratafilechannel<
HINWEIS:  Truncate-Vorgang leert ebenfalls Tabelle >rhnerratafilepackage<
HINWEIS:  Truncate-Vorgang leert ebenfalls Tabelle >rhnerratafilepackagesource<
TRUNCATE TABLE

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.
The rhnErrata-table contains erratas for all my systems (SUSE and CentOS).
But last night I also got some sql-errors about "duplicate key value violates" again.

Torsten


From: Robert Morrow [mailto:rmorrow at kumc.edu]
Sent: Monday, March 20, 2017 3:09 PM
To: Haupt, Torsten <Torsten.Haupt at lhw.mlu.sachsen-anhalt.de>
Subject: Re: [Spacewalk-list] Errata not updating.


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.



Date: Mon, 20 Mar 2017 09:50:32 +0000

From: "Haupt, Torsten" <Torsten.Haupt at lhw.mlu.sachsen-anhalt.de<mailto:Torsten.Haupt at lhw.mlu.sachsen-anhalt.de>>

To: "spacewalk-list at redhat.com<mailto:spacewalk-list at redhat.com>" <spacewalk-list at redhat.com<mailto:spacewalk-list at redhat.com>>

Subject: Re: [Spacewalk-list] Errata not updating.

Message-ID:

                <081a878bfb114f2ea2228651b5d6f65b at smdmail.lhw.mlu.lsa-net.de<mailto:081a878bfb114f2ea2228651b5d6f65b at smdmail.lhw.mlu.lsa-net.de>>

Content-Type: text/plain; charset="us-ascii"



Hey,



is there a solution for this problem?

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.



Torsten



From: spacewalk-list-bounces at redhat.com<mailto:spacewalk-list-bounces at redhat.com> [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Robert Morrow

Sent: Monday, March 06, 2017 11:10 PM

To: 'spacewalk-list at redhat.com' <spacewalk-list at redhat.com<mailto:spacewalk-list at redhat.com>>

Subject: [Spacewalk-list] Errata not updating.



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"'

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',

Does anyone have an idea how to resolve this issue?



-------------- next part --------------

An HTML attachment was scrubbed...

URL: <https://www.redhat.com/archives/spacewalk-list/attachments/20170320/705bf2c4/attachment.html>



------------------------------

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20170321/5835baa9/attachment.htm>