[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

Ascending order - Click to sort in descending order

Anel Husakovic created issue - 2023-11-30 14:24

Sergei Golubchik made changes - 2023-12-04 19:28

Field	Original Value	New Value
Affects Version/s		10.4 [ 22408 ]
Affects Version/s		10.5 [ 23123 ]
Affects Version/s		10.6 [ 24028 ]
Affects Version/s		10.11 [ 27614 ]
Affects Version/s		11.0 [ 28320 ]
Affects Version/s		11.1 [ 28549 ]
Affects Version/s		11.2 [ 28603 ]

Sergei Golubchik made changes - 2023-12-04 19:28

Fix Version/s		10.4 [ 22408 ]
Fix Version/s		10.5 [ 23123 ]
Fix Version/s		10.6 [ 24028 ]
Fix Version/s		10.11 [ 27614 ]
Fix Version/s		11.0 [ 28320 ]
Fix Version/s		11.1 [ 28549 ]
Fix Version/s		11.2 [ 28603 ]

Sergei Golubchik made changes - 2023-12-04 19:28

Assignee

Anel Husakovic [ anel ]

Sergei Golubchik made changes - 2023-12-04 19:28

Priority

Major [ 3 ]

Minor [ 4 ]

Anel Husakovic made changes - 2023-12-05 06:21

Status

Open [ 1 ]

In Progress [ 3 ]

Anel Husakovic made changes - 2023-12-06 06:20

Assignee	Anel Husakovic [ anel ]	Vicențiu Ciorbaru [ cvicentiu ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Anel Husakovic made changes - 2023-12-06 06:20

Remote Link

This issue links to "PR 2901 (Web Link)" [ 36318 ]

Anel Husakovic made changes - 2023-12-06 06:21

Fix Version/s	10.4 [ 22408 ]
Affects Version/s	10.4 [ 22408 ]

Julien Fritsch made changes - 2024-05-03 14:41

Fix Version/s

11.0 [ 28320 ]

Julien Fritsch made changes - 2024-09-10 15:28

Fix Version/s

11.1 [ 28549 ]

Sergei Golubchik made changes - 2024-11-16 17:19

Assignee

Vicențiu Ciorbaru [ cvicentiu ]

Sergei Golubchik [ serg ]

Sergei Golubchik made changes - 2024-11-16 17:42

Status

In Review [ 10002 ]

In Testing [ 10301 ]

Julien Fritsch made changes - 2024-11-22 17:12

Fix Version/s

11.2(EOL) [ 28603 ]

Sergei Golubchik made changes - 2025-01-09 11:15

Component/s		Authentication and Privilege System [ 13101 ]
Component/s		Information Schema [ 14413 ]
Fix Version/s		10.6.21 [ 29953 ]
Fix Version/s		10.11.11 [ 29954 ]
Fix Version/s		11.4.5 [ 29956 ]
Fix Version/s		11.7.2 [ 29914 ]
Fix Version/s	10.5 [ 23123 ]
Fix Version/s	10.6 [ 24028 ]
Fix Version/s	10.11 [ 27614 ]
Resolution		Fixed [ 1 ]
Status	In Testing [ 10301 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2025-01-09 11:18

Component/s

Authentication and Privilege System [ 13101 ]

Elena Stepanova made changes - 2025-01-26 17:28

Link

This issue causes ~~MDEV-35943~~ [ ~~MDEV-35943~~ ]

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

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration