Debian Codegraph @

mysql-test/suite/galera_3nodes/t/GAL-501.test

raw
1 #
2 # Test GAL-501 Improved URI parsing for IPv6 addresses
3 # The .cnf file contains
4 # wsrep_node_address=[::1]
5 # ist.recv_addr=[::1]
6
7 --let galera_connection_address=::1
8 --source include/galera_cluster.inc
9 --source include/check_ipv6.inc
10 --source include/force_restart.inc
11
12 --let $galera_connection_name = node_3
13 --let $galera_server_number = 3
14 --source include/galera_connect.inc
15 --connection node_3
16 --source include/galera_wait_ready.inc
17
18 # Confirm that initial handshake happened over ipv6
19
20 SELECT VARIABLE_VALUE LIKE '%[::1]%' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_incoming_addresses';
21 SELECT VARIABLE_VALUE = 3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
22
23 # Force IST
24
25 --connection node_2
26 SET GLOBAL wsrep_provider_options='gmcast.isolate=1';
27
28 --connection node_1
29 --let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
30 --source include/wait_condition.inc
31
32 CREATE TABLE t1 (f1 INTEGER NOT NULL PRIMARY KEY) ENGINE=InnoDB;
33 INSERT INTO t1 VALUES (1);
34
35 --connection node_2
36 SET GLOBAL wsrep_provider_options='gmcast.isolate=0';
37
38 --let $wait_condition = SELECT VARIABLE_VALUE = 3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
39 --source include/wait_condition.inc
40
41 --let $wait_condition = SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
42 --source include/wait_condition.inc
43
44 SELECT COUNT(*) AS EXPECT_1 FROM t1;
45
46 DROP TABLE t1;