Plesk upgrade fails:
ERROR while trying to upgrade APSC SQL database from 11.1.0 Check the error reason(see log file: /var/log/plesk/install/plesk_12.5.30_repair.log), fix and try again
The following error can be observed in the
ERROR 1558 (HY000) at line 67: Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50095, now running 50538. Please use mysql_upgrade to fix this error.
mysql.proc table has incorrect schema (was not upgraded during MySQL upgrade).
Create databases backups:
# mkdir /root/mysql_backups/ # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa -Ne"show databases"|grep -v information_schema|while read db;do MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -uadmin $db > /root/mysql_backups/$db.`date +%F_%H.%M`.sql;done
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin
Make sure that
mysql.procwas upgraded and has 20 columns:
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin mysql -Nse "desc proc" | wc -l 20
Run Plesk upgrade: