Roundcube database Unknown storage engine 'InnoDB'

Zabidin

Well-Known Member
Jan 6, 2016
47
4
8
Malaysia
cPanel Access Level
Root Administrator
Hi,

We receive notice from cpanel as below:

check_mysql has determined that there are corrupted database tables

cPanel & WHM has determined that the following database tables are corrupt:
Code:
Database

Error

roundcube

roundcube.cache Error : Unknown storage engine 'InnoDB' error : Corrupt roundcube.cache_index Error : Unknown storage engine 'InnoDB' error : Corrupt roundcube.cache_messages Error : Unknown storage engine 'InnoDB' error : Corrupt roundcube.cache_shared Error : Unknown storage engine 'InnoDB' error : Corrupt roundcube.cache_thread Error : Unknown storage engine 'InnoDB' error : Corrupt roundcube.contactgroupmembers Error : Unknown storage engine 'InnoDB' error : Corrupt roundcube.contactgroups Error : Unknown storage engine 'InnoDB' error : Corrupt roundcube.contacts Error : Unknown storage engine 'InnoDB' error : Corrupt roundcube.dictionary Error : Unknown storage engine 'InnoDB' error : Corrupt roundcube.identities Error : Unknown storage engine 'InnoDB' error : Corrupt roundcube.searches Error : Unknown storage engine 'InnoDB' error : Corrupt roundcube.session Error : Unknown storage engine 'InnoDB' error : Corrupt roundcube.system Error : Unknown storage engine 'InnoDB' error : Corrupt roundcube.users Error : Unknown storage engine 'InnoDB' error : Corrupt

munin_innodb

munin_innodb.sample_table Error : Unknown storage engine 'InnoDB' error : Corrupt
We have repair it as suggested by getting error. Refer attachment.

What is workaround for this issue?
 

Attachments

Last edited by a moderator:

sarath8372

Active Member
Jan 6, 2015
35
7
8
Kochi, India
cPanel Access Level
Root Administrator
Hello,

From the error message, it appears that InnoDB engine is currently disabled on the server.

Check for any disable options for InnoDB in /etc/my.cnf and remove it, if found. Then restart mysql.

If there isn't any disable options in my.cnf for InnoDB, try :

Code:
# /etc/init.d/mysql stop

# mv /var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile0.bak

# mv /var/lib/mysql/ib_logfile1 /var/lib/mysql/ib_logfile1.bak

# /etc/init.d/mysql start

Check if Innodb engine is active.

Code:
# mysql -e "show engines";

InnoDB is enabled by default. But, MySQL seems to disable it automatically if your InnoDB log files get corrupted. When you remove them, they are recreated, allowing InnoDB to start again.
 
  • Like
Reactions: urgido

Zabidin

Well-Known Member
Jan 6, 2016
47
4
8
Malaysia
cPanel Access Level
Root Administrator
As request:
Code:
[email protected] [/home]# mysql -e "show engines";
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine  | Support | Comment  | Transactions | XA  | Savepoints |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| MyISAM  | DEFAULT | MyISAM storage engine  | NO  | NO  | NO  |
| MRG_MYISAM  | YES  | Collection of identical MyISAM tables  | NO  | NO  | NO  |
| CSV  | YES  | CSV storage engine  | NO  | NO  | NO  |
| BLACKHOLE  | YES  | /dev/null storage engine (anything you write to it disappears) | NO  | NO  | NO  |
| MEMORY  | YES  | Hash based, stored in memory, useful for temporary tables  | NO  | NO  | NO  |
| PERFORMANCE_SCHEMA | YES  | Performance Schema  | NO  | NO  | NO  |
| ARCHIVE  | YES  | Archive storage engine  | NO  | NO  | NO  |
| FEDERATED  | NO  | Federated MySQL storage engine  | NULL  | NULL | NULL  |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
[email protected] [/home]#
We do not use InnoDB since start the web.
 

sarath8372

Active Member
Jan 6, 2015
35
7
8
Kochi, India
cPanel Access Level
Root Administrator
Hello,

Roundcube database tables uses innodb engine and hence you are getting error. You should enable innodb engine in order to correct the issue.

Code:
# mysql -e "SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'roundcube' AND engine = 'InnoDB';"
+---------------------+
| TABLE_NAME          |
+---------------------+
| cache               |
| cache_index         |
| cache_messages      |
| cache_shared        |
| cache_thread        |
| contactgroupmembers |
| contactgroups       |
| contacts            |
| dictionary          |
| identities          |
| searches            |
| session             |
| system              |
| users               |
+---------------------+

Please try the fixes I mentioned in my last reply.
 
  • Like
Reactions: urgido

Zabidin

Well-Known Member
Jan 6, 2016
47
4
8
Malaysia
cPanel Access Level
Root Administrator
Code:
[email protected] [/var/lib/mysql]# mysql -e "show engines";
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine             | Support | Comment                                                        | Transactions | XA   | Savepoints |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| MyISAM             | DEFAULT | MyISAM storage engine                                          | NO           | NO   | NO         |
| MRG_MYISAM         | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         |
| CSV                | YES     | CSV storage engine                                             | NO           | NO   | NO         |
| BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   | NO         |
| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |
| PERFORMANCE_SCHEMA | YES     | Performance Schema                                             | NO           | NO   | NO         |
| ARCHIVE            | YES     | Archive storage engine                                         | NO           | NO   | NO         |
| FEDERATED          | NO      | Federated MySQL storage engine                                 | NULL         | NULL | NULL       |
| InnoDB             | YES     | Supports transactions, row-level locking, and foreign keys     | YES          | YES  | YES        |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
Code:
Repairing roundcube
roundcube.cache
note     : The storage engine for the table doesn't support repair
roundcube.cache_index
note     : The storage engine for the table doesn't support repair
roundcube.cache_messages
note     : The storage engine for the table doesn't support repair
roundcube.cache_shared
note     : The storage engine for the table doesn't support repair
roundcube.cache_thread
note     : The storage engine for the table doesn't support repair
roundcube.contactgroupmembers
note     : The storage engine for the table doesn't support repair
roundcube.contactgroups
note     : The storage engine for the table doesn't support repair
roundcube.contacts
note     : The storage engine for the table doesn't support repair
roundcube.cp_schema_version                        OK
roundcube.dictionary
note     : The storage engine for the table doesn't support repair
roundcube.identities
note     : The storage engine for the table doesn't support repair
roundcube.searches
note     : The storage engine for the table doesn't support repair
roundcube.session
note     : The storage engine for the table doesn't support repair
roundcube.system
note     : The storage engine for the table doesn't support repair
roundcube.users
note     : The storage engine for the table doesn't support repair

Done.
 

sarath8372

Active Member
Jan 6, 2015
35
7
8
Kochi, India
cPanel Access Level
Root Administrator
Hello,

As InnoDB engine is currently enabled, you won't receive any further alerts/notifications from cPanel for "roundcube" and "munin" databases.

Please note that you can't repair InnoDB tables using "Repair a MySQL Database" option and will get notification "The storage engine for the table doesn't support repair". "Repair a MySQL Database" option will only work for MyISAM tables.
 

WorkinOnIt

Well-Known Member
Aug 3, 2016
227
30
78
UK
cPanel Access Level
Root Administrator
I had the same issue as the OP - no InnoDB and the same email notification.... although the fix provided by sarath8372 I am curious to know what might have caused InnoDB to have stopped.

Any thoughts?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,218
463
I am curious to know what might have caused InnoDB to have stopped.
It's possible that InnoDB was manually disabled in the past on the system due to corruption. Do you notice any issues after enabling it?

Thank you.