Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
None
Description
In the error log, with InnoDB semaphore wait NOTE or WARNING (as shown below), information about which thread is holding the mutex is not shown. E.g.:
2020-04-21 18:49:04 139273581979392 [Note] InnoDB: A semaphore wait:
|
--Thread 139269554730752 has waited at dict0dict.cc line 1153 for 514.00 seconds the semaphore:
|
Mutex at 0x5612f8e8ec40, Mutex DICT_SYS created dict0dict.cc:1089, lock var 2
|
The log should show information on who is holding the mutexes to aid in troubleshooting:
2020-04-21 18:49:04 139273581979392 [Note] InnoDB: A semaphore wait:
|
--Thread 139269603882752 has waited at btr0cur.cc line 3872 for 0.00 seconds the semaphore:
|
X-lock on RW-latch at 0x5612f8c2ee80 created in file btr0sea.cc line 193
|
a writer (thread id 139271632033536) has reserved it in mode exclusive
|
number of readers 0, waiters flag 0, lock_word: 0
|
Last time read locked in file btr0sea.ic line 134
|
Last time write locked in file btr0cur.cc line 3872
|
Attachments
Issue Links
- duplicates
-
MDEV-21330 Lock monitor doesn't print a semaphore's last reserved thread in non-debug builds and INFORMATION_SCHEMA.INNODB_SYS_SEMAPHORE_WAITS is totally broken
-
- Closed
-