[MDEV-28417] Merge new release of InnoDB 5.7.38 to 10.2 - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Blocker
Resolution: Fixed
Affects Version/s: 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL)
Fix Version/s: 10.2.44, 10.3.35, 10.4.25, 10.5.16, 10.6.8, 10.7.4, 10.8.3, 10.9.1
Component/s: Storage Engine - InnoDB
Labels:
None

Description

MySQL 5.7.38 includes the following InnoDB changes:

Not applicable to MariaDB Server

BUG #33459653 : coredump after add index for partion table with ibd file missing
The included test case produces an error HA_ERR_TABLESPACE_MISSING from ha_innobase::open() for the missing data file of the partition.
The code fix is for the refactored MySQL 5.7 “native partitioning” (ha_innopart), which never existed in MariaDB Server.
Bug #33600109 Segmentation fault at ha_innobase::index_type, Improper code handling
This duplicates ~~MDEV-22928~~. No test case is included.
BUG #32586721 : SERVER CRASH IN FIL_SPACE_IS_BEING_TRUNCATED
The affected function fil_space_is_being_truncated() (which performs a redundant tablespace lookup) was removed from MariaDB as part of a fix of ~~MDEV-11202~~. The test case involves encrypted tablespaces, which Oracle implemented in MySQL 5.7 differently in response to MariaDB Server 10.1.

Applicable to MariaDB Server

Bug #33101844 CREATE FULLTEXT INDEX CRASHES SERVER FOR LARGE TABLE
Filed as ~~MDEV-28415~~.
Bug 26906787 - INCORRECT AUTO_INCREMENT IDS ISSUED WHEN CLOSE TO ULLONG_MAX
Filed as ~~MDEV-28416~~.

Attachments

Issue Links

blocks

MDEV-29165 Merge new release of InnoDB 5.7.39 to 10.3

Closed

includes

MDEV-28415 ALTER TABLE on a large table hangs InnoDB

Closed

MDEV-28416 Incorrect AUTO_INCREMENT may be issued when close to UINT64_MAX

Closed

is blocked by

MDEV-27539 Merge new release of InnoDB 5.7.37 to 10.2

Closed

Activity

Ascending order - Click to sort in descending order

Marko Mäkelä created issue - 2022-04-26 10:27

Marko Mäkelä made changes - 2022-04-26 10:27

Field	Original Value	New Value
Link		This issue is blocked by ~~MDEV-27539~~ [ ~~MDEV-27539~~ ]

Marko Mäkelä made changes - 2022-04-26 10:27

Link

This issue includes ~~MDEV-24815~~ [ ~~MDEV-24815~~ ]

Marko Mäkelä made changes - 2022-04-26 10:27

Link

This issue includes MDEV-24816 [ MDEV-24816 ]

Marko Mäkelä made changes - 2022-04-26 10:28

Component/s

Storage Engine - InnoDB [ 10129 ]

Marko Mäkelä made changes - 2022-04-26 10:40

Link

This issue includes ~~MDEV-28416~~ [ ~~MDEV-28416~~ ]

Marko Mäkelä made changes - 2022-04-26 10:40

Link

This issue includes ~~MDEV-28415~~ [ ~~MDEV-28415~~ ]

Marko Mäkelä made changes - 2022-04-26 10:40

Description

MySQL 5.7.38 includes the following InnoDB changes:

