[MDEV-23163] Merge new release of InnoDB 5.7.31 to 10.2 Created: 2020-07-14  Updated: 2020-10-28  Resolved: 2020-07-14

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.2, 10.3, 10.4, 10.5
Fix Version/s: 10.2.33, 10.3.24, 10.4.14, 10.5.5

Type: Bug Priority: Blocker
Reporter: Marko Mäkelä Assignee: Marko Mäkelä
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
blocks MDEV-23989 Merge new release of InnoDB 5.7.32 to... Closed
is blocked by MDEV-22394 Merge new release of InnoDB 5.7.30 to... Closed
is blocked by MDEV-23161 avg_count_reset for monitor set owner... Closed
PartOf
is part of MDEV-23164 2020 Q3 release merge Closed

 Description   

MySQL 5.7.31 includes the following InnoDB changes:

Not applicable to MariaDB Server

Bug#30875956 : PURGE ACTIVITY IS TOO MUCH AT CPU% BOUND AND CAUSES IDLE OVERDRIVE (and a follow-up to wake up purge on ANALYZE TABLE)
This is adding conditions to the callers of srv_wake_purge_thread_if_not_active() and also adding some extra calls to that function. MDEV-11802 should already have fixed this.

Bug #29759555 INNODB: PAGE [PAGE ID: SPACE=1337, PAGE NUMBER=39] STILL FIXED OR DIRTY
This is fixing a regression that was introduced in MySQL 5.7.26. That change was not applicable to MariaDB. (MDEV-19342 explains that MDEV-11487 had removed the code from MariaDB.)

Bug #29451999 CRASH WITH RANGE QUERIES
This is yet another follow-up fix to Bug#23481444 OPTIMISER CALL ROW_SEARCH_MVCC() AND READ THE INDEX APPLIED BY UNCOMMITTED ROWS, which we chose not to apply to MariaDB already in MDEV-11751.

Bug #30770380 INNODB: IBUF CURSOR RESTORATION FAILS!
This change is suppressing an error message in the change buffer, related to the WL#6501 TRUNCATE TABLE implementation of MySQL 5.7. MDEV-13564 replaced that implementation. The error message is only possible in MariaDB 10.2 when using the non-default setting innodb_safe_truncate=OFF.

Applicable to MariaDB Server

Bug #98990 avg_count_reset for monitor set owner is always NULL in I_S.INNODB_METRICS
Filed as MDEV-23161.


Generated at Thu Feb 08 09:20:19 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.