Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 560672 - dev-db/mariadb-10.1.7_rc complains about type mismatch and falls back on using transient stats
Summary: dev-db/mariadb-10.1.7_rc complains about type mismatch and falls back on usin...
Status: RESOLVED INVALID
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: All Linux
: Normal normal
Assignee: Gentoo Linux MySQL bugs team
URL: https://mariadb.atlassian.net/browse/...
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-09-16 22:50 UTC by Attila Tóth
Modified: 2015-09-17 00:00 UTC (History)
0 users

See Also:
Package list:
Runtime testing required: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Attila Tóth 2015-09-16 22:50:47 UTC
2015-09-17 00:31:55 3c786628700 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).
2015-09-17 00:31:55 3c786628700 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.

Reproducible: Always




Solution:
mysql> ALTER TABLE `mysql`.`innodb_table_stats`
        MODIFY `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;
mysql> ALTER TABLE `mysql`.`innodb_index_stats`
        MODIFY `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;

I haven't started mysql_upgrade, since it wasn't a major version bump.
Comment 1 Brian Evans (RETIRED) gentoo-dev 2015-09-17 00:00:52 UTC
You must run mysql_upgrade on every minor version change.  10.0 -> 10.1 requires it.

This has always been true for dev-db/mysql as well.  5.5 -> 5.6 and soon 5.6 -> 5.7