Article ID: 121383, created on Apr 29, 2014, last review on Jun 19, 2016

  • Applies to:
  • Plesk 12.5 for Linux
  • Plesk 11.0 for Linux
  • Plesk 11.5 for Linux
  • Plesk 10.3 for Linux/Unix


  1. Plesk Panel is not accessible after the upgrade. The following error can be observed in the /usr/local/psa/admin/logs/panel.log:

    2013-09-14T00:30:40+01:00 CRIT (2): Zend_Db_Statement_Exception: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql_691_0.MYI' (Errcode: 28)
    file: /usr/local/psa/admin/plib/Zend/Db/Statement/Pdo.php
    line: 238
    code: 0
  2. The Plesk version file /usr/local/psa/version has incorrect Plesk version:

    # cat /usr/local/psa/version
    10.3.1 CentOS 6 1013110726.09
  3. There are two psa packages in the system: psa package from the previous Plesk Panel version and from the 11.5 Plesk Panel.

    # rpm -q psa


Failed upgrade from previous version.


  1. Create databases backup:

    # 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. Find the pre-upgrade psa dump:

    # grep -i dump_d /etc/psa/psa.conf
    DUMP_D /var/lib/psa/dumps
    # ls -l /var/lib/psa/dumps/mysql.preupgrade*
    -rw------- 1 root root 461031 Sep 14 19:15 /var/lib/psa/dumps/mysql.preupgrade.10.12.0-
    -rw------- 1 root root   2524 Sep 14 19:15 /var/lib/psa/dumps/mysql.preupgrade.apsc.10.12.0-
  3. Use found mysql.preupgrade dump, run the following command:

    # zcat /var/lib/psa/dumps/mysql.preupgrade.10.12.0- | sed -n '/^CREATE DATABASE.*psa/,/^CREATE DATABASE.*horde/p' > preupgrade.sql                                                                             
  4. Remove psa-11.5.30 package:

    # rpm -q psa
    # rpm -e --nodeps --noscripts --justdb psa-11.5.30-cos6.build115130819.13.x86_64
  5. Restore the pre-upgrade psa database :

    # cat preupgrade.sql | MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin
  6. Run Plesk Panel upgrade using the autoinstaller:

    # /usr/local/psa/admin/bin/autoinstaller

Search Words

After Upgrade Plesk pannel disappeared

Plesk is not accessible

Can't create/write to file '/tmp/#sql_691_0.MYI

bad gateway

Customer says he can't access his Plesk Control Panel

Panel is not accessible

Unable to execute SQL: Table 'psa.domainaliases' doesn't exist

Internal error: MySQL query failed: Table 'psa.domainaliases' doesn't exist

a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c 01bc4c8cf5b7f01f815a7ada004154a2 29d1e90fd304f01e6420fbe60f66f838 0a53c5a9ca65a74d37ef5c5eaeb55d7f aea4cd7bfd353ad7a1341a257ad4724a 742559b1631652fadd74764ae8be475e e335d9adf7edffca6a8af8039031a4c7 f4ce8084cb23619ef5fe9428ecc388ea dd0611b6086474193d9bf78e2b293040

Email subscription for changes to this article
Save as PDF