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

        Issue Links

          Activity

            yyanin Yanko Yanin added a comment -

            We have a cluster A being replicated from cluster B, cluster A was installed with 10.6.18 but updated yesterday to .19 because of this bug, but it is still a problem, table is growing quite fast. Also interesting to note, restarting the affected nodes will clear the table on startup.

            yyanin Yanko Yanin added a comment - We have a cluster A being replicated from cluster B, cluster A was installed with 10.6.18 but updated yesterday to .19 because of this bug, but it is still a problem, table is growing quite fast. Also interesting to note, restarting the affected nodes will clear the table on startup.

            I can also reproduce in the linked Docker compose test setup on 10.6.20. Using the latest docker.io/bitnami/mariadb-galera:10.6 docker image. And we are also affected by this on 10.6.19 in a real deployment. So I doubt this is fixed in 10.6.19.

            Steinlin Gaudenz Steinlin added a comment - I can also reproduce in the linked Docker compose test setup on 10.6.20. Using the latest docker.io/bitnami/mariadb-galera:10.6 docker image. And we are also affected by this on 10.6.19 in a real deployment. So I doubt this is fixed in 10.6.19.

            I can even reproduce this with 11.5.2 in the Docker compose setup.

            Steinlin Gaudenz Steinlin added a comment - I can even reproduce this with 11.5.2 in the Docker compose setup.
            janlindstrom Jan Lindström added a comment - - edited https://github.com/MariaDB/server/pull/3718
            sysprg Julius Goryavsky added a comment - The fix has been merged with the head revision: https://github.com/MariaDB/server/commit/133e26fd7dc454c5b154495ab876c76bbcfd1715

            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.