Stall of instance after INSERT (...) SELECT
General
Escalation
General
Escalation
Description
Environment
None
AFFECTED CS IDs
CS0036594
Activity
Show:
Satya Bodapati May 25, 2023 at 10:24 AM
From the upstream bug report, the reporter says, all pages are pinned. this essentially means cache eviction is disabled.
THe described code that tries to optimize insert/select for intrinsic temp tables still exists. Indeed, this is a big design and a WTF moment!
I also believe this mtr holding latching pages is acting as a cover to hide other problems. may be around buffer page relocations etc. IMHO, simply disabling the optimization isn't going to be straighforward.
Needs some serious effort to understand the side effects. And upstream doesn't think it to be serious bug
Done
Details
Details
Assignee
Unassigned
UnassignedReporter
Iwo PanowiczReviewer
Satya BodapatiUpstream Bug URL
Needs QA
Yes
Fix versions
Affects versions
Priority
HighSmart Checklist
Open Smart Checklist
Smart Checklist
Open Smart Checklist
Created May 24, 2023 at 12:07 PM
Updated March 6, 2024 at 9:41 AM
Resolved July 21, 2023 at 9:56 PM
It's a copy of a bug report: https://bugs.mysql.com/bug.php?id=96236.
MySQL can get easily stalled with:
Another way to reproduce:
source table needs a lot of rows, around 500k.