ERROR 3092 (HY000): The server is not configured properly to be an active member of the group
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
Subject
Views
Written By
Posted
ERROR 3092 (HY000): The server is not configured properly to be an active member of the group
4474
August 26, 2021 06:31AM
1308
August 26, 2021 09:20AM
Sorry, you can't reply to this topic. It has been closed.
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.