Debian Codegraph @

mysql-test/suite/ndb/t/ndb_restart.test

raw
1 --source include/have_multi_ndb.inc
2
3 #
4 # Setup
5 #
6
7 #
8 # Create metadata
9 #
10 CREATE LOGFILE GROUP lg1
11 ADD UNDOFILE 'lg1_undofile.dat'
12 INITIAL_SIZE 16M
13 UNDO_BUFFER_SIZE 1M
14 ENGINE NDB;
15
16 CREATE TABLESPACE ts1
17 ADD DATAFILE 'ts1_datafile.dat'
18 USE LOGFILE GROUP lg1
19 INITIAL_SIZE 16M
20 ENGINE NDB;
21
22 CREATE TABLESPACE ts2
23 ADD DATAFILE 'ts2_datafile.dat'
24 USE LOGFILE GROUP lg1
25 INITIAL_SIZE 16M
26 ENGINE NDB;
27
28 CREATE TABLE t1 (
29 a INT PRIMARY KEY,
30 b INT
31 ) ENGINE NDB;
32
33 INSERT INTO t1 VALUES (1, 2);
34
35 CREATE TABLE t2 (
36 a INT PRIMARY KEY,
37 b INT
38 ) ENGINE NDB
39 TABLESPACE ts1
40 STORAGE DISK;
41
42 INSERT INTO t2 VALUES (1, 1);
43
44 #
45 # Restart node 1
46 #
47 --exec $NDB_MGM -e "1 RESTART -n"
48 --exec $NDB_WAITER --nowait-nodes=2 --not-started
49 --exec $NDB_MGM -e "1 START"
50 --exec $NDB_WAITER
51
52 # Check that the metadata is still present
53 SELECT TABLESPACE_NAME, LOGFILE_GROUP_NAME
54 FROM INFORMATION_SCHEMA.FILES
55 WHERE ENGINE = "NDBCLUSTER";
56
57 SHOW TABLES;
58 INSERT INTO t1 VALUES (2, 3);
59 --sorted_result
60 SELECT * FROM t1;
61 INSERT INTO t2 VALUES (2, 3);
62 --sorted_result
63 SELECT * FROM t2;
64
65 #
66 # Restart node 1 --initial
67 #
68 --exec $NDB_MGM -e "1 RESTART -n -I"
69 --exec $NDB_WAITER --nowait-nodes=2 --not-started
70 --exec $NDB_MGM -e "1 START"
71 --exec $NDB_WAITER
72
73 # Check that the metadata is still present
74 SELECT TABLESPACE_NAME, LOGFILE_GROUP_NAME
75 FROM INFORMATION_SCHEMA.FILES
76 WHERE ENGINE = "NDBCLUSTER";
77
78 SHOW TABLES;
79 INSERT INTO t1 VALUES (3, 4);
80 --sorted_result
81 SELECT * FROM t1;
82 INSERT INTO t2 VALUES (5, 8);
83 --sorted_result
84 SELECT * FROM t2;
85
86 #
87 # Restart all
88 #
89 --exec $NDB_MGM -e "ALL RESTART -N"
90 --exec $NDB_WAITER --not-started
91 --exec $NDB_MGM -e "ALL START"
92 --exec $NDB_WAITER
93
94 # Wait for mysqld to reconnect
95 --source include/ndb_not_readonly.inc
96
97 --echo # verify that the mysqld detected the restart
98 --let $assert_text= Detect normal restart in MySQL Server 1
99 --let $assert_select= Detected a normal system restart
100 --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.1.1.err
101 --let $assert_only_after= NDB Binlog: Detected server start
102 --let $assert_match= .*Detected a normal system restart.*
103 --source include/assert_grep.inc
104
105 --connection server2
106 # Wait for mysqld to reconnect
107 --source include/ndb_not_readonly.inc
108
109 --let $assert_text= Detect normal restart in MySQL Server 2
110 --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.2.1.err
111 --source include/assert_grep.inc
112
113 --connection server1
114 # Check that the metadata is still present
115 SELECT TABLESPACE_NAME, LOGFILE_GROUP_NAME
116 FROM INFORMATION_SCHEMA.FILES
117 WHERE ENGINE = "NDBCLUSTER";
118
119 SHOW TABLES;
120 INSERT INTO t1 VALUES (4, 5);
121 --sorted_result
122 SELECT * FROM t1;
123 INSERT INTO t2 VALUES (13, 21);
124 SELECT * FROM t2 ORDER BY a;
125
126 #
127 # Restart all initial
128 #
129
130 --exec $NDB_MGM -e "ALL RESTART -N -I"
131 --exec $NDB_WAITER --not-started
132 --exec $NDB_MGM -e "ALL START"
133 --exec $NDB_WAITER
134
135 # Wait for mysqld to reconnect
136 --source include/ndb_not_readonly.inc
137
138 --echo # verify that the mysqld detected the initial restart
139 --let $assert_text= Detect initial restart in MySQL Server 1
140 --let $assert_select= Detected an initial system restart
141 --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.1.1.err
142 --let $assert_only_after= NDB Binlog: Detected server start
143 --let $assert_match= .*Detected an initial system restart.*
144 --source include/assert_grep.inc
145
146 --connection server2
147 # Wait for mysqld to reconnect
148 --source include/ndb_not_readonly.inc
149
150 --let $assert_text= Detect initial restart in MySQL Server 2
151 --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.2.1.err
152 --source include/assert_grep.inc
153
154 --connection server1
155 # Check that the metadata has been deleted
156 SELECT TABLESPACE_NAME, LOGFILE_GROUP_NAME
157 FROM INFORMATION_SCHEMA.FILES
158 WHERE ENGINE = "NDBCLUSTER";
159 SHOW TABLES;