What to do when every mirror gives 404 on a package?

I’m trying to install libreoffice-fresh. I have ranked mirrors multiple times. I can install other packages.

==> Packages to install (eg: 1 2 3, 1-3 or ^4)
==> 246
Sync Explicit (1): libreoffice-fresh-24.8.4-2.1
resolving dependencies...
looking for conflicting packages...

Package (27)                        New Version   Net Change  Download Size

cachyos-extra-v3/clucene            2.3.3.4-15.1    2.70 MiB               
cachyos-extra-v3/libabw             0.1.3-4.1       2.79 MiB               
cachyos-extra-v3/libatomic_ops      7.8.2-1.1       0.67 MiB               
cachyos-extra-v3/libcmis            0.6.2-3.1       1.33 MiB               
cachyos-extra-v3/libe-book          0.1.3-16.1     11.08 MiB               
cachyos-extra-v3/libepubgen         0.1.1-5.1       2.76 MiB               
cachyos-extra-v3/libetonyek         0.1.12-2.1      2.37 MiB               
cachyos-extra-v3/libexttextcat      3.4.7-1.1       0.47 MiB               
cachyos-extra-v3/libfreehand        0.1.2-5.1       5.97 MiB               
cachyos-extra-v3/libixion           0.19.0-7.1      1.27 MiB               
cachyos-extra-v3/liblangtag         0.6.7-1.1       3.24 MiB               
cachyos-extra-v3/libmspub           0.1.4-16.1      7.83 MiB               
cachyos-extra-v3/libmwaw            0.3.22-3.1      7.61 MiB               
cachyos-extra-v3/libnumbertext      1.0.11-2.1      0.74 MiB               
cachyos-extra-v3/libodfgen          0.1.8-3.1       1.81 MiB               
cachyos-extra-v3/liborcus           0.19.2-5.1      3.12 MiB               
cachyos-extra-v3/libpagemaker       0.0.4-4.1       2.18 MiB               
cachyos-extra-v3/libqxp             0.0.2-12.1      3.50 MiB               
cachyos-extra-v3/libstaroffice      0.0.7-4.1       2.36 MiB               
cachyos-extra-v3/libtommath         1.3.0-1.1       0.13 MiB               
cachyos-extra-v3/libwps             0.4.14-3.1      2.25 MiB               
cachyos-extra-v3/libzmf             0.0.2-16.1      1.86 MiB               
cachyos-extra-v3/lpsolve            5.5.2.11-3.1    1.68 MiB               
cachyos-extra-v3/rasqal             1:0.9.33-7.1    2.77 MiB               
cachyos-extra-v3/redland            1:1.0.17-9.1    1.70 MiB               
cachyos-extra-v3/xmlsec             1.3.6-1.1       5.96 MiB               
cachyos-extra-v3/libreoffice-fresh  24.8.4-2.1    427.43 MiB     148.94 MiB

Total Download Size:   148.94 MiB
Total Installed Size:  507.56 MiB

:: Proceed with installation? [Y/n] y
:: Retrieving packages...
 libreoffice-fresh-24.8.4-2.1-x86_64_v3.pkg.tar.zst failed to download
error: failed retrieving file 'libreoffice-fresh-24.8.4-2.1-x86_64_v3.pkg.tar.zst' from nl-ams.soulharsh007.dev : The requested URL returned error: 404
error: failed retrieving file 'libreoffice-fresh-24.8.4-2.1-x86_64_v3.pkg.tar.zst' from mirror.cachyos.org : The requested URL returned error: 404
error: failed retrieving file 'libreoffice-fresh-24.8.4-2.1-x86_64_v3.pkg.tar.zst' from de-nue.soulharsh007.dev : The requested URL returned error: 404
error: failed retrieving file 'libreoffice-fresh-24.8.4-2.1-x86_64_v3.pkg.tar.zst' from aur.cachyos.org : The requested URL returned error: 404
error: failed retrieving file 'libreoffice-fresh-24.8.4-2.1-x86_64_v3.pkg.tar.zst' from cdn.cachyos.org : The requested URL returned error: 404
error: failed retrieving file 'libreoffice-fresh-24.8.4-2.1-x86_64_v3.pkg.tar.zst' from cdn77.cachyos.org : The requested URL returned error: 404
error: failed retrieving file 'libreoffice-fresh-24.8.4-2.1-x86_64_v3.pkg.tar.zst' from at.cachyos.org : The requested URL returned error: 404
error: failed retrieving file 'libreoffice-fresh-24.8.4-2.1-x86_64_v3.pkg.tar.zst' from cdn-1.cachyos.org : The requested URL returned error: 404
error: failed retrieving file 'libreoffice-fresh-24.8.4-2.1-x86_64_v3.pkg.tar.zst' from us.cachyos.org : The requested URL returned error: 404
error: failed retrieving file 'libreoffice-fresh-24.8.4-2.1-x86_64_v3.pkg.tar.zst' from cachy-mirror.wtako.net : The requested URL returned error: 404
error: failed retrieving file 'libreoffice-fresh-24.8.4-2.1-x86_64_v3.pkg.tar.zst' from mirror.nju.edu.cn : The requested URL returned error: 404
warning: failed to retrieve some files
error: failed to commit transaction (failed to retrieve some files)
Errors occurred, no packages were upgraded.
 -> error installing repo packages

Are you using proper syntax (-Syu) for the update so that the repo gets updated?
Rank your mirrors, because that’s MONTHS behind. (I have 25.2.0-1)

I think they’re missing from the repo

Ranking mirrors will never do anything in this case. You need to sync your repos (sudo pacman -Syu).