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

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.11.8, 10.6.18, 11.0.6, 11.1.5, 11.2.4
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 Failed to load

Activity

Ascending order - Click to sort in descending order

Hartmut Holzgraefe created issue - 2023-02-15 11:29

Thirunarayanan Balathandayuthapani made changes - 2023-02-15 18:33

Field	Original Value	New Value
Assignee		Thirunarayanan Balathandayuthapani [ thiru ]

Thirunarayanan Balathandayuthapani made changes - 2023-02-16 06:27

Assignee

Thirunarayanan Balathandayuthapani [ thiru ]

Ian Gilfillan [ greenman ]

Julien Fritsch made changes - 2023-02-27 08:23

Assignee

Ian Gilfillan [ greenman ]

Anne Strasser [ annestrasser ]

Julien Fritsch made changes - 2023-02-28 12:54

Fix Version/s		10.4 [ 22408 ]
Fix Version/s		10.5 [ 23123 ]
Fix Version/s		10.6 [ 24028 ]

Julien Fritsch made changes - 2023-02-28 12:54

Fix Version/s		10.7 [ 24805 ]
Fix Version/s		10.8 [ 26121 ]
Fix Version/s		10.9 [ 26905 ]
Fix Version/s		10.10 [ 27530 ]
Fix Version/s		10.11 [ 27614 ]

Julien Fritsch made changes - 2023-02-28 12:54

Component/s

Documentation [ 10903 ]

Julien Fritsch made changes - 2023-03-03 17:30

Fix Version/s

10.7 [ 24805 ]

Julien Fritsch made changes - 2023-03-27 12:36

Priority

Major [ 3 ]

Critical [ 2 ]

Anne Strasser (Inactive) made changes - 2023-04-12 15:39

Remote Link

This issue links to "DOCSCOLLAB-851 (Jira)" [ 35205 ]

Anne Strasser (Inactive) made changes - 2023-04-12 15:41

Remote Link

This issue links to "DOCS-3511 (Jira)" [ 35206 ]

Julien Fritsch made changes - 2023-04-27 14:51

Fix Version/s

10.8 [ 26121 ]

Julien Fritsch made changes - 2023-05-25 06:23

Remote Link

This issue links to "DOCS-3511 (Jira)" [ 35206 ]

Julien Fritsch made changes - 2023-06-02 15:40

Fix Version/s		N/A [ 14700 ]
Fix Version/s	10.4 [ 22408 ]
Fix Version/s	10.5 [ 23123 ]
Fix Version/s	10.6 [ 24028 ]
Fix Version/s	10.9 [ 26905 ]
Fix Version/s	10.10 [ 27530 ]
Fix Version/s	10.11 [ 27614 ]
Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Closed [ 6 ]

Hartmut Holzgraefe made changes - 2023-12-11 19:19

Assignee	Anne Strasser [ annestrasser ]
Resolution	Fixed [ 1 ]
Status	Closed [ 6 ]	Stalled [ 10000 ]

Julien Fritsch made changes - 2023-12-11 19:23

Assignee

Marko Mäkelä [ marko ]

Julien Fritsch made changes - 2023-12-11 19:23

Fix Version/s		10.4 [ 22408 ]
Fix Version/s		10.5 [ 23123 ]
Fix Version/s		10.6 [ 24028 ]
Fix Version/s	N/A [ 14700 ]

Marko Mäkelä made changes - 2023-12-19 16:27

Assignee

Marko Mäkelä [ marko ]

Thirunarayanan Balathandayuthapani [ thiru ]

Thirunarayanan Balathandayuthapani made changes - 2024-01-08 11:10

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Thirunarayanan Balathandayuthapani made changes - 2024-01-30 10:53

Assignee	Thirunarayanan Balathandayuthapani [ thiru ]	Marko Mäkelä [ marko ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Marko Mäkelä made changes - 2024-01-31 09:27

Assignee	Marko Mäkelä [ marko ]	Thirunarayanan Balathandayuthapani [ thiru ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Thirunarayanan Balathandayuthapani made changes - 2024-02-06 09:16

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Thirunarayanan Balathandayuthapani made changes - 2024-02-06 09:16

Assignee	Thirunarayanan Balathandayuthapani [ thiru ]	Marko Mäkelä [ marko ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Marko Mäkelä made changes - 2024-02-12 16:27

Assignee	Marko Mäkelä [ marko ]	Thirunarayanan Balathandayuthapani [ thiru ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Thirunarayanan Balathandayuthapani made changes - 2024-02-15 15:37

Status

Stalled [ 10000 ]

In Testing [ 10301 ]

Thirunarayanan Balathandayuthapani made changes - 2024-02-15 15:37

Assignee

Thirunarayanan Balathandayuthapani [ thiru ]

Matthias Leich [ mleich ]

Matthias Leich made changes - 2024-02-19 14:28

Assignee	Matthias Leich [ mleich ]	Thirunarayanan Balathandayuthapani [ thiru ]
Status	In Testing [ 10301 ]	Stalled [ 10000 ]

Thirunarayanan Balathandayuthapani made changes - 2024-02-20 16:05

Fix Version/s		10.6.18 [ 29627 ]
Fix Version/s	10.4 [ 22408 ]
Fix Version/s	10.5 [ 23123 ]
Fix Version/s	10.6 [ 24028 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

JiraAutomate made changes - 2024-02-20 16:05

Fix Version/s		10.11.8 [ 29630 ]
Fix Version/s		11.0.6 [ 29628 ]
Fix Version/s		11.1.5 [ 29629 ]
Fix Version/s		11.2.4 [ 29631 ]

Jira Automation (IT) made changes - 2024-07-04 01:12

Zendesk Related Tickets

182126

Marko Mäkelä made changes - 2024-10-02 07:54

Link

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

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:: 2024-10-02 08:09

Resolved:: 2024-02-20 16:05

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