Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-23636

mysql_upgrade [ERROR] InnoDB: Fetch of persistent statistics requested for table

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 10.3.23
    • Fix Version/s: 10.3.28
    • Component/s: Server
    • Labels:
      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

            Activity

              People

              Assignee:
              danblack Daniel Black
              Reporter:
              ralee LEESORA
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration