Unable to start MySQL service: Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

Created:

2016-11-16 13:11:12 UTC

Modified:

2017-06-25 10:46:03 UTC

7

Was this article helpful?


Have more questions?

Submit a request

Unable to start MySQL service: Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

Applicable to:

  • Plesk for Windows
  • Plesk for Linux

Symptoms

MySQL server failed to start. The following error message is shown in MySQL error log:

InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file .\\ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 10485760 bytes!
[ERROR] Plugin 'InnoDB' init function returned error.
[ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
[ERROR] Unknown/unsupported storage engine: INNODB
[ERROR] Aborting

Plesk is not accessible:

ERROR: PleskDBException: Unable to connect to database: mysql_connect(): No such file or directory /var/lib/mysql/mysql.sock (Error code: 2002). Please check that database server is started and accessible. (Abstract.php:69)

Resolution

Connect to the server using SSH/RDP.

For Windows:

  1. Add the following string into the configuration file %plesk_dir%\\Databases\\MySQL\\data\\my.ini :

    innodb_fast_shutdown=0
  2. If it did not help, change log size to required in my.ini and rename ib_logfile0 and ib_logfile1 . In this example it is required to change log size to 5242880 bytes:

    innodb_log_file_size=5M
  3. Start MySQL Server

For Linux :

  1. Add the following string into the configuration file /etc/my.cnf :

    innodb_fast_shutdown=0
  2. If it did not help, change log size to required in /etc/my.cnf , in this example, it is required to change log size to 5242880 bytes:

    innodb_log_file_size=5M
  3. Rename ib_logfile0 and ib_logfile1 :

    # mv /var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile0_old
    # mv /var/lib/mysql/ib_logfile1 /var/lib/mysql/ib_logfile1_old
  4. Start mysql service:

    # service mysqld start
  5. If it did not help, backup all ib_logfile* files in /var/lib/mysql directory and remove original ones (all of ib_logfile* files).

If the issue persists, please visit How to fix InnoDB corruption cases for the MySQL database

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