[MDEV-31091] Fedora broken RPM repository on archive.mariadb.org for 10.4.24-28 Created: 2023-04-20  Updated: 2023-09-28  Resolved: 2023-09-28

Status: Closed
Project: MariaDB Server
Component/s: Repositories
Affects Version/s: 10.4.24, 10.4.25, 10.4.26, 10.4.27, 10.4.28
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Robin Newhouse Assignee: Daniel Bartholomew
Resolution: Fixed Votes: 0
Labels: installation, rpm, yum
Environment:

Fedora 37


 Description   

There appears to be a broken repository on https://archive.mariadb.org/. When manually selecting the yum repository for versions 10.4.24-10.4.28, installing MariaDB Server fails with

Downloading error(s): repodata/50a4af1d6779e8011267b3557b29e874e97cf7d83003df58a467be319c858fbf-updateinfo.xml.gz - Cannot download, all mirrors were already tried without success

This is reproducible in a docker container with the following commands

 
 
docker run --rm -it fedora:latest bash
 
 
 
cat <<EOF >/etc/yum.repos.d/MariaDB.repo
 
[mariadb]
 
name=MariaDB
 
baseurl=https://archive.mariadb.org/mariadb-10.4.26/yum/fedora/33/x86_64/
 
gpgkey=https://ftp.osuosl.org/pub/mariadb/yum/RPM-GPG-KEY-MariaDB
 
gpgcheck=1
 
EOF
 
 
 
dnf install -y MariaDB-server
 
# Errors during downloading metadata for repository 'mariadb':
 
#   - Status code: 404 for https://archive.mariadb.org/mariadb-10.4.26/yum/fedora/33/x86_64/repodata/50a4af1d6779e8011267b3557b29e874e97cf7d83003df58a467be319c858fbf-updateinfo.xml.gz (IP: 138.201.152.105)
 
# Error: Failed to download metadata for repo 'mariadb': Yum repo downloading error: Downloading error(s): repodata/50a4af1d6779e8011267b3557b29e874e97cf7d83003df58a467be319c858fbf-updateinfo.xml.gz - Cannot download, all mirrors were already tried without success
 
 
 
cat <<EOF >/etc/yum.repos.d/MariaDB.repo
 
[mariadb]
 
name=MariaDB
 
baseurl=https://archive.mariadb.org/mariadb-10.4.22/yum/fedora/33/x86_64/
 
gpgkey=https://ftp.osuosl.org/pub/mariadb/yum/RPM-GPG-KEY-MariaDB
 
gpgcheck=1
 
EOF
 
 
 
 
 
# Separate issue. Latest fedora does not have the earlier required version of boost. Install it manually.
 
dnf install -y http://springdale.princeton.edu/data/springdale/7/x86_64/os/Computational/boost173-program-options-1.73.0-7.sdl7.x86_64.rpm
 
 
 
dnf install -y MariaDB-server
 
mariadb --version
 
# mariadb  Ver 15.1 Distrib 10.4.22-MariaDB, for Linux (x86_64) using  EditLine wrapper



 Comments   
Comment by Robin Newhouse [ 2023-04-20 ]

More specifically, it is missing the "*-updateinfo.xml.gz" file that is present in other repositories.

e.g. 10.4.22: https://archive.mariadb.org/mariadb-10.4.22/yum/fedora/33/x86_64/repodata/50a4af1d6779e8011267b3557b29e874e97cf7d83003df58a467be319c858fbf-updateinfo.xml.gz

Comment by Daniel Black [ 2023-04-20 ]

Well noticed robinnew, note old fedora mariadb versions probably won't work on newer Fedora version as in addition to boost, they will require an old openssl version.

Recommend container based tests for a independence from OS using the verion as a tag mariadb:10.4.24.

Comment by Robin Newhouse [ 2023-04-20 ]

Thanks @Daniel Black, I've encountered trouble with building older versions on newer distributions before, but it appears installing old versions from RPMs brings along the correct libraries (mostly), including OpenSSL 1.1.

e.g., In Fedora 37, after installing MariaDB 10.4.22

[root@fe3fb4985b05 /]# ldd /usr/bin/mariadb | grep ssl
 
        libssl.so.1.1 => /lib64/libssl.so.1.1 (0x00007f55e89d2000)

This issue was found while working on some tests of upgrades between minor and major versions starting from 10.3. All of them installed correctly (after installing the correct boost library) and the server started without issue. That is except for the 10.4.24-28.

Comment by Daniel Bartholomew [ 2023-04-21 ]

I went through and fixed several of the old fedora releases a few months ago, but these must have been missed. Thanks. I'll get them updated with correct metadata.

Comment by Daniel Black [ 2023-09-28 ]

I checked. Its fixed.

[root@9f55972a968c /]# dnf install -y MariaDB-server
 
Fedora 33 openh264 (From Cisco) - x86_64                                                                                                                 946  B/s | 2.5 kB     00:02    
Fedora Modular 33 - x86_64                                                                                                                               1.7 MB/s | 3.3 MB     00:01    
Fedora 33 - x86_64 - Updates                                                                                                                             5.1 MB/s |  31 MB     00:06    
Fedora Modular 33 - x86_64 - Updates                                                                                                                     1.2 MB/s | 3.2 MB     00:02    
Dependencies resolved.
 
=========================================================================================================================================================================================
 
 Package                                             Architecture                        Version                                              Repository                            Size
 
=========================================================================================================================================================================================
 
Installing:
 
 MariaDB-server                                      x86_64                              10.4.22-1.fc33                                       mariadb                               17 M
 
Installing dependencies:
 
 MariaDB-client                                      x86_64                              10.4.22-1.fc33                                       mariadb                              7.6 M
 
 MariaDB-common                                      x86_64                              10.4.22-1.fc33                                       mariadb

Generated at Thu Feb 08 10:21:13 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.