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

Parallel Replication Breaks if XA PREPARE Fails Updating Slave GTID State

Details

    Description

      Similar to MDEV-29642, but instead of a slave crashing, if a parallel slave executing an XA PREPARE fails the follow up autocommit transaction due to a temporary error which can be retried (e.g. a deadlock when trying to lock mysql.gtid_slave_pos), then the retry will run into the same issue as MDEV-29642, i.e. an out-of-order GTID attempt (if gtid strict mode is enabled) or XID already exists (otherwise).

      This is because the XA PREPARE had already committed successfully in binlog and storage engines, and only the slave GTID state update failed. Then on retry, the transaction has already been seen, so we error.

      Filed as a separate ticket (rather than extending MDEV-29642 scope) because this is specific to the parallel slave, and may need a separate effort.

      Attachments

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31185 rw_trx_hash_t::find() unpins pins too early

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

          Task - A task that needs to be done. MDEV-21777 Implement crash-safe execution the user XA on binlog-less slave

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31185 rw_trx_hash_t::find() unpins pins too early

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29642 Server Crash During XA Prepare Can Break Replication

          • Major - Major loss of function.
          • Closed

          Activity

            Transition Time In Source Status Execution Times
            Brandon Nesterenko made transition -
            Open In Progress
            		7d 16h 50m 1
            Brandon Nesterenko made transition -
            In Progress In Review
            		40s 1
            Andrei Elkin made transition -
            In Review Stalled
            		1d 3h 3m 1
            Brandon Nesterenko made transition -
            Stalled Closed
            		4d 7h 45m 1
            Vladislav Lesin made transition -
            Closed Stalled
            		2d 11h 22m 1
            Vladislav Lesin made transition -
            Stalled In Progress
            		2h 12m 1
            Brandon Nesterenko made transition -
            In Progress Closed
            		46d 5h 51m 1

            People

              vlad.lesin Vladislav Lesin
              bnestere Brandon Nesterenko
              Votes:
              2 Vote for this issue
              Watchers:
              12 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.