Bug #88452 | No Check for duplicatio @@server_uuid when joining group | ||
---|---|---|---|
Submitted: | 13 Nov 2017 1:15 | Modified: | 13 Dec 2017 15:40 |
Reporter: | Jesper wisborg Krogh | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Group Replication | Severity: | S2 (Serious) |
Version: | 5.7.19 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[13 Nov 2017 1:15]
Jesper wisborg Krogh
[13 Nov 2017 1:19]
Jesper wisborg Krogh
Posted by developer: Result of START GROUP_REPLICATION: Node 1: ------- gr1> SET GLOBAL group_replication_bootstrap_group = ON; Query OK, 0 rows affected (0.00 sec) gr1> START GROUP_REPLICATION; Query OK, 0 rows affected (2.07 sec) gr1)> SET GLOBAL group_replication_bootstrap_group = OFF; Query OK, 0 rows affected (0.00 sec) Node 2: ------- gr2> START GROUP_REPLICATION; Query OK, 0 rows affected (6.57 sec) Node 3: ------- (Has the duplicate UUID) gr3> START GROUP_REPLICATION; Query OK, 0 rows affected (3.16 sec)
[13 Dec 2017 15:40]
David Moss
Posted by developer: Thank you for your feedback, this has been fixed in upcoming versions and the following was added to the 5.7.21 / 8.0.4 change logs: All servers that belong to a group must have unique UUIDs set by server_uuid, but this was not being enforced by Group Replication and it was possible to add members with duplicated UUIDs.
[1 Feb 2018 14:03]
David Moss
Now published.