[MDEV-14384] MariaDB client cannot be installed over MySQL on Debian ppc64le trusty Created: 2017-11-13  Updated: 2022-04-04  Resolved: 2022-04-04

Status: Closed
Project: MariaDB Server
Component/s: Packaging, Platform Debian, Platform Power
Affects Version/s: 10.0, 10.1, 10.2
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Incomplete Votes: 0
Labels: None

Issue Links:
Blocks
blocks MDEV-14386 Remove workaround for MDEV-14384 from... Closed
Relates
relates to MDEV-14369 [5.5, 10.1] MariaDB server cannot be ... Open
Sub-Tasks:
Key
 Summary
 Type
 Status
 Assignee
MDEV-14386 Remove workaround for MDEV-14384 from... Technical task Closed Elena Stepanova  

 Description   

Initial installation

 
$ dpkg -l | grep -iE 'mysql|maria'
 
ii  libdbd-mysql-perl                  4.025-1ubuntu0.1                  ppc64el      Perl5 database interface to the MySQL database
 
ii  libmysqlclient18:ppc64el           5.5.54-0ubuntu0.14.04.1           ppc64el      MySQL database client library
 
ii  mysql-client-5.5                   5.5.54-0ubuntu0.14.04.1           ppc64el      MySQL database client binaries
 
ii  mysql-client-core-5.5              5.5.54-0ubuntu0.14.04.1           ppc64el      MySQL database core client binaries
 
ii  mysql-common                       5.5.54-0ubuntu0.14.04.1           all          MySQL database common files, e.g. /etc/mysql/my.cnf
 
ii  mysql-server                       5.5.54-0ubuntu0.14.04.1           all          MySQL database server (metapackage depending on the latest version)
 
ii  mysql-server-5.5                   5.5.54-0ubuntu0.14.04.1           ppc64el      MySQL database server binaries and system database setup
 
ii  mysql-server-core-5.5              5.5.54-0ubuntu0.14.04.1           ppc64el      MySQL database server binaries


$ sudo apt-get install mariadb-client
 
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-client : Depends: mariadb-client-10.2 (>= 10.2.11+maria~trusty) but it is not going to be installed
 
E: Unable to correct problems, you have held broken packages.

This does not work either:

$ sudo apt-get install mariadb-server mariadb-client  
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-client : Depends: mariadb-client-10.2 (>= 10.2.11+maria~trusty) but it is not going to be installed
 
 mariadb-server : Depends: mariadb-server-10.2 (>= 10.2.11+maria~trusty) but it is not going to be installed
 
E: Unable to correct problems, you have held broken packages.

Same for mariadb-test, possibly there are some other packages.

mariadb-client-10.2 works:

$ sudo apt-get install mariadb-client-10.2
 
Reading package lists... Done
 
Building dependency tree       
Reading state information... Done
 
The following extra packages will be installed:
 
  libreadline5 mariadb-client-core-10.2 mariadb-common mysql-common
 
The following packages will be REMOVED:
 
  mysql-client-5.5 mysql-client-core-5.5 mysql-server mysql-server-5.5
 
  mysql-server-core-5.5
 
The following NEW packages will be installed:
 
  libreadline5 mariadb-client-10.2 mariadb-client-core-10.2 mariadb-common
 
The following packages will be upgraded:
 
  mysql-common
 
1 upgraded, 4 newly installed, 5 to remove and 76 not upgraded.
 
Need to get 91.6 kB/1,858 kB of archives.
 
After this operation, 60.7 MB disk space will be freed.
 
Do you want to continue? [Y/n]

There is a similar issue with mariadb-server on 5.5-10.1 (MDEV-14369), but the client problem happens on 10.2, the latest GA, which makes it more important.

Summary for trusty-ppc64le

  5.5 10.0 10.1 10.2
