error

[jayj]

guys wondering if you can help me ive got up today and noticed all my sites had gone down
so i tried to log into plesk and this is what i got

ERROR: PleskMainDBException
MySQL query failed: Incorrect information in file: './psa/misc.frm'

0: common_func.php3:168
db_query(string 'select param, val from misc')
1: common_func.php3:587
get_param(string 'mysql41_compatible')
2: common_func.php3:484
db_set_names()
3: common_func.php3:463
db_connect_real(string 'localhost', string 'admin', string '********', string 'psa')
4: common_func.php3:443
db_connect()
5: auth.php3:90


i havnt got a clue what the problem is or what happend
could some one shed some light on either how i can correct this without lossing my db or how it happend cheers

 

[Andrey Kucherov]

Hello,

This error means that misc table for your psa database is corrupted.
Please try to restore the database from backup.

You can use the following article in order to do this:

===

http://download1.parallels.com/Plesk/PPP9/Doc/en-US/plesk-9.2-backup-cli-guide/62006.htm

===

 

[GreedyGopher]

Hi,

Looks like the DB got corrupted.
You can try to repair it like this:
mysqlcheck -uadmin -p`<plesk_admin_password>` psa -r
If that does not help, the only thing to do is restore the database from the most recent dump.

 

[Nataliya Zagr]

Hello,

The problem is caused by incorrect permissions to directory /tmp. Thus, MySQL is not able to properly create its temporary files for InnoDB engine on start.

Here are correct permissions:

~# ls -ld /tmp/
drwxrwxrwt 4 root root 36864 Aug 8 08:41 /tmp/
~#

Correct the permissions with the following comment:

~# chmod 1777 /tmp

Please, see the follwoing article for more information:

http://kb.odin.com/en/6595

Thank you

 

[Yulia Kostina]

Hello

Seems misc table is corrupted. The simplest way is to restore whole Plesk database from backup:
gunzip -dc /var/lib/psa/dumps/mysql.daily.dump.0.gz | mysql -uadmin -p`cat /etc/psa/.psa.shadow`
Or, you can try to repair tables:
http://www.softwareprojects.com/res...to-fix-mysql-database-myisam-innodb-1634.html