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

release row locks for non-modified rows at XA PREPARE

    XMLWordPrintable

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
          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

            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.