MYSQL::MY-011505 Repl Plugin group_replication reported Member was expelled from the --group due to network failures changing member status to ERROR MY-011712 MY-011735

 #MY-011505 Repl Plugin group_replication reported Member was expelled from the 

--group due to network failures changing member status to ERROR MY-011712 MY-011735 

--Verified MISSING node ERROR node resolution#

Solution: cluster.rejoinInstance("adminlogin@DBSERVER_IP:3306") at primary node .

---------------------------------------------------------------------------------

 MySQL  JS > \c adminlogin@DBSERVER_IP:3306

Creating a session to 'adminlogin@DBSERVER_IP:3306'

Fetching schema names for autocompletion... Press ^C to stop.

Your MySQL connection id is 26666197

Server version: 8.0.20-commercial MySQL Enterprise Server - Commercial

No default schema selected; type \use <schema> to set one.

 MySQL  DBSERVER_IP:3306 ssl  JS > var cluster=dba.getCluster()

 MySQL  DBSERVER_IP:3306 ssl  JS > cluster.status();

{

    "clusterName": "uatcluster",

    "defaultReplicaSet": {

        "name": "default",

        "primary": "DBSERVER_IP:3306",

        "ssl": "REQUIRED",

        "status": "OK_NO_TOLERANCE",

        "statusText": "Cluster is NOT tolerant to any failures. 1 member is not active",

        "topology": {

            "DBSERVERIP1:3306": {

                "address": "DBSERVERIP1:3306",

                "mode": "R/O",

                "readReplicas": {},

                "role": "HA",

                "status": "(MISSING)"

            },

            "DBSERVER_IP:3306": {

                "address": "DBSERVER_IP:3306",

                "mode": "R/W",

                "readReplicas": {},

                "replicationLag": null,

                "role": "HA",

                "status": "ONLINE",

                "version": "8.0.20"

            },

            "DBSERVERIP2:3306": {

                "address": "DBSERVERIP2:3306",

                "mode": "R/O",

                "readReplicas": {},

                "replicationLag": null,

                "role": "HA",

                "status": "ONLINE",

                "version": "8.0.20"

            }

        },

        "topologyMode": "Single-Primary"

    },

    "groupInformationSourceMember": "DBSERVER_IP:3306"

}

 MySQL  DBSERVER_IP:3306 ssl  JS > : cluster.rejoinInstance("adminlogin@DBSERVERIP1:3306")

SyntaxError: Unexpected token :

 MySQL  DBSERVER_IP:3306 ssl  JS > cluster.rejoinInstance("adminlogin@DBSERVERIP1:3306")

Rejoining the instance to the InnoDB cluster. Depending on the original

problem that made the instance unavailable, the rejoin operation might not be

successful and further manual steps will be needed to fix the underlying

problem.

Please monitor the output of the rejoin operation and take necessary action if

the instance cannot rejoin.

Rejoining instance to the cluster ...

The instance 'DBSERVERIP1:3306' was successfully rejoined on the cluster.

 MySQL  DBSERVER_IP:3306 ssl  JS >

---------------------------------------------------------------------------------