Articles in this section

See more

Unable to access Plesk: Table 'psa.table_name' doesn't exist

Avatar
Kuzma Ivanov
Updated
Follow

Applicable to:

  • Plesk for Linux
  • Plesk for Windows

Symptoms

  • Plesk is not accessible with one of the following error messages in a web-browser:

    PLESK_INFO: ERROR: Zend_Db_Statement_Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.sessions' doesn't exist
    ERROR: Zend_Db_Statement_Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.sessioncontexts' doesn't exist
    ERROR: Zend_Db_Statement_Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.servicenodes' doesn't exist

    OR

    PLESK_INFO: ERROR: PleskMainDBException
    MySQL query failed: Unknown column 'id' in 'field list'

    OR

    PLESK_INFO: ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.sessions' doesn't exist, query was: DESCRIBE `sessions`

    OR

    PLESK_INFO: DB query failed: "DESCRIBE `sessions`" Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.sessions' doesn't exist, query was: DESCRIBE `sessions`

    OR

    PLESK_INFO: DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.misc' doesn't exist, query was: replace into misc (param, val) values(:param, :val)

Cause

The Plesk 'psa' system database is corrupted.

Resolution

Restore the Plesk 'psa' system database from a Plesk daily dump.

Note: Restoration of the 'psa' database does not affect users' data. However, recent actions done via Plesk interface will be lost.

For Plesk on Linux

  1. Connect to the Plesk server via SSH.

  2. Switch to the directory with daily dumps:

    # cd /var/lib/psa/dumps

  3. List all available Plesk daily dumps:

    # ls -l mysql.daily*
    -rw------- 1 root root 236253 Feb 3 01:51 mysql.daily.dump.0.gz
    -rw------- 1 root root 229653 Feb 2 01:48 mysql.daily.dump.1.gz
    -rw------- 1 root root 222485 Feb 1 01:56 mysql.daily.dump.2.gz

    • where mysql.daily.dump.0.gz is the most recent daily dump.

  4. Restore the 'psa' database from the most recent daily dump. In this example, the 'psa' database is being restored from mysql.daily.dump.0.gz:

    # zcat mysql.daily.dump.0.gz | sed -n '/-- Current Database: `psa`/,/-- Current Database:*/p' | MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin --default-character-set=utf8

  5. Access Plesk.

    If Plesk is still not accessible, try to restore the 'psa' database from an earlier Plesk daily dump:

    # zcat mysql.daily.dump.1.gz | sed -n '/-- Current Database: `psa`/,/-- Current Database:*/p' | MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin --default-character-set=utf8

For Plesk on Windows Server

  1. Connect to the Plesk server via RDP.

  2. Switch to the directory with daily dumps:

    C:\> cd %plesk_dir%Mysql\Backup

  3. List all available Plesk daily dumps with the 'psa' database sorted by date (newest first):

    C:\> dir psa* /O:-D

    Directory of C:\Program Files (x86)\Plesk\MySQL\Backup

    03/29/2019 08:33 PM 502,879 psa-20190329203301.sql
    03/28/2019 08:33 PM 468,888 psa-20190328203301.sql
    03/27/2019 08:33 PM 468,888 psa-20190327203301.sql

  4. Restore the 'psa' database from the latest available daily dump. In this example, we are restoring the dump from 03/29/2019:

    • For Plesk Onyx

      C:\> plesk db < psa-20190329203301.sql

    • For Plesk 12.5 and previous releases

      Note: MySQL admin password is required for this operation.

      C:\> "%plesk_dir%"\Mysql\bin\mysql.exe -uadmin -p -P8306 < psa-20190329203301.sql

  5. Access Plesk.

Related Articles

Comments

2 comments

Sort by Date Votes

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles