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

wsrep_sst_mariabackup not working on FreeBSD

Details

    Description

      With wsrep_sst_method=mariabackup the SST/IST process fails at this stage:

      WSREP_SST: [INFO] mariabackup SST started on joiner (20230613 09:04:17.N)
      		 
      WSREP_SST: [INFO] SSL configuration: CA='', CAPATH='', CERT='', KEY='', MODE='DISABLED', encrypt='0' (20230613 09:04:17.N)
      		 
      WSREP_SST: [INFO] Streaming with mbstream (20230613 09:04:18.N)
      		 
      WSREP_SST: [INFO] Using socat as streamer (20230613 09:04:18.N)
      		 
       
      		 
      Usage: timeout [--signal sig | -s sig] [--preserve-status] [--kill-after time | -k time] [--foreground] <duration> <command> <arg ...>
      		 
      WSREP_SST: [INFO] Evaluating timeout -s9 300 socat -u TCP-LISTEN:4444,reuseaddr stdio | '/usr/local//bin/mbstream' -x; RC=( ${PIPESTATUS[@]} ) 
      (20230613 09:04:18.N)
      		 
       
      		 
      2023-06-13  9:04:18 2 [Note] WSREP: ####### IST uuid:7f4bd4bc-73ee-11ed-8cc1-77200a87198f f: 203400, l: 203407, STRv: 3
      		 
      2023-06-13  9:04:18 2 [Note] WSREP: IST receiver addr using tcp://192.168.1.1:4568
      		 
      2023-06-13  9:04:18 2 [Note] WSREP: Prepared IST receiver for 203400-203407, listening at: tcp://192.168.1.1:4568
      		 
      2023-06-13  9:04:18 0 [Note] WSREP: Member 1.0 (galera1) requested state transfer from '*any*'. Selected 0.0 (galera3)(SYNCED) as don
      		 
      or.
      		 
      2023-06-13  9:04:18 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 203407)
      		 
      2023-06-13  9:04:18 2 [Note] WSREP: Requesting state transfer: success, donor: 0
      		 
      2023-06-13  9:04:18 0 [Warning] WSREP: 0.0 (galera3): State transfer to 1.0 (galera1) failed: -2 (No such file or directory)
      		 
      2023-06-13  9:04:18 0 [ERROR] WSREP: /wrkdirs/usr/ports/databases/galera26/work/galera-release_26.4.14/gcs/src/gcs_group.cpp:gcs_group_handle_j
      		 
      oin_msg():1172: Will never receive state. Need to abort.
      		 
      2023-06-13  9:04:18 0 [Note] WSREP: gcomm: terminating thread
      		 
      2023-06-13  9:04:18 0 [Note] WSREP: gcomm: joining thread
      		 
      2023-06-13  9:04:18 0 [Note] WSREP: gcomm: closing backend
      		 
      2023-06-13  9:04:18 0 [Note] WSREP: view(view_id(NON_PRIM,76dfdac7-93fe,53) memb {
      		 
              82d2bc20-a998,0
      		 
      } joined {
      		 
      } left {
      		 
      } partitioned {
      		 
              76dfdac7-93fe,0
      		 
              8f298c44-9cca,0
      		 
      })
      		 
      2023-06-13  9:04:18 0 [Note] WSREP: PC protocol downgrade 1 -> 0
      		 
      2023-06-13  9:04:18 0 [Note] WSREP: view((empty))
      		 
      2023-06-13  9:04:18 0 [Note] WSREP: gcomm: closed
      		 
      2023-06-13  9:04:18 0 [Note] WSREP: mariadbd: Terminated.

      The timeout command seems to expect a different call on FreeBSD systems than on Linux.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          danblack Daniel Black added a comment -

          Is this the right patch?

          diff --git a/scripts/wsrep_sst_mariabackup.sh b/scripts/wsrep_sst_mariabackup.sh
          		 
          index d6334052f24..54e92bfba7b 100644
          		 
          --- a/scripts/wsrep_sst_mariabackup.sh
          		 
          +++ b/scripts/wsrep_sst_mariabackup.sh
          		 
          @@ -799,9 +799,9 @@ recv_joiner()
          		 
               if [ $tmt -gt 0 ]; then
          		 
                   if [ -n "$(commandex timeout)" ]; then
          		 
                       if timeout --help | grep -qw -F -- '-k'; then
          		 
          -                ltcmd="timeout -k $(( tmt+10 )) $tmt $tcmd"
          		 
          +                ltcmd="timeout -k $(( tmt+10 ))s ${tmt}s $tcmd"
          		 
                       else
          		 
          -                ltcmd="timeout -s9 $tmt $tcmd"
          		 
          +                ltcmd="timeout -s 9 $tmt $tcmd"
          		 
                       fi
          		 
                   fi
          		 
               fi

          danblack Daniel Black added a comment - Is this the right patch? diff --git a/scripts/wsrep_sst_mariabackup.sh b/scripts/wsrep_sst_mariabackup.sh index d6334052f24..54e92bfba7b 100644 --- a/scripts/wsrep_sst_mariabackup.sh +++ b/scripts/wsrep_sst_mariabackup.sh @@ -799,9 +799,9 @@ recv_joiner() if [ $tmt -gt 0 ]; then if [ -n "$(commandex timeout)" ]; then if timeout --help | grep -qw -F -- '-k'; then - ltcmd="timeout -k $(( tmt+10 )) $tmt $tcmd" + ltcmd="timeout -k $(( tmt+10 ))s ${tmt}s $tcmd" else - ltcmd="timeout -s9 $tmt $tcmd" + ltcmd="timeout -s 9 $tmt $tcmd" fi fi fi
          sysprg Julius Goryavsky added a comment -

          Fixed, https://github.com/MariaDB/server/commit/073a088f3190c6da63df979a154853d4b5309e50

          sysprg Julius Goryavsky added a comment - Fixed, https://github.com/MariaDB/server/commit/073a088f3190c6da63df979a154853d4b5309e50

          People

            sysprg Julius Goryavsky
            thbabut Thomas Babut
            Votes:
            1 Vote for this issue
            Watchers:
            4 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.