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
            View 12 older comments
            jplindst Jan Lindström (Inactive) added a comment -

            lmk@netic.dk Thank you for your report. I opened https://jira.mariadb.org/browse/TODO-3320 to fix this.

            jplindst Jan Lindström (Inactive) added a comment - lmk@netic.dk Thank you for your report. I opened https://jira.mariadb.org/browse/TODO-3320 to fix this.
            jplindst Jan Lindström (Inactive) added a comment -

            Please try following: https://archive.mariadb.org/mariadb-10.4.22/galera-26.4.9/

            jplindst Jan Lindström (Inactive) added a comment - Please try following: https://archive.mariadb.org/mariadb-10.4.22/galera-26.4.9/
            lmk@netic.dk Lars Mikkelsen added a comment -

            Thats also an old version from october 2020

            ➜  galera wget https://archive.mariadb.org/mariadb-10.4.22/galera-26.4.9/bintar/galera-26.4.9-systemd-x86_64.tar.gz
            		 
            --2022-01-26 08:16:35--  https://archive.mariadb.org/mariadb-10.4.22/galera-26.4.9/bintar/galera-26.4.9-systemd-x86_64.tar.gz
            		 
            Resolving archive.mariadb.org (archive.mariadb.org)... 2a01:4f8:c17:cad6::1, 138.201.152.105
            		 
            Connecting to archive.mariadb.org (archive.mariadb.org)|2a01:4f8:c17:cad6::1|:443... connected.
            		 
            HTTP request sent, awaiting response... 200 OK
            		 
            Length: 20394498 (19M) [application/octet-stream]
            		 
            Saving to: ‘galera-26.4.9-systemd-x86_64.tar.gz’
            		 
             
            		 
            galera-26.4.9-systemd-x86_64.tar.gz                        100%[=======================================================================================================================================>]  19,45M  4,71MB/s    in 5,5s
            		 
             
            		 
            2022-01-26 08:16:41 (3,52 MB/s) - ‘galera-26.4.9-systemd-x86_64.tar.gz’ saved [20394498/20394498]
            		 
             
            		 
            ➜  galera tar zxvf galera-26.4.9-systemd-x86_64.tar.gz
            		 
            x galera-26.4.9-systemd-x86_64/
            		 
            x galera-26.4.9-systemd-x86_64/usr/
            		 
            x galera-26.4.9-systemd-x86_64/usr/lib/
            		 
            x galera-26.4.9-systemd-x86_64/usr/lib/galera/
            		 
            x galera-26.4.9-systemd-x86_64/usr/lib/galera/libgalera_smm.so
            		 
            x galera-26.4.9-systemd-x86_64/usr/lib/libgalera_smm.so
            		 
            ...   
            x galera-26.4.9-systemd-x86_64/etc/
            		 
            x galera-26.4.9-systemd-x86_64/etc/default/
            		 
            x galera-26.4.9-systemd-x86_64/etc/default/garb
            		 
            x galera-26.4.9-systemd-x86_64/etc/init.d/
            		 
            x galera-26.4.9-systemd-x86_64/etc/init.d/garb
            		 
            ➜  galera ls -l galera-26.4.9-systemd-x86_64/usr/lib/galera/libgalera_smm.so
            		 
            -rw-r--r--  1 lmk  staff  40221093 Oct 22  2020 galera-26.4.9-systemd-x86_64/usr/lib/galera/libgalera_smm.so

            lmk@netic.dk Lars Mikkelsen added a comment - Thats also an old version from october 2020 ➜ galera wget https://archive.mariadb.org/mariadb-10.4.22/galera-26.4.9/bintar/galera-26.4.9-systemd-x86_64.tar.gz --2022-01-26 08:16:35-- https://archive.mariadb.org/mariadb-10.4.22/galera-26.4.9/bintar/galera-26.4.9-systemd-x86_64.tar.gz Resolving archive.mariadb.org (archive.mariadb.org)... 2a01:4f8:c17:cad6::1, 138.201.152.105 Connecting to archive.mariadb.org (archive.mariadb.org)|2a01:4f8:c17:cad6::1|:443... connected. HTTP request sent, awaiting response... 200 OK Length: 20394498 (19M) [application/octet-stream] Saving to: ‘galera-26.4.9-systemd-x86_64.tar.gz’   galera-26.4.9-systemd-x86_64.tar.gz 100%[=======================================================================================================================================>] 19,45M 4,71MB/s in 5,5s   2022-01-26 08:16:41 (3,52 MB/s) - ‘galera-26.4.9-systemd-x86_64.tar.gz’ saved [20394498/20394498]   ➜ galera tar zxvf galera-26.4.9-systemd-x86_64.tar.gz x galera-26.4.9-systemd-x86_64/ x galera-26.4.9-systemd-x86_64/usr/ x galera-26.4.9-systemd-x86_64/usr/lib/ x galera-26.4.9-systemd-x86_64/usr/lib/galera/ x galera-26.4.9-systemd-x86_64/usr/lib/galera/libgalera_smm.so x galera-26.4.9-systemd-x86_64/usr/lib/libgalera_smm.so ... x galera-26.4.9-systemd-x86_64/etc/ x galera-26.4.9-systemd-x86_64/etc/default/ x galera-26.4.9-systemd-x86_64/etc/default/garb x galera-26.4.9-systemd-x86_64/etc/init.d/ x galera-26.4.9-systemd-x86_64/etc/init.d/garb ➜ galera ls -l galera-26.4.9-systemd-x86_64/usr/lib/galera/libgalera_smm.so -rw-r--r-- 1 lmk staff 40221093 Oct 22 2020 galera-26.4.9-systemd-x86_64/usr/lib/galera/libgalera_smm.so
            jplindst Jan Lindström (Inactive) added a comment -

            Debian seems to be fine but bintar not.

            jplindst Jan Lindström (Inactive) added a comment - Debian seems to be fine but bintar not.
            jplindst Jan Lindström (Inactive) added a comment -

            Fixed on Galera library 26.4.11 commit 9561a159c

            jplindst Jan Lindström (Inactive) added a comment - Fixed on Galera library 26.4.11 commit 9561a159c

            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.