Bug #87884 MySQL 5.7.15 hangs when executing truncate table
Submitted: 27 Sep 2017 10:18 Modified: 4 Nov 2017 9:56
Reporter: lou shuai (OCA) Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server: InnoDB storage engine Severity:S1 (Critical)
Version:5.7.18 OS:Linux
Assigned to: MySQL Verification Team CPU Architecture:Any

[27 Sep 2017 10:18] lou shuai
MySQL server hangs for long time:

plz see pstack and processlist

How to repeat:
Happened sometimes, not get the way to repeat!
[27 Sep 2017 10:19] lou shuai

Attachment: pstack.log (application/octet-stream, text), 342.66 KiB.

[27 Sep 2017 10:19] lou shuai
all processlist log

Attachment: allps.log (application/octet-stream, text), 40.30 KiB.

[27 Sep 2017 16:29] MySQL Verification Team
See https://bugs.mysql.com/bug.php?id=68184.
[27 Sep 2017 19:44] MySQL Verification Team
Thank you for the bug report. Duplicate of https://bugs.mysql.com/bug.php?id=80060. Please try latest 5.7 release. Thanks.
[29 Sep 2017 0:54] lou shuai
Thanks a lot!
[29 Sep 2017 1:20] lou shuai
Sorry , i take wrong version
[29 Sep 2017 1:21] lou shuai
The version we use is 5.7.18!!
[4 Oct 2017 9:56] MySQL Verification Team

I can't directly reproduce this issue but if it's related to the 68184 (and it very well might be) you might want to upgrade to 5.7.19 and try if you will hit it again.

Furthermore I need from you
- your config file
- show global stats/variables
- description of the hardware you are running this on (what type of storage subsystem, what cpu, how many of them, how much ram..)

[5 Nov 2017 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".