Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Stall of instance after INSERT (...) SELECT

Description

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.

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

Assignee

Reporter

Labels

Reviewer

Upstream Bug URL

https://bugs.mysql.com/bug.php?id=96236

Needs QA

Yes

Fix versions

Affects versions

Priority

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