[MDEV-28014] 10.2.43 ubuntu bionic aarch64 package broken dependency Created: 2022-03-07  Updated: 2022-03-25  Resolved: 2022-03-11

Status: Closed
Project: MariaDB Server
Component/s: Docker, Packaging
Fix Version/s: 10.2.43

Type: Task Priority: Major
Reporter: Daniel Black Assignee: Daniel Bartholomew
Resolution: Fixed Votes: 0
Labels: None


 Description   

The docker library failed to build a aarch64 bionic package: https://doi-janky.infosiftr.net/job/multiarch/job/arm64v8/job/mariadb/

Cause MDBF-347 (now fixed)

+ apt-get update
 
Get:1 http://ports.ubuntu.com/ubuntu-ports bionic InRelease [242 kB]
 
Get:3 http://ports.ubuntu.com/ubuntu-ports bionic-updates InRelease [88.7 kB]
 
Get:4 http://ports.ubuntu.com/ubuntu-ports bionic-backports InRelease [74.6 kB]
 
Get:2 https://archive.mariadb.org/mariadb-10.2.43/repo/ubuntu bionic InRelease [7722 B]
 
Get:5 http://ports.ubuntu.com/ubuntu-ports bionic-security InRelease [88.7 kB]
 
Get:6 http://ports.ubuntu.com/ubuntu-ports bionic/main arm64 Packages [1285 kB]
 
Get:7 http://ports.ubuntu.com/ubuntu-ports bionic/restricted arm64 Packages [572 B]
 
Get:8 http://ports.ubuntu.com/ubuntu-ports bionic/universe arm64 Packages [11.0 MB]
 
Get:9 https://archive.mariadb.org/mariadb-10.2.43/repo/ubuntu bionic/main arm64 Packages [14.4 kB]
 
Get:10 http://ports.ubuntu.com/ubuntu-ports bionic/multiverse arm64 Packages [153 kB]
 
Get:11 http://ports.ubuntu.com/ubuntu-ports bionic-updates/multiverse arm64 Packages [5351 B]
 
Get:12 http://ports.ubuntu.com/ubuntu-ports bionic-updates/restricted arm64 Packages [4824 B]
 
Get:13 http://ports.ubuntu.com/ubuntu-ports bionic-updates/universe arm64 Packages [2009 kB]
 
Get:14 http://ports.ubuntu.com/ubuntu-ports bionic-updates/main arm64 Packages [1813 kB]
 
Get:15 http://ports.ubuntu.com/ubuntu-ports bionic-backports/main arm64 Packages [11.6 kB]
 
Get:16 http://ports.ubuntu.com/ubuntu-ports bionic-backports/universe arm64 Packages [12.2 kB]
 
Get:17 http://ports.ubuntu.com/ubuntu-ports bionic-security/multiverse arm64 Packages [2759 B]
 
Get:18 http://ports.ubuntu.com/ubuntu-ports bionic-security/main arm64 Packages [1427 kB]
 
Get:19 http://ports.ubuntu.com/ubuntu-ports bionic-security/restricted arm64 Packages [4146 B]
 
Get:20 http://ports.ubuntu.com/ubuntu-ports bionic-security/universe arm64 Packages [1312 kB]
 
Fetched 19.6 MB in 18s (1061 kB/s)
 
Reading package lists...
 
+ DEBIAN_FRONTEND=noninteractive apt-get install -y mariadb-server-10.2=1:10.2.43+maria~bionic mariadb-backup-10.2 socat
 
Reading package lists...
 
Building dependency tree...
 
Reading state information...
 
Some packages could not be installed. This may mean that you have
 
requested an impossible situation or if you are using the unstable
 
distribution that some required packages have not yet been created
 
or been moved out of Incoming.
 
The following information may help to resolve the situation:
 
 
 
The following packages have unmet dependencies:
 
 mariadb-server-10.2 : Depends: iproute but it is not installable or
 
                                iproute but it is not installable
 
                       Recommends: libhtml-template-perl but it is not going to be installed
 
E: Unable to correct problems, you have held broken packages.



 Comments   
Comment by Daniel Black [ 2022-03-07 ]

Daniel is it acceptable to update a single package from the same source?

pushed bb-10.2-danielblack-MDEV-28014-aarch64-bionic-packge-broken branching from the mariadb-10.2.43 tag.
Results coming to https://ci.mariadb.org/23016/

Comment by Daniel Black [ 2022-03-07 ]

pushed bb-10.2-compatibility as its a branch that isn't a release/main branch that saves packages.

take 2: https://ci.mariadb.org/23049/

Comment by Daniel Black [ 2022-03-08 ]

tested:

$ podman run --arch arm64 --variant v8 --rm -ti ubuntu:18.04
 
Resolved "ubuntu" as an alias (/etc/containers/registries.conf.d/000-shortnames.conf)
 
Trying to pull docker.io/library/ubuntu:18.04...
 
Getting image source signatures
 
Copying blob 20d796c36622 skipped: already exists  
Copying config 29e70752d7 done  
Writing manifest to image destination
 
Storing signatures
 
