[BUG] If repos are outdated, dependencies fail to install

[blalop]

Description

If repos are outdated, dependencies' task fails to install. See next section for details.

Steps to Reproduce

Spotted this with the recent release of Debian 11.8. If the host is not up to date with the repos, the task that installs the dependencies will surely fail:

TASK [mysql : MySQL | Installing dependencies] *********************************
fatal: [***]: FAILED! => changed=false 
  cache_update_time: 1688709118
  cache_updated: false
  msg: |-
    '/usr/bin/apt-get -y -o "Dpkg::Options::=--force-confdef" -o "Dpkg::Options::=--force-confold"      install 'python3-mysqldb' 's3fs'' failed: E: Failed to fetch http://cdn-aws.deb.debian.org/debian/pool/main/m/mariadb-10.5/mariadb-common_10.5.19-0%2bdeb11u2_all.deb  404  Not Found [IP: 18.67.240.4 80]
    E: Failed to fetch http://cdn-aws.deb.debian.org/debian/pool/main/m/mariadb-10.5/libmariadb3_10.5.19-0%2bdeb11u2_amd64.deb  404  Not Found [IP: 18.67.240.4 80]
    E: Unable to fetch some archives, maybe run apt-get update or try with --fix-missing?
  rc: 100
  stderr: |-
    E: Failed to fetch http://cdn-aws.deb.debian.org/debian/pool/main/m/mariadb-10.5/mariadb-common_10.5.19-0%2bdeb11u2_all.deb  404  Not Found [IP: 18.67.240.4 80]
    E: Failed to fetch http://cdn-aws.deb.debian.org/debian/pool/main/m/mariadb-10.5/libmariadb3_10.5.19-0%2bdeb11u2_amd64.deb  404  Not Found [IP: 18.67.240.4 80]
    E: Unable to fetch some archives, maybe run apt-get update or try with --fix-missing?

Expected behavior:

It should be capable of installing the latest version.

Actual behavior:

It fails.

Reproduces how often:

Always when the repos are not up to date. An apt update is enough.

Environment

• The release version/s you are using:
• OS: Debian 11.6 (with 11.7 now released)
• Ansible Version: -
• Python Version: -
• Others: -

Additional Information

N/A

[blalop]

Released in 4.5.3