Bug #89993 ERROR: Error joining instance to cluster: 'db2:3306' - Query failed. 3092 (HY000
Submitted: 9 Mar 2018 15:48 Modified: 8 May 2018 4:13
Reporter: Sibel Kamer Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.7.20 OS:Red Hat
Assigned to: MySQL Verification Team CPU Architecture:Any

[9 Mar 2018 15:48] Sibel Kamer
Description:
mysql-js> var cluster = dba.getCluster('mycl');
mysql-js> cluster.addInstance('cladm@db2:3306', { memberSslMode: 'AUTO', ipWhitelist:'10.0.1.180,10.0.3.136,10.0.5.166'});
A new instance will be added to the InnoDB cluster. Depending on the amount of
data on the cluster this might take from a few seconds to several hours.

Please provide the password for 'cladm@db2:3306':
Adding instance to the cluster ...

Cluster.addInstance: WARNING: Not running locally on the server and can not access its error log.
ERROR:
Group Replication join failed.
ERROR: Error joining instance to cluster: 'db2:3306' - Query failed. 3092 (HY000): The server is not configured properly to be an active member of the group. Please see more details on error log.. Query: START group_replication (RuntimeError)
mysql-js>

How to repeat:
Try adding the mode again
[12 Mar 2018 15:11] Sibel Kamer
Hi,
I would appreciate if you could help me with this as I don't see what is wrong. SElinux is permissive, all ports open on FW.
[12 Mar 2018 15:11] Sibel Kamer
Hi,
I would appreciate if you could help me with this as I don't see what is wrong. SElinux is permissive, all ports open on FW.
[8 May 2018 4:13] MySQL Verification Team
Hi,

I'm sorry but I'm failing to reproduce your issue.  Creating cluster and adding nodes work ok.

can you share more data maybe?
all best
Bogdan