Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5151

mysql_upgrade does not fix "last_update" in "mysql.innodb_table_stats"

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.4
    • 10.0.13
    • None
    • None

    Description

      Started mariadb_10.0.4 with mysql_5.6.14 databaste. Server error log had lots of errors of course, so ran mysql_upgrade. Stopped and re-started server. Following messages still appear:

      2013-10-18 12:16:37 919fab40 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is BINARY(4) NOT NULL but should be INT UNSIGNED NOT NULL (flags mismatch).
      		 
      2013-10-18 12:16:37 919fab40 InnoDB: Error: Fetch of persistent statistics requested for table "mysql"."gtid_slave_pos" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
      		 
      131018 12:16:37 [Note] /usr/libexec/mysqld: ready for connections.
      		 
      Version: '10.0.4-MariaDB'  socket: '/var/run/mysql/mysql.sock'  port: 0  MariaDB Server
      		 
      2013-10-18 12:17:58 911fab40 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is BINARY(4) NOT NULL but should be INT UNSIGNED NOT NULL (flags mismatch).
      		 
      2013-10-18 12:17:58 911fab40 InnoDB: Error: Fetch of persistent statistics requested for table "CD_collection"."Album" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.

      Attachments

        1. mariadb_100004.tar.gz
          359 kB
          Duncan Roe
        2. mysql_50614.tar.gz
          363 kB
          Duncan Roe

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-6349 innodb_table_stats/innodb_index_stats broken after upgrade from 5.6

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30809 mysql_upgrade is not upgrading the type of last_update column for innodb_index_stats and innodb_table_stats tables

          • Major - Major loss of function.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-5010 InnoDB errors appearing in logs with upgrade from 10.0.0 to 10.0.4

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            People

              serg Sergei Golubchik
              duncan_roe Duncan Roe
              Votes:
              3 Vote for this issue
              Watchers:
              13 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.