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

          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.