Skip to main content

Roundcube Error - Unknown storage engine InnoDB

Luana Premoli
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: [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: root@vps [/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 root@vps [/var/lib/mysql]#
MySQL engines: root@vps [/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 | +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+ root@vps [/var/lib/mysql]#
In the MySQL log when restarting the service is shown: 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: root@vps [~]# 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)
root@vps [~]# rpm -qa|grep roundcube cpanel-roundcubemail-1.3.3-5.cp1164.noarch root@vps [~]#
Nothing is shown by executing the command: mysql -e "SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'roundcube' AND engine = 'InnoDB';"
root@vps [~]# mysql -e "SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'roundcube' AND engine = 'Myisam';" +-------------------+ | TABLE_NAME | +-------------------+ | cp_schema_version | +-------------------+ root@vps [~]#
root@vps [~]# 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 root@vps [~]#
Commands that we already execute: mysql -e "set password for roundcube@localhost = 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

Comments

3 comments

Date Votes
  • cPanelMichael
    innodb_force_recovery=5

    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.
    0
  • Luana Premoli
    Hi, Of course. See below. Thanks root@vps [~]# 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
    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)
    0
  • cPanelMichael
    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: Please go through this resource and let us know if you have any questions. Thank you.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post