Debian Codegraph @

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

raw
1 #
2 # This test performs basic checks on the contents of the wsrep_schema
3 #
4 # wsrep_members_history checks are temporarily disabled until it
5 # can be made configurable.
6 #
7
8 --source include/galera_cluster.inc
9
10 --connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3
11 --connection node_1
12
13 # Save original auto_increment_offset values.
14 --let $node_1=node_1
15 --let $node_2=node_2
16 --let $node_3=node_3
17 --source ../galera/include/auto_increment_offset_save.inc
18
19 # Make the test fail if table structure has changed
20
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 SHOW CREATE TABLE mysql.wsrep_cluster;
25 SHOW CREATE TABLE mysql.wsrep_cluster_members;
26
27 # Checks for the wsrep_cluster table
28
29 SELECT COUNT(*) AS EXPECT_1 FROM mysql.wsrep_cluster;
30
31 SELECT cluster_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_state_uuid') FROM mysql.wsrep_cluster;
32
33 # Checks for the wsrep_cluster_members table
34
35 SELECT COUNT(*) AS EXPECT_3 FROM mysql.wsrep_cluster_members;
36
37 SELECT COUNT(*) = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size') FROM mysql.wsrep_cluster_members;
38
39 SELECT COUNT(*) AS EXPECT_1 FROM mysql.wsrep_cluster_members WHERE node_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_gcomm_uuid');
40
41 SELECT node_incoming_address LIKE '127.0.0.1:%' from mysql.wsrep_cluster_members;
42
43 SELECT cluster_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_state_uuid') FROM mysql.wsrep_cluster_members;
44
45 --connection node_2
46
47 --let $wait_condition = SELECT VARIABLE_VALUE = 3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
48 --source include/wait_condition.inc
49
50 SELECT COUNT(*) AS EXPECT_3 FROM mysql.wsrep_cluster_members;
51
52 --source include/shutdown_mysqld.inc
53
54 --connection node_1
55
56 --let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
57 --source include/wait_condition.inc
58
59 SELECT cluster_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_state_uuid') FROM mysql.wsrep_cluster;
60
61 SELECT COUNT(*) AS EXPECT_2 FROM mysql.wsrep_cluster_members;
62
63 --connection node_2
64 let $restart_noprint=2;
65 --source include/start_mysqld.inc
66 --source include/wait_until_connected_again.inc
67
68 --let $wait_condition = SELECT VARIABLE_VALUE = 3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'
69 --source include/wait_condition.inc
70
71 SELECT cluster_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_state_uuid') FROM mysql.wsrep_cluster;
72
73 SELECT COUNT(*) AS EXPECT_3 FROM mysql.wsrep_cluster_members;
74
75 --connection node_1
76 SELECT cluster_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_state_uuid') FROM mysql.wsrep_cluster;
77
78 SELECT COUNT(*) AS EXPECT_3 FROM mysql.wsrep_cluster_members;
79
80 --source ../galera/include/auto_increment_offset_restore.inc
81
82 --disconnect node_3