[MDEV-30655] IMPORT TABLESPACE fails with column count or index count mismatch - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.4.18, 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.6.18, 10.11.8, 11.0.6, 11.2.4, 11.1.5
Component/s: Documentation, Storage Engine - InnoDB
Labels:
None

Description

When trying to import a table from a mariabackup taken from a 10.4.18 instance using mariabackup --prepare --export and ALTER TABLE ... IMPORT TABLESPACE I'm getting

ERROR 1808 (HY000): Schema mismatch (Number of columns don't match, table has 9 columns but the tablespace meta-data file has 10 columns)

when importing into 10.4.18 to 10.4.22; and for later versions, all the way up to 10.11

ERROR 1808 (HY000): Schema mismatch (Number of indexes don't match, table has 5 indexes but the tablespace meta-data file has 6 indexes)

Attachments

Issue Links

causes

MDEV-35059 ALTER TABLE...IMPORT TABLESPACE with FULLTEXT SEARCH may corrupt the adaptive hash index

Closed

DOCSCOLLAB-851 Loading...

relates to

MDEV-38391 Memory leak in innodb.import_hidden_fts_debug

Closed

Activity

People

Assignee:: Thirunarayanan Balathandayuthapani

Reporter:: Hartmut Holzgraefe

Votes:: 1 Vote for this issue

Watchers:: 9 Start watching this issue

Dates

Created:: 2023-02-15 11:29

Updated:: 2025-12-19 07:28

Resolved:: 2024-02-20 16:05

Time Tracking

Estimated:

Remaining:

Logged:

13d 7.5h

Git Integration

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