[MDEV-14070] remove check: WSREP: wsrep_sst_receive_address is set to '127.0.0.1:16001' which makes it impossible for another host to reach this one. Please set it to the address which this node can be connected at by other cluster members. Created: 2017-10-14  Updated: 2021-05-13  Resolved: 2018-03-23

Status: Closed
Project: MariaDB Server
Component/s: Galera SST
Affects Version/s: 10.1, 10.2
Fix Version/s: 10.1.32, 10.2.14

Type: Bug Priority: Major
Reporter: Andrii Nikitin (Inactive) Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
blocks MDEV-14069 galera_sst_mysqldump.test fails with:... Closed

 Description   

WSREP: wsrep_sst_receive_address is set to '127.0.0.1:16001' which makes it impossible for another host to reach this one. Please set it to the address which this node can be connected at by other cluster members.



 Comments   
Comment by Andrii Nikitin (Inactive) [ 2017-10-15 ]

[ERROR] WSREP: wsrep_sst_method is set to 'mysqldump' yet mysqld bind_address is set to '127.0.0.1', which makes it impossible to receive state transfer from another node, since mysqld won't accept such connections. If you wish to use mysqldump state transfer method, set bind_address to allow mysql client connections from other cluster members (e.g. 0.0.0.0).

Comment by Andrii Nikitin (Inactive) [ 2017-11-02 ]

These two checks complicate use and testing nodes on single host , which is completely valid scenario for many cases.
It will be easy to diagnose why this host cannot be contacted from another host, so this check doesn't really help and puts artificial requirement to have bind_address=0.0.0.0 if node is intended to be used only locally.

Comment by Andrii Nikitin (Inactive) [ 2017-11-02 ]

sachin.setiya.007 Could you approve following patch:

--- a/sql/wsrep_check_opts.cc
+++ b/sql/wsrep_check_opts.cc
@@ -335,7 +335,7 @@ check_opts (int const argc, const char* const argv[], struct opt opts[])
         if (!strcasecmp(opts[BIND_ADDRESS].value, "127.0.0.1") ||
             !strcasecmp(opts[BIND_ADDRESS].value, "localhost"))
         {
-            WSREP_ERROR ("wsrep_sst_method is set to 'mysqldump' yet "
+            WSREP_WARN ("wsrep_sst_method is set to 'mysqldump' yet "
                          "mysqld bind_address is set to '%s', which makes it "
                          "impossible to receive state transfer from another "
                          "node, since mysqld won't accept such connections. "
@@ -343,7 +343,7 @@ check_opts (int const argc, const char* const argv[], struct opt opts[])
                          "set bind_address to allow mysql client connections "
                          "from other cluster members (e.g. 0.0.0.0).",
                          opts[BIND_ADDRESS].value);
-            rcode = EINVAL;
+//            rcode = EINVAL;
         }
     }

Generated at Thu Feb 08 08:10:41 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.