Plesk access error: "1286 Unknown table engine 'InnoDB'"

Created:

2016-11-16 13:17:52 UTC

Modified:

2017-08-08 13:44:55 UTC

3

Was this article helpful?


Have more questions?

Submit a request

Plesk access error: "1286 Unknown table engine 'InnoDB'"

Applicable to:

  • Plesk for Linux

Symptoms

When log into Plesk it shows the error:

    Syntax error or access violation: 1286 Unknown table engine 'InnoDB' (Pdo.php:234)

Cause

Innodb engine plugin is not installed.

Resolution

  1. Check that this article is applicable for the issue, you should have the same output of the queries:

    mysql> show engines;
    +------------+---------+------------------------------------------------------+

    | Engine | Support | Comment | Transactions | XA | Savepoints |
    +------------+---------+------------------------------------------------------+

    | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
    | CSV | YES | CSV storage engine | NO | NO | NO |
    | MyISAM | DEFAULT | Default engine as of MySQL 3.23 | NO | NO | NO |
    | MEMORY | YES | Hash based, stored in memory | NO | NO | NO |
    +------------+---------+------------------------------------------------------+
    4 rows in set (0.00 sec)

    mysql> show variables like 'have_innodb';
    +---------------+-------+
    | Variable_name | Value |
    +---------------+-------+
    | have_innodb | NO |
    +---------------+-------+
    1 row in set (0.00 sec)

    mysql> SHOW PLUGINS;
    +------------+--------+----------------+---------+---------+
    | Name | Status | Type | Library | License |
    +------------+--------+----------------+---------+---------+
    | binlog | ACTIVE | STORAGE ENGINE | NULL | GPL |
    | partition | ACTIVE | STORAGE ENGINE | NULL | GPL |
    | CSV | ACTIVE | STORAGE ENGINE | NULL | GPL |
    | MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL |
    | MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
    | MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
    +------------+--------+----------------+---------+---------+
    6 rows in set (0.00 sec)

    mysql> show variables like '%plugin_dir';
    +---------------+-------------------------+
    | Variable_name | Value |
    +---------------+-------------------------+
    | plugin_dir | /usr/lib64/mysql/plugin |
    +---------------+-------------------------+
    1 row in set (0.00 sec)
  2. List directory with plugins:

    # ls -al /usr/lib64/mysql/plugin/
    total 1424
    drwxr-xr-x 2 root root 4096 Jul 2 2014 .
    drwxr-xr-x 3 root root 4096 Jul 2 2014 ..
    lrwxrwxrwx 1 root root 19 Jul 2 2014 ha_archive.so -> ha_archive.so.0.0.0
    lrwxrwxrwx 1 root root 19 Jul 2 2014 ha_archive.so.0 -> ha_archive.so.0.0.0
    -rwxr-xr-x 1 root root 54048 Feb 12 2014 ha_archive.so.0.0.0
    lrwxrwxrwx 1 root root 21 Jul 2 2014 ha_blackhole.so -> ha_blackhole.so.0.0.0
    lrwxrwxrwx 1 root root 21 Jul 2 2014 ha_blackhole.so.0 -> ha_blackhole.so.0.0.0
    -rwxr-xr-x 1 root root 30288 Feb 12 2014 ha_blackhole.so.0.0.0
    lrwxrwxrwx 1 root root 19 Jul 2 2014 ha_example.so -> ha_example.so.0.0.0
    lrwxrwxrwx 1 root root 19 Jul 2 2014 ha_example.so.0 -> ha_example.so.0.0.0
    -rwxr-xr-x 1 root root 33168 Feb 12 2014 ha_example.so.0.0.0
    lrwxrwxrwx 1 root root 21 Jul 2 2014 ha_federated.so -> ha_federated.so.0.0.0
    lrwxrwxrwx 1 root root 21 Jul 2 2014 ha_federated.so.0 -> ha_federated.so.0.0.0
    -rwxr-xr-x 1 root root 58064 Feb 12 2014 ha_federated.so.0.0.0
    lrwxrwxrwx 1 root root 25 Jul 2 2014 ha_innodb_plugin.so -> ha_innodb_plugin.so.0.0.0
    lrwxrwxrwx 1 root root 25 Jul 2 2014 ha_innodb_plugin.so.0 -> ha_innodb_plugin.so.0.0.0
    -rwxr-xr-x 1 root root 1259136 Feb 12 2014 ha_innodb_plugin.so.0.0.0
  3. Log into MySQL and install the plugin:

    mysql> INSTALL PLUGIN InnoDB SONAME 'ha_innodb_plugin.so';
  4. Restart MySQL service

    # service mysql restart

Note : the following article can contain useful information about the issue: How to fix InnoDB corruption cases for the MySQL database .

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