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

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

    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`

    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`

    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.

 

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.

Comments

3 comments

Sort by Date Votes
  • Avatar
    Sharul Hafiz

    I've got this error when trying to restore the database

    ERROR 1813 (HY000) at line 15: Tablespace for table '`psa`.`APSApplicationItems`' exists. Please DISCARD the tablespace before IMPORT

    Moving out all content from psa folder sort of solve it. Is that the correct way to solve it?

    0
    Comment actions Permalink
  • Avatar
    Anton Maslov

    Sharul, error might have different reason behind, thus hard to evaluate your solution. 

    What I'd like to recommend is please check MySQL:

    MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqlcheck -u admin --all-databases

    And if you'll see errors about non-existing databases or others you might need to do a recovery:

    https://support.plesk.com/hc/en-us/articles/213939865-How-to-fix-InnoDB-corruption-cases-for-the-MySQL-databases-on-Plesk-for-Linux-

    0
    Comment actions Permalink
  • Avatar
    Sepehr Ashoori

    I get ERROR 1045 (28000): Access Denied for user 'admin'@'localhost' (using password: YES) when I execute the zcat mysql.daily.dump ....

    Please help.

    My problem:

    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)
    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles