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

Add option for SQL thread to kill any blocking DML

    XMLWordPrintable

Details

    • New Feature
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • Replication
    • None

    Description

      DML executed on primary may be blocked by any long running DML that takes write locks, like SELECT FOR UPDATE or SELECT IN SHARE MODE, on the replica, thus breaking the "high availability" of this setup.

      Please, add a server variable to force priority for SQL thread in such cases,, similar to --slave-abort-blocking-timeout.

      Attachments

        Issue Links

          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-27131 Add option for SQL thread to kill any blocking local activity that blocks replicated DDL

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38647 GTT: Slave thread-hangs on 'Waiting for table metadata lock' on DROP TABLE

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

          Activity

            People

              knielsen Kristian Nielsen
              monty Michael Widenius
              Votes:
              1 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 1d
                  1d
                  Remaining:
                  Time Spent - 2.75h Remaining Estimate - 5.25h
                  5.25h
                  Logged:
                  Time Spent - 2.75h Remaining Estimate - 5.25h
                  2.75h

                  Git Integration

                    Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.