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

With wsrep_sst_rsync , Node goes into endless loop when trying to establish connection to donor for IST

Details

    Description

      Platform: FreeBSD

      With regex in wsrep_sst_rsync script function check_pid_and_port :

       
      		 
      if [ $lsof_available -ne 0 ]; then
      		 
      port_info=$(lsof -Pnl -i ":$port" 2>/dev/null | \
      		 
      grep -F '(LISTEN)')
      		 
      echo "$port_info" | \
      		 
      grep -q -E "[[:space:]](\\*|\\[?::\\]?):$port[[:space:]]" && busy=1

      If the database is bind on specific IP address, not * the IST will never happen and Joiner node will loop forever and wait "rsync" to start listen on * .

      When we remove lsof package, the * wsrep_sst_rsync* script fallback to sockstat and its working fine.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          pramod.mahto@mariadb.com Pramod Mahto created issue -
          pramod.mahto@mariadb.com Pramod Mahto made changes -
          Field Original Value New Value
          Description Platform: FreeBSD

          With regex in *wsrep_sst_rsync *script function *check_pid_and_port* :

          {code}

          if [ $lsof_available -ne 0 ]; then
          port_info=$(lsof -Pnl -i ":$port" 2>/dev/null | \
          grep -F '(LISTEN)')
          echo "$port_info" | \
          grep -q -E "[[:space:]](\\*|\\[?::\\]?):$port[[:space:]]" && busy=1

          {code}

          If the database is bind on specific IP address, not "*" the IST will never happen and Joiner node will loop forever and wait "rsync" to start listen on "*".

          When we remove *lsof *package, the* wsrep_sst_rsync* script fallback to sockstat and its working fine.           		Platform: FreeBSD

          With regex in *wsrep_sst_rsync * script function *check_pid_and_port* :

          {code}

          if [ $lsof_available -ne 0 ]; then
          port_info=$(lsof -Pnl -i ":$port" 2>/dev/null | \
          grep -F '(LISTEN)')
          echo "$port_info" | \
          grep -q -E "[[:space:]](\\*|\\[?::\\]?):$port[[:space:]]" && busy=1

          {code}

          If the database is bind on specific IP address, not "*" the IST will never happen and Joiner node will loop forever and wait "rsync" to start listen on "*".

          When we remove *lsof * package, the * wsrep_sst_rsync* script fallback to sockstat and its working fine.
          pramod.mahto@mariadb.com Pramod Mahto made changes -
          Description Platform: FreeBSD

          With regex in *wsrep_sst_rsync * script function *check_pid_and_port* :

          {code}

          if [ $lsof_available -ne 0 ]; then
          port_info=$(lsof -Pnl -i ":$port" 2>/dev/null | \
          grep -F '(LISTEN)')
          echo "$port_info" | \
          grep -q -E "[[:space:]](\\*|\\[?::\\]?):$port[[:space:]]" && busy=1

          {code}

          If the database is bind on specific IP address, not "*" the IST will never happen and Joiner node will loop forever and wait "rsync" to start listen on "*".

          When we remove *lsof * package, the * wsrep_sst_rsync* script fallback to sockstat and its working fine.           		Platform: FreeBSD

          With regex in wsrep_sst_rsync script function check_pid_and_port :

          {code}

          if [ $lsof_available -ne 0 ]; then
          port_info=$(lsof -Pnl -i ":$port" 2>/dev/null | \
          grep -F '(LISTEN)')
          echo "$port_info" | \
          grep -q -E "[[:space:]](\\*|\\[?::\\]?):$port[[:space:]]" && busy=1

          {code}

          If the database is bind on specific IP address, not * the IST will never happen and Joiner node will loop forever and wait "rsync" to start listen on * .

          When we remove lsof package, the * wsrep_sst_rsync* script fallback to sockstat and its working fine.
          pramod.mahto@mariadb.com Pramod Mahto made changes -
          Assignee Julius Goryavsky [ sysprg ]
          Labels FreeBSD
          sysprg Julius Goryavsky made changes -
          Fix Version/s 10.4 [ 22408 ]
          Fix Version/s 10.5 [ 23123 ]
          Fix Version/s 10.6 [ 24028 ]
          sysprg Julius Goryavsky made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          ralf.gebhardt Ralf Gebhardt made changes -
          Status In Progress [ 3 ] Needs Feedback [ 10501 ]
          ramesh Ramesh Sivaraman made changes -
          Status Needs Feedback [ 10501 ] Open [ 1 ]
          ramesh Ramesh Sivaraman made changes -
          Status Open [ 1 ] Confirmed [ 10101 ]
          sysprg Julius Goryavsky made changes -
          Status Confirmed [ 10101 ] In Progress [ 3 ]
          ralf.gebhardt Ralf Gebhardt made changes -
          Priority Critical [ 2 ] Major [ 3 ]
          sysprg Julius Goryavsky made changes -
          Status In Progress [ 3 ] Stalled [ 10000 ]
          mariadb-jira-automation Jira Automation (IT) made changes -
          Zendesk Related Tickets 143823
          sysprg Julius Goryavsky made changes -
          Status Stalled [ 10000 ] In Progress [ 3 ]
          sysprg Julius Goryavsky added a comment -

          Fixed, https://github.com/MariaDB/server/commit/2c5d8376cdfd25d7510c85b3896b506715f96590

          sysprg Julius Goryavsky added a comment - Fixed, https://github.com/MariaDB/server/commit/2c5d8376cdfd25d7510c85b3896b506715f96590
          sysprg Julius Goryavsky made changes -
          Fix Version/s 10.5.27 [ 29902 ]
          Fix Version/s 10.4 [ 22408 ]
          Fix Version/s 10.5 [ 23123 ]
          Fix Version/s 10.6 [ 24028 ]
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Closed [ 6 ]
          JIraAutomate JiraAutomate made changes -
          Fix Version/s 10.6.20 [ 29903 ]
          Fix Version/s 10.11.10 [ 29904 ]
          Fix Version/s 11.2.6 [ 29906 ]
          Fix Version/s 11.4.4 [ 29907 ]
          sysprg Julius Goryavsky made changes -
          Labels FreeBSD FreeBSD linux

          People

            sysprg Julius Goryavsky
            pramod.mahto@mariadb.com Pramod Mahto
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.