RE: Recent errors syncing EL7's EPEL repo

8 Sep 2021

      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  
Sent: 08 September 2021 13:57
To: uyuni-users@opensuse.org; users@lists.uyuni-project.org
Cc: Simon Avery 
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:  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.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
--
Julio González Gil
Release Engineer, SUSE Manager and Uyuni jgonzalez@suse.com