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!

Roundcube Error - Unknown storage engine InnoDB

Discussion in 'Database Discussion' started by Luana Premoli, Aug 23, 2018.

  1. Luana Premoli

    Luana Premoli Well-Known Member

    Joined:
    Oct 3, 2016
    Messages:
    55
    Likes Received:
    5
    Trophy Points:
    8
    Location:
    São Paulo/Brazil
    cPanel Access Level:
    Root Administrator
    Hi,

    When accessing the RoundCube webmail error message is displayed in the browser:

    DATABASE ERROR: CONNECTION FAILED!
    Unable to connect to the database!
    Please contact your server-administrator.

    In /var/cpanel/roundcube/log/errors is shown:

    Code:
    [23-Aug-2018 09:25:57 -0300]: <9qct9rqj> DB Error: SQLSTATE[28000] [1045] Access denied for user 'roundcube'@'localhost' (using password: YES) in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 175 (GET /cpsess9985262176/3rdparty/roundcube/index.php)
    [23-Aug-2018 09:25:57 -0300]: <9qct9rqj> DB Error: SQLSTATE[28000] [1045] Access denied for user 'roundcube'@'localhost' (using password: YES) (GET /cpsess9985262176/3rdparty/roundcube/index.php)
    
    When checking the roundCube database, it is shown:

    Code:
    [email protected] [/var/lib/mysql]# mysqlcheck 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.cp_schema_version                        OK
    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
    [email protected] [/var/lib/mysql]#

    MySQL engines:

    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       |
    +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
    [email protected] [/var/lib/mysql]#
    In the MySQL log when restarting the service is shown:

    Code:
    180823  9:31:28 [Note] /usr/sbin/mysqld: Shutdown complete
    
    
    
    
    
    180823  9:31:35 [Note] Plugin 'FEDERATED' is disabled.
    180823  9:31:35 InnoDB: The InnoDB memory heap is disabled
    180823  9:31:35 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    180823  9:31:35 InnoDB: Compressed tables use zlib 1.2.3
    180823  9:31:35 InnoDB: Using Linux native AIO
    180823  9:31:35 InnoDB: Initializing buffer pool, size = 128.0M
    180823  9:31:36 InnoDB: Completed initialization of buffer pool
    InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes
    InnoDB: than specified in the .cnf file 0 5242880 bytes!
    180823  9:31:36 [ERROR] Plugin 'InnoDB' init function returned error.
    180823  9:31:36 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    180823  9:31:36 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    180823  9:31:36 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    180823  9:31:36 [Note] Server socket created on IP: '0.0.0.0'.
    
    180823  9:31:36 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mysql/tables_priv.frm'
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'THREAD_ID' at position 0 to have type int(11), found type bigint(20) unsigned.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'EVENT_NAME' at position 2, found 'END_EVENT_ID'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'EVENT_NAME' at position 2 to have type varchar(128), found type bigint(20) unsigned.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'SOURCE' at position 3, found 'EVENT_NAME'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'SOURCE' at position 3 to have type varchar(64), found type varchar(128).
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'TIMER_START' at position 4, found 'SOURCE'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'TIMER_START' at position 4 to have type bigint(20), found type varchar(64).
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'TIMER_END' at position 5, found 'TIMER_START'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'TIMER_WAIT' at position 6, found 'TIMER_END'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'SPINS' at position 7, found 'TIMER_WAIT'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'SPINS' at position 7 to have type int(10), found type bigint(20) unsigned.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'OBJECT_SCHEMA' at position 8, found 'SPINS'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'OBJECT_SCHEMA' at position 8 to have type varchar(64), found type int(10) unsigned.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'OBJECT_NAME' at position 9, found 'OBJECT_SCHEMA'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'OBJECT_NAME' at position 9 to have type varchar(512), found type varchar(64).
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'OBJECT_TYPE' at position 10, found 'OBJECT_NAME'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'OBJECT_TYPE' at position 10 to have type varchar(64), found type varchar(512).
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'OBJECT_INSTANCE_BEGIN' at position 11, found 'INDEX_NAME'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'OBJECT_INSTANCE_BEGIN' at position 11 to have type bigint(20), found type varchar(64).
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'NESTING_EVENT_ID' at position 12, found 'OBJECT_TYPE'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'NESTING_EVENT_ID' at position 12 to have type bigint(20), found type varchar(64).
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'OPERATION' at position 13, found 'OBJECT_INSTANCE_BEGIN'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'OPERATION' at position 13 to have type varchar(16), found type bigint(20) unsigned.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'NUMBER_OF_BYTES' at position 14, found 'NESTING_EVENT_ID'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'FLAGS' at position 15, found 'NESTING_EVENT_TYPE'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'FLAGS' at position 15 to have type int(10), found type enum('STATEMENT','STAGE','WAIT').
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'THREAD_ID' at position 0 to have type int(11), found type bigint(20) unsigned.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'EVENT_NAME' at position 2, found 'END_EVENT_ID'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'EVENT_NAME' at position 2 to have type varchar(128), found type bigint(20) unsigned.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'SOURCE' at position 3, found 'EVENT_NAME'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'SOURCE' at position 3 to have type varchar(64), found type varchar(128).
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'TIMER_START' at position 4, found 'SOURCE'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'TIMER_START' at position 4 to have type bigint(20), found type varchar(64).
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'TIMER_END' at position 5, found 'TIMER_START'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'TIMER_WAIT' at position 6, found 'TIMER_END'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'SPINS' at position 7, found 'TIMER_WAIT'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'SPINS' at position 7 to have type int(10), found type bigint(20) unsigned.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'OBJECT_SCHEMA' at position 8, found 'SPINS'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'OBJECT_SCHEMA' at position 8 to have type varchar(64), found type int(10) unsigned.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'OBJECT_NAME' at position 9, found 'OBJECT_SCHEMA'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'OBJECT_NAME' at position 9 to have type varchar(512), found type varchar(64).
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'OBJECT_TYPE' at position 10, found 'OBJECT_NAME'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'OBJECT_TYPE' at position 10 to have type varchar(64), found type varchar(512).
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'OBJECT_INSTANCE_BEGIN' at position 11, found 'INDEX_NAME'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'OBJECT_INSTANCE_BEGIN' at position 11 to have type bigint(20), found type varchar(64).
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'NESTING_EVENT_ID' at position 12, found 'OBJECT_TYPE'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'NESTING_EVENT_ID' at position 12 to have type bigint(20), found type varchar(64).
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'OPERATION' at position 13, found 'OBJECT_INSTANCE_BEGIN'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'OPERATION' at position 13 to have type varchar(16), found type bigint(20) unsigned.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'NUMBER_OF_BYTES' at position 14, found 'NESTING_EVENT_ID'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'FLAGS' at position 15, found 'NESTING_EVENT_TYPE'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'FLAGS' at position 15 to have type int(10), found type enum('STATEMENT','STAGE','WAIT').
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'THREAD_ID' at position 0 to have type int(11), found type bigint(20) unsigned.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'EVENT_NAME' at position 2, found 'END_EVENT_ID'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'EVENT_NAME' at position 2 to have type varchar(128), found type bigint(20) unsigned.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'SOURCE' at position 3, found 'EVENT_NAME'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'SOURCE' at position 3 to have type varchar(64), found type varchar(128).
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'TIMER_START' at position 4, found 'SOURCE'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'TIMER_START' at position 4 to have type bigint(20), found type varchar(64).
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'TIMER_END' at position 5, found 'TIMER_START'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'TIMER_WAIT' at position 6, found 'TIMER_END'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'SPINS' at position 7, found 'TIMER_WAIT'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'SPINS' at position 7 to have type int(10), found type bigint(20) unsigned.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'OBJECT_SCHEMA' at position 8, found 'SPINS'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'OBJECT_SCHEMA' at position 8 to have type varchar(64), found type int(10) unsigned.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'OBJECT_NAME' at position 9, found 'OBJECT_SCHEMA'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'OBJECT_NAME' at position 9 to have type varchar(512), found type varchar(64).
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'OBJECT_TYPE' at position 10, found 'OBJECT_NAME'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'OBJECT_TYPE' at position 10 to have type varchar(64), found type varchar(512).
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'OBJECT_INSTANCE_BEGIN' at position 11, found 'INDEX_NAME'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'OBJECT_INSTANCE_BEGIN' at position 11 to have type bigint(20), found type varchar(64).
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'NESTING_EVENT_ID' at position 12, found 'OBJECT_TYPE'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'NESTING_EVENT_ID' at position 12 to have type bigint(20), found type varchar(64).
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'OPERATION' at position 13, found 'OBJECT_INSTANCE_BEGIN'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'OPERATION' at position 13 to have type varchar(16), found type bigint(20) unsigned.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'NUMBER_OF_BYTES' at position 14, found 'NESTING_EVENT_ID'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'FLAGS' at position 15, found 'NESTING_EVENT_TYPE'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'FLAGS' at position 15 to have type int(10), found type enum('STATEMENT','STAGE','WAIT').
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.threads: expected column 'THREAD_ID' at position 0 to have type int(11), found type bigint(20) unsigned.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.threads: expected column 'PROCESSLIST_ID' at position 1, found 'NAME'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.threads: expected column 'PROCESSLIST_ID' at position 1 to have type int(11), found type varchar(128).
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.threads: expected column 'NAME' at position 2, found 'TYPE'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.threads: expected column 'NAME' at position 2 to have type varchar(128), found type varchar(10).
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_thread_by_event_name: expected column 'THREAD_ID' at position 0 to have type int(11), found type bigint(20) unsigned.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.file_summary_by_event_name: expected column 'COUNT_READ' at position 1, found 'COUNT_STAR'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.file_summary_by_event_name: expected column 'COUNT_WRITE' at position 2, found 'SUM_TIMER_WAIT'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.file_summary_by_event_name: expected column 'SUM_NUMBER_OF_BYTES_READ' at position 3, found 'MIN_TIMER_WAIT'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.file_summary_by_event_name: expected column 'SUM_NUMBER_OF_BYTES_WRITE' at position 4, found 'AVG_TIMER_WAIT'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.file_summary_by_instance: expected column 'COUNT_READ' at position 2, found 'OBJECT_INSTANCE_BEGIN'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.file_summary_by_instance: expected column 'COUNT_WRITE' at position 3, found 'COUNT_STAR'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.file_summary_by_instance: expected column 'SUM_NUMBER_OF_BYTES_READ' at position 4, found 'SUM_TIMER_WAIT'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.file_summary_by_instance: expected column 'SUM_NUMBER_OF_BYTES_WRITE' at position 5, found 'MIN_TIMER_WAIT'.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.mutex_instances: expected column 'LOCKED_BY_THREAD_ID' at position 2 to have type int(11), found type bigint(20) unsigned.
    180823  9:31:36 [ERROR] Incorrect definition of table performance_schema.rwlock_instances: expected column 'WRITE_LOCKED_BY_THREAD_ID' at position 2 to have type int(11), found type bigint(20) unsigned.
    180823  9:31:36 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mysql/event.frm'
    180823  9:31:36 [ERROR] Cannot open mysql.event
    180823  9:31:36 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
    180823  9:31:36 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.59-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    
    
    The versions are:

    Code:
    [email protected] [~]# grep '' /usr/local/cpanel/version && grep '' /var/cpanel/roundcube/version && mysql --version && cat /etc/[A-Za-z]*[_-][rv]e[lr]*
    11.72.0.11
    1.3.3-5.cp1164
    mysql  Ver 14.14 Distrib 5.5.59, for Linux (x86_64) using readline 5.1
    CentOS release 6.10 (Final)
    

    Code:
    [email protected] [~]# rpm -qa|grep roundcube
    cpanel-roundcubemail-1.3.3-5.cp1164.noarch
    [email protected] [~]#


    Nothing is shown by executing the command:

    Code:
    mysql -e "SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'roundcube' AND engine = 'InnoDB';"

    Code:
     [email protected] [~]# mysql -e "SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'roundcube' AND engine = 'Myisam';"
    +-------------------+
    | TABLE_NAME        |
    +-------------------+
    | cp_schema_version |
    +-------------------+
    [email protected] [~]# 

    Code:
    [email protected] [~]# grep innodb /etc/my.cnf
    innodb_file_per_table=1 # Ensure that each innodb table is it's own binary data block just in case there's corruption.
    #innodb_flush_method=O_DSYNC # Do not enable this without a good reason - it doesn't work well on new dedis
    innodb_buffer_pool_size=128M # check mysql -e "SHOW GLOBAL STATUS LIKE 'Innodb_buffer_pool%';" - free vs total
    innodb_thread_concurrency=4 # Number of physical + virtual CPU's, be careful of adding more
    innodb_io_capacity=100
    innodb_force_recovery=5
    [email protected] [~]#

    Commands that we already execute:

    mysql -e "set password for [email protected] = password('*********');"
    /scripts/upcp --force
    /scripts/check_cpanel_rpms --fix
    /usr/local/cpanel/bin/update-roundcube --force
    rpm -e --nodeps cpanel-roundcubemail


    What else can we do?

    Thanks
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,525
    Likes Received:
    2,180
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @Luana Premoli,

    This line is typically only utilized when attempting to repair InnoDB tables. Can you let us know the output to the MySQL error log upon restarting MySQL when this line is not present in the /etc/my.cnf file?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Luana Premoli

    Luana Premoli Well-Known Member

    Joined:
    Oct 3, 2016
    Messages:
    55
    Likes Received:
    5
    Trophy Points:
    8
    Location:
    São Paulo/Brazil
    cPanel Access Level:
    Root Administrator
    Hi,

    Of course. See below.

    Thanks


    Code:
    [email protected] [~]# grep innodb /etc/my.cnf
    innodb_file_per_table=1 # Ensure that each innodb table is it's own binary data block just in case there's corruption.
    #innodb_flush_method=O_DSYNC # Do not enable this without a good reason - it doesn't work well on new dedis
    innodb_buffer_pool_size=128M # check mysql -e "SHOW GLOBAL STATUS LIKE 'Innodb_buffer_pool%';" - free vs total
    innodb_thread_concurrency=4 # Number of physical + virtual CPU's, be careful of adding more
    innodb_io_capacity=100
    #innodb_force_recovery=1
    


    Code:
    180824 16:49:08 [Note] /usr/sbin/mysqld: Normal shutdown
    
    180824 16:49:08 [Note] /usr/sbin/mysqld: Shutdown complete
    
    180824 16:49:10 [Note] Plugin 'FEDERATED' is disabled.
    180824 16:49:10 InnoDB: The InnoDB memory heap is disabled
    180824 16:49:10 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    180824 16:49:10 InnoDB: Compressed tables use zlib 1.2.3
    180824 16:49:10 InnoDB: Using Linux native AIO
    180824 16:49:10 InnoDB: Initializing buffer pool, size = 128.0M
    180824 16:49:10 InnoDB: Completed initialization of buffer pool
    InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes
    InnoDB: than specified in the .cnf file 0 5242880 bytes!
    180824 16:49:10 [ERROR] Plugin 'InnoDB' init function returned error.
    180824 16:49:10 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    180824 16:49:10 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    180824 16:49:10 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    180824 16:49:10 [Note] Server socket created on IP: '0.0.0.0'.
    180824 16:49:10 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mysql/tables_priv.frm'
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'THREAD_ID' at position 0 to have type int(11), found type bigint(20) unsigned.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'EVENT_NAME' at position 2, found 'END_EVENT_ID'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'EVENT_NAME' at position 2 to have type varchar(128), found type bigint(20) unsigned.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'SOURCE' at position 3, found 'EVENT_NAME'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'SOURCE' at position 3 to have type varchar(64), found type varchar(128).
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'TIMER_START' at position 4, found 'SOURCE'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'TIMER_START' at position 4 to have type bigint(20), found type varchar(64).
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'TIMER_END' at position 5, found 'TIMER_START'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'TIMER_WAIT' at position 6, found 'TIMER_END'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'SPINS' at position 7, found 'TIMER_WAIT'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'SPINS' at position 7 to have type int(10), found type bigint(20) unsigned.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'OBJECT_SCHEMA' at position 8, found 'SPINS'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'OBJECT_SCHEMA' at position 8 to have type varchar(64), found type int(10) unsigned.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'OBJECT_NAME' at position 9, found 'OBJECT_SCHEMA'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'OBJECT_NAME' at position 9 to have type varchar(512), found type varchar(64).
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'OBJECT_TYPE' at position 10, found 'OBJECT_NAME'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'OBJECT_TYPE' at position 10 to have type varchar(64), found type varchar(512).
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'OBJECT_INSTANCE_BEGIN' at position 11, found 'INDEX_NAME'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'OBJECT_INSTANCE_BEGIN' at position 11 to have type bigint(20), found type varchar(64).
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'NESTING_EVENT_ID' at position 12, found 'OBJECT_TYPE'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'NESTING_EVENT_ID' at position 12 to have type bigint(20), found type varchar(64).
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'OPERATION' at position 13, found 'OBJECT_INSTANCE_BEGIN'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'OPERATION' at position 13 to have type varchar(16), found type bigint(20) unsigned.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'NUMBER_OF_BYTES' at position 14, found 'NESTING_EVENT_ID'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'FLAGS' at position 15, found 'NESTING_EVENT_TYPE'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'FLAGS' at position 15 to have type int(10), found type enum('STATEMENT','STAGE','WAIT').
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'THREAD_ID' at position 0 to have type int(11), found type bigint(20) unsigned.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'EVENT_NAME' at position 2, found 'END_EVENT_ID'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'EVENT_NAME' at position 2 to have type varchar(128), found type bigint(20) unsigned.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'SOURCE' at position 3, found 'EVENT_NAME'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'SOURCE' at position 3 to have type varchar(64), found type varchar(128).
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'TIMER_START' at position 4, found 'SOURCE'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'TIMER_START' at position 4 to have type bigint(20), found type varchar(64).
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'TIMER_END' at position 5, found 'TIMER_START'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'TIMER_WAIT' at position 6, found 'TIMER_END'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'SPINS' at position 7, found 'TIMER_WAIT'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'SPINS' at position 7 to have type int(10), found type bigint(20) unsigned.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'OBJECT_SCHEMA' at position 8, found 'SPINS'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'OBJECT_SCHEMA' at position 8 to have type varchar(64), found type int(10) unsigned.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'OBJECT_NAME' at position 9, found 'OBJECT_SCHEMA'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'OBJECT_NAME' at position 9 to have type varchar(512), found type varchar(64).
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'OBJECT_TYPE' at position 10, found 'OBJECT_NAME'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'OBJECT_TYPE' at position 10 to have type varchar(64), found type varchar(512).
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'OBJECT_INSTANCE_BEGIN' at position 11, found 'INDEX_NAME'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'OBJECT_INSTANCE_BEGIN' at position 11 to have type bigint(20), found type varchar(64).
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'NESTING_EVENT_ID' at position 12, found 'OBJECT_TYPE'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'NESTING_EVENT_ID' at position 12 to have type bigint(20), found type varchar(64).
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'OPERATION' at position 13, found 'OBJECT_INSTANCE_BEGIN'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'OPERATION' at position 13 to have type varchar(16), found type bigint(20) unsigned.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'NUMBER_OF_BYTES' at position 14, found 'NESTING_EVENT_ID'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'FLAGS' at position 15, found 'NESTING_EVENT_TYPE'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'FLAGS' at position 15 to have type int(10), found type enum('STATEMENT','STAGE','WAIT').
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'THREAD_ID' at position 0 to have type int(11), found type bigint(20) unsigned.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'EVENT_NAME' at position 2, found 'END_EVENT_ID'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'EVENT_NAME' at position 2 to have type varchar(128), found type bigint(20) unsigned.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'SOURCE' at position 3, found 'EVENT_NAME'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'SOURCE' at position 3 to have type varchar(64), found type varchar(128).
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'TIMER_START' at position 4, found 'SOURCE'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'TIMER_START' at position 4 to have type bigint(20), found type varchar(64).
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'TIMER_END' at position 5, found 'TIMER_START'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'TIMER_WAIT' at position 6, found 'TIMER_END'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'SPINS' at position 7, found 'TIMER_WAIT'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'SPINS' at position 7 to have type int(10), found type bigint(20) unsigned.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'OBJECT_SCHEMA' at position 8, found 'SPINS'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'OBJECT_SCHEMA' at position 8 to have type varchar(64), found type int(10) unsigned.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'OBJECT_NAME' at position 9, found 'OBJECT_SCHEMA'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'OBJECT_NAME' at position 9 to have type varchar(512), found type varchar(64).
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'OBJECT_TYPE' at position 10, found 'OBJECT_NAME'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'OBJECT_TYPE' at position 10 to have type varchar(64), found type varchar(512).
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'OBJECT_INSTANCE_BEGIN' at position 11, found 'INDEX_NAME'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'OBJECT_INSTANCE_BEGIN' at position 11 to have type bigint(20), found type varchar(64).
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'NESTING_EVENT_ID' at position 12, found 'OBJECT_TYPE'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'NESTING_EVENT_ID' at position 12 to have type bigint(20), found type varchar(64).
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'OPERATION' at position 13, found 'OBJECT_INSTANCE_BEGIN'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'OPERATION' at position 13 to have type varchar(16), found type bigint(20) unsigned.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'NUMBER_OF_BYTES' at position 14, found 'NESTING_EVENT_ID'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'FLAGS' at position 15, found 'NESTING_EVENT_TYPE'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'FLAGS' at position 15 to have type int(10), found type enum('STATEMENT','STAGE','WAIT').
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.threads: expected column 'THREAD_ID' at position 0 to have type int(11), found type bigint(20) unsigned.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.threads: expected column 'PROCESSLIST_ID' at position 1, found 'NAME'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.threads: expected column 'PROCESSLIST_ID' at position 1 to have type int(11), found type varchar(128).
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.threads: expected column 'NAME' at position 2, found 'TYPE'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.threads: expected column 'NAME' at position 2 to have type varchar(128), found type varchar(10).
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_thread_by_event_name: expected column 'THREAD_ID' at position 0 to have type int(11), found type bigint(20) unsigned.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.file_summary_by_event_name: expected column 'COUNT_READ' at position 1, found 'COUNT_STAR'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.file_summary_by_event_name: expected column 'COUNT_WRITE' at position 2, found 'SUM_TIMER_WAIT'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.file_summary_by_event_name: expected column 'SUM_NUMBER_OF_BYTES_READ' at position 3, found 'MIN_TIMER_WAIT'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.file_summary_by_event_name: expected column 'SUM_NUMBER_OF_BYTES_WRITE' at position 4, found 'AVG_TIMER_WAIT'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.file_summary_by_instance: expected column 'COUNT_READ' at position 2, found 'OBJECT_INSTANCE_BEGIN'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.file_summary_by_instance: expected column 'COUNT_WRITE' at position 3, found 'COUNT_STAR'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.file_summary_by_instance: expected column 'SUM_NUMBER_OF_BYTES_READ' at position 4, found 'SUM_TIMER_WAIT'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.file_summary_by_instance: expected column 'SUM_NUMBER_OF_BYTES_WRITE' at position 5, found 'MIN_TIMER_WAIT'.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.mutex_instances: expected column 'LOCKED_BY_THREAD_ID' at position 2 to have type int(11), found type bigint(20) unsigned.
    180824 16:49:10 [ERROR] Incorrect definition of table performance_schema.rwlock_instances: expected column 'WRITE_LOCKED_BY_THREAD_ID' at position 2 to have type int(11), found type bigint(20) unsigned.
    180824 16:49:10 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mysql/event.frm'
    180824 16:49:10 [ERROR] Cannot open mysql.event
    180824 16:49:10 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
    180824 16:49:10 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.59-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,525
    Likes Received:
    2,180
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @Luana Premoli,

    It looks like there is some InnoDB corruption that you will need to address. We provide a resource with information on how to repair InnoDB at:

    Tutorial - InnoDB Corruption Repair Guide

    Please go through this resource and let us know if you have any questions.

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

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