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

gtid_slave_pos table rows newer been deleted on non replica nodes (wsrep_gtid_mode = 1)

Details

    Description

      To reproduce:

      Requirements:

      installed docker + docker compose + attached script

       
      		 
      docker compose up -d
      		 
      # wait until both cluster are up
      		 
       
      		 
      # create async replication
      		 
      ./init.sh  
       
      		 
      # create traffic (can be repeated multiple times)
      		 
      ./flood.sh

      Node 1 will be cleared after ~ 60 entries, but entries on node 2 and 3 persists
      and will be never deleted.

      Reproducable on 10.5.24, 10.5.25 and 10.5.26, but not on 10.6.19

      Attachments

        1. galrep.tar
          30 kB
          Richard Stracke

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33977 MariaDB hangs on --wsrep-recover phase

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35447 Multi-layered replication does not work from 10.4 -> 10.11 -> 10.11

          • Major - Major loss of function.
          • Closed
          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33977 MariaDB hangs on --wsrep-recover phase

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34211 Seconds_Behind_Master gives impossible values

          • Major - Major loss of function.
          • Closed
          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31413 Node has been dropped from the cluster on Startup / Shutdown with async replica

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35627 mysql.gtid_slave_pos gets really big

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31905 WSREP GTID MODE is inconsistent

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34170 table gtid_slave_pos entries never been deleted with wsrep_gtid_mode = 0

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

          Activity

            Transition Time In Source Status Execution Times
            Julien Fritsch made transition -
            Open Confirmed
            		13d 16h 28m 1
            Jan Lindström made transition -
            Confirmed In Progress
            		82d 23h 5m 1
            Jan Lindström made transition -
            In Progress In Review
            		1m 40s 1
            Julius Goryavsky made transition -
            In Review Stalled
            		25d 16h 58m 1
            Julius Goryavsky made transition -
            Stalled Closed
            		12m 7s 1

            People

              sysprg Julius Goryavsky
              Richard Richard Stracke
              Votes:
              1 Vote for this issue
              Watchers:
              10 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.