Doh! I even commented on that issue - how rubbish my memory is. I'll update my "I'm not seeing that" with "I am seeing that"... Thanks Julio. -----Original Message----- From: Julio Gonzalez <jgonzalez@suse.com> Sent: 08 September 2021 13:57 To: uyuni-users@opensuse.org; users@lists.uyuni-project.org Cc: Simon Avery <Simon.Avery@atass-sports.co.uk> Subject: [EXTERNAL EMAIL] Re: Recent errors syncing EL7's EPEL repo The failing constraint is: ALTER TABLE rhnErrata ADD CONSTRAINT rhn_errata_adv_status_ck CHECK (advisory_status in ('final', 'stable', 'testing', 'retracted')); Checking https://www.mirrorservice.org/sites/dl.fedoraproject.org/pub/epel/7/ x86_64/repodata/ 5662e94b3f052a686820482527991543c417921fe9e7d986d3e19983fab51cb0- updateinfo.xml.bz2 I see that ERRATA is: <update from="updates@fedoraproject.org" status="pending" type="unspecified" version="2.0"> <id>FEDORA-EPEL-2021-aa19cf2506</id> This seems to be the same as: https://github.com/uyuni-project/uyuni/issues/4011 PR with the fix is https://github.com/uyuni-project/uyuni/pull/4134, I am asking if someone can handle it to have it ready in time for Uyuni 2021.09 Best regards. On miércoles, 8 de septiembre de 2021 14:40:55 (CEST) Simon Avery wrote:

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/x8 6_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.p y", line 600, in sync self.import_updates(plugin) File "/usr/lib/python3.6/site-packages/spacewalk/satellite_tools/reposync.p y", line 741, in import_updates processed_updates_count = self.upload_updates(notices) File "/usr/lib/python3.6/site-packages/spacewalk/satellite_tools/reposync.p y", 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/errataImp ort.p y", line 217, in submit dml = self.backend.processErrata(self.batch) File "/usr/lib/python3.6/site-packages/spacewalk/server/importlib/backend.p y", line 1011, in processErrata transactional=1) File "/usr/lib/python3.6/site-packages/spacewalk/server/importlib/backend.p y", line 2151, in __processObjectCollection return self.__processObjectCollection__(objColl, parentTable, childDict, **kwargs) File "/usr/lib/python3.6/site-packages/spacewalk/server/importlib/backend.p y", line 2322, in __processObjectCollection__ return self.__doDML(dml) File "/usr/lib/python3.6/site-packages/spacewalk/server/importlib/backend.p y", line 2427, in __doDML self.__doInsert(dml.insert, dml.tables) File "/usr/lib/python3.6/site-packages/spacewalk/server/importlib/backend.p y", line 2434, in __doInsert self.__doInsertTable(tname, dict) File "/usr/lib/python3.6/site-packages/spacewalk/server/importlib/backend.p y", 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_postg resql .py", line 299, in _execute_wrapper retval = function(*p, **kw) File "/usr/lib/python3.6/site-packages/spacewalk/server/rhnSQL/driver_postg resql .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<mailto: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

-- Julio González Gil Release Engineer, SUSE Manager and Uyuni jgonzalez@suse.com