Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.3.23
-
None
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).
Attachments
Issue Links
- duplicates
-
MDEV-24172 data structure tests for innodb_table_stats and innodb_index_stats incorrect
- Closed