Roundcube Error - Unknown storage engine InnoDB

Luana Premoli

Well-Known Member
Oct 3, 2016
68
7
8
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
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,229
463
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.
 

Luana Premoli

Well-Known Member
Oct 3, 2016
68
7
8
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)
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,229
463
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.