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

Server hang due to Galera lock conflict resolution

    XMLWordPrintable

Details

    Description

      When a SQL KILL statement is requesting a transaction to be aborted at the same time when the same transaction is chosen as a victim in the Galera transaction certification process, the server can hang.

      There have been attempts to fix this problem earlier. A suggested fix for MDEV-18464 had been pushed and soon thereafter reverted because of issues. Another fix (which adds another field to THD, expanding the potential state space) was pushed to 10.4 and 10.5 in MDEV-21910, but it fails to prevent such hangs.

      It seems possible that something related to this caused MDEV-17092, which I had worked around by changing the code in InnoDB.

      Attachments

        1. mdev-23328-spin.txt
          9 kB
        2. mdev-23328.pl
          2 kB
        3. mdev-pre-21010-spin.txt
          11 kB
        4. mdev-pre-21910.pl
          1 kB
        5. kill_test.diff
          6 kB
        6. atomics.cc
          3 kB

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              marko Marko Mäkelä
              Votes:
              3 Vote for this issue
              Watchers:
              21 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.