MySQL crash during multiple DDL operations on separate schemas
Description
Environment
OS: "Ubuntu 22.04.5 LTS (Jammy Jellyfish)"
Server Version: 8.0.35-27 Percona Server (GPL), Release '27', Revision '2f8eeab2'$Thread pointer: 0x7f03282f2650
Activity
Aaditya Dubey 13 hours ago
Hi
Thank you for the information/data; it will be reviewed, and I will keep you posted.
Mikael Gbai 13 hours ago
Chris is out today, and i’m sharing the information requested
What OS was used to create that core dump?
All binary requested have been uploaded via the SFTP link
Aaditya Dubey 19 hours ago
Hi
We require the following information to debug the core dump further:
What OS was used to create that core dump?
We will need a copy of MySQL binary and linked libraries to read core dumps properly. Execute the below steps to gather them:
Please share this information as soon as possible to make this debugging process faster.
Aaditya Dubey 2 days ago
Hi
Our engineering team acknowledged this issue, and the core dump will be reviewed for further debugging. However, I can’t provide an ETA because it completely depends on engineering’s road map. You will be notified when there are any updates.
Aaditya Dubey 2 days ago
Hi
Thank you for the confirmation. I’ll check with our engineering team to look into the core dump to see if they find anything interesting.
Details
Details
Assignee
Reporter
Chris JackNeeds QA
Affects versions
Priority
HighSmart Checklist
Open Smart Checklist
Smart Checklist
We have a large MySQL instance that sometimes crashes during when multiple DDL operations happen concurrently on separate schemas. I have included the error log, “show global variables” output, show processlist and show engine innodb status right before the crash (we take snapshots of these every 30 seconds and write locally). I have a very large (116GB) core dump file available as well.
Error log:
Processlist:
show engine Innodb status:
https://pastebin.com/wfBUKRaj
Show global variables output: