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

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

              Dates

              • Created:
                Updated: