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

XML

Word

Printable

Details

Type: Bug
Status: In Testing (View Workflow)
Priority: Minor
Resolution: Unresolved
Affects Version/s: 10.5, 10.6, 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL)
Fix Version/s: 10.5, 10.6, 10.11
Component/s: None
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

links to

PR 2901

Activity

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:: 5 hours ago

Git Integration

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