MySQL Bugs: #67900: last_update not found mysql.innodb_table

Bug #67900	last_update not found mysql.innodb_table_stats
Submitted:	13 Dec 2012 19:20	Modified:	13 Dec 2012 20:18
Reporter:	Franjo Markovic	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S3 (Non-critical)
Version:	5.6.9	OS:	MacOS
Assigned to:		CPU Architecture:	Any

Description:
after upgrade from 5.6.4 to 5.6.9, I am getting the following messages in .err file:

InnoDB: Error: required column last_update not found in table "mysql"."innodb_table_stats".
 InnoDB: Error: Fetch of persistent statistics requested for table "mydb"."mytable" 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.

I did run mysql_upgrade immediately after install (and once again with --force after seeing these errors) but the "last update" column is not there. 

How to repeat:
upgrade existing database to 5.6.9; ignore installed "data" folder (and all databases inside) and replace back original "data" folder.

Suggested fix:
mysql_upgrade needs fix? It would be nice to have definitions of these tables more easily available. I remember having similar problem with these 2 tables (_table_stats and _index_stats) on previous upgrades too.

Thank you for the report.

Version 5.6.4 was a milestone release which has these notes at http://dev.mysql.com/doc/refman/5.6/en/news-5-6-4.html:

This is a milestone release, for use at your own risk. Significant development changes take place in milestone releases and you may encounter compatibility issues, such as data format changes that require attention in addition to the usual procedure of running mysql_upgrade. For example, you may find it necessary to dump your data with mysqldump before the upgrade and reload it afterward.

Upgrade 5.6.6 -> 5.6.9 works fine already. This is not a bug.