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)

    XMLWordPrintable

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

        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.
          • Confirmed
          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.
          • Open
          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

            People

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