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

MariaDB hangs on commit

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.5.8
    • N/A
    • None
    • Galera version: 26.4.6-buster
      Debian Version: 10.6
      Kernel version: 4.19.0-12-amd64

    Description

      In an environment with 3 node Galera Cluster and some replicas, for some reason, almost all the transactions hang in the “starting” state on the commit statement.
      We tried to kill these transactions without success.
      We tried to restart the service but it hangs on stopping Galera replication.
      By looking at the backtrace it seems that we have a mutex deadlock on the group commit feature.

      Unfortunately, we didn't find a way to reproduce the problem

      Attachments

        1. stop-log.txt
          1 kB
          William Welter
        2. innodb.txt
          165 kB
          William Welter
        3. backtraces.txt
          98 kB
          William Welter

        Activity

          People

            jplindst Jan Lindström (Inactive)
            williamwelter William Welter
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.