Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.6
Description
This issue was found during the testing of MDEV-24621, by an intermittent failure of the test innodb.insert_into_empty. The failure occurred during the ROLLBACK of an INSERT into a table that was empty.
I was not able to repeat a failure on 10.6, but I think that a similar race condition is present. When we are computing statistics for an index tree, we failed to check whether an insert into an empty table is in progress by an active transaction. If yes, we should do what MVCC reads do: pretend that the table is empty.
No crash or other problem is known in the current 10.6 or in 10.7, but I think that it is better to treat this situation in a safe and consistent manner.
Attachments
Issue Links
- blocks
-
MDEV-24621 In bulk insert, pre-sort and build indexes one page at a time
-
- Closed
-
- is caused by
-
-
- Closed
-
Activity
| Link |
This issue blocks |
| Labels | race regression-10.6 | performance race regression-10.6 |
| Priority | Blocker [ 1 ] | Critical [ 2 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| issue.field.resolutiondate | 2021-09-17 12:11:24.0 | 2021-09-17 12:11:24.502 |
| Fix Version/s | 10.6.5 [ 26034 ] | |
| Fix Version/s | 10.7.0 [ 26072 ] | |
| Fix Version/s | 10.6 [ 24028 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 125096 ] | MariaDB v4 [ 159693 ] |