MySQL InnoDB errors after upgrade to 5.7

[cosmin]

Hi!

I migrate yesterday from MySQL 5.6 to 5.7 and now mysqld.log is full of

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

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!

 

[sktest123]

follow the guide Tutorial - InnoDB Corruption Repair Guide
You need to proceed with innodb recovery.

 

[cPanelMichael]

Hello,

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

Thank you.