[Spacewalk-list] Errata not updating

Thu Sep 7 15:04:16 UTC 2017

I reran my sync script and here is the output:
06:44:48 ======================================
06:44:48 | Channel: oraclelinux5-x86_64
06:44:48 ======================================
06:44:48 Sync of channel started.
06:44:48 Repo URL: http://public-yum.oracle.com/repo/OracleLinux/OL5/latest/x86_64/
06:44:51 Packages in repo:             15724
06:51:34 No new packages to sync.
06:51:34 Repo http://public-yum.oracle.com/repo/OracleLinux/OL5/latest/x86_64/ has comps file comps.xml.
06:51:34 Repo http://public-yum.oracle.com/repo/OracleLinux/OL5/latest/x86_64/ has 1311 errata.
06:53:43 ERROR: duplicate key value violates unique constraint "rhn_errata_advisory_uq"

06:53:43 Sync of channel completed in 0:08:54.
06:53:43 Total time: 0:08:54
06:53:44 ======================================
06:53:44 | Channel: oraclelinux5-i386
06:53:44 ======================================
06:53:44 Sync of channel started.
06:53:44 Repo URL: http://public-yum.oracle.com/repo/OracleLinux/OL5/latest/i386/
06:53:47 Packages in repo:             13710
06:59:01 No new packages to sync.
06:59:01 Repo http://public-yum.oracle.com/repo/OracleLinux/OL5/latest/i386/ has comps file comps.xml.
06:59:02 Repo http://public-yum.oracle.com/repo/OracleLinux/OL5/latest/i386/ has 1285 errata.
07:00:57 ERROR: duplicate key value violates unique constraint "rhn_errata_advisory_uq"

07:00:57 Sync of channel completed in 0:07:13.
07:00:57 Total time: 0:07:13
07:00:58 ======================================
07:00:58 | Channel: oraclelinux6-x86_64
07:00:58 ======================================
07:00:58 Sync of channel started.
07:00:59 Repo URL: http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/x86_64/
07:01:05 Packages in repo:             39383
07:14:20 No new packages to sync.
07:14:20 Repo http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/x86_64/ has comps file comps.xml.
07:14:21 Repo http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/x86_64/ has 2946 errata.
07:18:39 Sync of channel completed in 0:17:40.
07:18:39 Total time: 0:17:40
07:18:40 ======================================
07:18:40 | Channel: oraclelinux7-x86_64
07:18:40 ======================================
07:18:40 Sync of channel started.
07:18:40 Repo URL: http://public-yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/
07:18:44 Packages in repo:             22757
07:24:38 No new packages to sync.
07:24:38 Repo http://public-yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/ has comps file comps.xml.
07:24:39 Repo http://public-yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/ has 2453 errata.
07:27:06 Sync of channel completed in 0:08:25.
07:27:06 Total time: 0:08:25
07:27:08 ======================================
07:27:08 | Channel: oraclelinux5-i386-oracle-addons
07:27:08 ======================================
07:27:08 Sync of channel started.
07:27:08 Repo URL: http://public-yum.oracle.com/repo/EnterpriseLinux/EL5/oracle_addons/i386/
07:27:08 Packages in repo:                 7
07:27:08 No new packages to sync.
07:27:08 Repo http://public-yum.oracle.com/repo/EnterpriseLinux/EL5/oracle_addons/i386/ has 0 errata.
07:27:08 Sync of channel completed in 0:00:00.
07:27:08 Total time: 0:00:00

What I find interesting is that OL7/OL5-i386-addons didn’t have the error, but the OL5-i386/x86_64 did have the errors.  Does the errata write to the same table?

Sean

-----Original Message-----
From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Sean Roe
Sent: Thursday, September 07, 2017 7:30 AM
To: spacewalk-list at redhat.com
Subject: Re: [Spacewalk-list] Errata not updating

The upgrade(s) went without a hitch.  The only issue was when we converted from Oracle to postgres and I had was as follows from an earlier email thead:

Sean Roe:
> I found a solution that I am sharing with you. Because the linux postgresql database would barf on the ALF32UTF8 input file generated by doing the spacewalk-dump-schema command I had to take the output from that command and I ran it through the following command:
> 
> iconv -c -t utf-8 migrate-to-postgres.sql > migrate-to-postgres2.sql
> 
> and then do the:
> 
> spacewalk-sql -verbose migrate-to-postgres2.sql
> 
> Just thought I would share my solution.

I've updated wiki page with this piece of information.
Thanks for sharing.

> Thanks,
> Sean

That was my only issue.

Sean

-----Original Message-----
From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Michael Mraka
Sent: Thursday, September 07, 2017 1:58 AM
To: spacewalk-list at redhat.com
Subject: Re: [Spacewalk-list] Errata not updating

Sean Roe:
> Hi All,
> 
> I just finished updating my spacewalk install to 2.6 and then we migrated to postgres.  I manually run the repo syncs and now I am getting this error "ERROR: duplicate key value violates unique constraint "rhn_errata_advisory_uq""  when I do one.  My research indicates that this will kill my erratas.  How do I repair this?
> 
> Output from the repo sync:
> 13:15:52 Linking packages to channel.
> 13:15:55 Repo http://public-yum.oracle.com/repo/OracleLinux/OL5/latest/i386/ has comps file comps.xml.
> 13:15:56 Repo http://public-yum.oracle.com/repo/OracleLinux/OL5/latest/i386/ has 1285 errata.
> 13:17:26 ERROR: duplicate key value violates unique constraint "rhn_errata_advisory_uq"
> 
> Any suggestions would be helpful.

Did all upgrade steps described on https://github.com/spacewalkproject/spacewalk/wiki/HowToUpgrade passed succefully?
Especially schema upgrade step; were there any errors?

> Thanks,
> Sean

Regards,

--
Michael Mráka
System Management Engineering, Red Hat

_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list