| Bug #117296 | Group Replication fails when hostname consists only of digits | ||
|---|---|---|---|
| Submitted: | 27 Jan 11:22 | Modified: | 28 Jan 11:02 |
| Reporter: | Przemysław Skibiński (OCA) | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: Group Replication | Severity: | S3 (Non-critical) |
| Version: | 8.0.41, 8.4.4 | OS: | Ubuntu |
| Assigned to: | CPU Architecture: | Any | |
[27 Jan 13:14]
MySQL Verification Team
I think this is intentional and not a bug but I'll verify this so that GR team can confirm one way or another. Thank you for report.
[28 Jan 11:02]
Przemysław Skibiński
Is it documented somewhere that hostnames consisting only of digits are not allowed for MySQL and a server will fail to start?
Description: All GR MTR tests failed when my hostname was "9554": CURRENT_TEST: group_replication.gr_binlog_checksum mysqltest: At line 21: Query 'START GROUP_REPLICATION' failed. ERROR 3096 (HY000): The START GROUP_REPLICATION command failed as there was an error when initializing the group communication layer. In included file ./include/start_group_replication_command.inc: 21 included from ./include/start_group_replication.inc: 55 included from ./include/start_and_bootstrap_group_replication.inc: 25 included from /data/mysql-server/mysql-8.0/mysql-test/suite/group_replication/t/gr_binlog_checksum.test: 32 The error was: 2025-01-27T10:06:00.304505Z 15 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Invalid IP or subnet mask in the allowlist: 9554/8' I found it comes from mysqld.1/data/mysqld-auto.cnf: {"Version": 2, "mysql_static_variables": {"group_replication_ip_allowlist": {"Value": "127.0.0.1/32,10.0.0.0/8,172.16.0.0/12,192.168.0.0/16,::1/128,fe80::/10,fd00::/8,9554/8", "Metadata": {"Host": "localhost", "User": "root", "Timestamp": 1737973389412240}}}} Probably MySQL treats numerical hostname as an IP address. How to repeat: Change your hostname to digits only. Run GR tests.