3092 database network_error ai_generated partial

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

Also available as: JSON · Markdown · 中文
78%Fix Rate
87%Confidence
1Evidence
2024-05-22First Seen

Version Compatibility

VersionStatusIntroducedDeprecatedNotes
MySQL 8.0 active — — —
MySQL 8.4 active — — —
MySQL 9.0 active — — —
MySQL Shell 8.0.34 active — — —
Group Replication 8.0 active — — —

Root Cause

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

中文

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

Official Documentation

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

Workarounds

  1. 75% success 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'; 
    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. 70% success Increase group_replication_member_expel_timeout to allow more time for reconnection. Example: SET GLOBAL group_replication_member_expel_timeout=30; 
    Increase group_replication_member_expel_timeout to allow more time for reconnection. Example: SET GLOBAL group_replication_member_expel_timeout=30;
  3. 85% success 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 
    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. 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

Dead Ends

Common approaches that don't work:

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

    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% fail

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