Plesk panel is not accessible after upgrade with psa.table error: Table ‘psa.table_name’ doesn’t exist

Symptoms

• Plesk is not accessible, the following error message is displayed under /var/log/plesk/panel.log:

  ERR [panel] Cannot load settings: DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.misc' doesn't exist, query was: select param, val from misc
  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)

  Note: table name may be different

• Plesk was recently upgraded:

  # plesk db “select * from upgrade_history”
  +———————+————–+————+——————+
  | upgrade_date | version_info | db_version | os | mu | update_ticket |
  +———————+————–+————+——————-+
  | 2020-04-03 02:54:58 | 18.0.28 | NULL | CentOS 7.7.1908 | 2 | |
  +———————+————–+————+———-+

Cause

Plesk database psa was not fully upgraded during the Plesk upgrade.

Resolution

1. Connect to the server via SSH

2. Create Plesk database backup

3. List all available Plesk daily database dumps sorted by the date:

   # ls -lt /var/lib/psa/dumps/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

   Note: where mysql.daily.dump.0.gz is the most recent daily database dump.

4. Restore the psa database from the most recent daily dump:

   # zcat mysql.daily.dump.0.gz | sed -n ‘/– Current Database: psa/,/– Current Database:*/p’ | MYSQL_PWD=cat /etc/psa/.psa.shadow mysql -uadmin

• If restoration of the psa database fails with the below error, restore from the next most recent backup:

  ERROR 1265 (01000) at line 3375: Data truncated for column 'event_type' at row 2362

5. Rerun the Plesk upgrade operation: How to upgrade Plesk?