Roundcube Error - Unknown storage engine InnoDB

Luana Premoli

Well-Known Member
Oct 3, 2016
59
6
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
 

Luana Premoli

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