InnoDB: Error: semaphore wait has lasted > 600 seconds. InnoDB: We intentionally crash the server, because it appears to be hung. 2013-10-07 16:29:16 7fc3ebfff700 InnoDB: Assertion failure in thread <nr> in file srv0srv.cc line 2124 (II)
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
High
|
Laurynas Biveinis | ||
5.1 |
Invalid
|
Undecided
|
Unassigned | ||
5.5 |
Invalid
|
Undecided
|
Unassigned | ||
5.6 |
Fix Released
|
High
|
Laurynas Biveinis |
Bug Description
Thread 1 (LWP 15538):
+bt
#0 0x000000363720c69c in pthread_kill () from /lib64/
#1 0x0000000000687d8e in handle_fatal_signal (sig=6) at /bzr/5.
#2 <signal handler called>
#3 0x0000003636e328a5 in raise () from /lib64/libc.so.6
#4 0x0000003636e34085 in abort () from /lib64/libc.so.6
#5 0x0000000000b58c9d in srv_error_
#6 0x0000003637207851 in start_thread () from /lib64/
#7 0x0000003636ee890d in clone () from /lib64/libc.so.6
===========
Version: '5.6.13-
2013-10-07 16:11:56 15516 [Warning] InnoDB: changed page bitmap file './ib_modified_
2013-10-07 16:13:06 15516 [Warning] InnoDB: changed page bitmap file './ib_modified_
InnoDB: Warning: a long semaphore wait:
--Thread 140479423301376 has waited at srv0srv.cc line 2589 for 241.00 seconds the semaphore:
X-lock on RW-latch at 0x1562560 '&dict_
a writer (thread id 140479530440448) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file row0purge.cc line 720
Last time write locked in file /bzr/5.
InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
InnoDB: Pending preads 0, pwrites 0
=======
2013-10-07 16:17:43 7fc3eabfd700 INNODB MONITOR OUTPUT
=======
[...]
InnoDB: Error: semaphore wait has lasted > 600 seconds
InnoDB: We intentionally crash the server, because it appears to be hung.
2013-10-07 16:29:16 7fc3ebfff700 InnoDB: Assertion failure in thread 140479454770944 in file srv0srv.cc line 2124
Related branches
- Alexey Kopytov (community): Approve
- Laurynas Biveinis: Pending requested
- Vlad Lesin: Pending (g2) requested
-
Diff: 345 lines (+82/-49)7 files modifiedPercona-Server/storage/innobase/include/sync0rw.h (+4/-4)
Percona-Server/storage/innobase/include/sync0rw.ic (+7/-25)
Percona-Server/storage/innobase/include/sync0sync.h (+5/-6)
Percona-Server/storage/innobase/include/sync0sync.ic (+0/-1)
Percona-Server/storage/innobase/sync/sync0arr.cc (+3/-3)
Percona-Server/storage/innobase/sync/sync0rw.cc (+45/-8)
Percona-Server/storage/innobase/sync/sync0sync.cc (+18/-2)
summary: |
InnoDB: Error: semaphore wait has lasted > 600 seconds. InnoDB: We intentionally crash the server, because it appears to be hung. 2013-10-07 16:29:16 7fc3ebfff700 InnoDB: Assertion failure in thread - <nr> in file srv0srv.cc line 2124 + <nr> in file srv0srv.cc line 2124 (II) |
<laurynas> unless further debugging changes something, it happens if AHI is enabled and some of thread priorities (which are experimental) are set