[Spacewalk-list] Issue with syncing CentOS 7 Updates repository to Spacewalk

[Max Mitschke]

You were correct. There were two packages that I had to manually delete:

1. firefox-45.1.1-1el7.centos.i686.rpm
2. firefox-45.1.1-1el7.centos.x86_64.rpm

Then I just recreated the repository and now I am all good. Thank you for your help!

Max Mitschke

-----Original Message-----
From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Ricky Boone
Sent: Wednesday, June 01, 2016 11:31 AM
To: spacewalk-list at redhat.com
Subject: Re: [Spacewalk-list] Issue with syncing CentOS 7 Updates repository to Spacewalk

I ran into that, too.  I can't remember which log I checked (likely the one respective to the repo under /var/log/rhn/reposync), but I found that there were firefox related packages that were to blame.
Probably an issue upstream, but I just deleted the packages from the repo, deleted the orphaned packages, and was able to resync the affected repo.

On Wed, Jun 1, 2016 at 11:16 AM, Max Mitschke <max.mitschke at msufcu.org> wrote:
> Hello,
>
>
>
> Spacewalk keeps failing when trying to sync packages from the CentOS 7
> updates repository. What are some methods to resolve this issue?
>
>
>
> Things that I have tried:
>
> ·        Clearing the cache and resyncing
>
> ·        Deleted all the packages in channel repo and resyncing
>
>
>
> Error Message:
>
> ERROR: (23, 'ERROR:  duplicate key value violates unique constraint
> "rhn_cnp_cid_nid_uq"', 'Could not update database entry.')
>
> Traceback (most recent call last):
>
>   File "/usr/bin/spacewalk-repo-sync", line 218, in <module>
>
>     sys.exit(abs(main() or 0))
>
>   File "/usr/bin/spacewalk-repo-sync", line 211, in main
>
>     sync.sync()
>
>   File
> "/usr/lib/python2.7/site-packages/spacewalk/satellite_tools/reposync.p
> y",
> line 224, in sync
>
>     [self.channel_label], [], "server.app.yumreposync")
>
>   File
> "/usr/lib/python2.7/site-packages/spacewalk/server/taskomatic.py",
> line 69, in add_to_repodata_queue_for_channel_package_subscription
>
>     add_to_repodata_queue(channel, caller, reason[:128])
>
>   File
> "/usr/lib/python2.7/site-packages/spacewalk/server/taskomatic.py",
> line 53, in add_to_repodata_queue
>
>     queue.add(entry)
>
>   File
> "/usr/lib/python2.7/site-packages/spacewalk/server/taskomatic.py",
> line 44, in add
>
>     bypass_filters=self._boolean_as_char(entry.bypass_filters))
>
>   File
> "/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/sql_base.py"
> , line 151, in execute
>
>     return self._execute_wrapper(self._execute, *p, **kw)
>
>   File
> "/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/driver_postg
> resql.py",
> line 296, in _execute_wrapper
>
>     raise sql_base.SQLSchemaError(error_code, e.pgerror, e)
>
> spacewalk.server.rhnSQL.sql_base.SQLSchemaError: (99999, 'ERROR:
> current transaction is aborted, commands ignored until end of
> transaction block', '', InternalError('current transaction is aborted,
> commands ignored until end of transaction block\n',))
>
>
>
> Thanks,
>
>
>
> Max Mitschke
>
>
>
>
> ________________________________
>
> This electronic transmission and any information that it contains is
> the property of MSU Federal Credit Union and is intended for the use
> of the intended recipient. If you are not the intended recipient, any
> disclosure, copying or other use of this information is strictly
> prohibited. If you acquired this transmission in error or feel that
> any of the information contained within it is offensive or
> inappropriate, please contact internalaudit at msufcu.org.
>
>
> _______________________________________________
> 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

________________________________
This electronic transmission and any information that it contains is the property of MSU Federal Credit Union and is intended for the use of the intended recipient. If you are not the intended recipient, any disclosure, copying or other use of this information is strictly prohibited. If you acquired this transmission in error or feel that any of the information contained within it is offensive or inappropriate, please contact internalaudit at msufcu.org<mailto:internalaudit at msufcu.org>.