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
        2. db-prod04.joiner.txt
          87 kB
        3. node1.err
          19 kB
        4. node2.err
          38 kB

        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

            Ascending order - Click to sort in descending order
            ponsuresh.pandians Pon Suresh Pandian (Inactive) created issue -
            julien.fritsch Julien Fritsch made changes -
            Field Original Value New Value
            Assignee Ramesh Sivaraman [ JIRAUSER48189 ]
            ramesh Ramesh Sivaraman made changes -
            Attachment node1.err [ 61668 ]
            ramesh Ramesh Sivaraman made changes -
            Attachment node2.err [ 61669 ]
            ramesh Ramesh Sivaraman made changes -
            Assignee Ramesh Sivaraman [ JIRAUSER48189 ] Jan Lindström [ jplindst ]
            ramesh Ramesh Sivaraman made changes -
            Assignee Jan Lindström [ jplindst ] Seppo Jaakola [ seppo ]
            ramesh Ramesh Sivaraman made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            ramesh Ramesh Sivaraman made changes -
            ramesh Ramesh Sivaraman made changes -
            ramesh Ramesh Sivaraman made changes -
            Fix Version/s 10.4 [ 22408 ]
            ramesh Ramesh Sivaraman made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            julien.fritsch Julien Fritsch made changes -
            Status Confirmed [ 10101 ] Open [ 1 ]
            julien.fritsch Julien Fritsch made changes -
            Status Open [ 1 ] Needs Feedback [ 10501 ]
            julien.fritsch Julien Fritsch made changes -
            Status Needs Feedback [ 10501 ] Open [ 1 ]
            julien.fritsch Julien Fritsch made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            seppo Seppo Jaakola made changes -
            Status Confirmed [ 10101 ] In Progress [ 3 ]
            seppo Seppo Jaakola made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            seppo Seppo Jaakola made changes -
            Assignee Seppo Jaakola [ seppo ] Jan Lindström [ jplindst ]
            Status Stalled [ 10000 ] In Review [ 10002 ]
            jplindst Jan Lindström (Inactive) made changes -
            Status In Review [ 10002 ] In Testing [ 10301 ]
            jplindst Jan Lindström (Inactive) made changes -
            Assignee Jan Lindström [ jplindst ] Ramesh Sivaraman [ JIRAUSER48189 ]
            ramesh Ramesh Sivaraman made changes -
            Assignee Ramesh Sivaraman [ JIRAUSER48189 ] Jan Lindström [ jplindst ]
            ramesh Ramesh Sivaraman made changes -
            Status In Testing [ 10301 ] Stalled [ 10000 ]
            jplindst Jan Lindström (Inactive) made changes -
            Labels need_feedback
            julien.fritsch Julien Fritsch made changes -
            Status Stalled [ 10000 ] Open [ 1 ]
            julien.fritsch Julien Fritsch made changes -
            Status Open [ 1 ] Needs Feedback [ 10501 ]
            julien.fritsch Julien Fritsch made changes -
            Labels need_feedback
            valerii Valerii Kravchuk made changes -
            Affects Version/s 10.5.12 [ 26025 ]
            julien.fritsch Julien Fritsch made changes -
            Status Needs Feedback [ 10501 ] Open [ 1 ]
            jplindst Jan Lindström (Inactive) made changes -
            Fix Version/s 10.4.23 [ 26807 ]
            Fix Version/s 10.5.14 [ 26809 ]
            Fix Version/s 10.6.6 [ 26811 ]
            Fix Version/s 10.7.2 [ 26813 ]
            Fix Version/s 10.4 [ 22408 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            pramod.mahto@mariadb.com Pramod Mahto made changes -
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 108294 158663 191328

            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.