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

release row locks for non-modified rows at XA PREPARE

Details

    Description

      After MDEV-26682 InnoDB releases gap locks on XA PREPARE. This is safe and doesn't impact correctness, while fixing some deadlocks in parallel replication.

      But it's not enough, row locks can still cause deadlocks. This task is about releasing row locks on XA PREPARE. InnoDB cannot release all row locks, of course, it'll cause incorrect results if a concurrent transaction will be able to see uncommitted changes.

      Still InnoDB can release row locks on all unmodified rows at XA PREPARE — this should be safe.

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. MDEV-33455 skip modified rows in parallel XA replication, don't wait

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34466 XA prepare don't release unmodified records in non-blocking mode

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34690 lock_rec_unlock_unmodified() causes deadlock

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34777 Wrong page mode during getting page from buffer pool for lock_rec_unlock_unmodified()

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-35228 Have a configuration variable to enable/disable lock release at XA PREPARE

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26682 slave lock timeout with xa and gap locks

          • Major - Major loss of function.
          • Closed

          Activity

            Transition Time In Source Status Execution Times
            Marko Mäkelä made transition -
            Open In Progress
            		53m 19s 1
            Marko Mäkelä made transition -
            In Progress In Review
            		4h 19m 1
            Vladislav Lesin made transition -
            In Review Stalled
            		36d 19h 43m 1
            Marko Mäkelä made transition -
            Stalled Closed
            		1d 2h 31m 1

            People

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