Debian Codegraph @

mysql-test/suite/group_replication/r/gr_recovery_endpoints_invalid_conf.result

raw
1 include/group_replication.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection server1]
6
7 # 1. Persist only group_replication_advertise_recovery_endpoints, it
8 # will be updated on configuration and read after restart
9 SET PERSIST_ONLY group_replication_advertise_recovery_endpoints = "127.0.0.1:0";
10
11 # 2. Restart server and start Group Replication on boot, it will fail
12 # due invalid configuration
13 # restart:--group_replication_group_name=GROUP_REPLICATION_GROUP_NAME --group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_bootstrap_group=1 --group_replication_start_on_boot=1
14 include/rpl_reconnect.inc
15
16 # 3. Assert server log message on wrong option on recovery endpoints
17 include/assert_grep.inc [invalid configuration used on recovery endpoints]
18
19 # 4. Persist only group_replication_advertise_recovery_endpoints, it
20 # will be updated on configuration and read after restart
21 SET PERSIST_ONLY group_replication_advertise_recovery_endpoints = "127.0.0.1:3600a";
22
23 # 5. Restart server and start Group Replication on boot, it will fail
24 # due configuration bad format
25 # restart:--group_replication_group_name=GROUP_REPLICATION_GROUP_NAME --group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_bootstrap_group=1 --group_replication_start_on_boot=1
26 include/rpl_reconnect.inc
27
28 # 6. Assert server log message on wrong option on recovery endpoints
29 include/assert_grep.inc [invalid configuration used on recovery endpoints]
30
31 # 7. START GROUP_REPLICATION , it will fail due invalid format.
32 START GROUP_REPLICATION;
33 ERROR HY000: Invalid input value for recovery socket endpoints '127.0.0.1:3600a'. Please, provide a valid, comma separated, list of endpoints (IP:port)
34
35 # 8. Restart server and start Group Replication with command START
36 # GROUP_REPLICATION , it will fail due invalid endpoint
37 SET PERSIST_ONLY group_replication_advertise_recovery_endpoints = "128.0.0.1:3600";
38 # restart:--group_replication_group_name=GROUP_REPLICATION_GROUP_NAME --group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_bootstrap_group=1 --group_replication_start_on_boot=0
39 include/rpl_reconnect.inc
40 START GROUP_REPLICATION;
41 ERROR HY000: The server is not listening on endpoint '128.0.0.1:3600'. Only endpoints that the server is listening on are valid recovery endpoints.
42
43 # 9. Try invalid configurations and confirm all return error
44 SET @@GLOBAL.group_replication_advertise_recovery_endpoints= "127.0.0.1:0";
45 ERROR HY000: Variable 'group_replication_advertise_recovery_endpoints' cannot be set to the value of '127.0.0.1:0'. Invalid value on recovery endpoint '127.0.0.1:0'.
46 SET @@GLOBAL.group_replication_advertise_recovery_endpoints= "127.0.0.500:1234";
47 ERROR HY000: Variable 'group_replication_advertise_recovery_endpoints' cannot be set to the value of '127.0.0.500:1234'. Invalid value on recovery endpoint '127.0.0.500:1234'.
48 SET @@GLOBAL.group_replication_advertise_recovery_endpoints= "[::1:1234";
49 ERROR HY000: Variable 'group_replication_advertise_recovery_endpoints' cannot be set to the value of '[::1:1234'. Invalid value on recovery endpoint '[::1:1234'.
50 SET @@GLOBAL.group_replication_advertise_recovery_endpoints= "[::1]:1234";
51 ERROR HY000: Variable 'group_replication_advertise_recovery_endpoints' cannot be set to the value of '[::1]:1234'. Invalid value on recovery endpoint '[::1]:1234'.
52 SET @@GLOBAL.group_replication_advertise_recovery_endpoints= "[0:0:0:0:0:0:0:2]:SERVER1_PORT";
53 ERROR HY000: Variable 'group_replication_advertise_recovery_endpoints' cannot be set to the value of '[0:0:0:0:0:0:0:2]:SERVER1_PORT'. Invalid value on recovery endpoint '[0:0:0:0:0:0:0:2]:SERVER1_PORT'.
54 SET @@GLOBAL.group_replication_advertise_recovery_endpoints= "127.0.0.1/namespace:1234";
55 ERROR HY000: Variable 'group_replication_advertise_recovery_endpoints' cannot be set to the value of '127.0.0.1/namespace:1234'. Invalid value on recovery endpoint '127.0.0.1/namespace:1234'.
56 SET @@GLOBAL.group_replication_advertise_recovery_endpoints= "unusedhostname:1234";
57 ERROR HY000: Variable 'group_replication_advertise_recovery_endpoints' cannot be set to the value of 'unusedhostname:1234'. Invalid value on recovery endpoint 'unusedhostname:1234'.
58 SET @@GLOBAL.group_replication_advertise_recovery_endpoints= "localhost:123";
59 ERROR HY000: Variable 'group_replication_advertise_recovery_endpoints' cannot be set to the value of 'localhost:123'. Invalid value on recovery endpoint 'localhost:123'.
60 SET @@GLOBAL.group_replication_advertise_recovery_endpoints= "";
61 ERROR HY000: Variable 'group_replication_advertise_recovery_endpoints' cannot be set to the value of ''. Please, provide a valid, comma separated, list of endpoints (IP:port).
62 SET @@GLOBAL.group_replication_advertise_recovery_endpoints= "127.0.0.1";
63 ERROR HY000: Variable 'group_replication_advertise_recovery_endpoints' cannot be set to the value of '127.0.0.1'. Please, provide a valid, comma separated, list of endpoints (IP:port).
64
65 # 10. Clean up
66 SET @@GLOBAL.group_replication_advertise_recovery_endpoints= "DEFAULT";
67 RESET PERSIST group_replication_advertise_recovery_endpoints;
68 set session sql_log_bin=0;
69 call mtr.add_suppression("Invalid input value for recovery socket endpoints '127.0.0.1:3600a'.*");
70 call mtr.add_suppression("The server is not listening on endpoint '127.0.0.1:0'.*");
71 call mtr.add_suppression("Unable to start Group Replication on boot");
72 set session sql_log_bin=1;
73 include/group_replication_end.inc