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

Created:

2016-11-16 13:11:12 UTC

Modified:

2017-08-18 12:11:42 UTC

12

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 fails to start. The following error message is shown in the MySQL error log file %plesk_dir%MySQL\Data\*.err:

    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 with one of the following error messages:

    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)

    or

    Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002]
    Additionally, an exception has occurred while trying to report this error: Zend_Exception
    No entry is registered for key 'translate' (Abstract.php:144)

Resolution

Connect to the server using SSH/RDP.

For Windows:

  1. Open the file %plesk_dir%MySQL\my.ini and add the record below to the [PleskSQLServer] section:

    innodb_fast_shutdown=0
  2. In the same my.ini file change the InnoDB log file size to the value mentioned in the error message. In the current example it is required to change the InnoDB log file size to 5242880 bytes:

    innodb_log_file_size=5M
  3. Rename files ib_logfile0 and ib_logfile1 located at %plesk_dir%MySQL\Data.
  4. Start the Plesk SQL Server service.

For Linux :

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

    innodb_fast_shutdown=0
  2. In the same my.ini file change the InnoDB log file size to the value mentioned in the error message. In the current example it is required to change the InnoDB log file size to 5242880 bytes:

    innodb_log_file_size=5M
  3. Rename files 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.