| 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: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | 5.7.20 | OS: | Red Hat |
| Assigned to: | MySQL Verification Team | CPU Architecture: | Any |
[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

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