3092 database network_error ai_generated partial

ERROR 3092 (HY000): 服务器未正确配置为组的一部分。该成员因网络分区或仲裁丢失而离开了组。

ERROR 3092 (HY000): The server is not configured properly to be part of a group. The member has left the group due to network partition or quorum loss.

ID: database/mysql-group-replication-quorum-loss

其他格式: JSON · Markdown 中文 · English
78%修复率
87%置信度
1证据数
2024-05-22首次发现

版本兼容性

版本状态引入弃用备注
MySQL 8.0 active — — —
MySQL 8.4 active — — —
MySQL 9.0 active — — —
MySQL Shell 8.0.34 active — — —
Group Replication 8.0 active — — —

根因分析

MySQL组复制成员无法与大多数组成员保持连接，导致其因仲裁丢失或网络分区而离开组。

English

A MySQL Group Replication member cannot maintain connectivity with the majority of group members, causing it to leave the group due to quorum loss or network partition.

generic

官方文档

https://dev.mysql.com/doc/refman/8.0/en/group-replication-quorum-loss.html

解决方案

  1. Force the group to re-elect a primary by setting group_replication_force_members to the surviving members' addresses. Example: SET GLOBAL group_replication_force_members='192.168.1.10:33061,192.168.1.11:33061';
  2. Increase group_replication_member_expel_timeout to allow more time for reconnection. Example: SET GLOBAL group_replication_member_expel_timeout=30;
  3. Check network connectivity between all group members using ping and telnet, then fix firewall rules or DNS resolution. Example: ping 192.168.1.12 && telnet 192.168.1.12 33061

无效尝试

常见但无效的做法:

  1. Restart the MySQL server without checking group replication status. 85% 失败

    Restarting alone does not restore quorum; the member will still fail to rejoin if the network partition persists or group view is inconsistent.

  2. Manually remove the member from the group using STOP GROUP_REPLICATION and then add it back without fixing network issues. 90% 失败

    If the underlying network issue (e.g., firewall, latency) is not resolved, the member will leave again immediately.