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
-
Connect to the server via SSH
-
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.gzNote: where
mysql.daily.dump.0.gz
is the most recent daily database dump. -
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
- Rerun the Plesk upgrade operation: How to upgrade Plesk?