Description:
The mysql server hung (stopped executing queries) and logged many messages such as:
InnoDB: Warning: a long semaphore wait:
--Thread 101103 has waited at btr0sea.c line 916 for 785.00 seconds the semaphore:
S-lock on RW-latch at 1057568 created in file btr0sea.c line 139
a writer (thread id 101100) has reserved it in mode wait exclusive
number of readers 0, waiters flag 1
Last time read locked in file btr0sea.c line 916
Last time write locked in file btr0sea.c line 1236
InnoDB: Warning: a long semaphore wait:
--Thread 101133 has waited at trx0trx.c line 213 for 785.00 seconds the semaphore:
Mutex at 1054768 created file srv0srv.c line 872, lock var 1
waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 101129 has waited at trx0trx.c line 213 for 783.00 seconds the semaphore:
Mutex at 1054768 created file srv0srv.c line 872, lock var 1
waiters flag 1
After some time it crashed:
InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
InnoDB: Pending preads 0, pwrites 0
InnoDB: ###### Diagnostic info printed to the standard error stream
InnoDB: Error: semaphore wait has lasted > 600 seconds
InnoDB: We intentionally crash the server, because it appears to be hung.
071029 10:32:25InnoDB: Assertion failure in thread 8 in file srv0srv.c line 2093
No core file.
How to repeat:
Unknown