Skip to main content

Roundcube database Unknown storage engine 'InnoDB'

Zabidin
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:
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?

Comments

8 comments

Date Votes
  • sarath8372
    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 :
    # /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.
    # 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.
    0
  • Zabidin
    As request:
    root@sv1 [/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 | +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+ root@sv1 [/home]#
    We do not use InnoDB since start the web.
    0
  • sarath8372
    Hello, Roundcube database tables uses innodb engine and hence you are getting error. You should enable innodb engine in order to correct the issue.
    # 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.
    0
  • Zabidin

    root@sv1 [/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 | +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+

    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.
    0
  • sarath8372
    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.
    0
  • cPanelMichael
    Hello, You may also need to repair InnoDB if it's corrupted. You can find a repair guide on the following thread: InnoDB Corruption Repair Guide Thank you.
    0
  • WorkinOnIt
    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?
    0
  • cPanelMichael
    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.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post