/ database

How to Fix [ERROR] Unknown/unsupported storage engine: InnoDB

After playing around with my MySQL configuration file in my docker container, MySQL was throwing a weird error, and was failing to start.

I checked the error logs and found an entry in the error log.

[ERROR] Plugin ‘InnoDB’ init function returned error.
[ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
[ERROR] Unknown/unsupported storage engine: InnoDB
[ERROR] Aborting

After googling and searching SO for a while, I realised that the solution is to rename or delete some of the log files of InnoDB. In case you are concerned about the data, it would be wise to have a backup of those files, in my case I encountered the error on a fresh docker MariaDB container. Hence I chose to remove the files.

rm /var/lib/mysql/ib_logfile0
rm /var/lib/mysql/ib_logfile1

and then restart MySQL.

root@docker# /etc/init.d/mysql start
Starting MySQL database server: mysqld . ..
Checking for tables which need an upgrade, are corrupt or were
not closed cleanly..
root@docker#

And thats it, I now have my MySQL server up and running once again.

Manu S Ajith

Manu S Ajith

Tech Entrepreneur, dating Elixir, in long-term ❤️ w/ Ruby, had multiple one night stands w/ Go. Into functional paradigms DDD/CQRS/EventSourcing architecture these days. @manusajith on the interwebs

Read More