Dist-upgrade from Ubuntu 14 to 16 fails: Sub-process /usr/bin/dpkg returned an error code (1)

Plesk for Linux kb: fixed kb: bug ABT: Group A

Applicable to:

Dist-upgrade from Ubuntu 14.04 to Ubuntu 16.04.1 fails to update MySQL 5.5:

CONFIG_TEXT: Errors were encountered while processing:
mysql-server-5.7
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

Plesk bug with ID #PPPM-7431 fixed in Plesk Obsidian on February 12, 2019 (fixed as PPP-33523, Linux).

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 and comment out two parameters:

CONFIG_TEXT: [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