[MDEV-30615] Can't read from I_S.INNODB_SYS_INDEXES when having a discarded tablesace - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.11.1, 10.4.28, 10.5.19, 10.6.12, 10.7.8, 10.8.7, 10.9.5, 10.10.3
Fix Version/s: 10.11.2, 10.4.29, 10.5.20, 10.6.13, 10.8.8, 10.9.6, 10.10.4
Component/s: Storage Engine - InnoDB
Labels:
- information_schema
- innodb

Description

When having a discarded tablespace it is not possible to read from INNODB_SYS_INDEXES, the below will fail with ERROR 1105 (HY000): Unknown error, and no further details in SHOW WARNINGS output or the error log.

CREATE TABLE test.t1(id INT PRIMARY KEY);

ALTER TABLE test.t1 DISCARD TABLESPACE;

SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_INDEXES;

Attachments

Issue Links

duplicates

MDEV-30616 Provide an easy way to list table currently in DISCARDED state.

Closed

relates to

MDEV-30616 Provide an easy way to list table currently in DISCARDED state.

Closed

Activity

Transition	Time In Source Status	Execution Times

Thirunarayanan Balathandayuthapani made transition - 2023-02-14 19:49

Open

In Progress

6d 5h

Thirunarayanan Balathandayuthapani made transition - 2023-02-14 19:50

In Progress

In Review

19s

Marko Mäkelä made transition - 2023-02-16 09:32

In Review

Stalled

1d 13h 42m

Thirunarayanan Balathandayuthapani made transition - 2023-02-16 10:57

Stalled

Closed

1h 24m

People

Assignee:: Thirunarayanan Balathandayuthapani

Reporter:: Hartmut Holzgraefe

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2023-02-08 14:49

Updated:: 2023-02-16 10:57

Resolved:: 2023-02-16 10:57

Git Integration

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

MariaDB Server