[MDEV-27458] MariaDB 10.6.4 Installation error Created: 2022-01-10  Updated: 2022-10-26  Resolved: 2022-10-26

Status: Closed
Project: MariaDB Server
Component/s: Platform Debian
Affects Version/s: 10.5, 10.6
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: itay p Assignee: Otto Kekäläinen
Resolution: Duplicate Votes: 0
Labels: None
Environment:

Ubuntu server 20.04 LTS Vanilla

Issue Links:
Duplicate
duplicates MDEV-28640 dpkg: warning: old mariadb-server-10.... In Testing

 Description   

Hello,
Attempting to install specific version: mariadb 10.6.4 results in failure on a fresh Ubuntu server 20.04

Steps:
Install ubuntu server 20.04 from ISO.
Add mariadb repository to apt sources as in documentation, nothing special

run:
sudo apt-get install mariadb-server="1:10.6.4+maria~focal"

Error:
Reading package lists... Done
Building dependency tree
Reading state information... Done
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.6 : Conflicts: mariadb-server (< 1:10.6.5+maria~focal) but 1:10.6.4+maria~focal is to be installed*
E: Unable to correct problems, you have held broken packages.

Again, this is a fresh ISO installation.. why did this fail?
Thanks for your time.

When running apt-get install mariadb-server it works fine, but installs 10.6.5 and 10.6.4 is required.

 Comments   
Comment by Elena Stepanova [ 2022-01-10 ]

Does it work if you do 

sudo apt-get install mariadb-server-10.6="1:10.6.4+maria~focal"

– that is, mariadb-server-10.6 instead of mariadb-server?

Comment by itay p [ 2022-01-10 ]

Thanks for the suggestion,
No,
Command:
sudo apt-get install mariadb-server-10.6="1:10.6.4+maria~focal"
Error:
Reading package lists... Done
Building dependency tree
Reading state information... Done
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.6 : Depends: mariadb-client-10.6 (>= 1:10.6.4+maria~focal) but it is not going to be installed
Depends: mariadb-server-core-10.6 (>= 1:10.6.4+maria~focal) but it is not going to be installed
E: Unable to correct problems, you have held broken packages.

Comment by Elena Stepanova [ 2022-01-10 ]

Indeed, it has to go one level further

$ sudo apt-get install mariadb-server-core-10.6="1:10.6.4+maria~focal" mariadb-client-core-10.6="1:10.6.4+maria~focal" mariadb-server-10.6="1:10.6.4+maria~focal" mariadb-client-10.6="1:10.6.4+maria~focal" mariadb-server="1:10.6.4+maria~focal" mariadb-common="1:10.6.4+maria~focal" libmariadb3="1:10.6.4+maria~focal"

The last 3 aren't strictly needed, it's just so everything ends up being 10.6.4

$ dpkg -l | grep mariadb
 
ii  libdbd-mariadb-perl                1.11-3ubuntu2                     amd64        Perl5 database interface to the MariaDB/MySQL databases
 
ii  libmariadb3:amd64                  1:10.6.4+maria~focal              amd64        MariaDB database client library
 
ii  mariadb-client-10.6                1:10.6.4+maria~focal              amd64        MariaDB database client binaries
 
ii  mariadb-client-core-10.6           1:10.6.4+maria~focal              amd64        MariaDB database core client binaries
 
ii  mariadb-common                     1:10.6.4+maria~focal              all          MariaDB common configuration files
 
ii  mariadb-server                     1:10.6.4+maria~focal              all          MariaDB database server (metapackage depending on the latest version)
 
ii  mariadb-server-10.6                1:10.6.4+maria~focal              amd64        MariaDB database server binaries
 
ii  mariadb-server-core-10.6           1:10.6.4+maria~focal              amd64        MariaDB database core server files

Comment by itay p [ 2022-01-10 ]

The above works! thanks for this workaround.

Comment by Daniel Black [ 2022-04-12 ]

test from 10.6-840bab858b643ef6c03f1c5a47809e6e5e061499 (latest to come though CI from time of post)

 
$  podman run -ti ubuntu:20.04 bash
 
root@9b26cecb2505:/# uname -a
 
