MySQL Forums
Forum List  »  InnoDB

Warning: a long semaphore wait
Posted by: Atanu Saha
Date: April 05, 2018 03:38AM

I am getting below error in error log

InnoDB: Warning: a long semaphore wait:
--Thread 47095778944768 has waited at btr0cur.cc line 536 for 241.00 seconds the semaphore:
X-lock (wait_ex) on RW-latch at 0x2ad52683ff78 created in file dict0dict.cc line 2644
a writer (thread id 47095778944768) has reserved it in mode wait exclusive
number of readers 4, waiters flag 1, lock_word: fffffffffffffffc
Last time read locked in file btr0cur.cc line 545
Last time write locked in file /local/mysql-5.6.27.R1/storage/innobase/btr/btr0cur.cc line 536

Options: ReplyQuote


Subject
Views
Written By
Posted
Warning: a long semaphore wait
7177
April 05, 2018 03:38AM
14462
April 05, 2018 08:51AM
2945
April 05, 2018 10:05AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.