MySQL InnoDB errors after upgrade to 5.7

cosmin

Well-Known Member
Feb 6, 2002
158
3
318
Bucuresti
Hi!

I migrate yesterday from MySQL 5.6 to 5.7 and now mysqld.log is full of
Code:
2018-06-21T04:42:53.199836Z 56591 [ERROR] InnoDB: Page [page id: space=121028, page number=3] log sequence number 298657981840 is in the future! Current system log sequence number 216198248.
2018-06-21T04:42:53.199866Z 56591 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to MySQL :: MySQL 5.7 Reference Manual :: 14.21.2 Forcing InnoDB Recovery for information about forcing recovery.
and if I want to change passowrd of a mysql user I get
Code:
The system received an error from the “MySQL” database “mysql”: ER_BAD_FIELD_ERROR (Unknown column 'password_lifetime' in 'field list')
I see in phpMyAdmin on mysql db:

innodb_index_stats, innodb_table_stats, slave_master_info, slave_relay_log_info, slave_worker_info are all "in use". I try to remove than from /var/lib/mysql/mysql and import structure from other server with mysql5.7 but without success.

Any ideea here?

Many many thanks!
 
Last edited by a moderator:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,218
463
Hello,

The error message suggests InnoDB is corrupted. The link provided in the previous post includes information about how to repair InnoDB.

Thank you.