MariaDB Development
  1. MariaDB Development
  2. MDEV-5035

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

    Details

    • Global Rank:
      3631

      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

        Activity

        Hide
        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
        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
        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
        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
        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
        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
        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
        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
        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
        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:
            Sergei Golubchik
            Reporter:
            Hubert Krause
          • Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: