MySQL Error number: MY-011505; Symbol: ER_GRP_RPL_MEMBER_EXPELLED; SQLSTATE: HY000 报错 故障修复 远程处理

文档解释

Error number: MY-011505; Symbol: ER_GRP_RPL_MEMBER_EXPELLED; SQLSTATE: HY000

Message: Member was expelled from the group due to network failures, changing member status to ERROR.

MySQL error number MY-011505 (ER_GRP_RPL_MEMBER_EXPELLED) is an error indication that a Group Replication member has been expelled from a replication group.

Description：

The ER_GRP_RPL_MEMBER_EXPELLED MySQL error message indicates the Group Replication member has been automatically expelled from the replication group. This error can happen when the server’s resources have been exhausted, when a non-recovered non-temporary error occurs, or when there is an incompatibility between members of the replication group. All of these conditions must be addressed before the Replication Group member can be re-established and synchronized with other members.

Common Cases：

Common cases that could lead to this particular error include the following:

1. If a server’s resources are exhausted due to a disproportionate amount of traffic or other operations, the server may be unable to handle all the tasks associated with Group Replication. This can lead to the Group Replication member being automatically expelled as a result.

2. In some cases, a non-recovered non-temporary error can occur in a Replication Group. If the error is severe enough, the server may be expelled from the Group Replication cluster.

3. When forming a Replication Group, each member must be technically and logically compatible with each other. If there is an incompatibility detected between two or more members, then the server may be expelled from the Group Replication cluster.

Solution：

In order to address and prevent this error from occurring in the future, the root cause of the problem must be identified and corrected. If the problem is related to resource exhaustion, the load on the server must be reduced. This can be done by reducing the number of requests made to the server, or by increasing the server’s capacity to handle more traffic. If the problem is related to a non-recovered non-temporary error, then this must be resolved before proceeding with re-integrating the server into the Replication Group. Lastly, if the issue is related to incompatibility between members of the Replication Group, then a system patch must be applied to bring the versions of the members into sync.

Once the underlying cause of the problem is identified and corrected, the expelled Group Replication member may be re-established and synchronized with the other members.