Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5035

debian package conflict libmariadbclient18 5.5.33+maria-1~wheezy vs. mariadb-server-5.3 5.3.12-mariadb122~wheezy

    Details

      Description

      The last upgrade to libmariadbclient18 (from 5.5.32 to 5.5.33) breaks compability with mariadb-server-5.3 package. The error message from dpkg and apt-get:

      Preparing to replace libmariadbclient18 5.5.32+maria-1~wheezy (using .../libmariadbclient18_5.5.33+maria-1~wheezy_amd64.deb) ...                                                                                   
      Unpacking replacement libmariadbclient18 ...                                                                                                                                                                       
      dpkg: error processing /var/cache/apt/archives/libmariadbclient18_5.5.33+maria-1~wheezy_amd64.deb (--unpack):                                                                                                      
       trying to overwrite '/usr/lib/mysql/plugin/dialog.so', which is also in package mariadb-server-5.3 5.3.12-mariadb122~wheezy                                                                                       
      Errors were encountered while processing:                                                                                                                                                                          
       /var/cache/apt/archives/libmariadbclient18_5.5.33+maria-1~wheezy_amd64.deb                     
      

      Workaround: keep libmariadbclient18 and libmysqlclient18 at version 5.5.32+maria-1~wheezy

        Gliffy Diagrams

          Activity

          Hide
          elenst Elena Stepanova added a comment -

          Hi Hubert,

          Could you please explain how you configured your apt-get so that you have 5.3 server and 5.5 client on the same machine? From all I see, an attempt to install 5.5 client over 5.3 server pulls the server upgrade to 5.5, and vice versa, an attempt to install 5.3 server over 5.5 client pulls the client downgrade (both of which might be a bug in itself, but it doesn't allow me to check whether our upcoming bugfix works for your configuration).

          Thanks.

          Show
          elenst Elena Stepanova added a comment - Hi Hubert, Could you please explain how you configured your apt-get so that you have 5.3 server and 5.5 client on the same machine? From all I see, an attempt to install 5.5 client over 5.3 server pulls the server upgrade to 5.5, and vice versa, an attempt to install 5.3 server over 5.5 client pulls the client downgrade (both of which might be a bug in itself, but it doesn't allow me to check whether our upcoming bugfix works for your configuration). Thanks.
          Hide
          joakimfors Joakim Fors added a comment - - edited

          I encountered a similar issue trying to install mariadb-galera-server on a fresh Debian Wheezy 7.1 machine:

          root@db03:~# apt-cache policy
          Package files:
          100 /var/lib/dpkg/status
          release a=now
          500 http://repo.varnish-cache.org/debian/ wheezy/varnish-3.0 amd64 Packages
          release v=,o=varnish-cache.org,a=wheezy,n=wheezy,c=varnish-3.0
          origin repo.varnish-cache.org
          500 http://ftp.ddg.lth.se/mariadb/repo/5.5/debian/ wheezy/main amd64 Packages
          release o=MariaDB,n=wheezy,l=MariaDB,c=main
          origin ftp.ddg.lth.se
          500 http://hwraid.le-vert.net/debian/ wheezy/main amd64 Packages
          release o=hwraid.le-vert.net,a=wheezy,l=hwraid.le-vert.net,c=main
          origin hwraid.le-vert.net
          500 http://ftp.se.debian.org/debian/ wheezy-updates/main Translation-en
          500 http://ftp.se.debian.org/debian/ wheezy-updates/main amd64 Packages
          release o=Debian,a=stable-updates,n=wheezy-updates,l=Debian,c=main
          origin ftp.se.debian.org
          500 http://security.debian.org/ wheezy/updates/main Translation-en
          500 http://security.debian.org/ wheezy/updates/main amd64 Packages
          release v=7.0,o=Debian,a=stable,n=wheezy,l=Debian-Security,c=main
          origin security.debian.org
          500 http://ftp.se.debian.org/debian/ wheezy/main Translation-en
          500 http://ftp.se.debian.org/debian/ wheezy/main amd64 Packages
          release v=7.1,o=Debian,a=stable,n=wheezy,l=Debian,c=main
          origin ftp.se.debian.org
          Pinned packages:
          root@db03:~#

          root@db03:~# apt-cache show mariadb-galera-server
          Package: mariadb-galera-server
          Source: mariadb-5.5
          Version: 5.5.32+maria-1~wheezy
          Architecture: all
          Maintainer: MariaDB Developers <maria-developers@lists.launchpad.net>
          Installed-Size: 27
          Depends: mariadb-galera-server-5.5 (= 5.5.32+maria-1~wheezy)
          Homepage: http://mariadb.org/
          Priority: misc
          Section: optional
          Filename: pool/main/m/mariadb-5.5/mariadb-galera-server_5.5.32+maria-1~wheezy_all.deb
          Size: 3006
          SHA256: ca909aa77f005a01763caee6c0c114c9019ff3a3c9aed7c74e146b454fc638ef
          SHA1: c25bb8f4c817ade72af99abcbdbf91664e45e702
          MD5sum: 35d0054e570e48cbb9e750728c587ab0
          Description: MariaDB database server with Galera cluster
          (metapackage depending on the latest version)
          This is an empty package that depends on the current "best" version of
          mariadb-galera-server (currently mariadb-galera-server-5.5), as determined by the MariaDB
          maintainers. Install this package if in doubt about which MariaDB-Galera
          version you need. That will install the version recommended by the
          package maintainers.
          .
          MariaDB is a fast, stable and true multi-user, multi-threaded SQL database
          server. SQL (Structured Query Language) is the most popular database query
          language in the world. The main goals of MariaDB are speed, robustness and
          ease of use.
          Original-Maintainer: Maria Developers <maria-developers@lists.launchpad.net>

          root@db03:~#

          root@db03:~# apt-get install mariadb-galera-server
          Reading package lists... Done
          Building dependency tree
          Reading state information... Done
          The following extra packages will be installed:
          libdbd-mysql-perl libmariadbclient18 libmysqlclient18 mariadb-client-5.5 mariadb-client-core-5.5 mariadb-common mariadb-galera-server-5.5 mysql-common
          Suggested packages:
          tinyca mariadb-test
          The following NEW packages will be installed:
          libdbd-mysql-perl libmariadbclient18 libmysqlclient18 mariadb-client-5.5 mariadb-client-core-5.5 mariadb-common mariadb-galera-server mariadb-galera-server-5.5
          mysql-common
          0 upgraded, 9 newly installed, 0 to remove and 0 not upgraded.
          Need to get 31.9 MB of archives.
          After this operation, 111 MB of additional disk space will be used.
          Do you want to continue [Y/n]? y
          Get:1 http://ftp.se.debian.org/debian/ wheezy/main libdbd-mysql-perl amd64 4.021-1+b1 [126 kB]
          Get:2 http://ftp.ddg.lth.se/mariadb/repo/5.5/debian/ wheezy/main mysql-common all 5.5.33+maria-1~wheezy [8,786 B]
          Get:3 http://ftp.ddg.lth.se/mariadb/repo/5.5/debian/ wheezy/main mariadb-common all 5.5.33+maria-1~wheezy [3,262 B]
          Get:4 http://ftp.ddg.lth.se/mariadb/repo/5.5/debian/ wheezy/main libmariadbclient18 amd64 5.5.33+maria-1~wheezy [845 kB]
          Get:5 http://ftp.ddg.lth.se/mariadb/repo/5.5/debian/ wheezy/main libmysqlclient18 amd64 5.5.33+maria-1~wheezy [2,922 B]
          Get:6 http://ftp.ddg.lth.se/mariadb/repo/5.5/debian/ wheezy/main mariadb-client-core-5.5 amd64 5.5.33+maria-1~wheezy [1,817 kB]
          Get:7 http://ftp.ddg.lth.se/mariadb/repo/5.5/debian/ wheezy/main mariadb-client-5.5 amd64 5.5.33+maria-1~wheezy [5,089 kB]
          Get:8 http://ftp.ddg.lth.se/mariadb/repo/5.5/debian/ wheezy/main mariadb-galera-server-5.5 amd64 5.5.32+maria-1~wheezy [24.0 MB]
          Get:9 http://ftp.ddg.lth.se/mariadb/repo/5.5/debian/ wheezy/main mariadb-galera-server all 5.5.32+maria-1~wheezy [3,006 B]
          Fetched 31.9 MB in 2min 13s (238 kB/s)
          Preconfiguring packages ...
          Selecting previously unselected package mysql-common.
          (Reading database ... 32428 files and directories currently installed.)
          Unpacking mysql-common (from .../mysql-common_5.5.33+maria-1~wheezy_all.deb) ...
          Selecting previously unselected package mariadb-common.
          Unpacking mariadb-common (from .../mariadb-common_5.5.33+maria-1~wheezy_all.deb) ...
          Selecting previously unselected package libmariadbclient18.
          Unpacking libmariadbclient18 (from .../libmariadbclient18_5.5.33+maria-1~wheezy_amd64.deb) ...
          Selecting previously unselected package libmysqlclient18.
          Unpacking libmysqlclient18 (from .../libmysqlclient18_5.5.33+maria-1~wheezy_amd64.deb) ...
          Selecting previously unselected package libdbd-mysql-perl.
          Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.021-1+b1_amd64.deb) ...
          Selecting previously unselected package mariadb-client-core-5.5.
          Unpacking mariadb-client-core-5.5 (from .../mariadb-client-core-5.5_5.5.33+maria-1~wheezy_amd64.deb) ...
          Selecting previously unselected package mariadb-client-5.5.
          Unpacking mariadb-client-5.5 (from .../mariadb-client-5.5_5.5.33+maria-1~wheezy_amd64.deb) ...
          Processing triggers for man-db ...
          Setting up mysql-common (5.5.33+maria-1~wheezy) ...
          Setting up mariadb-common (5.5.33+maria-1~wheezy) ...
          (Reading database ... 32529 files and directories currently installed.)
          Unpacking mariadb-galera-server-5.5 (from .../mariadb-galera-server-5.5_5.5.32+maria-1~wheezy_amd64.deb) ...
          dpkg: error processing /var/cache/apt/archives/mariadb-galera-server-5.5_5.5.32+maria-1~wheezy_amd64.deb (--unpack):
          trying to overwrite '/usr/lib/mysql/plugin/dialog.so', which is also in package libmariadbclient18 5.5.33+maria-1~wheezy
          Selecting previously unselected package mariadb-galera-server.
          Unpacking mariadb-galera-server (from .../mariadb-galera-server_5.5.32+maria-1~wheezy_all.deb) ...
          Processing triggers for man-db ...
          Errors were encountered while processing:
          /var/cache/apt/archives/mariadb-galera-server-5.5_5.5.32+maria-1~wheezy_amd64.deb
          E: Sub-process /usr/bin/dpkg returned an error code (1)
          root@db03:~#

          Show
          joakimfors Joakim Fors added a comment - - edited I encountered a similar issue trying to install mariadb-galera-server on a fresh Debian Wheezy 7.1 machine: root@db03:~# apt-cache policy Package files: 100 /var/lib/dpkg/status release a=now 500 http://repo.varnish-cache.org/debian/ wheezy/varnish-3.0 amd64 Packages release v=,o=varnish-cache.org,a=wheezy,n=wheezy,c=varnish-3.0 origin repo.varnish-cache.org 500 http://ftp.ddg.lth.se/mariadb/repo/5.5/debian/ wheezy/main amd64 Packages release o=MariaDB,n=wheezy,l=MariaDB,c=main origin ftp.ddg.lth.se 500 http://hwraid.le-vert.net/debian/ wheezy/main amd64 Packages release o=hwraid.le-vert.net,a=wheezy,l=hwraid.le-vert.net,c=main origin hwraid.le-vert.net 500 http://ftp.se.debian.org/debian/ wheezy-updates/main Translation-en 500 http://ftp.se.debian.org/debian/ wheezy-updates/main amd64 Packages release o=Debian,a=stable-updates,n=wheezy-updates,l=Debian,c=main origin ftp.se.debian.org 500 http://security.debian.org/ wheezy/updates/main Translation-en 500 http://security.debian.org/ wheezy/updates/main amd64 Packages release v=7.0,o=Debian,a=stable,n=wheezy,l=Debian-Security,c=main origin security.debian.org 500 http://ftp.se.debian.org/debian/ wheezy/main Translation-en 500 http://ftp.se.debian.org/debian/ wheezy/main amd64 Packages release v=7.1,o=Debian,a=stable,n=wheezy,l=Debian,c=main origin ftp.se.debian.org Pinned packages: root@db03:~# — root@db03:~# apt-cache show mariadb-galera-server Package: mariadb-galera-server Source: mariadb-5.5 Version: 5.5.32+maria-1~wheezy Architecture: all Maintainer: MariaDB Developers <maria-developers@lists.launchpad.net> Installed-Size: 27 Depends: mariadb-galera-server-5.5 (= 5.5.32+maria-1~wheezy) Homepage: http://mariadb.org/ Priority: misc Section: optional Filename: pool/main/m/mariadb-5.5/mariadb-galera-server_5.5.32+maria-1~wheezy_all.deb Size: 3006 SHA256: ca909aa77f005a01763caee6c0c114c9019ff3a3c9aed7c74e146b454fc638ef SHA1: c25bb8f4c817ade72af99abcbdbf91664e45e702 MD5sum: 35d0054e570e48cbb9e750728c587ab0 Description: MariaDB database server with Galera cluster (metapackage depending on the latest version) This is an empty package that depends on the current "best" version of mariadb-galera-server (currently mariadb-galera-server-5.5), as determined by the MariaDB maintainers. Install this package if in doubt about which MariaDB-Galera version you need. That will install the version recommended by the package maintainers. . MariaDB is a fast, stable and true multi-user, multi-threaded SQL database server. SQL (Structured Query Language) is the most popular database query language in the world. The main goals of MariaDB are speed, robustness and ease of use. Original-Maintainer: Maria Developers <maria-developers@lists.launchpad.net> root@db03:~# — root@db03:~# apt-get install mariadb-galera-server Reading package lists... Done Building dependency tree Reading state information... Done The following extra packages will be installed: libdbd-mysql-perl libmariadbclient18 libmysqlclient18 mariadb-client-5.5 mariadb-client-core-5.5 mariadb-common mariadb-galera-server-5.5 mysql-common Suggested packages: tinyca mariadb-test The following NEW packages will be installed: libdbd-mysql-perl libmariadbclient18 libmysqlclient18 mariadb-client-5.5 mariadb-client-core-5.5 mariadb-common mariadb-galera-server mariadb-galera-server-5.5 mysql-common 0 upgraded, 9 newly installed, 0 to remove and 0 not upgraded. Need to get 31.9 MB of archives. After this operation, 111 MB of additional disk space will be used. Do you want to continue [Y/n] ? y Get:1 http://ftp.se.debian.org/debian/ wheezy/main libdbd-mysql-perl amd64 4.021-1+b1 [126 kB] Get:2 http://ftp.ddg.lth.se/mariadb/repo/5.5/debian/ wheezy/main mysql-common all 5.5.33+maria-1~wheezy [8,786 B] Get:3 http://ftp.ddg.lth.se/mariadb/repo/5.5/debian/ wheezy/main mariadb-common all 5.5.33+maria-1~wheezy [3,262 B] Get:4 http://ftp.ddg.lth.se/mariadb/repo/5.5/debian/ wheezy/main libmariadbclient18 amd64 5.5.33+maria-1~wheezy [845 kB] Get:5 http://ftp.ddg.lth.se/mariadb/repo/5.5/debian/ wheezy/main libmysqlclient18 amd64 5.5.33+maria-1~wheezy [2,922 B] Get:6 http://ftp.ddg.lth.se/mariadb/repo/5.5/debian/ wheezy/main mariadb-client-core-5.5 amd64 5.5.33+maria-1~wheezy [1,817 kB] Get:7 http://ftp.ddg.lth.se/mariadb/repo/5.5/debian/ wheezy/main mariadb-client-5.5 amd64 5.5.33+maria-1~wheezy [5,089 kB] Get:8 http://ftp.ddg.lth.se/mariadb/repo/5.5/debian/ wheezy/main mariadb-galera-server-5.5 amd64 5.5.32+maria-1~wheezy [24.0 MB] Get:9 http://ftp.ddg.lth.se/mariadb/repo/5.5/debian/ wheezy/main mariadb-galera-server all 5.5.32+maria-1~wheezy [3,006 B] Fetched 31.9 MB in 2min 13s (238 kB/s) Preconfiguring packages ... Selecting previously unselected package mysql-common. (Reading database ... 32428 files and directories currently installed.) Unpacking mysql-common (from .../mysql-common_5.5.33+maria-1~wheezy_all.deb) ... Selecting previously unselected package mariadb-common. Unpacking mariadb-common (from .../mariadb-common_5.5.33+maria-1~wheezy_all.deb) ... Selecting previously unselected package libmariadbclient18. Unpacking libmariadbclient18 (from .../libmariadbclient18_5.5.33+maria-1~wheezy_amd64.deb) ... Selecting previously unselected package libmysqlclient18. Unpacking libmysqlclient18 (from .../libmysqlclient18_5.5.33+maria-1~wheezy_amd64.deb) ... Selecting previously unselected package libdbd-mysql-perl. Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.021-1+b1_amd64.deb) ... Selecting previously unselected package mariadb-client-core-5.5. Unpacking mariadb-client-core-5.5 (from .../mariadb-client-core-5.5_5.5.33+maria-1~wheezy_amd64.deb) ... Selecting previously unselected package mariadb-client-5.5. Unpacking mariadb-client-5.5 (from .../mariadb-client-5.5_5.5.33+maria-1~wheezy_amd64.deb) ... Processing triggers for man-db ... Setting up mysql-common (5.5.33+maria-1~wheezy) ... Setting up mariadb-common (5.5.33+maria-1~wheezy) ... (Reading database ... 32529 files and directories currently installed.) Unpacking mariadb-galera-server-5.5 (from .../mariadb-galera-server-5.5_5.5.32+maria-1~wheezy_amd64.deb) ... dpkg: error processing /var/cache/apt/archives/mariadb-galera-server-5.5_5.5.32+maria-1~wheezy_amd64.deb (--unpack): trying to overwrite '/usr/lib/mysql/plugin/dialog.so', which is also in package libmariadbclient18 5.5.33+maria-1~wheezy Selecting previously unselected package mariadb-galera-server. Unpacking mariadb-galera-server (from .../mariadb-galera-server_5.5.32+maria-1~wheezy_all.deb) ... Processing triggers for man-db ... Errors were encountered while processing: /var/cache/apt/archives/mariadb-galera-server-5.5_5.5.32+maria-1~wheezy_amd64.deb E: Sub-process /usr/bin/dpkg returned an error code (1) root@db03:~#
          Hide
          hukrause Hubert Krause added a comment -

          Hello Elena,

          like I stated in my Environment comment. I use both repos in my sources list:

          deb http://mirror2.hs-esslingen.de/mariadb/repo/5.3/debian wheezy main
          deb http://mirror2.hs-esslingen.de/mariadb/repo/5.5/debian wheezy main

          and installed the package mariadb-server-5.3 and mariadb-client-5.3. I never installed mariadb-client-5.5. libmariadbclient18 will be required by libmysqlclient18 which itself will be required by ruby-mysql, libdbd-mysql, php5-mysql, phython-mysqldb to name a few. This librarys again will be required by some tools around mysql, mysqltuner, percona-toolkit...

          If you use libmysqlclient18 only from debianrepo, mariadb-common gets a conflict / is missing and you can not install mariadb-server-5.3. This dependency is the reason why I need libmariadbclient18 from the 5.5 suite.

          Best regards,

          Hubert

          Show
          hukrause Hubert Krause added a comment - Hello Elena, like I stated in my Environment comment. I use both repos in my sources list: deb http://mirror2.hs-esslingen.de/mariadb/repo/5.3/debian wheezy main deb http://mirror2.hs-esslingen.de/mariadb/repo/5.5/debian wheezy main and installed the package mariadb-server-5.3 and mariadb-client-5.3. I never installed mariadb-client-5.5. libmariadbclient18 will be required by libmysqlclient18 which itself will be required by ruby-mysql, libdbd-mysql, php5-mysql, phython-mysqldb to name a few. This librarys again will be required by some tools around mysql, mysqltuner, percona-toolkit... If you use libmysqlclient18 only from debianrepo, mariadb-common gets a conflict / is missing and you can not install mariadb-server-5.3. This dependency is the reason why I need libmariadbclient18 from the 5.5 suite. Best regards, Hubert
          Hide
          elenst Elena Stepanova added a comment -

          Hi Hubert,

          I see, thanks. I've checked that the upcoming fix works for your configuration as well. Although, it appears that your libmariadbclient18 will stick to 5.5.32 till you upgrade your server to 5.5.

          Just for our understanding of version dynamics, is there any particular reason why you choose to stay on 5.3 and not to upgrade to 5.5?

          I presume you have already figured the broken dependencies after the faulty upgrade? If not, you can rollback the library to 5.5.32 version using the 5.5.32 repo, and after that return to the current repo (after it is upgraded to 5.5.33a release).

          Sorry for the inconvenience.

          Show
          elenst Elena Stepanova added a comment - Hi Hubert, I see, thanks. I've checked that the upcoming fix works for your configuration as well. Although, it appears that your libmariadbclient18 will stick to 5.5.32 till you upgrade your server to 5.5. Just for our understanding of version dynamics, is there any particular reason why you choose to stay on 5.3 and not to upgrade to 5.5? I presume you have already figured the broken dependencies after the faulty upgrade? If not, you can rollback the library to 5.5.32 version using the 5.5.32 repo, and after that return to the current repo (after it is upgraded to 5.5.33a release). Sorry for the inconvenience.
          Hide
          hukrause Hubert Krause added a comment -

          Hello Elena,

          we stick to 5.3 because our application was only testet to this version. We try hard to test our application against 5.5, but are not ready yet.

          Thank you for the effort,

          Hubert

          Show
          hukrause Hubert Krause added a comment - Hello Elena, we stick to 5.3 because our application was only testet to this version. We try hard to test our application against 5.5, but are not ready yet. Thank you for the effort, Hubert

            People

            • Assignee:
              serg Sergei Golubchik
              Reporter:
              hukrause Hubert Krause
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: