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

Non-transactional mysql.gtid_slave_pos breaks --slave-parallel-mode=[optimistic|aggressive] replication

    XMLWordPrintable

Details

    Description

      See mail thread at https://lists.launchpad.net/maria-developers/msg09722.html.

      Optimistic parallel replication does not work when mysql.gtid_slave_pos is
      non-transactional. So either it needs to fallback to non-parallel (like for
      other non-transactional updates/DDL), or an error should be given.

      An error seems better, as silently falling back to all transactions being
      run serially does not seem very useful.

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19157 Optimistic Parallel Replication fails when gtid_slave_pos table is non transactional and binlog events are transactional

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34346 [ERROR] Slave (additional info): Commit failed due to failure of an earlier commit on which this one depends Error_code: 1964 on parallel replica

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

          Activity

            People

              knielsen Kristian Nielsen
              knielsen Kristian Nielsen
              Votes:
              2 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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