Plesk Table ‘psa.sessions’ doesn’t exist

When restarting the PSA service or browsing the Plesk panel, the following error is occur.

Table ‘psa.sessions’ doesn’t exist

To resolve the above error refer to the following steps but make sure that you have logged in to the shell as a root user.

cd /var/lib/psa/dumps

Now check the available psa database backup files.

[root@myroot dumps]# ll | grep mysql.daily.dump
-rw——- 1 root root 460665 Nov 25 03:54 mysql.daily.dump.0.gz
-rw——- 1 root root 455787 Nov 24 03:44 mysql.daily.dump.1.gz
-rw——- 1 root root 455382 Nov 23 03:55 mysql.daily.dump.2.gz

As per above command result. the three backup files are present.

You can first try to generate the existing PSA database backup.

[root@myroot dumps]# mysqldump –opt -uadmin -p`cat /etc/psa/.psa.shadow` psa > psa_ori.sql
mysqldump: Got error: 1146: Table ‘psa.siteapppackages_apscategories’ doesn’t exist when using LOCK TABLES

The mysqldump also not allowing to take backup, no issue simply copy the whole /var/lib/mysql/psa directory to /var/lib/mysql/psa-back.

[root@myroot dumps]#cp -p /var/lib/mysql/psa /var/lib/mysql/psa-back -R

Now try to restore the latest backup file.

[root@myroot dumps]# gunzip mysql.daily.dump.1.gz

[root@myroot dumps]# mv mysql.daily.dump.1 mysql.daily.dump

[root@myroot dumps]#mysql -f -uadmin -p`cat /etc/psa/.psa.shadow` < /var/lib/psa/dumps/mysql.daily.dump

It will restore the backup file but some time the following error is occur.

[root@myroot dumps]# mysql -f -uadmin -p`cat /etc/psa/.psa.shadow` < /var/lib/psa/dumps/mysql.daily.dump
ERROR 1005 (HY000) at line 3636: Can’t create table ‘psa.sessions’ (errno: -1)
ERROR 1146 (42S02) at line 3654: Table ‘psa.sessions’ doesn’t exist
ERROR 1146 (42S02) at line 3655: Table ‘psa.sessions’ doesn’t exist
ERROR 1146 (42S02) at line 3656: Table ‘psa.sessions’ doesn’t exist
ERROR 1146 (42S02) at line 3657: Table ‘psa.sessions’ doesn’t exist

To resolve the above error simply follow the steps.

[root@myroot dumps]# mysql -u admin -p$(cat /etc/psa/.psa.shadow)

It will provide you mysql command prompt.

mysql> use psa;

mysql> show databases;

Now run the query given on the following URL from command prompt.

Create PS-SESSION table mysql database query

once above query completed, simply restore the psa database backup

mysql -f -uadmin -p`cat /etc/psa/.psa.shadow` < /var/lib/psa/dumps/mysql.daily.dump

 

If the latest psa backup file is corrupted then refer to the following steps.

Check the old psa database file and restore it.

zcat /var/lib/psa/dumps/mysql.daily.dump.2.gz | mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa

 

 

 

Be Sociable, Share!