Unable to update Plesk: Sub-process /usr/bin/dpkg returned an error code (1): iF mysql-server-5.7

Symptoms

• Debian or Ubuntu is used.

• Unable to update Plesk server due to the following errors in /var/log/plesk/systemupdatestool.log :

  # tail /var/log/plesk/systemupdatestool.log
  Errors were encountered while processing:
  package_name
  E:Sub-process /usr/bin/dpkg returned an error code (1)
  2017-06-28 17:56:57 ERROR: installArchives() failed
  2017-06-28 17:56:57 ERROR: Exited with returncode 1. 

• Unable to install Plesk micro-updates or updates due to the following error in /var/log/plesk/install/autoinstaller3.log :

  # tail /var/log/plesk/install/autoinstaller3.log
  dpkg: error processing package mysql-server (--configure):
  dependency problems - leaving unconfigured
  No apport report written because the error message indicates its a followup error from a previous failure.
  Errors were encountered while processing:
  mysql-server-5.7
  mysql-server

Cause

Packages are misconfigured or were not properly installed.

Resolution

Warning: Manipulations with the package manager can lead to system inoperability or data loss. Back up the server, proceed with caution or contact professionals if needed.

1. Connect to the server via SSH.

2. Configure the packages with the iF attributes:

   # dpkg --configure mysql-server-5.7

3. Configure the packages with the iU attributes:

   # dpkg --configure mysql-server

4. Make sure that the packages were successfully configured (they should have the ii attribute):

   # dpkg -l | grep mysql-server
   ii mysql-server-5.7 5.7.18-0ubuntu0.16.04.1 amd64 MySQL database server binaries and system database setup
   iU mysql-server 5.7.18-0ubuntu0.16.04.1 all MySQL database server (metapackage depending on the latest version)

5. If the issue persists, reinstall the failing package:

   # apt-get install --reinstall mysql-server

6. Restart update or upgrade tasks.