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

mysql56-temporal-format=off creates incorrect innodb stats tables

    XMLWordPrintable

Details

    Description

      mysql56-temporal-format had been disabled in MariaDB 10.1.17 environment. This seemed to work fine, but then the following errors around the innodb persistent statistics tables were observed in the MySQL error logs:

      InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
      

      I think this is related to mysql56-temporal-format=off - checking the tables I do see "MYSQL_TYPE_TIMESTAMP" rather than MYSQL_TYPE_TIMESTAMP I reenabled this option, recreated just these tables and these log messages went away and the tables are being populated as expected.

      Attachments

        Activity

          People

            Unassigned Unassigned
            andrew.garner Andrew Garner
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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