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

Node fails to join mdb cluster with wsrep_sst_mariabackup due to dependency from socat

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 10.2.12, 10.1(EOL)
    • N/A
    • Backup, Galera SST
    • None
    • CentOS 7.4

    Description

      Node fails to join mdb cluster with wsrep_sst_mariabackup due to dependency from socat

      how to repeat
      1. install MariaDB-server
      3 .enable wsrep
      3. on the first none issue command galera_new_cluster
      4. initiate the first joining of the second node to the cluster –
      service mysql start --wsrep_cluster_address=gcomm://192.168.104.193 – it fails with Error

      WSREP_SST: [ERROR] socat not found in path: /usr/sbin:/sbin:/usr//bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin (20180122 14:55:32.993)
      2018-01-22 14:55:32 140617791280896 [ERROR] WSREP: Failed to read 'ready <addr>' from: wsrep_sst_mariabackup --role 'joiner' --address '192.168.104.195' --datadir '/var/lib/mysql/'   --parent '31544'  ''
              Read: '(null)'
      2018-01-22 14:55:32 140617791280896 [ERROR] WSREP: Process completed with error: wsrep_sst_mariabackup --role 'joiner' --address '192.168.104.195' --datadir '/var/lib/mysql/'   --parent '31544'  '' : 2 (No such file or directory)
      2018-01-22 14:55:32 140618039088896 [ERROR] WSREP: Failed to prepare for 'mariabackup' SST. Unrecoverable.
      2018-01-22 14:55:32 140618039088896 [ERROR] Aborting
      

      2018-01-22 14:55:32 140618139555968 [Note] WSREP: Waiting for SST to complete.
      2018-01-22 14:55:32 140617799673600 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2
      2018-01-22 14:55:32 140617799673600 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 8804dc30-ff73-11e7-8389-e33e6fce0d53
      2018-01-22 14:55:32 140617799673600 [Note] WSREP: STATE EXCHANGE: sent state msg: 8804dc30-ff73-11e7-8389-e33e6fce0d53
      2018-01-22 14:55:32 140617799673600 [Note] WSREP: STATE EXCHANGE: got state msg: 8804dc30-ff73-11e7-8389-e33e6fce0d53 from 0 (t4w5)
      2018-01-22 14:55:32 140617799673600 [Note] WSREP: STATE EXCHANGE: got state msg: 8804dc30-ff73-11e7-8389-e33e6fce0d53 from 1 (t4w5)
      2018-01-22 14:55:32 140617799673600 [Note] WSREP: Quorum results:
              version    = 4,
              component  = PRIMARY,
              conf_id    = 175,
              members    = 1/2 (joined/total),
              act_id     = 31,
              last_appl. = -1,
              protocols  = 0/7/3 (gcs/repl/appl),
              group UUID = ca2bb6d4-ff5d-11e7-8871-7f48103f96c0
      2018-01-22 14:55:32 140617799673600 [Note] WSREP: Flow-control interval: [23, 23]
      2018-01-22 14:55:32 140617799673600 [Note] WSREP: Trying to continue unpaused monitor
      2018-01-22 14:55:32 140617799673600 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 31)
      2018-01-22 14:55:32 140618039088896 [Note] WSREP: State transfer required:
              Group state: ca2bb6d4-ff5d-11e7-8871-7f48103f96c0:31
              Local state: 00000000-0000-0000-0000-000000000000:-1
      2018-01-22 14:55:32 140618039088896 [Note] WSREP: New cluster view: global state: ca2bb6d4-ff5d-11e7-8871-7f48103f96c0:31, view# 176: Primary, number of nodes: 2, my index: 0, protocol version 3
      2018-01-22 14:55:32 140618039088896 [Warning] WSREP: Gap in state sequence. Need state transfer.
      2018-01-22 14:55:32 140617791280896 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'joiner' --address '192.168.104.195' --datadir '/var/lib/mysql/'   --parent '31544'  '' '
      WSREP_SST: [INFO] Streaming with xbstream (20180122 14:55:32.986)
      WSREP_SST: [INFO] Using socat as streamer (20180122 14:55:32.989)
      which: no socat in (/usr/sbin:/sbin:/usr//bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin)
      WSREP_SST: [ERROR] socat not found in path: /usr/sbin:/sbin:/usr//bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin (20180122 14:55:32.993)
      2018-01-22 14:55:32 140617791280896 [ERROR] WSREP: Failed to read 'ready <addr>' from: wsrep_sst_mariabackup --role 'joiner' --address '192.168.104.195' --datadir '/var/lib/mysql/'   --parent '31544'  ''
              Read: '(null)'
      2018-01-22 14:55:32 140617791280896 [ERROR] WSREP: Process completed with error: wsrep_sst_mariabackup --role 'joiner' --address '192.168.104.195' --datadir '/var/lib/mysql/'   --parent '31544'  '' : 2 (No such file or directory)
      2018-01-22 14:55:32 140618039088896 [ERROR] WSREP: Failed to prepare for 'mariabackup' SST. Unrecoverable.
      2018-01-22 14:55:32 140618039088896 [ERROR] Aborting
      

      Error in my_thread_global_end(): 1 threads didn't exit
      

      Attachments

        Issue Links

          Activity

            People

              jplindst Jan Lindström (Inactive)
              winstone Zdravelina Sokolovska (Inactive)
              Votes:
              0 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.