Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
10.1.10
-
Red Hat Enterprise Linux Server release 6.6 (Santiago)
Description
MariaDB was responsive for a long time, queries are in the struck state. Even killing queries is not helping as it is in the killed state for such a long time.
Forcefully killed mysqld, but post restart issue still persists. These errors are logged in errorlogs
InnoDB: Warning: a long semaphore wait:
--Thread 139382773094144 has waited at row0sel.cc line 3056 for 241.00 seconds the semaphore:
S-lock on RW-latch at 0x7f1224fb6120 '&block->lock'
a writer (thread id 139382773094144) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file row0sel.cc line 3231
Last time write locked in file /home/buildbot/buildbot/build/storage/xtradb/buf/buf0buf.cc line 4044
Holder thread 0 file not yet reserved line 0
--Thread 139365758682880 has waited at lock0lock.cc line 7620 for 0.0000 seconds the semaphore:
Mutex at 0x7ec298006068 '&lock_sys->mutex', lock var 1
Last time reserved by thread 139365793367808 in file not yet reserved line 0, waiters flag 1