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

MariaDB crashing with long semaphore waits after upgrade from v10.2 to v10.5.8

Details

    Description

      Hi,
      Our prod database was crashing daily at least two times after we have upgraded to V10.5.8 from v10.2.

      We disabled the adaptive hash index but it didn't prevent the crashes. Please do the needful.

      Attachments

        Issue Links

          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

          Activity

            marko Marko Mäkelä added a comment -

            In Mariadb.zip I see the following:

            mariadb-10.5.8

            		 
            OS WAIT ARRAY INFO: reservation count 22537437
            		 
            --Thread 140242946348800 has waited at mtr0mtr.ic line 145 for 0.00 seconds the 
            semaphore:
            		 
            X-lock (wait_ex) on RW-latch at 0x7f90e41b1f78 created in file buf0buf.cc line 1299
            		 
            a writer (thread id 140242946348800) has reserved it in mode  wait exclusive

            There are no further references to that thread in the log output.

            This looks similar to MDEV-24378 and could be duplicating MDEV-24188. Without having the stack traces of all threads, I am unable to diagnose either that or this report.

            marko Marko Mäkelä added a comment - In Mariadb.zip I see the following: mariadb-10.5.8 OS WAIT ARRAY INFO: reservation count 22537437 --Thread 140242946348800 has waited at mtr0mtr.ic line 145 for 0.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x7f90e41b1f78 created in file buf0buf.cc line 1299 a writer (thread id 140242946348800) has reserved it in mode wait exclusive There are no further references to that thread in the log output. This looks similar to MDEV-24378 and could be duplicating MDEV-24188 . Without having the stack traces of all threads, I am unable to diagnose either that or this report.

            People

              Unassigned Unassigned
              prabha Prabha
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.