Hi Folks,

Anyone else having sync issues with EL7's EPEL repo for the past week or so?   

I've split out and recreated the repo on Uyuni but it still bombs out when importing one of the errata files. My hunch is this is actually an EPEL issue rather than a Uyuni one, but the pertinent error makes me wonder if this is a new thing that’s going to need extra handling in Uyuni?

“CheckViolation: new row for relation "rhnerrata" violates check constraint "rhn_errata_adv_status_ck"”

Things were okay a week or so-ish ago and I made no changes on my side, but started getting sync failures late last week, or over the weekend.

Thanks

Example repo url; https://www.mirrorservice.org/sites/dl.fedoraproject.org/pub/epel/7/x86_64/

2021/09/08 13:35:47 +01:00 Add Patch FEDORA-EPEL-2019-3630e34c31

2021/09/08 13:35:47 +01:00 Add Patch FEDORA-EPEL-2018-81bb24fe00

2021/09/08 13:35:47 +01:00 Add Patch FEDORA-EPEL-2018-6f7d6eeeed

2021/09/08 13:35:47 +01:00     Syncing 4684 new patch(es) to channel.

2021/09/08 13:36:02 +01:00 Unexpected error: <class 'psycopg2.errors.CheckViolation'>

2021/09/08 13:36:02 +01:00 Traceback (most recent call last):

  File "/usr/lib/python3.6/site-packages/spacewalk/satellite_tools/reposync.py", line 600, in sync

    self.import_updates(plugin)

  File "/usr/lib/python3.6/site-packages/spacewalk/satellite_tools/reposync.py", line 741, in import_updates

    processed_updates_count = self.upload_updates(notices)

  File "/usr/lib/python3.6/site-packages/spacewalk/satellite_tools/reposync.py", line 967, in upload_updates

    importer.run()

  File "/usr/lib/python3.6/site-packages/spacewalk/server/importlib/importLib.py", line 778, in run

    self.submit()

  File "/usr/lib/python3.6/site-packages/spacewalk/server/importlib/errataImport.py", line 217, in submit

    dml = self.backend.processErrata(self.batch)

  File "/usr/lib/python3.6/site-packages/spacewalk/server/importlib/backend.py", line 1011, in processErrata

    transactional=1)

  File "/usr/lib/python3.6/site-packages/spacewalk/server/importlib/backend.py", line 2151, in __processObjectCollection

    return self.__processObjectCollection__(objColl, parentTable, childDict, **kwargs)

  File "/usr/lib/python3.6/site-packages/spacewalk/server/importlib/backend.py", line 2322, in __processObjectCollection__

    return self.__doDML(dml)

  File "/usr/lib/python3.6/site-packages/spacewalk/server/importlib/backend.py", line 2427, in __doDML

    self.__doInsert(dml.insert, dml.tables)

  File "/usr/lib/python3.6/site-packages/spacewalk/server/importlib/backend.py", line 2434, in __doInsert

    self.__doInsertTable(tname, dict)

  File "/usr/lib/python3.6/site-packages/spacewalk/server/importlib/backend.py", line 2449, in __doInsertTable

    insertObj.query(hash)

  File "/usr/lib/python3.6/site-packages/spacewalk/server/importlib/backendLib.py", line 453, in query

    statement.execute_values(self._buildQuery(None), value_list, fetch=False, page_size=10_000)

  File "/usr/lib/python3.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 166, in execute_values

    return self._execute_wrapper(self._execute_values, sql, argslist, template, page_size, fetch)

  File "/usr/lib/python3.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 299, in _execute_wrapper

    retval = function(*p, **kw)

  File "/usr/lib/python3.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 353, in _execute_values

    results = psycopg2.extras.execute_values(self._real_cursor, sql, argslist, template=template, page_size=page_size, fetch=fetch)

  File "/usr/lib64/python3.6/site-packages/psycopg2/extras.py", line 1289, in execute_values

    cur.execute(b''.join(parts))

psycopg2.errors.CheckViolation: new row for relation "rhnerrata" violates check constraint "rhn_errata_adv_status_ck"

DETAIL:  Failing row contains (11847, FEDORA-EPEL-2021-aa19cf2506, Product Enhancement Advisory, FEDORA-EPEL-2021-aa19cf2506, 200, Fedora EPEL 7, Rebuild for Knot DNS 3.1, knot-resolver-5.4.1-2.el7,  ,  , 2021-09-06 03:52:14-01, 2021-09-06 03:52:14-01, null, null, 1, null, updates@fedoraproject.org, 2021-09-08 11:34:52.299009-01, 2021-09-08 11:34:52.299009-01, 2021-09-08 11:34:52.299009-01, 1, pending).

Simon Avery

Linux Systems Administrator