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

- **ID:** `database/mysql-group-replication-quorum-loss`
- **领域:** database
- **类别:** network_error
- **错误码:** `3092`
- **验证级别:** ai_generated
- **修复率:** 78%

## 根因

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

## 版本兼容性

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

## 解决方案

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
   ```

## 无效尝试

- **Restart the MySQL server without checking group replication status.** — Restarting alone does not restore quorum; the member will still fail to rejoin if the network partition persists or group view is inconsistent. (85% 失败率)
- **Manually remove the member from the group using STOP GROUP_REPLICATION and then add it back without fixing network issues.** — If the underlying network issue (e.g., firewall, latency) is not resolved, the member will leave again immediately. (90% 失败率)