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)
• Status: No Feedback
• 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

Description:
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

pstack

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

Hi,

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..)

Thanks
Bogdan

[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".