Bug #90365 | mysqld hangs / slave io thread hang in system lock | ||
---|---|---|---|
Submitted: | 10 Apr 2018 10:07 | Modified: | 10 Apr 2018 11:53 |
Reporter: | Georgi Iovchev | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server | Severity: | S1 (Critical) |
Version: | 5.6.27 | OS: | CentOS (7.4) |
Assigned to: | CPU Architecture: | Any (3.10.0-693.17.1.el7.x86_64) |
[10 Apr 2018 10:07]
Georgi Iovchev
[10 Apr 2018 10:09]
Georgi Iovchev
processlist
Attachment: processlist.txt (text/plain), 8.12 KiB.
[10 Apr 2018 10:11]
Georgi Iovchev
performance_schema.threads
Attachment: threads.txt (text/plain), 8.33 KiB.
[10 Apr 2018 10:12]
Georgi Iovchev
performance_schema.file_instances
Attachment: file_instances.txt (text/plain), 51.01 KiB.
[10 Apr 2018 10:12]
Georgi Iovchev
performance_schema.events_statements_current
Attachment: events_statements_current.txt (text/plain), 12.89 KiB.
[10 Apr 2018 10:14]
Georgi Iovchev
lsof
Attachment: lsof.txt (text/plain), 43.25 KiB.
[10 Apr 2018 10:14]
Georgi Iovchev
gdb backtrace threads
Attachment: gdb_bt.txt (text/plain), 640.62 KiB.
[10 Apr 2018 10:23]
MySQL Verification Team
Thank you for taking the time to report a problem. Unfortunately you are not using a current version of the product you reported a problem with (current version is 5.6.39) -- the problem might already be fixed. Please download a new version from http://www.mysql.com/downloads/. Also, there is no test case provided in the bug report and hence there is nothing we can verify here. If you are able to reproduce the bug with one of the latest versions, please attach the exact reproducible test case and change the version on this bug report to the version you tested and change the status back to "Open". Again, thank you for your continued support of MySQL.
[10 Apr 2018 11:53]
Georgi Iovchev
The problem can not be reproduced - it happens random - once a month or two. I have already upgraded some of the instances, but can not be sure if this fixed the issue, because as I say it is absolutely random.