Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-2043

if pv not installed, sst script still tries to use it and fails

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.6.40-26.25, 5.7.22-29.26
    • Component/s: None
    • Labels:
      None

      Description

       

      This was set on both donor and joiner nodes:

      [sst]
      progress=1
      

       

       

      joiner had 'pv' installed; donor did not have 'pv' installed.  SST failed. Donor log below. You can see the "innobackup.backup.log | | socat " and in between the two pipes should be the call to 'pv' but it is not installed.

      Not only does the SST fail on the donor, but, no signal is sent back to the joiner. The joiner waits forever for data.

       

       

      2018-01-26T17:29:43.606164Z WSREP_SST: [INFO] Streaming the backup to joiner at 10.64.64.201 4444
      /usr/bin/wsrep_sst_xtrabackup-v2: eval: line 169: syntax error near unexpected token `|'
      /usr/bin/wsrep_sst_xtrabackup-v2: eval: line 169: `xtrabackup --defaults-file=/etc/mysql/my.cnf --defaults-group=mysqld --parallel=4 $ieopts $INNOEXTRA $keyringbackupopt --backup --galera-info --binlog-info=ON --stream=$sfmt --target-dir=$itmpdir 2>${DATA}/innobackup.backup.log | | socat -u stdio TCP:10.64.64.201:4444,retry=30; RC=( ${PIPESTATUS[@]} )'
      2018-01-26T17:29:43.608271Z 0 [Note] WSREP: 1.0 (mysql3): State transfer to 0.0 (mysql1) complete.
      2018-01-26T17:29:43.608318Z 0 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 312930553)

       

        Attachments

          Activity

            People

            Assignee:
            kenn.takara Kenn Takara
            Reporter:
            matthew.boehm@percona.com Matthew Boehm
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 day, 1 hour
                1d 1h

                  Smart Checklist