Mysql not starting
MySQL not starting throwing error "Unknown/unsupported storage engine: InnoDB"
Problem
Whwn MySQL not starting and throwing below error. "Unknown/unsupported storage engine: InnoDB"
220821 20:42:34 mysqld_safe Starting mysqld daemon with databases from /opt/zimbra/db/data 2022-08-21 20:42:34 140450186807168 [Note] /opt/zimbra/common/sbin/mysqld (mysqld 10.1.25-MariaDB) starting as process 99524 ... 2022-08-21 20:42:34 140450186807168 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2022-08-21 20:42:34 140450186807168 [Note] InnoDB: The InnoDB memory heap is disabled 2022-08-21 20:42:34 140450186807168 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2022-08-21 20:42:34 140450186807168 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2022-08-21 20:42:34 140450186807168 [Note] InnoDB: Compressed tables use zlib 1.2.3 2022-08-21 20:42:34 140450186807168 [Note] InnoDB: Using Linux native AIO 2022-08-21 20:42:34 140450186807168 [Note] InnoDB: Using SSE crc32 instructions 2022-08-21 20:42:34 140450186807168 [Note] InnoDB: Initializing buffer pool, size = 5.5G 2022-08-21 20:42:35 140450186807168 [Note] InnoDB: Completed initialization of buffer pool 2022-08-21 20:42:35 140450186807168 [Note] InnoDB: Highest supported file format is Barracuda. InnoDB: Set innodb_force_recovery to ignore this error. 2022-08-21 20:42:35 140450186807168 [ERROR] Plugin 'InnoDB' init function returned error. 2022-08-21 20:42:35 140450186807168 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2022-08-21 20:42:35 140450186807168 [Note] Plugin 'FEEDBACK' is disabled. 2022-08-21 20:42:35 140450186807168 [ERROR] Unknown/unsupported storage engine: InnoDB 2022-08-21 20:42:35 140450186807168 [ERROR] Aborting
Solution
The issue usually occurred due to the following corrupted log files stored under /opt/zimbra/db/data
ib_logfile0
ib_logfile1
Upon moving/deleting these files, the issue will resolve.
su - zimbra cd /opt/zimbra/db/data mv ib_logfile0 /tmp/. mv ib_logfile1 /tmp/. or rm ib_logfile0 rm ib_logfile1
Now try starting the MySQL and it should start
mysql.server start
Submitted by: Amol Mistry |