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

Port kill_one_trx fixes from 10.4 to 10.1

    XMLWordPrintable

Details

    Description

      There following issues here:

      • Whenever Galera BF (brute force) transaction decides to abort conflicting transaction it will kill that thread using thd::awake()
      • Whenever replication selects a thread as a victim it will call thd::awake()
      • User KILL [QUERY|CONNECTION] ... for a thread it will also call thd::awake()

      Whenever one of these actions is executed we will hold number of InnoDB internal mutexes and thd mutexes.
      Sometimes these mutexes are taken in different order causing mutex deadlock (see one detailed case below).

      Refs

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. MDEV-12009 Allow to force kill user threads/query which are flagged as high priority by Galera

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17063 server locks up and is killed after innodb_fatal_semaphore_wait_threshold is reached

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19803 Long semaphore wait error on galera.MW-388

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23328 Server hang due to Galera lock conflict resolution

          • 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-18874 Galera test MW-286 causes Mutex = TTASEventMutex<GenericPolicy>]: Assertion `!is_owned()' failed. assertion

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

          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

          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

          Activity

            People

              jplindst Jan Lindström (Inactive)
              jplindst Jan Lindström (Inactive)
              Votes:
              2 Vote for this issue
              Watchers:
              9 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.