Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4.3, 10.5.0
Description
The recently added test innodb.innodb_wl6326 hangs in 10.4, because a query
SELECT a00,a01 FROM t1 WHERE a00 = 'cp'; |
causes ha_innobase::records_in_range() to be called with min_key=NULL. No secondary indexes have been defined on the table; only PRIMARY KEY(a00,a01,a02,a03,a04,a05,a06).
That section of the test is demonstrating that only some pages of the table are supposed to be latched.
The hang is caused by ‘too broad’ ha_innobase::records_in_range() calls. Those calls were introduced by an early commit of MDEV-16188. With the parent of that commit, the following test will not hang:
git checkout bc43bf3e430c20bc2178e584215bd443054709d6 mysql-test/suite/innodb/t/innodb_wl6326.*
|
(cd path/to/build/mysql-test; ./mtr innodb.innodb_wl6326)
|
I would expect the too broad ha_innobase::records_in_range() calls to cause a performance regression, especially if they are being invoked for each and every query. InnoDB will not cache the results of that call in any way.
Attachments
Issue Links
- is caused by
-
MDEV-16188 Use in-memory PK filters built from range index scans
-
- Closed
-
- relates to
-
-
- Closed
-
-
-
- Open
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link |
This issue is caused by |
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
| Link | This issue relates to MENT-635 [ MENT-635 ] |
| Attachment | MDEV-21535-workaround.patch [ 50544 ] |
| Assignee | Igor Babaev [ igor ] | Michael Widenius [ monty ] |
| Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
| issue.field.resolutiondate | 2020-04-08 07:06:36.0 | 2020-04-08 07:06:36.634 |
| Fix Version/s | 10.4.13 [ 24223 ] | |
| Fix Version/s | 10.5.2 [ 24030 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Resolution | Fixed [ 1 ] | |
| Status | Closed [ 6 ] | Stalled [ 10000 ] |
| Fix Version/s | 10.5 [ 23123 ] | |
| Fix Version/s | 10.5.2 [ 24030 ] |
| Assignee | Michael Widenius [ monty ] | Marko Mäkelä [ marko ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Link |
This issue relates to |
| issue.field.resolutiondate | 2020-04-14 16:14:40.0 | 2020-04-14 16:14:40.058 |
| Fix Version/s | 10.5.2 [ 24030 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 103184 ] | MariaDB v4 [ 157224 ] |
| Link | This issue relates to MDEV-26389 [ MDEV-26389 ] |