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

Add thread info for innodb semaphore wait in error log

    XMLWordPrintable

    Details

      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

            Activity

              People

              Assignee:
              marko Marko Mäkelä
              Reporter:
              manjot Manjot Singh
              Votes:
              1 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration