Message-ID: <e1a36135-5502-458f-b98e-1f1825a9cdf0@uvic.ca>
Date: Tue, 31 Oct 2023 09:09:20 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Content-Language: en-US
To: pgsql-admin@postgresql.org
From: Evan Rempel <erempel@uvic.ca>
Subject: RPMs changing in the yum repository
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/e1a36135-5502-458f-b98e-1f1825a9cdf0%40uvic.ca>
Precedence: bulk

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.