MySQL packaging changed the location /usr/bin/myisam_ftdump in a stable release

[Richard Hansen]

I was upgrading MySQL 5.7 (both client and server) to MariaDB 10.1 (client and server) and I got the following error:

dpkg: error processing archive /var/cache/apt/archives/mariadb-server-10.1_1%3a10.1.44-0ubuntu0.18.04.1_amd64.deb (--unpack):
 trying to overwrite '/usr/bin/myisam_ftdump', which is also in package mysql-client-5.7 5.7.29-0ubuntu0.18.04.1

ProblemType: Package
DistroRelease: Ubuntu 18.04
Package: mariadb-server-10.1 (not installed)
ProcVersionSignature: Ubuntu 5.3.0-47.39~18.04.1-generic 5.3.18
Uname: Linux 5.3.0-47-generic x86_64
ApportVersion: 2.20.9-0ubuntu7.14
Architecture: amd64
Date: Tue Apr 21 17:39:54 2020
DuplicateSignature:
 package:mariadb-server-10.1:(not installed)
 Unpacking mariadb-server-10.1 (1:10.1.44-0ubuntu0.18.04.1) ...
 dpkg: error processing archive /var/cache/apt/archives/mariadb-server-10.1_1%3a10.1.44-0ubuntu0.18.04.1_amd64.deb (--unpack):
  trying to overwrite '/usr/bin/myisam_ftdump', which is also in package mysql-client-5.7 5.7.29-0ubuntu0.18.04.1
ErrorMessage: trying to overwrite '/usr/bin/myisam_ftdump', which is also in package mysql-client-5.7 5.7.29-0ubuntu0.18.04.1
InstallationDate: Installed on 2012-10-27 (2732 days ago)
InstallationMedia: Ubuntu 12.10 "Quantal Quetzal" - Release amd64 (20121017.5)
Python3Details: /usr/bin/python3.6, Python 3.6.9, python3-minimal, 3.6.7-1~18.04
PythonDetails: /usr/bin/python2.7, Python 2.7.17, python-minimal, 2.7.15~rc1-1
RelatedPackageVersions:
 dpkg 1.19.0.5ubuntu2.3
 apt 1.6.12
SourcePackage: mariadb-10.1
Title: package mariadb-server-10.1 (not installed) failed to install/upgrade: trying to overwrite '/usr/bin/myisam_ftdump', which is also in package mysql-client-5.7 5.7.29-0ubuntu0.18.04.1
UpgradeStatus: Upgraded to bionic on 2020-04-18 (3 days ago)

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[Rafael David Tinoco (rafaeldtinoco)]

From logs:

Start-Date: 2020-04-21 17:38:21
Requested-By: rhansen (1000)

Install: mariadb-common:amd64 (1:10.1.44-0ubuntu0.18.04.1, automatic), mariadb-server-core-10.1:amd64 (1:10.1.44-0ubuntu0.18.04.1, automatic), libterm-readkey-perl:amd64 (2.37-1build1, automatic), mariadb-server-10.1:amd64 (1:10.1.44-0ubuntu0.18.04.1, automatic), galera-3:amd64 (25.3.20-1, automatic), libconfig-inifiles-perl:amd64 (2.94-1, automatic), libjemalloc1:amd64 (3.6.0-11, automatic), mariadb-client-10.1:amd64 (1:10.1.44-0ubuntu0.18.04.1, automatic), mariadb-server:amd64 (1:10.1.44-0ubuntu0.18.04.1), mariadb-client-core-10.1:amd64 (1:10.1.44-0ubuntu0.18.04.1, automatic), mariadb-client:amd64 (1:10.1.44-0ubuntu0.18.04.1)

Purge: mysql-client-5.7:amd64 (5.7.29-0ubuntu0.18.04.1), libevent-core-2.1-6:amd64 (2.1.8-stable-4build1), mysql-server-5.7:amd64 (5.7.29-0ubuntu0.18.04.1), mysql-server:amd64 (5.7.29-0ubuntu0.18.04.1), mysql-client:amd64 (5.7.29-0ubuntu0.18.04.1), mysql-client-core-5.7:amd64 (5.7.29-0ubuntu0.18.04.1), mysql-server-core-5.7:amd64 (5.7.29-0ubuntu0.18.04.1)

[Robie Basak (racb)]

Looks like this is still present in Groovy? MySQL seems to have it in the client (or client-core) package all the way through, but MariaDB has it in the server package all the way through.

The easiest way to resolve this is to decide whether it should be in the client package or in the server package, and then make that consistent across both MySQL and MariaDB.

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[Otto Kekäläinen (otto)]

This is a duplicate of https://bugs.launchpad.net/ubuntu/+source/mariadb-10.0/+bug/1612647

This was fixed in https://salsa.debian.org/mariadb-team/mariadb-10.3/-/commit/0429e584d58be5af0da4eede4ea20cd7ca8fc597 and released in 1:10.3.22-1.

Upgrade to MariaDB 10.3 if you were running MySQL 5.7.

From Oracle MySQL 5.7 you need to upgrade to MariaDB 10.2 or newer. Downgrading to MySQL 5.6 or MariaDB 10.1 is not supported.