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 line 536 for 241.00 seconds the semaphore:
X-lock (wait_ex) on RW-latch at 0x2ad52683ff78 created in file 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 line 545
Last time write locked in file /local/mysql-5.6.27.R1/storage/innobase/btr/ line 536

Options: ReplyQuote

Written By
Warning: a long semaphore wait
April 05, 2018 03:38AM
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.