Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.1.6
-
None
-
2018-20
Description
After upgrade to 1.1.6 the following error message occured in the mysql error log.
[Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
|
Root cause is a important change in MySQL 5.7.23
Important Change; Partitioning: After creating partitioned InnoDB tables with very long names, the table_name columns in the corresponding entries in the mysql.innodb_index_stats and mysql.innodb_table_stats system tables were truncated. To fix this issue, the length of the table_name column in each of these tables has been increased from 64 to 199 characters. |
https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-23.html |
MCS 1.1.6 based on MariaDB 10.217
MariaDB 10.2.17 Release Notes
"InnoDB updated to 5.7.23 "
So I suggest to add an additional point
mysql_upgrade
for the
upgrade description.