Plesk 11.0.9 #34, stuck can't update further

[bmwlinux]

SOLVED: Plesk 11.0.9 #34, stuck can't update further

This has been going on for a while but today I started trying to solve the problem for real.

This is a CentOS 6.3 system

When I run the update from within the Plesk GUI or from the command line the process stops with the following error in autoinstaller3.log

Trying to backup MySQL database...
ERROR while trying to backup MySQL database
Check the error reason(see log file: /tmp/plesk_11.0.9_installation.log), fix and try again


So I check log file and see this....
Trying to start service mysqld... mysqld (pid 1583) is running...
done
Trying to establish test connection... connected
done
Trying to backup MySQL database...
ERROR while trying to backup MySQL database
Check the error reason(see log file: /tmp/plesk_11.0.9_installation.log), fix and try again

I can successfully connect to mysql with the following command:
mysql -uadmin -p`cat /etc/psa/.psa.shadow`

So I'm stuck. Any suggestions are appreciated.

 

[bmwlinux]

Sometimes all I have to do is post a problem and then I'll find the answer on my own.

I tried running bootstrapper.sh repair to see what would happen. That's when I found a very insightful error message telling me it could not
chown /var/lib/psa/dumps/mysql.preupgrade.11.0.9-11.0.9.20130321-142316.dump.gz permission denied

Ah ha!!!! I then remembered that I had mounted /var/lib/psa/dumps directory on my NAS. It was not letting the script execute the chown and hence the failure.

Solution was to keep /var/lib/psa/dumps local to the plesk server. Upgrade complete, problem solved!