Hi guys,
i tried to update a running 5.6 to 5.7.
Here’s what I did:
-
service mysql stop
-
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 http://repo.mysql.com/apt//ubuntu/ precise/mysql-5.6 mysql-common amd64 5.6.30-1ubuntu12.04 [696 kB]
Get:2 http://repo.percona.com/apt/ precise/main percona-server-common-5.7 amd64 5.7.11-4-1.precise [782 kB]
Get:3 http://repo.percona.com/apt/ precise/main percona-server-client-5.7 amd64 5.7.11-4-1.precise [13.2 MB]
Get:4 http://repo.percona.com/apt/ 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 
Thanks: Lars