Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

check_mysql has determined that there are corrupted database tables

Discussion in 'Database Discussion' started by calamus, Apr 11, 2016.

  1. calamus

    calamus Member

    Joined:
    Sep 30, 2011
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Root Administrator
    I recive form cPanel this email and round cube does't work

    Code:
    cPanel & WHM has determined that the following database tables are corrupt:
    
    Database   Error
    mysql   mysql.gtid_slave_pos
    Error  : Table 'mysql.gtid_slave_pos' doesn't exist in engine
    mysql.innodb_index_stats
    Error  : Table 'mysql.innodb_index_stats' doesn't exist in engine
    mysql.innodb_table_stats
    Error  : Table 'mysql.innodb_table_stats' doesn't exist in engine
    mysql.slave_master_info
    Error  : Table 'mysql.slave_master_info' doesn't exist in engine
    mysql.slave_relay_log_info
    Error  : Table 'mysql.slave_relay_log_info' doesn't exist in engine
    mysql.slave_worker_info
    Error  : Table 'mysql.slave_worker_info' doesn't exist in engine
    roundcube   roundcube.cache
    Error  : Table 'roundcube.cache' doesn't exist in engine
    roundcube.cache_index
    Error  : Table 'roundcube.cache_index' doesn't exist in engine
    roundcube.cache_messages
    Error  : Table 'roundcube.cache_messages' doesn't exist in engine
    roundcube.cache_shared
    Error  : Table 'roundcube.cache_shared' doesn't exist in engine
    roundcube.cache_thread
    Error  : Table 'roundcube.cache_thread' doesn't exist in engine
    roundcube.contactgroupmembers
    Error  : Table 'roundcube.contactgroupmembers' doesn't exist in engine
    roundcube.contactgroups
    Error  : Table 'roundcube.contactgroups' doesn't exist in engine
    roundcube.contacts
    Error  : Table 'roundcube.contacts' doesn't exist in engine
    roundcube.dictionary
    Error  : Table 'roundcube.dictionary' doesn't exist in engine
    roundcube.identities
    Error  : Table 'roundcube.identities' doesn't exist in engine
    roundcube.searches
    Error  : Table 'roundcube.searches' doesn't exist in engine
    roundcube.session
    Error  : Table 'roundcube.session' doesn't exist in engine
    roundcube.system
    Error  : Table 'roundcube.system' doesn't exist in engine
    roundcube.users
    Error  : Table 'roundcube.users' doesn't exist in engine
    horde   horde.content_schema_info
    Error  : Table 'horde.content_schema_info' doesn't exist in engine
    horde.horde_alarm_schema_info
    Error  : Table 'horde.horde_alarm_schema_info' doesn't exist in engine
    horde.horde_auth_schema_info
    Error  : Table 'horde.horde_auth_schema_info' doesn't exist in engine
    horde.horde_cache_schema_info
    Error  : Table 'horde.horde_cache_schema_info' doesn't exist in engine
    horde.horde_core_schema_info
    Error  : Table 'horde.horde_core_schema_info' doesn't exist in engine
    horde.horde_dav_collections
    Error  : Table 'horde.horde_dav_collections' doesn't exist in engine
    horde.horde_dav_objects
    Error  : Table 'horde.horde_dav_objects' doesn't exist in engine
    horde.horde_dav_schema_info
    Error  : Table 'horde.horde_dav_schema_info' doesn't exist in engine
    horde.horde_group_schema_info
    Error  : Table 'horde.horde_group_schema_info' doesn't exist in engine
    horde.horde_histories_modseq
    Error  : Table 'horde.horde_histories_modseq' doesn't exist in engine
    horde.horde_history_schema_info
    Error  : Table 'horde.horde_history_schema_info' doesn't exist in engine
    horde.horde_imap_client_data
    Error  : Table 'horde.horde_imap_client_data' doesn't exist in engine
    horde.horde_imap_client_message
    Error  : Table 'horde.horde_imap_client_message' doesn't exist in engine
    horde.horde_imap_client_metadata
    Error  : Table 'horde.horde_imap_client_metadata' doesn't exist in engine
    horde.horde_imap_client_schema_info
    Error  : Table 'horde.horde_imap_client_schema_info' doesn't exist in engine
    horde.horde_lock_schema_info
    Error  : Table 'horde.horde_lock_schema_info' doesn't exist in engine
    horde.horde_muvfs
    Error  : Table 'horde.horde_muvfs' doesn't exist in engine
    horde.horde_perms_schema_info
    Error  : Table 'horde.horde_perms_schema_info' doesn't exist in engine
    horde.horde_prefs_schema_info
    Error  : Table 'horde.horde_prefs_schema_info' doesn't exist in engine
    horde.horde_queue_schema_info
    Error  : Table 'horde.horde_queue_schema_info' doesn't exist in engine
    horde.horde_queue_tasks
    Error  : Table 'horde.horde_queue_tasks' doesn't exist in engine
    horde.horde_sessionhandler
    Error  : Table 'horde.horde_sessionhandler' doesn't exist in engine
    horde.horde_sessionhandler_schema_info
    Error  : Table 'horde.horde_sessionhandler_schema_info' doesn't exist in engine
    horde.horde_syncml_schema_info
    Error  : Table 'horde.horde_syncml_schema_info' doesn't exist in engine
    horde.horde_token_schema_info
    Error  : Table 'horde.horde_token_schema_info' doesn't exist in engine
    horde.horde_vfs_schema_info
    Error  : Table 'horde.horde_vfs_schema_info' doesn't exist in engine
    horde.imp_schema_info
    Error  : Table 'horde.imp_schema_info' doesn't exist in engine
    horde.ingo_schema_info
    Error  : Table 'horde.ingo_schema_info' doesn't exist in engine
    horde.ingo_sharesng
    Error  : Table 'horde.ingo_sharesng' doesn't exist in engine
    horde.ingo_sharesng_groups
    Error  : Table 'horde.ingo_sharesng_groups' doesn't exist in engine
    horde.ingo_sharesng_users
    Error  : Table 'horde.ingo_sharesng_users' doesn't exist in engine
    horde.kronolith_events_geo
    Error  : Table 'horde.kronolith_events_geo' doesn't exist in engine
    horde.kronolith_events_mysqlgeo
    Error  : Table 'horde.kronolith_events_mysqlgeo' doesn't exist in engine
    horde.kronolith_resources
    Error  : Table 'horde.kronolith_resources' doesn't exist in engine
    horde.kronolith_schema_info
    Error  : Table 'horde.kronolith_schema_info' doesn't exist in engine
    horde.kronolith_sharesng
    Error  : Table 'horde.kronolith_sharesng' doesn't exist in engine
    horde.kronolith_sharesng_groups
    Error  : Table 'horde.kronolith_sharesng_groups' doesn't exist in engine
    horde.kronolith_sharesng_users
    Error  : Table 'horde.kronolith_sharesng_users' doesn't exist in engine
    horde.mnemo_schema_info
    Error  : Table 'horde.mnemo_schema_info' doesn't exist in engine
    horde.mnemo_sharesng
    Error  : Table 'horde.mnemo_sharesng' doesn't exist in engine
    horde.mnemo_sharesng_groups
    Error  : Table 'horde.mnemo_sharesng_groups' doesn't exist in engine
    horde.mnemo_sharesng_users
    Error  : Table 'horde.mnemo_sharesng_users' doesn't exist in engine
    horde.nag_schema_info
    Error  : Table 'horde.nag_schema_info' doesn't exist in engine
    horde.nag_sharesng
    Error  : Table 'horde.nag_sharesng' doesn't exist in engine
    horde.nag_sharesng_groups
    Error  : Table 'horde.nag_sharesng_groups' doesn't exist in engine
    horde.nag_sharesng_users
    Error  : Table 'horde.nag_sharesng_users' doesn't exist in engine
    horde.rampage_objects
    Error  : Table 'horde.rampage_objects' doesn't exist in engine
    horde.rampage_tag_stats
    Error  : Table 'horde.rampage_tag_stats' doesn't exist in engine
    horde.rampage_tagged
    Error  : Table 'horde.rampage_tagged' doesn't exist in engine
    horde.rampage_tags
    Error  : Table 'horde.rampage_tags' doesn't exist in engine
    horde.rampage_types
    Error  : Table 'horde.rampage_types' doesn't exist in engine
    horde.rampage_user_tag_stats
    Error  : Table 'horde.rampage_user_tag_stats' doesn't exist in engine
    horde.rampage_users
    Error  : Table 'horde.rampage_users' doesn't exist in engine
    horde.trean_bookmarks
    Error  : Table 'horde.trean_bookmarks' doesn't exist in engine
    horde.trean_schema_info
    Error  : Table 'horde.trean_schema_info' doesn't exist in engine
    horde.turba_schema_info
    Error  : Table 'horde.turba_schema_info' doesn't exist in engine
    horde.turba_sharesng
    Error  : Table 'horde.turba_sharesng' doesn't exist in engine
    horde.turba_sharesng_groups
    Error  : Table 'horde.turba_sharesng_groups' doesn't exist in engine
    horde.turba_sharesng_users
    Error  : Table 'horde.turba_sharesng_users' doesn't exist in engine
    munin_innodb   munin_innodb.sample_table
    Error  : Table 'munin_innodb.sample_table' doesn't exist in engine
    We recommend that you repair these tables with WHM’s Repair a MySQL/MariaDB Database interface at: example.com:2087/scripts/repairmysqllist If the repair fails, contact cPanel Support for further assistance.
    
    Try repair the table but this is the output:
    Code:
    Repairing roundcube
    roundcube.cache
    Error    : Table 'roundcube.cache' doesn't exist in engine
    status   : Operation failed
    roundcube.cache_index
    Error    : Table 'roundcube.cache_index' doesn't exist in engine
    status   : Operation failed
    roundcube.cache_messages
    Error    : Table 'roundcube.cache_messages' doesn't exist in engine
    status   : Operation failed
    roundcube.cache_shared
    Error    : Table 'roundcube.cache_shared' doesn't exist in engine
    status   : Operation failed
    roundcube.cache_thread
    Error    : Table 'roundcube.cache_thread' doesn't exist in engine
    status   : Operation failed
    roundcube.contactgroupmembers
    Error    : Table 'roundcube.contactgroupmembers' doesn't exist in engine
    status   : Operation failed
    roundcube.contactgroups
    Error    : Table 'roundcube.contactgroups' doesn't exist in engine
    status   : Operation failed
    roundcube.contacts
    Error    : Table 'roundcube.contacts' doesn't exist in engine
    status   : Operation failed
    roundcube.cp_schema_version                        OK
    roundcube.dictionary
    Error    : Table 'roundcube.dictionary' doesn't exist in engine
    status   : Operation failed
    roundcube.identities
    Error    : Table 'roundcube.identities' doesn't exist in engine
    status   : Operation failed
    roundcube.searches
    Error    : Table 'roundcube.searches' doesn't exist in engine
    status   : Operation failed
    roundcube.session
    Error    : Table 'roundcube.session' doesn't exist in engine
    status   : Operation failed
    roundcube.system
    Error    : Table 'roundcube.system' doesn't exist in engine
    status   : Operation failed
    roundcube.users
    Error    : Table 'roundcube.users' doesn't exist in engine
    status   : Operation failed
    
    Done.
    
    
    Please help
    Thanks
    Piero

    Solved for roudcube, horde and munin table width this guide:
    blog.triantech.com/tag/check_mysql-has-determined-that-there-are-corrupted-database-tables/

    mysql table still corrupted
     
    #1 calamus, Apr 11, 2016
    Last edited by a moderator: Apr 11, 2016
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,758
    Likes Received:
    1,886
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello :)

    Could you let us know the contents of your /etc/my.cnf file?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. calamus

    calamus Member

    Joined:
    Sep 30, 2011
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Root Administrator
    [mysqld]
    max_allowed_packet=268435456
    open_files_limit=10000

    default-storage-engine=MyISAM
    innodb_file_per_table=1

    default configuration
     
    #3 calamus, Apr 12, 2016
    Last edited by a moderator: Apr 12, 2016
  4. calamus

    calamus Member

    Joined:
    Sep 30, 2011
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Root Administrator
    still corrupted mysql table
    this is the report sent via email from cpanel


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

    Database Error
    mysql mysql.gtid_slave_pos
    Error : Table 'mysql.gtid_slave_pos' doesn't exist in engine
    mysql.innodb_index_stats
    Error : Table 'mysql.innodb_index_stats' doesn't exist in engine
    mysql.innodb_table_stats
    Error : Table 'mysql.innodb_table_stats' doesn't exist in engine
    mysql.slave_master_info
    Error : Table 'mysql.slave_master_info' doesn't exist in engine
    mysql.slave_relay_log_info
    Error : Table 'mysql.slave_relay_log_info' doesn't exist in engine
    mysql.slave_worker_info
    Error : Table 'mysql.slave_worker_info' doesn't exist in engine
     
  5. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,758
    Likes Received:
    1,886
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Yes, you will continue to receive that email until the "mysql" database is repaired. Could you let us know of any error messages logged to /var/lib/mysql/$hostname.err when restarting MySQL? Also, have you recently upgraded to MariaDB? Does the "mysql_upgrade" command succeed?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. calamus

    calamus Member

    Joined:
    Sep 30, 2011
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Root Administrator
    Yes, I upgrade to MariaDB afther the problem.

    below the log of error file
    Code:
    160413 08:39:17 mysqld_safe mysqld from pid file /var/lib/mysql/srv10.example.com.pid ended
    160413 08:39:18 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    2016-04-13  8:39:18 139668595525664 [Note] /usr/sbin/mysqld (mysqld 10.1.13-MariaDB) starting as process 14176 ...
    2016-04-13  8:39:19 139668595525664 [Note] InnoDB: Using mutexes to ref count buffer pool pages
    2016-04-13  8:39:19 139668595525664 [Note] InnoDB: The InnoDB memory heap is disabled
    2016-04-13  8:39:19 139668595525664 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2016-04-13  8:39:19 139668595525664 [Note] InnoDB: Memory barrier is not used
    2016-04-13  8:39:19 139668595525664 [Note] InnoDB: Compressed tables use zlib 1.2.3
    2016-04-13  8:39:19 139668595525664 [Note] InnoDB: Using Linux native AIO
    2016-04-13  8:39:19 139668595525664 [Note] InnoDB: Using generic crc32 instructions
    2016-04-13  8:39:19 139668595525664 [Note] InnoDB: Initializing buffer pool, size = 128.0M
    2016-04-13  8:39:19 139668595525664 [Note] InnoDB: Completed initialization of buffer pool
    2016-04-13  8:39:19 139668595525664 [Note] InnoDB: Highest supported file format is Barracuda.
    2016-04-13  8:39:19 139668595525664 [Note] InnoDB: 128 rollback segment(s) are active.
    2016-04-13  8:39:19 139668595525664 [Note] InnoDB: Waiting for purge to start
    2016-04-13  8:39:19 139668595525664 [Note] InnoDB:  Percona XtraDB (Experts in Database Performance Management) 5.6.28-76.1 started; log sequence number 42838$
    2016-04-13  8:39:19 139668595525664 [Note] Plugin 'FEEDBACK' is disabled.
    2016-04-13  8:39:19 139667861141248 [Note] InnoDB: Dumping buffer pool(s) not yet started
    2016-04-13  8:39:19 139668595525664 [Note] Server socket created on IP: '::'.
    2016-04-13  8:39:19 139668594559744 [Warning] InnoDB: Cannot open table mysql/gtid_slave_pos from the internal data dictionary of InnoDB t$
    2016-04-13  8:39:19 139668594559744 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1932: Table 'mysql.g$
    2016-04-13  8:39:19 139668595525664 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '10.1.13-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
    
     
    #6 calamus, Apr 13, 2016
    Last edited by a moderator: Apr 13, 2016
  7. calamus

    calamus Member

    Joined:
    Sep 30, 2011
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Root Administrator
    and this is the prompt of mysql restart:

    Code:
    Service Status
       mysql (/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/srv10.example.com.err --open-files-limit=10000 --pid-file=/var/lib/mysql/srv10.example.com.pid) is running as mysql with PID 14176 (pidfile check method).
    
    Startup Log
       Starting MySQL.. SUCCESS!
    
    Log Messages
       2016-04-13  8:39:19 139668595525664 [Note] /usr/sbin/mysqld: ready for connections.
       160413 08:39:18 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
       160413 08:39:17 mysqld_safe mysqld from pid file /var/lib/mysql/srv10.example.com.pid ended
    
    
     
    #7 calamus, Apr 13, 2016
    Last edited by a moderator: Apr 13, 2016
  8. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,758
    Likes Received:
    1,886
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    The following thread is offered for users with InnoDB corruption:

    InnoDB Corruption Repair Guide

    Please review this thread to determine if any of the steps offered are helpful.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice