Roundcube Error - Unknown storage engine InnoDB

Luana Premoli · Aug 23, 2018

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:

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:

Code:

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:

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:

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)

Code:

root@vps [~]# rpm -qa|grep roundcube
cpanel-roundcubemail-1.3.3-5.cp1164.noarch
root@vps [~]#

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:

 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 [~]#

Code:

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

cPanelMichael · Aug 24, 2018

Luana Premoli said:
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 · Aug 24, 2018

Hi,

Of course. See below.

Thanks

Code:

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

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 · Aug 27, 2018

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.

Thread starter	Similar threads	Forum	Replies	Date
B	Roundcube - sqlite DATABASE ERROR: CONNECTION FAILED!	Databases	8	Nov 2, 2020
	Roundcube database error	Databases	6	Sep 22, 2020
G	SOLVED [CPANEL-31773] RoundCube DATABASE ERROR: CONNECTION FAILED after cPanel update to 86.0.8	Databases	4	Mar 4, 2020
	Roundcube Database Error	Databases	2	Jun 7, 2014
R	11.24 Upgrade: Roundcube Database Connect Error	Databases	6	Dec 25, 2008

Search

Search

Roundcube Error - Unknown storage engine InnoDB

Luana Premoli

Well-Known Member

cPanelMichael

Administrator

Luana Premoli

Well-Known Member

cPanelMichael

Administrator