root@84809ed6d72e:/# echo 'deb [trusted=yes] https://ci.mariadb.org/23049/aarch64-ubuntu-1804-deb-autobake/debs ./' > /etc/apt/sources.list.d/mariadb.list
 
root@84809ed6d72e:/# apt-get update
 
...
 
E: Failed to fetch https://ci.mariadb.org/23049/aarch64-ubuntu-1804-deb-autobake/debs/./Packages  Certificate verification failed: The certificate is NOT trusted. The certificate issuer is unknown.  Could not handshake: Error in the certificate verification. [IP: 135.181.143.118 443]
 
E: Some index files failed to download. They have been ignored, or old ones used instead.
 
root@84809ed6d72e:/# apt-get install ca-certificates
 
...
 
Updating certificates in /etc/ssl/certs...
 
0 added, 0 removed; done.
 
Running hooks in /etc/ca-certificates/update.d...
 
done.
 
root@84809ed6d72e:/# apt-get update
 
Hit:1 http://ports.ubuntu.com/ubuntu-ports bionic InRelease             
Hit:2 http://ports.ubuntu.com/ubuntu-ports bionic-updates InRelease                               
Hit:3 http://ports.ubuntu.com/ubuntu-ports bionic-backports InRelease                             
Hit:4 http://ports.ubuntu.com/ubuntu-ports bionic-security InRelease        
Ign:5 https://ci.mariadb.org/23049/aarch64-ubuntu-1804-deb-autobake/debs ./ InRelease
 
Ign:6 https://ci.mariadb.org/23049/aarch64-ubuntu-1804-deb-autobake/debs ./ Release
 
Get:7 https://ci.mariadb.org/23049/aarch64-ubuntu-1804-deb-autobake/debs ./ Packages [10.5 kB]
 
Fetched 10.5 kB in 8s (1356 B/s)                                                                                                                                                                                       
Reading package lists... Done
 
root@84809ed6d72e:/# apt-get install mariadb-server
 
...
 
Setting up mariadb-server (1:10.2.43+maria~bionic) ...
 
Setting up libdbd-mysql-perl (4.046-1) ...
 
Setting up libhttp-date-perl (6.02-1) ...
 
Setting up libhtml-template-perl (2.97-1) ...
 
Setting up libcgi-fast-perl (1:2.13-1) ...
 
Setting up libhttp-message-perl (6.14-1) ...
 
Processing triggers for libc-bin (2.27-3ubuntu1.5) ...
 
/sbin/ldconfig.real: /usr/lib/aarch64-linux-gnu/libmariadb.so.3 is not a symbolic link
 
 
 
root@84809ed6d72e:/# dpkg -l | grep mariadb
 
ii  libmariadb3              1:10.2.43+maria~bionic    arm64        MariaDB database client library
 
ii  mariadb-client-10.2      1:10.2.43+maria~bionic    arm64        MariaDB database client binaries
 
ii  mariadb-client-core-10.2 1:10.2.43+maria~bionic    arm64        MariaDB database core client binaries
 
ii  mariadb-common           1:10.2.43+maria~bionic    all          MariaDB database common files (e.g. /etc/mysql/mariadb.conf.d/)
 
ii  mariadb-server           1:10.2.43+maria~bionic    all          MariaDB database server (metapackage depending on the latest version)
 
ii  mariadb-server-10.2      1:10.2.43+maria~bionic    arm64        MariaDB database server binaries
 
ii  mariadb-server-core-10.2 1:10.2.43+maria~bionic    arm64        MariaDB database core server files
 
 
 
root@84809ed6d72e:/# dpkg -l | grep iproute
 
ii  iproute2                 4.15.0-2ubuntu1.3         arm64        networking and traffic control tools

So, is a package update acceptable?

Comment by Daniel Bartholomew [ 2022-03-09 ]

Generally a package update is not acceptable. But in this case, since the current package is preventing all installs due to the errant dependency, updating it seems warranted.

I will proceed with updating the 10.2.43 Ubuntu repository with the mariadb-server-10.2_10.2.43+maria_bionic_arm64.deb package from https://ci.mariadb.org/23049/aarch64-ubuntu-1804-deb-autobake/debs/

Comment by Daniel Black [ 2022-03-11 ]

Thanks dbart

Docker Library container images released from it https://github.com/docker-library/official-images/pull/12022

Comment by Otto Kekäläinen [ 2022-03-18 ]

The aarch64 is not an official architecture of Ubuntu Bionic. Breakage on that ports.ubuntu.com is kind of likely and expected. The package iproute is very common and if it is broken on ports.ubuntu.com you should file a bug against ports.ubuntu.com, not start to change the dependencies of a stable MariaDB release on a Ubuntu LTS version.

I don't have an arm64 host now handy nor the time to reproduce this, but* I find it very unlikely that there would ever be any need to touch the contents of `debian/` on a MariaDB release that is several years old to adapt to a Ubuntu release that is several years old*. Neither has any changes, and that is intentional. If you now change them, there is a large risk of regressions and broken installs/upgrades.If the CI starts showing failure for an old MariaDB release on and old distro, the issue is most likely something broken with the distribution channel / unofficial ports etc and not with the old MariaDB release nor the old Ubuntu/Debian distro itself.

Generated at Thu Feb 08 09:57:23 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.