Plesk upgrade fails: Column count of mysql.proc is wrong

Created:

2016-11-16 13:13:48 UTC

Modified:

2017-04-24 13:05:21 UTC

1

Was this article helpful?


Have more questions?

Submit a request

Plesk upgrade fails: Column count of mysql.proc is wrong

Applicable to:

  • Plesk 12.5 for Linux
  • Plesk 12.0 for Windows
  • Plesk 12.0 for Linux

Symptoms

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 /var/log/plesk/install/plesk_12.0.18_installation.log :

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.

Cause

The mysql.proc table has incorrect schema (was not upgraded during MySQL upgrade).

Resolution

  1. 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
  2. Run mysql_upgrade

    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin
  3. Make sure that mysql.proc was upgraded and has 20 columns:

    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin mysql -Nse "desc proc" | wc -l
    20
  4. Run Plesk upgrade:

    # /usr/local/psa/admin/sbin/autoinstaller
Have more questions? Submit a request
Please sign in to leave a comment.