mariadb-server
mariadb-client
mariadb-test
libmariadbclient18
mariadb-server mariadb-client
mariadb-server + mariadb-test
mariadb-server + libmariadbclient18
mariadb-server + libmariadbclient18 + mariadb-client
mariadb-server + libmariadbclient18 + mariadb-test
mariadb-server + mariadb-client + mariadb-test
mariadb-server + libmariadbclient18 + mariadb-client + mariadb-test

On jessie-ppc64le it seems to work all right.

Summary for jessie-ppc64le

  5.5 10.0 10.1 10.2
mariadb-server
mariadb-client
mariadb-test
libmariadbclient18
mariadb-server + mariadb-client
mariadb-server + mariadb-test
mariadb-server + libmariadbclient18
mariadb-server + libmariadbclient18 + mariadb-client
mariadb-server + libmariadbclient18 + mariadb-test
mariadb-server + mariadb-client + mariadb-test
mariadb-server + libmariadbclient18 + mariadb-client + mariadb-test


 Comments   
Comment by Tuukka Pasanen [ 2022-03-21 ]

Is this still a problem?

Comment by Faustin Lammler [ 2022-03-23 ]

I tried to reproduce this with:

❯ ssh mdborg@bb-ppc.mariadb.org
 
$ docker run -it ubuntu:14.04 bash -c "export DEBIAN_FRONTEND=noninteractive && apt-get update && apt-get install -y mysql-client-5.5 mysql-server-5.5 mysql-server && dpkg -l | grep -iE 'mysql|maria' && echo \"deb https://mirror1.hs-esslingen.de/pub/Mirrors/mariadb/repo/10.2/ubuntu trusty main\" >>/etc/apt/sources.list && apt-get -y install curl apt-transport-https && curl -ko /etc/apt/trusted.gpg.d/mariadb_release_signing_key.asc https://mariadb.org/mariadb_release_signing_key.asc && apt-get update && apt-get install -y --force-yes mariadb-client"
 
...
 
ii  libdbd-mysql-perl               4.025-1ubuntu0.1                           ppc64el      Perl5 database interface to the MySQL database
 
ii  libmysqlclient18:ppc64el        5.5.62-0ubuntu0.14.04.1                    ppc64el      MySQL database client library
 
ii  mysql-client-5.5                5.5.62-0ubuntu0.14.04.1                    ppc64el      MySQL database client binaries
 
ii  mysql-client-core-5.5           5.5.62-0ubuntu0.14.04.1                    ppc64el      MySQL database core client binaries
 
ii  mysql-common                    5.5.62-0ubuntu0.14.04.1                    all          MySQL database common files, e.g. /etc/mysql/my.cnf
 
ii  mysql-server                    5.5.62-0ubuntu0.14.04.1                    all          MySQL database server (metapackage depending on the latest version)
 
ii  mysql-server-5.5                5.5.62-0ubuntu0.14.04.1                    ppc64el      MySQL database server binaries and system database setup
 
ii  mysql-server-core-5.5           5.5.62-0ubuntu0.14.04.1                    ppc64el      MySQL database server binaries
 
...
 
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-client : Depends: mariadb-client-10.2 (>= 10.2.23+maria~trusty) but it is not going to be installed
 
E: Unable to correct problems, you have held broken packages.

Note that you have to use --force-yes in order to skip the package authentication problem:

WARNING: The following packages cannot be authenticated!
 
  mariadb-common galera-3 mariadb-client-core-10.2 mariadb-client-10.2
 
  mariadb-server-core-10.2 mariadb-server-10.2 mariadb-client mariadb-server
 
E: There are problems and -y was used without --force-yes

The following seems to work though:

$ docker run -it ubuntu:14.04 bash -c "export DEBIAN_FRONTEND=noninteractive && apt-get update && apt-get install -y mysql-client-5.5 mysql-server-5.5 mysql-server && dpkg -l | grep -iE 'mysql|maria' && echo \"deb https://mirror1.hs-esslingen.de/pub/Mirrors/mariadb/repo/10.2/ubuntu trusty main\" >>/etc/apt/sources.list && apt-get -y install curl apt-transport-https && curl -ko /etc/apt/trusted.gpg.d/mariadb_release_signing_key.asc https://mariadb.org/mariadb_release_signing_key.asc && apt-get update && apt-get install -y --force-yes mariadb-client-10.2 && dpkg -l | grep -iE 'mysql|maria'"
 
