[MDEV-32919] Cannot select particular field from IS.tables in case table needs upgrade from MySQL 5.7 - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Minor
Resolution: Fixed
Affects Version/s: 10.5, 10.6, 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL)
Fix Version/s: 10.6.21, 10.11.11, 11.4.5, 11.7.2
Component/s: Information Schema
Labels:
None

Description

When selecting all fields we can get the table that needs to be upgraded (table that has MYSQL_JSON field).

MariaDB [(none)]> select * from information_schema.tables where table_comment LIKE 'Table rebuild required. Please do "ALTER TABLE %'\G

*************************** 1. row ***************************

   TABLE_CATALOG: def

    TABLE_SCHEMA: test

      TABLE_NAME: t

      TABLE_TYPE: BASE TABLE

          ENGINE: NULL

         VERSION: NULL

      ROW_FORMAT: NULL

      TABLE_ROWS: NULL

  AVG_ROW_LENGTH: NULL

     DATA_LENGTH: NULL

 MAX_DATA_LENGTH: NULL

    INDEX_LENGTH: NULL

       DATA_FREE: NULL

  AUTO_INCREMENT: NULL

     CREATE_TIME: NULL

     UPDATE_TIME: NULL

      CHECK_TIME: NULL

 TABLE_COLLATION: NULL

        CHECKSUM: NULL

  CREATE_OPTIONS: NULL

   TABLE_COMMENT: Table rebuild required. Please do "ALTER TABLE `test.t` FORCE" or dump/reload to fix it!

MAX_INDEX_LENGTH: NULL

       TEMPORARY: NULL

1 row in set, 50 warnings (0.055 sec)

MariaDB [(none)]> show warnings;

+---------+------+----------------------------------------------------------------------------------------------------------------------------------------------------------+

| Level   | Code | Message                                                                                                                                                  |

+---------+------+----------------------------------------------------------------------------------------------------------------------------------------------------------+

| Warning | 1707 | Table rebuild required. Please do "ALTER TABLE `test.t` FORCE" or dump/reload to fix it!                                                                 |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1356 | View 'sys.metrics' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them                            |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

| Warning | 1558 | Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50744, now running 100524. Please use mariadb-upgrade to fix this error |

+---------+------+----------------------------------------------------------------------------------------------------------------------------------------------------------+

50 rows in set (0.001 sec)

However when selecting single field it doesn't work

MariaDB [(none)]> select table_comment from information_schema.tables where table_comment LIKE 'Table rebuild required. Please do "ALTER TABLE %'\G

Empty set (0.016 sec)

MariaDB [(none)]> show warnings;

Empty set (0.000 sec)

Only error message is raised on server with above query

2023-11-30 14:19:48 12 [ERROR] mariadbd: Table rebuild required. Please do "ALTER TABLE `test.t` FORCE" or dump/reload to fix it!

Attachments

Issue Links

causes

MDEV-35943 ASAN errors in Query_arena::free_items / fill_schema_table_from_frm

Closed

links to

PR 2901

Activity

There are no comments yet on this issue.

People

Assignee:: Sergei Golubchik

Reporter:: Anel Husakovic

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2023-11-30 14:24

Updated:: 2025-01-26 17:28

Resolved:: 2025-01-09 11:15

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server