[MDEV-11887] Mariadb DB 10.0.28 to 10.0.29 failed. Created: 2017-01-23  Updated: 2017-01-25  Resolved: 2017-01-25

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

Type: Bug Priority: Critical
Reporter: Hugo Assignee: Otto Kekäläinen
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

Debian jessie 8.7


 Description   

Hello,

when upgrading to the new mariadb 10.0.0.29 we get an error for failed dependency (sorry this in in French) :

Lecture des listes de paquets... Fait
 
Construction de l'arbre des dépendances
 
Lecture des informations d'état... Fait
 
Calcul de la mise à jour... Fait
 
Les paquets suivants seront mis à jour :
 
  galera-3 libmariadbclient18 libmysqlclient18 mariadb-client-10.0 mariadb-client-core-10.0 mariadb-common mariadb-galera-server mariadb-galera-server-10.0 mysql-common
 
9 mis à jour, 0 nouvellement installés, 0 à enlever et 0 non mis à jour.
 
Il est nécessaire de prendre 0 o/19,7 Mo dans les archives.
 
Après cette opération, 521 ko d'espace disque seront libérés.
 
Souhaitez-vous continuer ? [O/n] oui
 
Préconfiguration des paquets...
 
(Lecture de la base de données... 34213 fichiers et répertoires déjà installés.)
 
Préparation du dépaquetage de .../mariadb-galera-server_10.0.29+maria-1~jessie_all.deb ...
 
Dépaquetage de mariadb-galera-server (10.0.29+maria-1~jessie) sur (10.0.28+maria-1~jessie) ...
 
Préparation du dépaquetage de .../libmariadbclient18_10.0.29+maria-1~jessie_amd64.deb ...
 
Dépaquetage de libmariadbclient18 (10.0.29+maria-1~jessie) sur (10.0.28+maria-1~jessie) ...
 
Préparation du dépaquetage de .../libmysqlclient18_10.0.29+maria-1~jessie_amd64.deb ...
 
Dépaquetage de libmysqlclient18 (10.0.29+maria-1~jessie) sur (10.0.28+maria-1~jessie) ...
 
Préparation du dépaquetage de .../mysql-common_10.0.29+maria-1~jessie_all.deb ...
 
Dépaquetage de mysql-common (10.0.29+maria-1~jessie) sur (10.0.28+maria-1~jessie) ...
 
Préparation du dépaquetage de .../mariadb-common_10.0.29+maria-1~jessie_all.deb ...
 
Dépaquetage de mariadb-common (10.0.29+maria-1~jessie) sur (10.0.29-0+deb8u1) ...
 
dpkg: concernant .../mariadb-client-core-10.0_10.0.29+maria-1~jessie_amd64.deb contenant mariadb-client-core-10.0Â :
 
 mariadb-client-10.0 entre en conflit avec mysql-client-core-5.5
 
  mariadb-client-core-10.0 fournit mysql-client-core-5.5 et doit être installé.
 
 
 
dpkg: erreur de traitement de l'archive /var/cache/apt/archives/mariadb-client-core-10.0_10.0.29+maria-1~jessie_amd64.deb (--unpack)Â :
 
 paquets en conflit - mariadb-client-core-10.0 non installé
 
dpkg: concernant .../mariadb-client-10.0_10.0.29+maria-1~jessie_amd64.deb contenant mariadb-client-10.0Â :
 
 mariadb-client-core-10.0 entre en conflit avec mysql-client-5.5
 
  mariadb-client-10.0 fournit mysql-client-5.5 et doit être installé.
 
 
 
dpkg: erreur de traitement de l'archive /var/cache/apt/archives/mariadb-client-10.0_10.0.29+maria-1~jessie_amd64.deb (--unpack)Â :
 
 paquets en conflit - mariadb-client-10.0 non installé
 
Préparation du dépaquetage de .../galera-3_25.3.19-jessie_amd64.deb ...
 
Dépaquetage de galera-3 (25.3.19-jessie) sur (25.3.18-jessie) ...
 
Des erreurs ont été rencontrées pendant l'exécution :
 
 /var/cache/apt/archives/mariadb-client-core-10.0_10.0.29+maria-1~jessie_amd64.deb
 
 /var/cache/apt/archives/mariadb-client-10.0_10.0.29+maria-1~jessie_amd64.deb
 
E: Sub-process /usr/bin/dpkg returned an error code (1)

before apt dist-upgrade command 

# dpkg -l | grep -iP '(maria|mysql)'
 
ii  libdbd-mysql-perl              4.028-2+deb8u2              amd64        Perl5 database interface to the MySQL database
 
ii  libmariadbclient18             10.0.28+maria-1~jessie      amd64        MariaDB database client library
 
ii  libmysqlclient18               10.0.28+maria-1~jessie      amd64        Virtual package to satisfy external depends
 
ii  mariadb-client-10.0            10.0.29-0+deb8u1            amd64        MariaDB database client binaries
 
ii  mariadb-client-core-10.0       10.0.29-0+deb8u1            amd64        MariaDB database core client binaries
 
ii  mariadb-common                 10.0.29-0+deb8u1            all          MariaDB common metapackage
 
ii  mariadb-galera-server          10.0.28+maria-1~jessie      all          MariaDB database server with Galera cluster (metapackage depending on the latest version)
 
ii  mariadb-galera-server-10.0     10.0.28+maria-1~jessie      amd64        MariaDB database server with Galera cluster binaries
 
ii  mysql-common                   10.0.28+maria-1~jessie      all          MariaDB database common files (e.g. /etc/mysql/my.cnf)

after the command here is the status of the packages :

# dpkg -l | grep -iP '(maria|mysql)'
 
ii  libdbd-mysql-perl              4.028-2+deb8u2              amd64        Perl5 database interface to the MySQL database
 
iU  libmariadbclient18             10.0.29+maria-1~jessie      amd64        MariaDB database client library
 
iU  libmysqlclient18               10.0.29+maria-1~jessie      amd64        Virtual package to satisfy external depends
 
ii  mariadb-client-10.0            10.0.29-0+deb8u1            amd64        MariaDB database client binaries
 
ii  mariadb-client-core-10.0       10.0.29-0+deb8u1            amd64        MariaDB database core client binaries
 
iU  mariadb-common                 10.0.29+maria-1~jessie      all          MariaDB database common files (e.g. /etc/mysql/conf.d/mariadb.cnf)
 
iU  mariadb-galera-server          10.0.29+maria-1~jessie      all          MariaDB database server with Galera cluster (metapackage depending on the latest version)
 
ii  mariadb-galera-server-10.0     10.0.28+maria-1~jessie      amd64        MariaDB database server with Galera cluster binaries
 
iU  mysql-common                   10.0.29+maria-1~jessie      all          MariaDB database common files (e.g. /etc/mysql/my.cnf)

We have been upgrading for one year now without any issue.
If you need more information fee free to ask.

 Comments   
Comment by Elena Stepanova [ 2017-01-23 ]

There seems to be a mix of deb8u1 packages (provided by Debian) and maria-1~jessie (provided by MariaDB). The problem was apparently caused by mariadb-client-10.0 and mariadb-client-core-10.0, both of which come from the Debian repository, thus re-assigning to otto to take a look – maybe there is some wrong dependency in there?

Our installation/upgrade tests for 10.0.29 release on Jessie x86-64 passed without a trouble, both for the vanilla server and Galera, but they only install maria-1~jessie packages.

Comment by Otto Kekäläinen [ 2017-01-23 ]

Please don't mix packages from official Debian/Ubuntu repositories with MariaDB.org repositories. If you want to use MariaDB.org repositories (e.g. because there is a newer version available than what the distro offers), please read up on apt pinning to make sure you never accidentally install any MariaDB package from the distro repos.

Comment by Hugo [ 2017-01-24 ]

Thank you for your time.
Indeed, this is a pinning issue, I didn't see we had something wrong in our setup.
now all packages are from MariaDB.org

thank you !

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