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

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

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration