| Bug #98524 | ERROR 3096 (HY000): The START GROUP_REPLICATION command failed as there was an e | ||
|---|---|---|---|
| Submitted: | 9 Feb 2020 2:47 | Modified: | 12 Sep 2023 10:51 |
| Reporter: | wayne hu | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server: Group Replication | Severity: | S3 (Non-critical) |
| Version: | 8.0.19 | OS: | CentOS |
| Assigned to: | CPU Architecture: | x86 | |
| Tags: | [MY-011735] | ||
[26 Feb 2020 5:12]
MySQL Verification Team
Hi, Thanks for the report. I agree this is a bug. Workaround is simple but should be fixed anyhow. Thanks Bogdan
[28 Feb 2020 12:20]
Nuno Carvalho
Posted by developer: Hi, Thank you for the bug report. I was not able to reproduce it. Looking to the error [16:58:03]2020-02-08T08:57:30.035733Z 2 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Invalid hostname or IP address (?"127.0.0.1:33061") assigned to the parameter local_node!' we can see a question mark on the group_replication_local_address value, this is a indication that the my.cnf has a encoding that was not understood. Can you please check what is your my.cnf encoding? Best regards, Nuno Carvalho
[28 Feb 2020 12:38]
wayne hu
vi my.cnf # Disable other storage engines # disabled_storage_engines="MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY" # # Replication configuration parameters fileencoding=utf-8 # # Replication configuration parameters # server_id=4401 gtid_mode=ON enforce_gtid_consistency=ON binlog_checksum=NONE master_info_repository=TABLE relay_log_info_repository=TABLE # # Group Replication configuration # transaction_write_set_extraction=XXHASH64 group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa" group_replication_start_on_boot=on group_replication_local_address='127.0.0.1:33061' group_replication_group_seeds='127.0.0.1:33061,127.0.0.1:33062,127.0.0.1:33063' ~ ~ ~ ~ ~ ~ ~ ~ fileencoding=utf-8 -------------------------------------- My my.cnf encoding is utf-8 ========================================= [16:58:03]2020-02-08T08:57:30.035604Z 2 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Peer address " "127.0.0.1:33061" is not valid.' [16:58:03]2020-02-08T08:57:30.035697Z 2 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Peer address "127.0.0.1:33063"" is not valid.' [16:58:03]2020-02-08T08:57:30.035733Z 2 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Invalid hostname or IP address ( "127.0.0.1:33061") assigned to the parameter local_node!' [16:58:03]2020-02-08T08:57:30.036025Z 2 [ERROR] [MY-011674] [Repl] Plugin group_replication reported: 'Unable to initialize the group communication engine' [16:58:03]2020-02-08T08:57:30.036074Z 2 [ERROR] [MY-011637] [Repl] Plugin group_replication reported: 'Error on group communication engine initialization' [16:58:03]2020-02-08T08:57:30.036106Z 2 [ERROR] [MY-011718] [Repl] Plugin group_replication reported: 'Error calling group communication interfaces while trying to leave the group' ----------------------------------------------------------------- the error was copy from error log,and there wasn't question mark ----------------------------------------------------------------- you can add space after equal sign(=) such as : group_replication_local_address = "......."
[28 Feb 2020 14:10]
Nuno Carvalho
Posted by developer: Hi Waine, I'm unable to reproduce this. What is the output of? file -i my.cnf Can you please upload your my.cnf? What is your operating system default encoding? Best regards, Nuno Carvalho
Description: my.cnf has configured as : group_replication_local_address= "127.0.0.1:33061" group_replication_group_seeds= "127.0.0.1:33061,127.0.0.1:33062,127.0.0.1:33063" ------------------------------------------------------------- or like this: group_replication_local_address= '127.0.0.1:33061' group_replication_group_seeds= '127.0.0.1:33061,127.0.0.1:33062,127.0.0.1:33063' ------------------------------------------------------------- when I run command: start group_replication mysql report error: [20:58:30]mysql> START GROUP_REPLICATION; [20:58:55] [21:01:51]ERROR 3096 (HY000): The START GROUP_REPLICATION command failed as there was an error when initializing the group communication layer. ------------------------------------------------------------- and the error log report error: [16:58:03]2020-02-08T08:57:30.035604Z 2 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Peer address " "127.0.0.1:33061" is not valid.' [16:58:03]2020-02-08T08:57:30.035697Z 2 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Peer address "127.0.0.1:33063"" is not valid.' [16:58:03]2020-02-08T08:57:30.035733Z 2 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Invalid hostname or IP address ( "127.0.0.1:33061") assigned to the parameter local_node!' [16:58:03]2020-02-08T08:57:30.036025Z 2 [ERROR] [MY-011674] [Repl] Plugin group_replication reported: 'Unable to initialize the group communication engine' [16:58:03]2020-02-08T08:57:30.036074Z 2 [ERROR] [MY-011637] [Repl] Plugin group_replication reported: 'Error on group communication engine initialization' [16:58:03]2020-02-08T08:57:30.036106Z 2 [ERROR] [MY-011718] [Repl] Plugin group_replication reported: 'Error calling group communication interfaces while trying to leave the group' How to repeat: my.cnf has configured as : group_replication_local_address= "127.0.0.1:33061" group_replication_group_seeds= "127.0.0.1:33061,127.0.0.1:33062,127.0.0.1:33063" ------------------------------------------------------------- or like this: group_replication_local_address= '127.0.0.1:33061' group_replication_group_seeds= '127.0.0.1:33061,127.0.0.1:33062,127.0.0.1:33063' ------------------------------------------------------------- run command: start group_replication Suggested fix: my.cnf can only configured as : group_replication_local_address='127.0.0.1:33061' group_replication_group_seeds='127.0.0.1:33061,127.0.0.1:33062,127.0.0.1:33063' ------------------------------------------------------------- It's not allowed to use Double quotation marks(") and can't use space after equal sign(=)