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

[FATAL] InnoDB: Semaphore wait has lasted > 600 seconds. We intentionally crash the server because it appears to be hung.

    XMLWordPrintable

Details

    Description

      We've upgraded several servers from the distro provided MariaDB to 10.5.8. Since then all upgraded servers crash every few days with:

      --Thread 140006271878912 has waited at btr0cur.cc line 1480 for 611.00 seconds the semaphore:
      SX-lock on RW-latch at 0x55aba8228a10 created in file dict0dict.cc line 2161
      a writer (thread id 140005582296832) has reserved it in mode SX
      number of readers 1, waiters flag 1, lock_word: fffffff
      Last time write locked in file dict0stats.cc line 1969

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24188 Hang in buf_page_create() after reusing a previously freed page

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24275 InnoDB persistent stats analyze forces full scan forcing lock crash

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24378 Crashes on Semaphore wait > 600 seconds

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24606 InnoDB: Semaphore wait has lasted > 600 second

          • Major - Major loss of function.
          • Closed

          Activity

            People

              marko Marko Mäkelä
              fhc Fredrik Chabot
              Votes:
              3 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.