MySQL Forums
Forum List  »  InnoDB clusters

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 >

Options: ReplyQuote


Subject
Views
Written By
Posted
Removing node from InnoDB cluster throws an exception.
137
January 23, 2019 12:59PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.