Package wont download, "Cannot download, all mirrors were already tried"

**Problem: I want to update my servers with new packages but they are all stuck at one specific package. yum update downloads around 400 packages and then stops with the following output: [FAILED] bcc-tools-0.30.0-9.el9.x86_64.rpm: No more mirrors to try - All mirrors were already tried without success
(304-305/558): bpftrace-0.21.1-1.el9.x86_64.rpm 29% [============================= ] 3.0 MB/s | 466 MB 06:01 ETA
The downloaded packages were saved in cache until the next successful transaction.
You can remove cached packages by executing ‘yum clean packages’.
Error: Error downloading packages:
bcc-tools-0.30.0-9.el9.x86_64: Cannot download, all mirrors were already tried without success

I tried all the steps, yum clean packages, deleted the dnf cache but nothing works. If I want to install the package manually the same error appears.

**Foreman and Proxy versions: Foreman 3.12 & Katello 4.14

**Distribution and version: CentOS9 Stream