Issue Upgrading to MySQL 5.7 fails

[PluginDB]

Hello! I tried to upgrade to MySQL 5.7 today due to missing functions in 5.6 but It can't seem to install the packages

first I got the sources using the debian package

# wget http://dev.mysql.com/get/mysql-apt-config_0.7.3-1_all.deb

# dpkg -i mysql-apt-config_0.7.3-1_all.deb

Then I installed the community server:

# apt-get install mysql-community-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following NEW packages will be installed:
  mysql-community-server
0 upgraded, 1 newly installed, 0 to remove and 33 not upgraded.
5 not fully installed or removed.
Need to get 54.9 MB of archives.
After this operation, 176 MB of additional disk space will be used.
Get:1 http://repo.mysql.com/apt/debian/ wheezy/mysql-5.7 mysql-community-server amd64 5.7.19-1debian7 [54.9 MB]
Fetched 54.9 MB in 4s (11.7 MB/s)
Preconfiguring packages ...
(Reading database ... 149660 files and directories currently installed.)
Unpacking mysql-community-server (from .../mysql-community-server_5.7.19-1debian7_amd64.deb) ...
................
dpkg: error processing /var/cache/apt/archives/mysql-community-server_5.7.19-1debian7_amd64.deb (--unpack):
 subprocess new pre-installation script returned error exit status 1
Errors were encountered while processing:
 /var/cache/apt/archives/mysql-community-server_5.7.19-1debian7_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

This is the part where it always fails. Nothing found on the Internet, any advice?

 

[IgorG]

Have you tried

# rm -f /var/lib/mysql/debian-*.flag

?

 

[AYamshanov]

Hi PluginDB,

I suggest you use MySQL in Docker container if it possible in your case. A short how-to you can find in our blog Let's talk about the Plesk Docker Extension | Plesk