[MDEV-32919] Cannot select particular field from IS.tables in case table needs upgrade from MySQL 5.7 Created: 2023-11-30  Updated: 2023-12-06

Status: In Review
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.5, 10.6, 10.11, 11.0, 11.1, 11.2
Fix Version/s: 10.5, 10.6, 10.11, 11.0, 11.1, 11.2

Type: Bug Priority: Minor
Reporter: Anel Husakovic Assignee: Vicențiu Ciorbaru
Resolution: Unresolved Votes: 0
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!


Generated at Thu Feb 08 10:35:01 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.