[MCOL-1809] Document mysql_upgrade requirement as part of the upgrade process Created: 2018-10-16  Updated: 2020-08-25  Resolved: 2018-11-23

Status: Closed
Project: MariaDB ColumnStore
Component/s: Documentation
Affects Version/s: 1.1.6
Fix Version/s: 1.2.1, 1.2.2

Type: Task Priority: Major
Reporter: Richard Stracke Assignee: Andrew Hutchings (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Duplicate
is duplicated by MCOL-1657 Drop table crashes crashes the server... Closed
is duplicated by MCOL-1827 mysql_upgrade needs to be part of our... Closed
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.

 Comments   
Comment by Andrew Hutchings (Inactive) [ 2018-11-19 ]

This is done for 1.2.1 upgrade documentation. It still needs doing for 1.1

Comment by David Hill (Inactive) [ 2018-11-21 ]

This was done by Patrick for the 1.2.1 release

Comment by Andrew Hutchings (Inactive) [ 2018-11-21 ]

Reopening. As stated in a previous comment the 1.1 upgrade docs still need updating.

Comment by Andrew Hutchings (Inactive) [ 2018-11-23 ]

Now applied to the 1.1.5->1.1.6 upgrade documentation

Generated at Thu Feb 08 02:31:32 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.