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

[Ricky Boone]

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.py",
> 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_postgresql.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