From: Evan Rempel <erempel@uvic.ca>
To: pgsql-admin@postgresql.org
Subject: RPMs changing in the yum repository
Date: Tue, 31 Oct 2023 09:09:20 -0700
Message-ID: <e1a36135-5502-458f-b98e-1f1825a9cdf0@uvic.ca> (raw)
I'm not sure where to send this message.
We synchronize a copy of the pgdgXX and the pgdg-common repositories
using the reposync tool.
Occasionally this tools reports errors and will not download some rpms.
An example of the errors are
pgbouncer-debuginfo-1.20.1-42P FAILED
pgbouncer-1.20.1-42PGDG.rhel7. FAILED
pgbouncer-debuginfo-1.20.1-42PGDG.rhel7.x86_64: [Errno 256] No more
mirrors to try.
pgbouncer-1.20.1-42PGDG.rhel7.x86_64: [Errno 256] No more mirrors to try.
It seems obvious that this is some kind of network error or some general
download issue that could be retried at a later time, however, the root
cause of this is that these RPMs had previously been downloaded but the
files were changed in the source repository.
If I move my existing rpms out of the way, the reposync tool happily
downloads the rpms again with no error.
After I have downloaded the files again, I can confirm that they are
different than the previously downloaded copy.
I can also confirm that the rpms I had were not corrupted. They matched
the copy in our backup system. They were dated Aug 9, 2023 and were
backed up on 2023-08-29 (we synchronize the repository on the 28 of each
month). The rpms downloaded today are dated Oct 17, 2023 which also
matches the date on the latest release pgbouncer-debuginfo-1.21.0-42PGDG
and pgbouncer-1.21.0-42PGDG.
It seems like files in the repository got deleted and were rebuilt with
the same version/release identifiers.
Looking at the rpms themselves, the previously downloaded rpm is
rpm -qip pgbouncer-1.20.1-42PGDG.rhel7.x86_64.rpm
Name : pgbouncer
Version : 1.20.1
Release : 42PGDG.rhel7
Architecture: x86_64
Install Date: (not installed)
Group : Unspecified
Size : 542313
License : MIT and BSD
Signature : DSA/SHA1, Wed 09 Aug 2023 04:41:03 AM PDT, Key ID
1f16d2e1442df0f8
Source RPM : pgbouncer-1.20.1-42PGDG.rhel7.src.rpm
Build Date : Wed 09 Aug 2023 04:41:02 AM PDT
Build Host : koji-centos7-x86-64-pgbuild
Relocations : (not relocatable)
Vendor : PostgreSQL Global Development Group
URL : https://www.pgbouncer.org/
Summary : Lightweight connection pooler for PostgreSQL
and the latest download is
rpm -qip pgbouncer-1.20.1-42PGDG.rhel7.x86_64.rpm
Name : pgbouncer
Version : 1.20.1
Release : 42PGDG.rhel7
Architecture: x86_64
Install Date: (not installed)
Group : Unspecified
Size : 542313
License : MIT and BSD
Signature : (none)
Source RPM : pgbouncer-1.20.1-42PGDG.rhel7.src.rpm
Build Date : Tue 17 Oct 2023 02:43:33 AM PDT
Build Host : koji-centos7-x86-64-pgbuild
Relocations : (not relocatable)
Vendor : PostgreSQL Global Development Group
URL : https://www.pgbouncer.org/
Summary : Lightweight connection pooler for PostgreSQL
The "Build Date" is now different and it appears that the Signature has
been removed.
This all seems to be a very uncommon workflow and is causing failures in
the ability to synchronize the repository.
Evan.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: erempel@uvic.ca
Subject: Re: RPMs changing in the yum repository
In-Reply-To: <e1a36135-5502-458f-b98e-1f1825a9cdf0@uvic.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox