Removing node from InnoDB cluster throws an exception.
Posted by:
root user
Date: January 23, 2019 12:59PM
Hi,
I'm trying to remove one of the nodes from MySQL InnoDB Cluster (5.7.24) but it throws an exception. I have tried to do the same from all the nodes but got the same exception.
Could someone check below details & help fixing this problem.
Commands executed with output:
MySQL node01:3306 ssl JS > var c = dba.getCluster()
MySQL node01:3306 ssl JS > c.status()
{
"clusterName": "dbacluster",
"defaultReplicaSet": {
"name": "default",
"primary": "node01:3306",
"ssl": "REQUIRED",
"status": "OK",
"statusText": "Cluster is ONLINE and can tolerate up to ONE failure.",
"topology": {
"node01:3306": {
"address": "node01:3306",
"mode": "R/W",
"readReplicas": {},
"role": "HA",
"status": "ONLINE"
},
"node02:3306": {
"address": "node02:3306",
"mode": "R/O",
"readReplicas": {},
"role": "HA",
"status": "ONLINE"
},
"node03:3306": {
"address": "node03:3306",
"mode": "R/O",
"readReplicas": {},
"role": "HA",
"status": "ONLINE"
}
}
},
"groupInformationSourceMember": "mysql://clusterAdministrator@node01:3306"
}
MySQL node01:3306 ssl JS > c.removeInstance("clusterAdministrator@node03:3306")
The instance will be removed from the InnoDB cluster. Depending on the instance
being the Seed or not, the Metadata session might become invalid. If so, please
start a new session to the Metadata Storage R/W instance.
Cluster.removeInstance: get_string(7): field is NULL (LogicError)
MySQL node01:3306 ssl JS >