Hello,
Since nine days ago I'm observing an error while syncing EPEL 8
repository. This error has appeared on different days with different
instances of the same kind (rhnerrata pgsql table constraint
violation):
2021/07/06 -> Initial EPEL 8 sync, no errors. All errata in.
2021/07/11 -> first error appears
psycopg2.errors.CheckViolation: new row for relation "rhnerrata"
violates check constraint "rhn_errata_adv_status_ck"
DETAIL: Failing row contains (8678, FEDORA-EPEL-2021-360b258add,
Product Enhancement Advisory, FEDORA-EPEL-2021-360b258add, 200,
pending, Fedora EPEL 8, Initial package
, rnnoise-0-0.3.20210312git7f449bf.el8, , , 2021-07-09 07:48:35-02,
2021-07-09 07:48:52-02, null, null, 1, null, updates@fedoraproject.org,
2021-07-10 22:02:40.365219-02, 2021-07-10 22:02:40.365219-02, 2021-07-
10 22:02:40.365219-02, null).
2021/07/19 -> the same with different data
psycopg2.errors.CheckViolation: new row for relation "rhnerrata"
violates check constraint "rhn_errata_adv_status_ck"
DETAIL: Failing row contains (8715, FEDORA-EPEL-2021-41eeae14d9,
Product Enhancement Advisory, FEDORA-EPEL-2021-41eeae14d9, 200,
pending, Fedora EPEL 8, Initial package, python-nagiosplugin-1.3.2-
1.el8, , , 2021-07-18 17:55:58-02, 2021-07-18 17:55:58-02, null,
null, 1, null, updates@fedoraproject.org, 2021-07-19 04:22:00.854661-
02, 2021-07-19 04:22:00.854661-02, 2021-07-19 04:22:00.854661-02,
null).
2021/07/21 -> third occurrence, this time repeating "python-
nagiosplugin" instance.
psycopg2.errors.CheckViolation: new row for relation "rhnerrata"
violates check constraint "rhn_errata_adv_status_ck"
DETAIL: Failing row contains (8735, FEDORA-EPEL-2021-41eeae14d9,
Product Enhancement Advisory, FEDORA-EPEL-2021-41eeae14d9, 200,
pending, Fedora EPEL 8, Initial package, python-nagiosplugin-1.3.2-
1.el8, , , 2021-07-18 17:55:58-02, 2021-07-18 17:55:58-02, null,
null, 1, null, updates@fedoraproject.org, 2021-07-19 22:02:34.756984-
02, 2021-07-19 22:02:34.756984-02, 2021-07-19 22:02:34.756984-02,
null).
This is from last night:
psycopg2.errors.CheckViolation: new row for relation "rhnerrata"
violates check constraint "rhn_errata_adv_status_ck"
DETAIL: Failing row contains (8752, FEDORA-EPEL-2021-a5a0c05adf,
Product Enhancement Advisory, FEDORA-EPEL-2021-a5a0c05adf, 200,
pending, Fedora EPEL 8, Initial package, python-jdcal-1.4.1-1.el8, ,
, 2021-07-19 16:46:28-02, 2021-07-19 16:46:28-02, null, null, 1, null,
updates@fedoraproject.org, 2021-07-20 04:05:53.484279-02, 2021-07-20
04:05:53.484279-02, 2021-07-20 04:05:53.484279-02, null).
Full log:
# LANG=C spacewalk-repo-sync -c epel8-almalinux8-x86_64
08:46:02 ======================================
08:46:02 | Channel: epel8-almalinux8-x86_64
08:46:02 ======================================
08:46:02 Sync of channel started.
Retrieving repository 'epel8-almalinux8-x86_64' metadata
...............................[done]
Building repository 'epel8-almalinux8-x86_64' cache
....................................[done]
All repositories have been refreshed.
08:46:06
08:46:06 Importing comps file
96d01da780a309a1803ea903a9f2a33b1c239a265847c6a86718acb9ef85f06e-comps-
Everything.x86_64.xml.
08:46:06 Renaming non-standard filename
96d01da780a309a1803ea903a9f2a33b1c239a265847c6a86718acb9ef85f06e-comps-
Everything.x86_64.xml to comps.x86_64.xml.
08:46:06 *** NOTE: Importing comps file for the channel 'epel8-
almalinux8-x86_64'. Previous comps will be discarded.
08:46:06 Repo URL:
https://dl.fedoraproject.org/pub/epel/8/Everything/x86_64/
08:46:06 Packages in repo: 7558
08:46:14 No new packages to sync.
08:46:15
08:46:15 Patches in repo: 3017.
08:46:15 Add Patch FEDORA-EPEL-2021-3ec3998292
08:46:16 Add Patch FEDORA-EPEL-2021-7dc78a18ca
08:46:16 Add Patch FEDORA-EPEL-2021-d33da662e7
08:46:16 Add Patch FEDORA-EPEL-2021-87b303b50e
08:46:17 Add Patch FEDORA-EPEL-2021-7ed6a63b7b
08:46:17 Add Patch FEDORA-EPEL-2021-a5a0c05adf
08:46:17 Add Patch FEDORA-EPEL-2021-f77315a931
08:46:17 Add Patch FEDORA-EPEL-2021-333cf44938
08:46:17 Add Patch FEDORA-EPEL-2021-fdb6cf1e3a
08:46:17 Add Patch FEDORA-EPEL-2021-b3771b0cd1
08:46:18 Add Patch FEDORA-EPEL-2021-15c5b7660c
08:46:18 Add Patch FEDORA-EPEL-2021-384d2492fa
08:46:18 Add Patch FEDORA-EPEL-2021-247500b671
08:46:18 Add Patch FEDORA-EPEL-2021-d4c3bbff96
08:46:19 Add Patch FEDORA-EPEL-2021-a60d1222d2
08:46:19 Add Patch FEDORA-EPEL-2021-ec70035a87
08:46:19 Add Patch FEDORA-EPEL-2021-d48e8d2d55
08:46:19 Add Patch FEDORA-EPEL-2021-293195e59b
08:46:19 Add Patch FEDORA-EPEL-2021-41eeae14d9
08:46:19 Add Patch FEDORA-EPEL-2021-ec2a0a616a
08:46:19 Add Patch FEDORA-EPEL-2021-b8960f6143
08:46:19 Add Patch FEDORA-EPEL-2021-20a66b3776
08:46:20 Add Patch FEDORA-EPEL-2020-7c3fde7f74
08:46:20 Add Patch FEDORA-EPEL-2021-ac096c00b0
08:46:20 Add Patch FEDORA-EPEL-2021-aa67d44d29
08:46:20 Add Patch FEDORA-EPEL-2021-d3d8cfc98d
08:46:20 Syncing 25 new patch(es) to channel.
08:46:20 Unexpected error: