[MDEV-23636] mysql_upgrade [ERROR] InnoDB: Fetch of persistent statistics requested for table Created: 2020-09-01  Updated: 2021-03-12  Resolved: 2021-03-12

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.3.23
Fix Version/s: 10.3.28

Type: Bug Priority: Major
Reporter: LEESORA Assignee: Daniel Black
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MDEV-24172 data structure tests for innodb_table... Closed

 Description   

The following error occurred after version upgrade
Upgraded to 10.3.23
Why did an error occur?

===================================================
ERROR LOG
2020-08-13 0:27:12 6 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2020-08-13 0:27:12 6 [ERROR] InnoDB: Column last_update in table `mysql`.`innodb_table_stats` is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type
mismatch).
2020-08-13 0:27:12 6 [ERROR] InnoDB: Fetch of persistent statistics requested for table `mysql`.`gtid_slave_pos` but the required system tables mysql.innodb_t
able_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2020-08-13 0:27:12 0 [Note] Server socket created on IP: '::'.
2020-08-13 0:27:12 0 [Warning] 'proxies_priv' entry '@% root@server01' ignored in --skip-name-resolve mode.
2020-08-13 0:27:12 0 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_C
ONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL',
'DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_T
ABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDEN
CE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','EMPTY_STRING_IS_NULL','SIMULTANEOUS_ASSIGNMENT'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANS
I_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXD
B','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_V...
2020-08-13 0:27:12 0 [ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
2020-08-13 0:27:12 0 [Note] /home/sigongweb/server/mysql/bin/mysqld: ready for connections.
Version: '10.3.23-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 MariaDB Server
2020-08-13 0:27:12 0 [Note] InnoDB: Buffer pool(s) load completed at 200813 0:27:12
2020-08-13 0:27:22 60 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2020-08-13 0:27:22 60 [ERROR] InnoDB: Column last_update in table `mysql`.`innodb_table_stats` is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type
mismatch).
2020-08-13 0:27:22 60 [ERROR] InnoDB: Fetch of persistent statistics requested for table `database1`.`table1` but the required system tables mysql.inno
db_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2020-08-13 0:27:22 60 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2020-08-13 0:27:22 60 [ERROR] InnoDB: Column last_update in table `mysql`.`innodb_table_stats` is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type
mismatch).
2020-08-13 0:27:22 60 [ERROR] InnoDB: Fetch of persistent statistics requested for table `edubank`.`table2` 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.
2020-08-13 0:27:22 60 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2020-08-13 0:27:22 60 [ERROR] InnoDB: Column last_update in table `mysql`.`innodb_table_stats` is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type
mismatch).



 Comments   
Comment by Daniel Black [ 2021-03-12 ]

MDEV-24172, now closed fixes innodb_*_stats.

Generated at Thu Feb 08 09:23:54 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.