Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.2.21, 10.3.17
-
None
Description
When importing a tablespace, especially when just having the .ibd tablespace file but no .cfg file, the import may fail with messages like:
2019-10-14 15:35:43 250 [Note] InnoDB: Phase I - Update all pages
|
2019-10-14 15:35:44 250 [Note] InnoDB: Sync to disk
|
2019-10-14 15:35:44 250 [Note] InnoDB: Sync to disk - done!
|
2019-10-14 15:35:44 250 [Note] InnoDB: Phase II - Purge records from index `Index_name`
|
2019-10-14 15:35:44 250 [ERROR] [FATAL] InnoDB: Trying to read page number 65200640 in space 574155, space name db/table, which is outside the tablespace bounds. Byte offset 0, len 16384
|
191014 15:35:44 [ERROR] mysqld got signal 6 ;
|
In such cases the import should simply be aborted, and the table left in DISCARD state.
Crashing the table due to a failed import doesn't look like a good idea as it is clear that the detected corruption is local to the not yet successfully imported table only
Attachments
Issue Links
- duplicates
-
-
- Closed
-
- is blocked by
-
-
- Closed
-
- relates to
-
-
- Closed
-
-
MDEV-20974 Don't require .cfg files to import InnoDB tablespaces
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Marko Mäkelä [ marko ] |
| Affects Version/s | 10.2.21 [ 23213 ] |
| Fix Version/s | 10.2 [ 14601 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Fix Version/s | 10.4 [ 22408 ] |
| Link |
This issue duplicates |
| Link |
This issue relates to |
| Assignee | Marko Mäkelä [ marko ] | Eugene Kosov [ kevg ] |
| Link |
This issue is blocked by |
| Summary | ALTER...IMPORT can crash the serve | ALTER...IMPORT can crash the server |
| Link |
This issue relates to |
| Priority | Major [ 3 ] | Critical [ 2 ] |
| Labels | ServiceNow |
| Labels | ServiceNow | 76qDvLB8Gju6Hs7nk3VY3EX42G795W5z |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Assignee | Eugene Kosov [ kevg ] | Marko Mäkelä [ marko ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Assignee | Marko Mäkelä [ marko ] | Eugene Kosov [ kevg ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Assignee | Eugene Kosov [ kevg ] | Marko Mäkelä [ marko ] |
| Status | Stalled [ 10000 ] | In Review [ 10002 ] |
| Assignee | Marko Mäkelä [ marko ] | Eugene Kosov [ kevg ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Assignee | Eugene Kosov [ kevg ] | Marko Mäkelä [ marko ] |
| Status | Stalled [ 10000 ] | In Review [ 10002 ] |
| Assignee | Marko Mäkelä [ marko ] | Eugene Kosov [ kevg ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Labels | 76qDvLB8Gju6Hs7nk3VY3EX42G795W5z |
| Fix Version/s | 10.2.41 [ 26032 ] | |
| Fix Version/s | 10.3.32 [ 26029 ] | |
| Fix Version/s | 10.4.22 [ 26031 ] | |
| Fix Version/s | 10.5.13 [ 26026 ] | |
| Fix Version/s | 10.6.5 [ 26034 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 100702 ] | MariaDB v4 [ 156921 ] |
| Zendesk Related Tickets | 201658 120960 201896 | |
| Zendesk active tickets | 201658 201896 |
| Zendesk active tickets | 201658 201896 | 201896 |