Bug 2219757 - CRB repo: invalid checksum for postgresql-docs on mirror.stream.centos.org
Summary: CRB repo: invalid checksum for postgresql-docs on mirror.stream.centos.org
Keywords:
Status: NEW
Alias: None
Product: Red Hat Enterprise Linux 9
Classification: Red Hat
Component: postgresql
Version: CentOS Stream
Hardware: Unspecified
OS: Unspecified
unspecified
low
Target Milestone: rc
: ---
Assignee: Filip Januš
QA Contact: RHEL CS Apps Subsystem QE
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2023-07-05 07:26 UTC by fossrob
Modified: 2023-07-05 09:38 UTC (History)
4 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed:
Type: Bug
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker RHELPLAN-161561 0 None None None 2023-07-05 08:34:07 UTC

Description fossrob 2023-07-05 07:26:57 UTC
Description of problem:

A file located at the url https://mirror.stream.centos.org/9-stream/CRB/x86_64/os/Packages/postgresql-docs-13.7-1.el9.x86_64.rpm failed validation due to checksum. Expected '59930a07af95a826b1d4b182b7895205e71bef2cbd1b5b7e3f992dcd19908dea', Actual '8992bc89ef759f805d8a13889728adba091a9867cda6035109aa4b0cad7cb97d'

Version-Release number of selected component (if applicable):

13.7-1.el9

How reproducible:

Perform a repo sync with Foreman, or download the rpm binary and verify the checksum against the repository metadata.

Steps to Reproduce:
1.
2.
3.

Actual results:

Checksum differs.

Expected results:

Checksums should match.

Additional info:

Comment 1 farrotin 2023-07-05 09:38:46 UTC
As it was discussed on Discourse, it should be fixed in Cloudfront CDN.

curl --silent https://mirror.stream.centos.org/9-stream/CRB/x86_64/os/Packages/postgresql-docs-13.7-1.el9.x86_64.rpm |sha256sum
59930a07af95a826b1d4b182b7895205e71bef2cbd1b5b7e3f992dcd19908dea  -

Explanation: one of the origin servers behind cloudfront had a corrupted pkg, then served by cloudfront depending on the location.

Taken action:
- identified which origin node had the problematic pkg and ensuring it got the correct one (it seems rsync doesn't complain which itself is a problem)
- invalidated that pkg/path in cloudfront
- test that it was serving correct pkg

For people in charge of routing from Bugzilla to Jira CS (CentOS Stream) project: you can refer this one and it's already solved but can be used to add more checks to ensure it doesn't happen again


Note You need to log in before you can comment on or make changes to this bug.