MySQL Forums
Forum List  »  InnoDB

Re: innodb_table_stats appears to be reporting bogus errors "length mismatch"
Posted by: Glenn Schworak
Date: December 20, 2018 09:47PM

Nope, I ended up rebuilding the database from scratch. But now, that stupid issue is back!!!!

InnoDB: Column table_name in table `mysql`.`innodb_table_stats` is VARCHAR(576) NOT NULL but should be VARCHAR(192) NOT NULL (length mismatch).

But that is not true.

show create table `mysql`.`innodb_table_stats`


CREATE TABLE `innodb_table_stats` (
`database_name` varchar(64) COLLATE utf8_bin NOT NULL,
`table_name` varchar(192) COLLATE utf8_bin NOT NULL,
`last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`n_rows` bigint(20) unsigned NOT NULL,
`clustered_index_size` bigint(20) unsigned NOT NULL,
`sum_of_other_index_sizes` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`database_name`,`table_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0


So that error is totally fake.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: innodb_table_stats appears to be reporting bogus errors "length mismatch"
369
December 20, 2018 09:47PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.