MySQL Bugs: #89715: Thread is waiting for itself at btr0sea.c

Bug #89715	Thread is waiting for itself at btr0sea.c
Submitted:	19 Feb 2018 10:58	Modified:	19 Feb 2018 14:31
Reporter:	Stefan Meier	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.5.41	OS:	Red Hat ( Red Hat Enterprise Linux Server release 6.6 (Santiago))
Assigned to:		CPU Architecture:	x86 (Intel(R) Xeon(R) CPU E7- 4830 @ 2.13GHz)

Description:
The server crashed after waiting for a semaphore for too long.
What seems strange to me is that a thread (140192441890560) seems to wait for a semaphore that it has reserved itself:

=====================================
180219 10:12:13 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 20 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 13397673 1_second, 13390402 sleeps, 1339761 10_second, 60 background, 7 flush
srv_master_thread log flush and writes: 13526993
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 1789716607, signal count 3468387353
--Thread 140339338864384 has waited at dict0dict.c line 311 for 949.00 seconds the semaphore:
X-lock on RW-latch at 0x7fa3548fc9c0 created in file dict0dict.c line 754
a writer (thread id 140192492476160) has reserved it in mode  exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file dict0dict.c line 308
Last time write locked in file /builddir/build/BUILD/mysql-5.5.41/storage/innobase/dict/dict0dict.c line 311
--Thread 140192441890560 has waited'T line 633 for 949.00 seconds the semaphore:
X-lock (wait_ex) on RW-latch at 0x7fa41755df38 created in file btr0sea.c line 178
a writer (thread id 140192441890560) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file btr0cur.c line 808
Last time write locked in file /builddir/build/BUILD/mysql-5.5.41/storage/innobase/btr/btr0sea.c line 633
--Thread 140194645325568 has waited at row0sel.c line 3713 for 949.00 seconds the semaphore:
S-lock on RW-latch at 0x7fa41755df38 created in file btr0sea.c line 178
a writer (thread id 140192441890560) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file btr0cur.c line 808
Last time write locked in file /builddir/build/BUILD/mysql-5.5.41/storage/innobase/btr/btr0sea.c line 633

How to repeat:
I have no idea how to repeat it.

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