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

SST works as expected on joiner node but donor node never leaves donor state.

Details

    Description

      Hi Team,

      Galera donor node left in "donor/desynced" after SST with mariabackup. Here I have attached the logs. Please check it.

      After SST the donor node is left in:

      MariaDB [(none)]> show status like 'wsrep_local_state%';
      		 
      +---------------------------+--------------------------------------+
      		 
      | Variable_name | Value |
      		 
      +---------------------------+--------------------------------------+
      		 
      | wsrep_local_state_uuid | abacdfcc-5c70-11ea-b34c-c2bcad908195 |
      		 
      | wsrep_local_state | 2 |
      		 
      | wsrep_local_state_comment | Donor/Desynced |
      		 
      +---------------------------+--------------------------------------+
      		 
      3 rows in set (0.001 sec)

      Attachments

        1. db-prod02.donor.txt
          20 kB
          Pon Suresh Pandian
        2. db-prod04.joiner.txt
          87 kB
          Pon Suresh Pandian
        3. node1.err
          19 kB
          Ramesh Sivaraman
        4. node2.err
          38 kB
          Ramesh Sivaraman

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27789 mysql_upgrade / mariadb-upgrade in 10.6.6 is putting password in host argument

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26918 mariabackup SST donor stuck in DONOR/DESYNCED state

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26969 mariabackup sst donor stuck in Donor/Desynced even after the SST succeeds

          • Major - Major loss of function.
          • Closed

          Activity

            Transition Time In Source Status Execution Times
            Julien Fritsch made transition -
            Confirmed Open
            		1d 1
            Julien Fritsch made transition -
            Open Confirmed
            		2d 17h 10m 2
            Seppo Jaakola made transition -
            Confirmed In Progress
            		2d 19h 35m 1
            Seppo Jaakola made transition -
            In Progress Stalled
            		2m 42s 1
            Seppo Jaakola made transition -
            Stalled In Review
            		17m 23s 1
            Jan Lindström (Inactive) made transition -
            In Review In Testing
            		2d 20h 47m 1
            Ramesh Sivaraman made transition -
            In Testing Stalled
            		2h 18m 1
            Julien Fritsch made transition -
            Stalled Open
            		1h 40m 1
            Julien Fritsch made transition -
            Open Needs Feedback
            		28s 2
            Julien Fritsch made transition -
            Needs Feedback Open
            		5d 13h 31m 2
            Jan Lindström (Inactive) made transition -
            Open Closed
            		13d 15h 10m 1

            People

              jplindst Jan Lindström (Inactive)
              ponsuresh.pandians Pon Suresh Pandian (Inactive)
              Votes:
              5 Vote for this issue
              Watchers:
              17 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.