Applicable to:
- Plesk for Linux
Symptoms
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)
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 following1. 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
Comments
1 comment
So the culprit is just innodb_additional_mem_pool_size? Reported here https://bugs.launchpad.net/serverguide/+bug/1725222
Please sign in to leave a comment.