MySQL InnoDB errors after upgrade to 5.7
Hi!
I migrate yesterday from MySQL 5.6 to 5.7 and now mysqld.log is full of
and if I want to change passowrd of a mysql user I get
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!
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!
-
follow the guide You need to proceed with innodb recovery. 0 -
Hello, The error message suggests InnoDB is corrupted. The link provided in the previous post includes information about how to repair InnoDB. Thank you. 0
Please sign in to leave a comment.
Comments
2 comments