• Article for your preferred language does not exist. Below is international version of the article.

Article ID: 6595, created on Aug 8, 2009, last review on Sep 15, 2015

  • Applies to:
  • Plesk 10.x for Linux
  • Plesk 9.x for Linux/Unix
  • Plesk 8.x for Linux/Unix

Symptoms

The following error is shown in Parallels Plesk Panel 8.x on the Login page at: https://plesk.host.name:8443:

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

0: /usr/local/psa/admin/plib/common_func.php3:216
        db_query(string 'select param, val from misc')
1: /usr/local/psa/admin/plib/common_func.php3:513
        get_param(string 'mysql41_compatible')
2: /usr/local/psa/admin/plib/common_func.php3:410
        db_set_names()
3: /usr/local/psa/admin/plib/common_func.php3:389
        db_connect_real(string 'localhost', string 'admin', string '***********', string 'psa')
4: /usr/local/psa/admin/plib/common_func.php3:369
        db_connect()
5: /usr/local/psa/admin/auto_prepend/auth.php3:87


for Parallels Plesk Panel 10.x:

ERROR: Zend_Db_Statement_Exception   
SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql_39f_0.MYI' (Errcode: 13)

0: Pdo.php:234
    Zend_Db_Statement_Pdo->_execute(array)
1: Statement.php:300
    Zend_Db_Statement->execute(array)
2: Abstract.php:479
    Zend_Db_Adapter_Abstract->query(string 'DESCRIBE `ServiceNodes`', array)
3: Abstract.php:238
    Zend_Db_Adapter_Pdo_Abstract->query(string 'DESCRIBE `ServiceNodes`')
4: Mysql.php:169
    Zend_Db_Adapter_Pdo_Mysql->describeTable(string 'ServiceNodes', NULL null)
5: Abstract.php:835
    Zend_Db_Table_Abstract->_setupMetadata()
6: Abstract.php:874
    Zend_Db_Table_Abstract->_setupPrimaryKey()
7: Abstract.php:982
    Zend_Db_Table_Abstract->info()
8: Select.php:100
    Zend_Db_Table_Select->setTable(object of type Db_Table_Broker_ServiceNodes)
9: Select.php:78
    Zend_Db_Table_Select->__construct(object of type Db_Table_Broker_ServiceNodes)
10: Abstract.php:1018
    Zend_Db_Table_Abstract->select()
11: Abstract.php:1331
    Zend_Db_Table_Abstract->fetchAll(string '`transport` = 'local'')
12: Abstract.php:110
    Db_Table_Abstract->findByField(string 'transport', string 'local')
13: Abstract.php:122
    Db_Table_Abstract->findOneByField(string 'transport', string 'local')
14: ServiceNodes.php:226
    Db_Table_Broker_ServiceNodes->getLocalServiceNode()
15: auth.php3:505


What causes the problem?

Cause

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

Here are the correct permissions:

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

Resolution

Correct the permissions with the following comment:

~# chmod 1777 /tmp

Additional information

To see the error, update the section [mysqld] in the file /etc/my.cnf with this line:

/etc/my.cnf
--->8---
[mysqld]
innodb_force_recovery = 4
---8<---


and restart the service with

~# /etc/init.d/mysqld restart
Stopping MySQL:                                            [  OK  ]
Starting MySQL:                                            [  OK  ]
~#

The following error should be shown in the MySQL error log file:

/var/log/mysqld.log
--->8---
^G/usr/libexec/mysqld: Can't create/write to file '/tmp/ib1suXEE' (Errcode: 13)
020326 22:26:17  InnoDB: Error: unable to create temporary file; errno: 13
020326 22:26:18 [Note] /usr/libexec/mysqld: ready for connections.
---8<---


The location of the MySQL error log file is set in the configuration file:

~# grep log-error /etc/my.cnf
log-error=/var/log/mysqld.log
~#

Additional information

Also see this article: [How to] How to fix InnoDB corruption cases for MySQL database

56797cefb1efc9130f7c48a7d1db0f0c dd0611b6086474193d9bf78e2b293040 a914db3fdc7a53ddcfd1b2db8f5a1b9c 29d1e90fd304f01e6420fbe60f66f838 6ef0db7f1685482449634a455d77d3f4 b8ef5052d936e902043e41759118114e 0efe2234e2ce513f2186f26c68447702

Email subscription for changes to this article
Save as PDF