Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10876

MariaDB unresponsive due to long semaphore wait

    XMLWordPrintable

    Details

      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

        Attachments

          Activity

            People

            Assignee:
            jplindst Jan Lindström
            Reporter:
            Sukan Sukan
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated: