Plesk update or upgrade failed: ERROR while trying to backup MySQL database

Symptoms

Plesk update or upgrade failed:

PLESK_ERROR: chown: changing ownership of `/var/lib/psa/dumps/mysql.preupgrade.11.5.30-11.5.30.20131211-190722.dump.gz': Operation not permitted

or:

PLESK_ERROR: ... touch: setting times of '/mnt/opendrive/webserver/Backup/mysql.preupgrade.17.5.3-17.5.3.20170921-194900.dump.gz': No such file or directory
ERROR while trying to backup MySQL database
Check the error reason(see log file: /var/log/plesk/install/plesk_17.5.3_installation.log), fix and try again ERROR: An error occurred during performing of installation PREP actions (see log for details). Installation was rolled back.
Warning! Not all packages were installed.
Please check if your system services are operable.
Please resolve this issue and try to install the packages again.
If you cannot resolve the issue on your own, contact product technical support for assistance.

Backup location has been customized:

# grep -i dump /etc/psa/psa.conf
DUMP_D /mnt/opendrive/webserver/Backup
DUMP_TMP_D /mnt/opendrive/webserver/tmp_plesk_backups

It's not possible to create a new file on this location:

# touch /mnt/opendrive/webserver/Backup/test.txt
touch: setting times of ‘/mnt/opendrive/webserver/Backup/test.txt’: No such file or directory

Cause

During the upgrade process Plesk creates databases (psa, horde) dumps. Prior to dumping database, it corrects permissions for files in the backup folder. If backup folder is located in NFS share or external drive, Plesk fails to change permissions there.

Resolution

In order to complete the upgrade do the following:

1. Back up /etc/psa/psa.conf configuration file

   # cp /etc/psa/psa.conf{,.orig}

2. Change the backup location directory to a default one:

   # grep -n DUMP /etc/psa/psa.conf
   83:DUMP_D /var/lib/psa/dumps
   84:DUMP_TMP_D /tmp

3. Make sure both directories have the same permissions as:
   

   # ls -ld /var/lib/psa/dumps
   drwxr-x--- 6 psaadm psaadm 20480 Sep 22 02:46 /var/lib/psa/dumps
   # ls -ld /tmp
   drwxrwxrwt 29 root root 20480 Sep 22 03:01 /tmp

4. Complete the update or upgrade in Plesk > Tools&Settings > Updates&Upgrades

5. When upgrade process is finished, revert changes made in /etc/psa/psa.conf