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. atomics.cc
          3 kB
        2. kill_test.diff
          6 kB
        3. mdev-23328.pl
          2 kB
        4. mdev-23328-spin.txt
          9 kB
        5. mdev-pre-21010-spin.txt
          11 kB
        6. mdev-pre-21910.pl
          1 kB

          Issue Links

            Activity

              People

              Assignee:
              serg Sergei Golubchik
              Reporter:
              marko Marko Mäkelä
              Votes:
              3 Vote for this issue
              Watchers:
              19 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: