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

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18874 Galera test MW-286 causes Mutex = TTASEventMutex<GenericPolicy>]: Assertion `!is_owned()' failed. assertion

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24704 Galera test failure on galera.galera_nopk_unicode

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24829 10.5.8 fails to startup on approx 10% of ubuntu focal deployments

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24915 Galera conflict resolution is unnecessarily complex

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25114 Crash: WSREP: invalid state ROLLED_BACK (FATAL)

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23536 Race condition between KILL and transaction commit

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21910 KIlling thread on Galera could cause mutex deadlock

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18534 galera_sr.GCF-1018B: Test failure: mysqltest: mysqltest: Can't connect to local MySQL server; signal 6

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23536 Race condition between KILL and transaction commit

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24966 Galera multi-master regression

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25518 mariadb crash with mysqld got signal 11

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17092 ERROR: AddressSanitizer: use-after-poison around lock_trx_handle_wait_low

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18464 Port kill_one_trx fixes from 10.4 to 10.1

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23851 Galera assertion at lock0lock.cc line 655 because of BF-BF lock wait

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24923 Port selected Galera conflict resolution changes from 10.6

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25368 Galera cluster hangs on Freeing items

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          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.