[MDEV-519] mariadb-client-5.5 conflicts with package mytop Created: 2012-09-10  Updated: 2013-05-03  Resolved: 2012-10-08

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.27
Fix Version/s: 5.5.28

Type: Bug Priority: Critical
Reporter: Kristian Nielsen Assignee: Kristian Nielsen
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MDEV-668 LP:1047337 - Ubuntu mariadb-client-5.... Closed
Relates
relates to MDEV-3952 Incompatible change in MariaDB-5.5.28... Closed
relates to MDEV-4476 mytop tracker Closed

 Description   

Recently in MDEV-286, the mytop program was added to mariadb-client-5.5 .deb.

But this is a problem - because there is already a standalone debian/ubuntu mytop package. So now install/upgrade of mariadb-client-5.5 conflicts if mytop is already installed.

I do not think there is a pressing need to deliver an alternative to mytop on .deb platforms, so I suggest just removing mytop again from .deb.

However, if we really want to provide an alternative .deb for mytop, then we

  • need to put it in a separate package, with proper /usr/share/doc/mytop/* and so on
  • need to create correct dependencies so upgrades will go smooth
  • need to check existing mytop package - there are a number of patches included, and we need to review them and include relevant ones so users do not loose important functionality in the upgrade

 Comments   
Comment by Jean Weisbuch [ 2012-09-12 ]

Here is the error that is produced during the apt-get/dpkg operation :
--------
Preparing to replace mariadb-client-5.5 5.5.25-mariadb1~squeeze (using .../mariadb-client-5.5_5.5.27-mariadb1~squeeze_i386.deb) ...
Unpacking replacement mariadb-client-5.5 ...
dpkg: error processing /var/cache/apt/archives/mariadb-client-5.5_5.5.27-mariadb1~squeeze_i386.deb (--unpack):
trying to overwrite '/usr/bin/mytop', which is also in package mytop 1.6-6
configured to not write apport reports
dpkg-deb: subprocess paste killed by signal (Broken pipe)
Processing triggers for man-db ...
Errors were encountered while processing:
/var/cache/apt/archives/mariadb-client-5.5_5.5.27-mariadb1~squeeze_i386.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
--------

Workaround :
To avoid/correct the problem, remove the mytop package by doing : dpkg -r mytop
Then (if you did try to install the mariadb-client-5.5 package before removing mytop), re-try the package installation by doing : apt-get -f install

There is another small issue on this mytop version if you want it to drop-in replace the debian one : by default the debian packaged mytop will connect on the "mysql" database and the Maria one try to connect on the "test" database, if you dont have an existing database named "test", mytop will fail to start with this error :
Unknown database 'test'

To workaround that, you can add "database=mysql" (as all servers will have a "mysql" database) on your ~/.my.cnf or ~/.mytop (depending on which file you use).
Another solution is to specify the "mysql" databse instead of "test" as the default setting on /usr/bin/mytop at line 80 (but if its not modified upstream you will have to modify that again on the next update).

Comment by Elena Stepanova [ 2012-09-12 ]

See also https://bugs.launchpad.net/maria/+bug/1047337 (needs to be updated when the problem is fixed).

Comment by Kristian Nielsen [ 2012-10-08 ]

Fix (removing mytop from mariadb-client-5.5 .deb) pushed to lp:maria/5.5

Generated at Thu Feb 08 06:29:21 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.