Debian Codegraph @

mysql-test/suite/galera_3nodes/t/galera_evs_suspect_timeout.test

raw
1 #
2 # Test the operation of evs.suspect_timeout.
3 #
4 # We set evs.inactive_timeout to a very high value so that evs.suspect_timeout can kick in instead.
5 #
6
7 --source include/galera_cluster.inc
8 --source include/have_innodb.inc
9
10 --let $galera_connection_name = node_3
11 --let $galera_server_number = 3
12 --source include/galera_connect.inc
13
14 # Save original auto_increment_offset values.
15 --let $node_1=node_1
16 --let $node_2=node_2
17 --let $node_3=node_3
18 --source ../galera/include/auto_increment_offset_save.inc
19
20 --connection node_1
21 --let $wait_condition = SELECT VARIABLE_VALUE = 3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'
22 --source include/wait_condition.inc
23
24 --let $wsrep_provider_options_node1 = `SELECT @@wsrep_provider_options`
25 SET GLOBAL wsrep_provider_options = 'evs.inactive_timeout=PT100M; evs.suspect_timeout=PT1S';
26
27 --connection node_2
28 --let $wsrep_provider_options_node2 = `SELECT @@wsrep_provider_options`
29 SET GLOBAL wsrep_provider_options = 'evs.inactive_timeout=PT100M; evs.suspect_timeout=PT1S';
30
31 --connection node_3
32 --let $wsrep_cluster_address_node3 = `SELECT @@wsrep_cluster_address`
33 --let $wsrep_provider_options_node3 = `SELECT @@wsrep_provider_options`
34
35 # Suspend node #3
36 --connection node_3
37 --source include/galera_suspend.inc
38
39 # Confirm that the other nodes have booted it out
40
41 --connection node_1
42 SET SESSION wsrep_sync_wait=0;
43 --let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'
44 --source include/wait_condition.inc
45
46 --connection node_2
47 SET SESSION wsrep_sync_wait=0;
48 --let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'
49 --source include/wait_condition.inc
50
51 --connection node_1
52 --disable_query_log
53 --eval SET GLOBAL wsrep_provider_options = '$wsrep_provider_options_node1';
54 --enable_query_log
55 --source include/wait_until_connected_again.inc
56
57 CREATE TABLE t1 (f1 INTEGER) engine=InnoDB;
58 INSERT INTO t1 VALUES (1);
59
60 --connection node_2
61 --disable_query_log
62 --eval SET GLOBAL wsrep_provider_options = '$wsrep_provider_options_node2';
63 --enable_query_log
64 --source include/wait_until_connected_again.inc
65
66 SET SESSION wsrep_sync_wait = 15;
67 SELECT COUNT(*) FROM t1;
68
69 # Reconnect node #3 so that MTR's end-of-test checks can run
70
71 --connection node_3
72 --source include/galera_resume.inc
73 --source include/wait_until_connected_again.inc
74
75 --disable_query_log
76 --eval SET GLOBAL wsrep_provider_options = '$wsrep_provider_options_node3';
77 --eval SET GLOBAL wsrep_cluster_address = '$wsrep_cluster_address_node3';
78 --enable_query_log
79 --source include/galera_wait_ready.inc
80
81 CALL mtr.add_suppression("WSREP: gcs_caused");
82 CALL mtr.add_suppression("WSREP: gcs/src/gcs_core\\.cpp:core_handle_uuid_msg");
83
84 SET SESSION wsrep_sync_wait = 15;
85 SELECT COUNT(*) FROM t1;
86
87 --connection node_1
88 --let $wait_condition = SELECT VARIABLE_VALUE = 3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'
89 --source include/wait_condition.inc
90
91 --connection node_2
92 --let $wait_condition = SELECT VARIABLE_VALUE = 3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'
93 --source include/wait_condition.inc
94
95 DROP TABLE t1;
96
97 # Restore original auto_increment_offset values.
98 --source ../galera/include/auto_increment_offset_restore.inc