Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1809

Document mysql_upgrade requirement as part of the upgrade process

    XMLWordPrintable

    Details

    • 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.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              LinuxJedi Andrew Hutchings (Inactive)
              Reporter:
              Richard Richard Stracke
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.