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:
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.orgmailto: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