...
 
ii  libdbd-mysql-perl               4.025-1ubuntu0.1                           ppc64el      Perl5 database interface to the MySQL database
 
ii  libmysqlclient18:ppc64el        5.5.62-0ubuntu0.14.04.1                    ppc64el      MySQL database client library
 
ii  mariadb-client-10.2             10.2.23+maria~trusty                       ppc64el      MariaDB database client binaries
 
ii  mariadb-client-core-10.2        10.2.23+maria~trusty                       ppc64el      MariaDB database core client binaries
 
ii  mariadb-common                  10.2.23+maria~trusty                       all          MariaDB database common files (e.g. /etc/mysql/conf.d/mariadb.cnf)
 
ii  mysql-common                    5.5.62-0ubuntu0.14.04.1                    all          MySQL database common files, e.g. /etc/mysql/my.cnf
 
rc  mysql-server-5.5                5.5.62-0ubuntu0.14.04.1                    ppc64el      MySQL database server binaries and system database setup

and also:

$ docker run -it ubuntu:14.04 bash -c "export DEBIAN_FRONTEND=noninteractive && apt-get update && apt-get install -y mysql-client-5.5 mysql-server-5.5 mysql-server && dpkg -l | grep -iE 'mysql|maria' && echo \"deb https://mirror1.hs-esslingen.de/pub/Mirrors/mariadb/repo/10.2/ubuntu trusty main\" >>/etc/apt/sources.list && apt-get -y install curl apt-transport-https && curl -ko /etc/apt/trusted.gpg.d/mariadb_release_signing_key.asc https://mariadb.org/mariadb_release_signing_key.asc && apt-get update && apt-get install -y --force-yes mariadb-client mariadb-server && dpkg -l | grep -iE 'mysql|maria'"
 
...
 
ii  libdbd-mysql-perl                 4.025-1ubuntu0.1                           ppc64el      Perl5 database interface to the MySQL database
 
ii  libmysqlclient18:ppc64el          5.5.62-0ubuntu0.14.04.1                    ppc64el      MySQL database client library
 
ii  mariadb-client                    10.2.23+maria~trusty                       all          MariaDB database client (metapackage depending on the latest version)
 
ii  mariadb-client-10.2               10.2.23+maria~trusty                       ppc64el      MariaDB database client binaries
 
ii  mariadb-client-core-10.2          10.2.23+maria~trusty                       ppc64el      MariaDB database core client binaries
 
ii  mariadb-common                    10.2.23+maria~trusty                       all          MariaDB database common files (e.g. /etc/mysql/conf.d/mariadb.cnf)
 
ii  mariadb-server                    10.2.23+maria~trusty                       all          MariaDB database server (metapackage depending on the latest version)
 
ii  mariadb-server-10.2               10.2.23+maria~trusty                       ppc64el      MariaDB database server binaries
 
ii  mariadb-server-core-10.2          10.2.23+maria~trusty                       ppc64el      MariaDB database core server files
 
ii  mysql-common                      5.5.62-0ubuntu0.14.04.1                    all          MySQL database common files, e.g. /etc/mysql/my.cnf
 
rc  mysql-server-5.5                  5.5.62-0ubuntu0.14.04.1                    ppc64el      MySQL database server binaries and system database setup

Anyway, given the age of Ubuntu 14.04, I think this is really low priority (if it is that we should fix it). Also, please note that not all mirror will work (for instance, https://deb.mariadb.org will not work with Ubuntu 14.04 as the new LE certificate is not supported on this distribution).

Comment by Faustin Lammler [ 2022-03-23 ]

See https://mariadb.com/kb/en/deprecation-policy/:

  • Ubuntu Trusty was deprecated April 2019
  • Debian Jessie was deprecated June 2020

I believe that this can be closed but leaving it to elenst

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