Symptoms
Dist-upgrade from Ubuntu 14.04 to Ubuntu 16.04.1 fails to update MySQL 5.5:
Errors were encountered while processing:
mysql-server-5.7
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
Cause
Plesk bug with ID #PPPM-7431 fixed in Plesk Obsidian on February 12, 2019 (fixed as PPP-33523, Linux).
Resolution
For Plesk Obsidian, install the latest Plesk micro-updates.
For Plesk Onyx, upgrade to the latest Plesk version.
If update is not possible for some reason, try the following
temporary solution
1. Login to Plesk server over SSH
2. Open
/etc/mysql/my.cnf
[mysqld_safe]
#innodb_additional_mem_pool_size=500K
[mysqld]
#innodb_additional_mem_pool_size=500K
3. Restart MySQL service:
# service mysql restart
4. Complete the failed upgrade:
# apt-get -f install
# /opt/psa/bin/distupgrade.helper.ubt14-ubt16.x64.sh
with