Unable to access Plesk: MySQL query failed: Incorrect information in file: './psa/misc.frm'

Created:

2016-11-16 13:21:31 UTC

Modified:

2017-08-16 17:28:54 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to access Plesk: MySQL query failed: Incorrect information in file: './psa/misc.frm'

Applicable to:

  • Plesk 11.x for Linux
  • Plesk 12.0 for Linux

Symptoms

Unable to access Plesk:

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

Following command produces errors:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqlcheck -u admin --check --all-databases

psa.APSApplicationItems
Error : Incorrect information in file: './psa/APSApplicationItems.frm'
error : Corrupt
...

During mysql restart the following error can be found in /var/log/mysqld.log :

160829 08:33:57  mysqld started
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 268435456 bytes!
160829 8:33:58 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.95' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution

Cause

Corrupted ib_logfile files.

Resolution

Check solution from Unable to start MySQL service .

Have more questions? Submit a request
Please sign in to leave a comment.