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.

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:~#

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

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.

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