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

@@sql_slave_skip_counter resets to 1 when skipping events by @@gtid_ignore_duplicates

    XMLWordPrintable

Details

    • Bug
    • Status: In Review (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 10.11, 12.3
    • 10.11
    • Replication
    • None
    • Can result in unexpected behaviour
    • Q1/2026 Server Development, Q1/2026 Server Maintenance

    Description

      MDEV-5804 implemented @@gtid_ignore_duplicates on serial replication by overwriting @@sql_slave_skip_counter to 1 regardless of its prior value (be it 0 or 100).
      The result of the attached test currently shows a drop from 100 to 0.

      Because SHOW SLAVE STATUS waits for a mutex that’s locked while @@gtid_ignore_duplicates takes effect, its Skip_Counter cannot show a temporary increase from 0 to 1 (at least for now).
      @@sql_slave_skip_counter, however, does not require this mutex and so can independently reveal this increase.

      MDEV-4937 almost banned @@sql_slave_skip_counter in GTID mode, but was revised to fix it.

      Attachments

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. MDEV-4698 With GTID replication, relay logs cannot be relied upon while purging binary logs on master

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

          Task - A task that needs to be done. MDEV-30458 Consolidate Serial Replica to Parallel Replica with 1 Worker Thread

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-38672 Consolidate replica-side event group filtering

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open
          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-5804 If same GTID is received on multiple master connections in multi-source replication, the event is double-executed causing corruption or replication failure

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-4937 sql_slave_skip_counter does not work with GTID

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

          Activity

            People

              knielsen Kristian Nielsen
              ParadoxV5 Jimmy Hú
              Jimmy Hú Jimmy Hú
              Kristian Nielsen Kristian Nielsen
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.