Details
-
Type:
Task
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 1.1.6
-
Component/s: Documentation
-
Labels:None
-
Sprint: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.