h2. Not applicable to MariaDB Server
[BUG #33459653 : coredump after add index for partion table with ibd file missing|https://github.com/mysql/mysql-server/commit/4e3e5030a27f9c75a52c546a961aafddb11571c6]
The included test case produces an error {{HA_ERR_TABLESPACE_MISSING}} from {{ha_innobase::open()}} for the missing data file of the partition.
The code fix is for the refactored MySQL 5.7 “native partitioning” ({{ha_innopart}}), which never existed in MariaDB Server.
[Bug #33600109 Segmentation fault at ha_innobase::index_type, Improper code handling|https://github.com/mysql/mysql-server/commit/0f5ba08e51cfbb66a3041add58f790fc28dd99d7
This duplicates ~~MDEV-22928~~. No test case is included.
[BUG #32586721 : SERVER CRASH IN FIL_SPACE_IS_BEING_TRUNCATED|https://github.com/mysql/mysql-server/commit/1df69b2aa278a706d241ffb34c085917423e1ca7]
The affected function {{fil_space_is_being_truncated()}} (which performs a redundant tablespace lookup) was [removed from MariaDB|https://github.com/MariaDB/server/commit/a1315a650a69745bac7166cfe1423215dfaac6e1] as part of a fix of ~~MDEV-11202~~. The test case involves encrypted tablespaces, which Oracle implemented in MySQL 5.7 differently in response to MariaDB Server 10.1.

h2. Applicable to MariaDB Server
[Bug #33101844 CREATE FULLTEXT INDEX CRASHES SERVER FOR LARGE TABLE|https://github.com/mysql/mysql-server/commit/9542f3015b00330ef537f6223565b28b82a5b325]
Filed as ~~MDEV-24815~~.
[Bug 26906787 - INCORRECT AUTO_INCREMENT IDS ISSUED WHEN CLOSE TO ULLONG_MAX|https://github.com/mysql/mysql-server/commit/1df69b2aa278a706d241ffb34c085917423e1ca7]
Filed as MDEV-24816.

MySQL 5.7.38 includes the following InnoDB changes:

h2. Not applicable to MariaDB Server
[BUG #33459653 : coredump after add index for partion table with ibd file missing|https://github.com/mysql/mysql-server/commit/4e3e5030a27f9c75a52c546a961aafddb11571c6]
The included test case produces an error {{HA_ERR_TABLESPACE_MISSING}} from {{ha_innobase::open()}} for the missing data file of the partition.
The code fix is for the refactored MySQL 5.7 “native partitioning” ({{ha_innopart}}), which never existed in MariaDB Server.
[Bug #33600109 Segmentation fault at ha_innobase::index_type, Improper code handling|https://github.com/mysql/mysql-server/commit/0f5ba08e51cfbb66a3041add58f790fc28dd99d7
This duplicates ~~MDEV-22928~~. No test case is included.
[BUG #32586721 : SERVER CRASH IN FIL_SPACE_IS_BEING_TRUNCATED|https://github.com/mysql/mysql-server/commit/1df69b2aa278a706d241ffb34c085917423e1ca7]
The affected function {{fil_space_is_being_truncated()}} (which performs a redundant tablespace lookup) was [removed from MariaDB|https://github.com/MariaDB/server/commit/a1315a650a69745bac7166cfe1423215dfaac6e1] as part of a fix of ~~MDEV-11202~~. The test case involves encrypted tablespaces, which Oracle implemented in MySQL 5.7 differently in response to MariaDB Server 10.1.

h2. Applicable to MariaDB Server
[Bug #33101844 CREATE FULLTEXT INDEX CRASHES SERVER FOR LARGE TABLE|https://github.com/mysql/mysql-server/commit/9542f3015b00330ef537f6223565b28b82a5b325]
Filed as ~~MDEV-28415~~.
[Bug 26906787 - INCORRECT AUTO_INCREMENT IDS ISSUED WHEN CLOSE TO ULLONG_MAX|https://github.com/mysql/mysql-server/commit/1df69b2aa278a706d241ffb34c085917423e1ca7]
Filed as ~~MDEV-28416~~.

Marko Mäkelä made changes - 2022-04-26 10:41

Link

This issue includes ~~MDEV-24815~~ [ ~~MDEV-24815~~ ]

Marko Mäkelä made changes - 2022-04-26 10:41

Link

This issue includes MDEV-24816 [ MDEV-24816 ]

Marko Mäkelä made changes - 2022-04-26 12:00

Status

Open [ 1 ]

In Progress [ 3 ]

Marko Mäkelä made changes - 2022-04-27 05:50

Fix Version/s		10.2.44 [ 27514 ]
Fix Version/s		10.3.35 [ 27512 ]
Fix Version/s		10.4.25 [ 27510 ]
Fix Version/s		10.5.16 [ 27508 ]
Fix Version/s		10.6.8 [ 27506 ]
Fix Version/s		10.7.4 [ 27504 ]
Fix Version/s		10.8.3 [ 27502 ]
Fix Version/s		10.9.1 [ 27114 ]
Fix Version/s	10.2 [ 14601 ]
Fix Version/s	10.3 [ 22126 ]
Fix Version/s	10.4 [ 22408 ]
Fix Version/s	10.5 [ 23123 ]
Fix Version/s	10.6 [ 24028 ]
Fix Version/s	10.7 [ 24805 ]
Fix Version/s	10.8 [ 26121 ]
Fix Version/s	10.9 [ 26905 ]
Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

Marko Mäkelä made changes - 2022-04-27 13:51

Description

MySQL 5.7.38 includes the following InnoDB changes:

h2. Not applicable to MariaDB Server
[BUG #33459653 : coredump after add index for partion table with ibd file missing|https://github.com/mysql/mysql-server/commit/4e3e5030a27f9c75a52c546a961aafddb11571c6]
The included test case produces an error {{HA_ERR_TABLESPACE_MISSING}} from {{ha_innobase::open()}} for the missing data file of the partition.
The code fix is for the refactored MySQL 5.7 “native partitioning” ({{ha_innopart}}), which never existed in MariaDB Server.
[Bug #33600109 Segmentation fault at ha_innobase::index_type, Improper code handling|https://github.com/mysql/mysql-server/commit/0f5ba08e51cfbb66a3041add58f790fc28dd99d7
This duplicates ~~MDEV-22928~~. No test case is included.
[BUG #32586721 : SERVER CRASH IN FIL_SPACE_IS_BEING_TRUNCATED|https://github.com/mysql/mysql-server/commit/1df69b2aa278a706d241ffb34c085917423e1ca7]
The affected function {{fil_space_is_being_truncated()}} (which performs a redundant tablespace lookup) was [removed from MariaDB|https://github.com/MariaDB/server/commit/a1315a650a69745bac7166cfe1423215dfaac6e1] as part of a fix of ~~MDEV-11202~~. The test case involves encrypted tablespaces, which Oracle implemented in MySQL 5.7 differently in response to MariaDB Server 10.1.

h2. Applicable to MariaDB Server
[Bug #33101844 CREATE FULLTEXT INDEX CRASHES SERVER FOR LARGE TABLE|https://github.com/mysql/mysql-server/commit/9542f3015b00330ef537f6223565b28b82a5b325]
Filed as ~~MDEV-28415~~.
[Bug 26906787 - INCORRECT AUTO_INCREMENT IDS ISSUED WHEN CLOSE TO ULLONG_MAX|https://github.com/mysql/mysql-server/commit/1df69b2aa278a706d241ffb34c085917423e1ca7]
Filed as ~~MDEV-28416~~.

MySQL 5.7.38 includes the following InnoDB changes:

h2. Not applicable to MariaDB Server
[BUG #33459653 : coredump after add index for partion table with ibd file missing|https://github.com/mysql/mysql-server/commit/4e3e5030a27f9c75a52c546a961aafddb11571c6]
The included test case produces an error {{HA_ERR_TABLESPACE_MISSING}} from {{ha_innobase::open()}} for the missing data file of the partition.
The code fix is for the refactored MySQL 5.7 “native partitioning” ({{ha_innopart}}), which never existed in MariaDB Server.
[Bug #33600109 Segmentation fault at ha_innobase::index_type, Improper code handling|https://github.com/mysql/mysql-server/commit/0f5ba08e51cfbb66a3041add58f790fc28dd99d7]
This duplicates ~~MDEV-22928~~. No test case is included.
[BUG #32586721 : SERVER CRASH IN FIL_SPACE_IS_BEING_TRUNCATED|https://github.com/mysql/mysql-server/commit/1df69b2aa278a706d241ffb34c085917423e1ca7]
The affected function {{fil_space_is_being_truncated()}} (which performs a redundant tablespace lookup) was [removed from MariaDB|https://github.com/MariaDB/server/commit/a1315a650a69745bac7166cfe1423215dfaac6e1] as part of a fix of ~~MDEV-11202~~. The test case involves encrypted tablespaces, which Oracle implemented in MySQL 5.7 differently in response to MariaDB Server 10.1.

h2. Applicable to MariaDB Server
[Bug #33101844 CREATE FULLTEXT INDEX CRASHES SERVER FOR LARGE TABLE|https://github.com/mysql/mysql-server/commit/9542f3015b00330ef537f6223565b28b82a5b325]
Filed as ~~MDEV-28415~~.
[Bug 26906787 - INCORRECT AUTO_INCREMENT IDS ISSUED WHEN CLOSE TO ULLONG_MAX|https://github.com/mysql/mysql-server/commit/1df69b2aa278a706d241ffb34c085917423e1ca7]
Filed as ~~MDEV-28416~~.

Marko Mäkelä made changes - 2022-07-26 06:15

Link

This issue blocks ~~MDEV-29165~~ [ ~~MDEV-29165~~ ]

People

Assignee:: Marko Mäkelä

Reporter:: Marko Mäkelä

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2022-04-26 10:27

Updated:: 2022-07-26 06:15

Resolved:: 2022-04-27 05:50

Git Integration

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