Linux 9b26cecb2505 5.18.0-0.rc1.18.fc37.x86_64 #1 SMP PREEMPT_DYNAMIC Mon Apr 4 14:49:43 UTC 2022 x86_64 x86_64 x86_64 GNU/Linux
 
root@9b26cecb2505:/# echo 'deb [trusted=yes] https://ci.mariadb.org/24064/amd64-ubuntu-2004-deb-autobake/debs ./' > /etc/apt/sources.list.d/mariadb.list
 
root@9b26cecb2505:/# apt-get update
 
..
 
root@9b26cecb2505:/# apt-get install ca-certificates
 
root@9b26cecb2505:/# apt-get install mariadb-server-10.6
 
Reading package lists... Done
 
Building dependency tree       
Reading state information... Done
 
The following additional packages will be installed:
 
  galera-4 gawk iproute2 libaio1 libatm1 libbsd0 libcap2 libcap2-bin libcgi-fast-perl libcgi-pm-perl libdbd-mariadb-perl libdbi-perl libelf1
 
  libencode-locale-perl libfcgi-perl libgdbm-compat4 libgdbm6 libhtml-parser-perl libhtml-tagset-perl libhtml-template-perl libhttp-date-perl
 
  libhttp-message-perl libio-html-perl liblwp-mediatypes-perl libmariadb3 libmnl0 libmpfr6 libmysqlclient21 libpam-cap libperl5.30 libpmem1 libpopt0 libreadline5
 
  libreadline8 libsigsegv2 libterm-readkey-perl libtimedate-perl liburi-perl libwrap0 libxtables12 lsof mariadb-client-10.6 mariadb-client-core-10.6
 
  mariadb-common mariadb-server-core-10.6 mysql-common netbase perl perl-modules-5.30 psmisc readline-common rsync socat
 
Suggested packages:
 
  gawk-doc iproute2-doc libclone-perl libmldbm-perl libnet-daemon-perl libsql-statement-perl gdbm-l10n libdata-dump-perl libipc-sharedcache-perl libwww-perl
 
  mailx mariadb-test netcat-openbsd perl-doc libterm-readline-gnu-perl | libterm-readline-perl-perl make libb-debug-perl liblocale-codes-perl readline-doc
 
  openssh-client openssh-server
 
The following NEW packages will be installed:
 
  galera-4 gawk iproute2 libaio1 libatm1 libbsd0 libcap2 libcap2-bin libcgi-fast-perl libcgi-pm-perl libdbd-mariadb-perl libdbi-perl libelf1
 
  libencode-locale-perl libfcgi-perl libgdbm-compat4 libgdbm6 libhtml-parser-perl libhtml-tagset-perl libhtml-template-perl libhttp-date-perl
 
  libhttp-message-perl libio-html-perl liblwp-mediatypes-perl libmariadb3 libmnl0 libmpfr6 libmysqlclient21 libpam-cap libperl5.30 libpmem1 libpopt0 libreadline5
 
  libreadline8 libsigsegv2 libterm-readkey-perl libtimedate-perl liburi-perl libwrap0 libxtables12 lsof mariadb-client-10.6 mariadb-client-core-10.6
 
  mariadb-common mariadb-server-10.6 mariadb-server-core-10.6 mysql-common netbase perl perl-modules-5.30 psmisc readline-common rsync socat
 
0 upgraded, 54 newly installed, 0 to remove and 0 not upgraded.
 
Need to get 27.7 MB of archives.
 
After this operation, 223 MB of additional disk space will be used.
 
Do you want to continue? [Y/n] y
 
....
 
Setting up mariadb-server-10.6 (1:10.6.8+maria~focal) ...

Nothing seemly obvious is the debian/control file changes.

I can't quite see the cause of the state. I'd expect more watchers on the bug if it occurred more frequently.

Comment by Otto Kekäläinen [ 2022-10-24 ]

I believe this is a duplicate of MDEV-28640. The root cause here is that due to previous uring issue the Salsa-CI step that upgrades MariaDB.org 10.6.N to 10.6.N+1 was ignored. Now I re-enabled it and this is clearly visible. Both this and MDEV-28640 are assigned to me, I will try to fix them.

This issue only affects MariaDB.org 10.6 package upgrades, not Debian MariaDB 10.6, which are fully green on Salsa-CI and had zero CI detectable bugs at the moment.

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