Bug #92665 There is no local IP address matching the one configured for the local node
Submitted: 4 Oct 2018 6:08 Modified: 4 Oct 2018 6:25
Reporter: Andrew Dalgleish Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Group Replication Severity:S2 (Serious)
Version:5.7.23 OS:Any
Assigned to: CPU Architecture:Any

[4 Oct 2018 6:08] Andrew Dalgleish 
Description:
Execute "start group_replication" fail and error log show : 

'[GCS] There is no local IP address matching the one configured for the local node (192.168.10.10:24901).'

There is no way to configure GR to use a valid IP which is not detectable on a local interface, even if that IP works correctly.

How to repeat:
Install MySQL in a VM.

This includes Oracle Cloud Compute Classic node, and MySQLCS.

Suggested fix:
Please make this a warning instead of a fatal error.
[4 Oct 2018 6:17] MySQL Verification Team 
Partial workaround:
Use names instead of IPs for the GR configuration.
Add a loopback address to /etc/hosts to start GR.
Remove the loopback address from /etc/hosts
Call createCluster with adoptFromGR:true
Add the loopback back to /etc/hosts
[2 Jul 2019 1:10] Zhenghu Wen 
same as https://bugs.mysql.com/bug.php?id=93004
[9 Feb 2023 14:33] MySQL Verification Team 
Solution from Bug#109996 should fix this bug too