MySQL Forums
Forum List  »  Replication

ERROR 3092 (HY000): The server is not configured properly to be an active member of the group
Posted by: Mayura Hettiarachchi
Date: August 26, 2021 06:31AM

Hi All
Please note below mention error raised when try to start group replication

2021-08-23T09:33:42.337402Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to 10.0.1.188:33061 on local port: 33061.'
2021-08-23T09:33:42.337645Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to 10.0.1.169:33061 on local port: 33061.'
2021-08-23T09:33:42.337879Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to 10.0.1.188:33061 on local port: 33061.'
2021-08-23T09:33:42.338135Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error on opening a connection to 10.0.1.169:33061 on local port: 33061.'
2021-08-23T09:33:42.338172Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error connecting to all peers. Member join failed. Local port: 33061'
2021-08-23T09:33:43.399624Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] The member was unable to join the group. Local port: 33061'
2021-08-23T09:33:46.978957Z 24 [ERROR] [MY-011640] [Repl] Plugin group_replication reported: 'Timeout on wait for view after joining group'
2021-08-23T09:33:46.979142Z 24 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] The member is leaving a group without being on one.'
2021-08-23T09:33:46.982752Z 25 [System] [MY-011566] [Repl] Plugin group_replication reported: 'Setting super_read_only=OFF.'


--------------This is my node 1 my.cnf------------------
server_id=1
bind-address=0.0.0.0
gtid_mode=ON
enforce_gtid_consistency=ON
binlog_checksum=NONE

loose-group_replication_group_name="9fe694fe-e578-11eb-858b-000017004a45"
loose-group_replication_start_on_boot=OFF
loose-group_replication_local_address= "10.0.1.140:33061"
loose-group_replication_group_seeds="10.0.1.140:33061, 10.0.1.188:33061, 10.0.1.169:33061"

---------------This is my node 2 my.cnf---------------
server_id=2
bind-address=0.0.0.0
gtid_mode=ON
enforce_gtid_consistency=ON
binlog_checksum=NONE


loose-group_replication_group_name="9fe694fe-e578-11eb-858b-000017004a45"
loose-group_replication_start_on_boot=OFF
loose-group_replication_local_address= "10.0.1.188:33061"
loose-group_replication_group_seeds="10.0.1.140:33061, 10.0.1.188:33061, 10.0.1.169:33061"
loose-group_replication_bootstrap_group=OFF

Regards
Mayura

Options: ReplyQuote


Subject
Views
Written By
Posted
ERROR 3092 (HY000): The server is not configured properly to be an active member of the group
385
August 26, 2021 06:31AM


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.