The Community Forums

Interact with an entire community of cPanel & WHM users.
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Roundcube database Unknown storage engine 'InnoDB'

Discussion in 'Database Discussions' started by Zabidin, May 19, 2016.

Tags:
  1. Zabidin

    Zabidin Active Member

    Joined:
    Jan 6, 2016
    Messages:
    28
    Likes Received:
    1
    Trophy Points:
    1
    Location:
    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?
     

    Attached Files:

    #1 Zabidin, May 19, 2016
    Last edited by a moderator: May 21, 2016
  2. sarath8372

    sarath8372 Active Member

    Joined:
    Jan 6, 2015
    Messages:
    35
    Likes Received:
    5
    Trophy Points:
    8
    Location:
    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.
     
  3. Zabidin

    Zabidin Active Member

    Joined:
    Jan 6, 2016
    Messages:
    28
    Likes Received:
    1
    Trophy Points:
    1
    Location:
    Malaysia
    cPanel Access Level:
    Root Administrator
    As request:
    Code:
    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.
     
  4. sarath8372

    sarath8372 Active Member

    Joined:
    Jan 6, 2015
    Messages:
    35
    Likes Received:
    5
    Trophy Points:
    8
    Location:
    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.
     
  5. Zabidin

    Zabidin Active Member

    Joined:
    Jan 6, 2016
    Messages:
    28
    Likes Received:
    1
    Trophy Points:
    1
    Location:
    Malaysia
    cPanel Access Level:
    Root Administrator
    Code:
    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        |
    +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
    
    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.
    
     
  6. sarath8372

    sarath8372 Active Member

    Joined:
    Jan 6, 2015
    Messages:
    35
    Likes Received:
    5
    Trophy Points:
    8
    Location:
    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.
     
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  8. WorkinOnIt

    WorkinOnIt Well-Known Member

    Joined:
    Aug 3, 2016
    Messages:
    49
    Likes Received:
    1
    Trophy Points:
    8
    Location:
    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?
     
  9. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page