Update to 5.7 fails on Ubuntu 12.04.5 LTS

MySQL & MariaDB Percona Server for MySQL 5.7
1

Hi guys,

i tried to update a running 5.6 to 5.7.

Here’s what I did:

  1. service mysql stop

  2. apt-get install percona-server-server-5.7

Install fails with the following error:

dpkg: error processing /var/cache/apt/archives/percona-server-common-5.7_5.7.11-4-1.precise_amd64.deb (–unpack):
trying to overwrite ‘/usr/share/mysql/estonian/errmsg.sys’, which is also in package mysql-common 5.6.30-1ubuntu12.04

Here’s the full output:

Reading package lists… Done
Building dependency tree
Reading state information… Done
The following extra packages will be installed:
mysql-common percona-server-client-5.7 percona-server-common-5.7
The following packages will be REMOVED:
percona-server-client-5.6 percona-server-server-5.6
The following NEW packages will be installed:
mysql-common percona-server-client-5.7 percona-server-common-5.7 percona-server-server-5.7
0 upgraded, 4 newly installed, 2 to remove and 1 not upgraded.
Need to get 55.9 MB of archives.
After this operation, 49.6 MB of additional disk space will be used.
Do you want to continue [Y/n]? yes
Get:1 [URL]http://repo.mysql.com/apt//ubuntu/[/URL] precise/mysql-5.6 mysql-common amd64 5.6.30-1ubuntu12.04 [696 kB]
Get:2 [URL]http://repo.percona.com/apt/[/URL] precise/main percona-server-common-5.7 amd64 5.7.11-4-1.precise [782 kB]
Get:3 [URL]http://repo.percona.com/apt/[/URL] precise/main percona-server-client-5.7 amd64 5.7.11-4-1.precise [13.2 MB]
Get:4 [URL]http://repo.percona.com/apt/[/URL] precise/main percona-server-server-5.7 amd64 5.7.11-4-1.precise [41.2 MB]
Fetched 55.9 MB in 20s (2773 kB/s)
Preconfiguring packages …
(Reading database … 50913 files and directories currently installed.)
Removing percona-server-server-5.6 …

  • Stopping MySQL (Percona Server) mysqld [ OK ]
    Removing percona-server-client-5.6 …
    Processing triggers for man-db …
    Selecting previously unselected package mysql-common.
    (Reading database … 50668 files and directories currently installed.)
    Unpacking mysql-common (from …/mysql-common_5.6.30-1ubuntu12.04_amd64.deb) …
    Selecting previously unselected package percona-server-common-5.7.
    Unpacking percona-server-common-5.7 (from …/percona-server-common-5.7_5.7.11-4-1.precise_amd64.deb) …
    dpkg: error processing /var/cache/apt/archives/percona-server-common-5.7_5.7.11-4-1.precise_amd64.deb (–unpack):
    trying to overwrite ‘/usr/share/mysql/estonian/errmsg.sys’, which is also in package mysql-common 5.6.30-1ubuntu12.04
    dpkg-deb: error: subprocess paste was killed by signal (Broken pipe)
    Selecting previously unselected package percona-server-client-5.7.
    Unpacking percona-server-client-5.7 (from …/percona-server-client-5.7_5.7.11-4-1.precise_amd64.deb) …
    Processing triggers for man-db …
    Errors were encountered while processing:
    /var/cache/apt/archives/percona-server-common-5.7_5.7.11-4-1.precise_amd64.deb
    localepurge: Disk space freed in /usr/share/locale: 0 KiB
    localepurge: Disk space freed in /usr/share/man: 0 KiB

Total disk space freed by localepurge: 0 KiB

Here’s the ouput of dpkg -l (percona* and mysql* only):

ii percona-release 0.1-3.precise Package to install Percona gpg key and APT repo
iU percona-server-client-5.7 5.7.11-4-1.precise Percona Server database client binaries
ii percona-server-common-5.6 5.6.30-76.3-1.precise Percona Server database common files (e.g. /etc/mysql/my.cnf)
rc percona-server-server-5.6 5.6.25-73.1-1.precise Percona Server database server binaries
ii mysql-apt-config 0.7.2-1 Auto configuration for MySQL APT Repo.
iU mysql-common 5.6.30-1ubuntu12.04 MySQL Common
rc mysql-community-server 5.6.25-1ubuntu12.04 MySQL Server
rc mysql-server-5.5 5.5.31-0ubuntu0.12.04.1 MySQL database server binaries and system database setup
ii mysqltuner 1.1.0 high-performance MySQL tuning script

I’d love to update the existing install and keep all the data instead of removing everything mysql* and make a new/clean install … “going back” to 5.6 is an option, too of course :slight_smile:

Thanks: Lars

2 

dpkg: error processing /var/cache/apt/archives/percona-server-common-5.7_5.7.11-4-1.precise_amd64.deb (--unpack):
trying to overwrite '/usr/share/mysql/estonian/errmsg.sys', which is also in package mysql-common 5.6.30-1ubuntu12.04
dpkg-deb: error: subprocess paste was killed by signal (Broken pipe)

Try uninstalling mysql-common first and then reinstall version 5.7.

3

I faced the same situation.
When upgrading mysql, after stopping the mysql service, you need to check if there is any process running with the following command. If there is any left, you need to kill the process.
service mysql stop
ps -aux |grep mysql
after
kill pid