akonadi-server package is incompatible with percona-server package

[Petr Burian]

When installing mysql-server-5.1.42 on Karmic Koala it conflicts with mysql-server-core-5.1:

Unpacking mysql-server-5.1 (from mysql-server-5.1_5.1.42-xtradb-1.0.6-9-50.5.0.3.8_amd64.deb) ...
dpkg: error processing mysql-server-5.1_5.1.42-xtradb-1.0.6-9-50.5.0.3.8_amd64.deb (--install):
 trying to overwrite '/usr/share/mysql/portuguese/errmsg.sys', which is also in package mysql-server-core-5.1 0:5.1.37-1ubuntu5.1

Using Karmic Kubuntu. Mysql-server-core is required for akonadi-server.

[Petr Burian (kruxik)]

Still same problem even with new Karmic Percona repositary (Percona Server version 10).

The following packages have unmet dependencies:
  percona-xtradb-server-5.1: Depends: percona-xtradb-client-5.1 (>= 5.1.45-xtradb-1.0.6-10-80.karmic.25) but it is not going to be installed
                             Depends: libpercona-xtradb-client16 but it is not going to be installed
                             PreDepends: percona-xtradb-common (>= 5.1.45-xtradb-1.0.6-10-80.karmic.25) but it is not going to be installed

If I try to install percona-xtradb-common. It tries to remove almost all KDE installation.

[Aleksandr Kuzminsky (akuzminsky)]

Petr,

This problem is similar to Bug #539190, I think it will be fixed in one of sequential builds of XtraDB 10

[Petr Burian (kruxik)]

Aleksandr,

thank you for explanation. Looking forward to a new release.

[Aleksandr Kuzminsky (akuzminsky)]

Petr,

Could you please show output of
apt-cache depends akonadi-server ?
By the way, check if the problem mentioned in #1 still exists. But before don't forget "apt-get update"

[Petr Burian (kruxik)]

Aleksandr,

there is a depend list of akonadi-server (sorry for very delayed reply):

root@kruxik:/home/krux # apt-cache depends akonadi-server
akonadi-server
  Depends: libakonadiprivate1
  Depends: libboost-program-options1.40.0
  Depends: libc6
  Depends: libgcc1
  Depends: libqt4-dbus
  Depends: libqtcore4
  Depends: libstdc++6
  Depends: libwrap0
  Depends: zlib1g
  Depends: mysql-server-core-5.1
  Depends: mysql-client-core-5.1
  Depends: libqt4-sql-mysql

[Stewart Smith (stewart)]

All development of XtraDB has moved under the Percona Server project - https://launchpad.net/percona-server - If this bug can be reproduced against current Percona Server, please file this bug against percona-server (you can simply do so by using the "Also affects project" link above).

Thanks,
Stewart Smith
Director of Server Development
Percona.

[c.h. (wryfi)]

This is still a problem with the latest versions of percona-server-5.1 packages and ubuntu-oneiric.

It is currently impossible to install the latest kde (4.8.2) and percona-server-5.1 on the same ubuntu machine.

[c.h. (wryfi)]

At the very least, percona-server packages should be marked as conflicting with mysql-server-core, to at least prevent the package manager from trying to do something that is guaranteed to produce an error.

[c.h. (wryfi)]

The title of this bug should probably be "akonadi-server package is incompatible with percona-server package".

[c.h. (wryfi)]

See http://ubuntuforums.org/showthread.php?p=11852020 for a potential packaging solution.

[Raghavendra D Prabhu (raghavendra-prabhu)]

dpkg -l | grep -iE 'percona|mysql'
        ii libdbd-mysql-perl 4.020-1build2 Perl5 database interface to the MySQL database
        ii libmysqlclient16 5.1.65-rel14.0-475.precise Percona Server database client library
        ii libmysqlclient16-dev 5.1.65-rel14.0-475.precise Percona Server database development files
        ii libmysqlclient18 5.5.27-rel28.1-296.precise Percona Server database client library
        ii percona-server-client 5.5.27-rel28.1-296.squeeze Percona Server database client
        ii percona-server-client-5.5 5.5.27-rel28.1-296.precise Percona Server database client binaries
        ii percona-server-common-5.5 5.5.27-rel28.1-296.precise Percona Server database common files (e.g. /etc/mysql/my.cnf)
        ii percona-server-server-5.5 5.5.27-rel28.1-296.precise Percona Server database server binaries
        ii percona-server-test-5.5 5.5.27-rel28.1-296.precise Percona Server database test suite
        ii percona-toolkit 2.1.3 Advanced MySQL and system command-line tools
        ii percona-xtrabackup 2.0.2-461.precise Open source backup tool for InnoDB and XtraDB
        ii percona-xtrabackup-test 2.0.2-461.precise Test suite for Percona XtraBackup

Got this while installing akonadi-server: http://sprunge.us/MPgW

Specifically,

    Unpacking mysql-client-core-5.5 (from .../mysql-client-core-5.5_5.5.24-0ubuntu0.12.04.1_amd64.deb) ...
    dpkg: error processing /var/cache/apt/archives/mysql-client-core-5.5_5.5.24-0ubuntu0.12.04.1_amd64.deb (--unpack):
    trying to overwrite '/usr/bin/mysql', which is also in package percona-server-client-5.5 5.5.27-rel28.1-296.precise
    dpkg-deb: error: subprocess paste was killed by signal (Broken pipe)

    Unpacking mysql-server-core-5.5 (from .../mysql-server-core-5.5_5.5.24-0ubuntu0.12.04.1_amd64.deb) ...
    dpkg: error processing /var/cache/apt/archives/mysql-server-core-5.5_5.5.24-0ubuntu0.12.04.1_amd64.deb (--unpack):
    trying to overwrite '/usr/sbin/mysqld', which is also in package percona-server-server-5.5 5.5.27-rel28.1-296.precise
    dpkg-deb: error: subprocess paste was killed by signal (Broken pipe)

Now,
    dpkg -s percona-server-server-5.5 | grep Provides
    Provides: mysql-server

Since percona-server-server provides files provided by mysql-server-core, it is better to add that to Provides as well, same with percona-server-client.