Debian Codegraph @

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

raw
1 -- source include/have_ndb.inc
2 -- source suite/ndb/include/backup_restore_setup.inc
3
4
5 # Build the standard command used for running "ndb_mgm"
6 let $mgm_cmd = $NDB_MGM;
7
8 #
9 # Build strings for masking ndb_mgm output
10 #
11
12 #echo MYSQL_SERVER_VERSION: $MYSQL_SERVER_VERSION;
13
14 # extract X.X.X for MySQL
15 let $mysql_version=
16 `select SUBSTRING_INDEX('$MYSQL_SERVER_VERSION','-', 1)`;
17 # Remove any trailing a in the X.X.X string(ugly but works)
18 let $mysql_version=
19 `select TRIM(TRAILING 'a' FROM '$mysql_version')`;
20 let $mysql_version = mysql-$mysql_version;
21 # echo mysql_version: $mysql_version;
22
23 # load ndb-X.X.X from the "ndb_version_string" variable, trim off
24 # the version status indicator i.e -dmr etc.
25 let $ndb_version=
26 `select REGEXP_SUBSTR(@@ndb_version_string, "^ndb-[0-9]*[.][0-9]*[.][0-9]*")`;
27 # echo ndb_version: $ndb_version;
28
29 #
30 # Test the SHOW command
31 # - make output stable by using a temporary
32 # table for the output
33 #
34 --disable_query_log
35 let $dump_file = $MYSQLTEST_VARDIR/tmp/ndb_mgm_show.txt;
36
37 # Dump the output of ndb_mgm to file
38 exec $mgm_cmd -e "show" > $dump_file;
39
40 # Load the file into a temporary table
41 CREATE TEMPORARY TABLE ndb_mgm_show (a varchar(512)) ENGINE = HEAP;
42
43 eval LOAD DATA INFILE '$dump_file' INTO TABLE ndb_mgm_show
44 FIELDS TERMINATED BY '\n';
45 --remove_file $dump_file
46
47 # Remove Windows line feeds
48 UPDATE ndb_mgm_show SET a = TRIM(TRAILING "\r" FROM a);
49
50 # Ignoring things like: Truncated incorrect DOUBLE value: '---'
51 --disable_warnings
52
53 # Show the two data nodes
54 --replace_result $mysql_version MYSQL_VERSION $ndb_version NDB_VERSION @127.0.0.1 LOCALHOST @::1 LOCALHOST
55 SELECT a as 'ndbd(s)' FROM ndb_mgm_show
56 WHERE SUBSTR(a, 4, 3) IN (1, 2);
57
58 # Show the mgm node
59 --replace_result $mysql_version MYSQL_VERSION $ndb_version NDB_VERSION @127.0.0.1 LOCALHOST @::1 LOCALHOST
60 SELECT a as 'ndb_mgmd(s)' FROM ndb_mgm_show
61 WHERE SUBSTR(a, 4, 3) IN (3);
62
63 # Show the two mysqld nodes which are using three nodeids each
64 # as well as the 8 free slots, mask out the nodeid since those are
65 # not deterministic, order the connected nodes first
66 --replace_regex /id=[0-9]+/id=X/
67 --replace_result $mysql_version MYSQL_VERSION $ndb_version NDB_VERSION @127.0.0.1 LOCALHOST @::1 LOCALHOST
68 SELECT a as 'mysqld(s)' FROM ndb_mgm_show
69 WHERE SUBSTR(a, 4, 3)
70 IN (16,32,48,49,63,127,192,228,229,230,231,232,233,255)
71 ORDER BY LOCATE("accepting", a);
72
73 --enable_warnings
74
75 DROP TABLE ndb_mgm_show;
76 --enable_query_log
77
78 echo ; # newline for nicer .result file
79
80 #
81 # Test the [ALL|<nodeid>] REPORT [MEMORYUSAGE|BACKUPSTATUS]
82 #
83 echo Missing report type specifier;
84 --error 255
85 exec $mgm_cmd -e "ALL REPORT ";
86
87 echo Unknown report type specifier;
88 --error 255
89 exec $mgm_cmd -e "ALL REPORT something";
90
91 echo ALL REPORT MEMORYUSAGE;
92 --replace_regex /[0-9]+\%\([0-9]+ [0-9]+K pages of total [0-9]+/X%(X XK pages of total X/
93 exec $mgm_cmd -e "ALL REPORT MEMORYUSAGE";
94
95 echo 1 REPORT MEMORYUSAGE;
96 --replace_regex /[0-9]+\%\([0-9]+ [0-9]+K pages of total [0-9]+/X%(X XK pages of total X/
97 exec $mgm_cmd -e "1 REPORT MEMORYUSAGE";
98
99 echo 2 REPORT MEMORYUSAGE;
100 --replace_regex /[0-9]+\%\([0-9]+ [0-9]+K pages of total [0-9]+/X%(X XK pages of total X/
101 exec $mgm_cmd -e "2 REPORT MEMORYUSAGE";
102
103 echo Testing abbreviated form;
104 --replace_regex /[0-9]+\%\([0-9]+ [0-9]+K pages of total [0-9]+/X%(X XK pages of total X/
105 exec $mgm_cmd -e "2 REPORT Mem";
106
107 echo Request memoryusage from non NDB node 3;
108 --error 255
109 exec $mgm_cmd -e "3 REPORT MEMORYUSAGE";
110
111 echo Request memoryusage from non existing node 17;
112 --error 255
113 exec $mgm_cmd -e "17 REPORT MEMORYUSAGE";
114
115 echo Request memoryusage from illegal nodeid 145;
116 --error 255
117 exec $mgm_cmd -e "145 REPORT MEMORYUSAGE";
118
119 --echo For the following, we want to be running ndbmtd with multiple
120 --echo LQH threads
121 --echo NDBD (1 instance) is ok, but 2 instances indicates ndbmtd
122 --echo with proxy and only 1 real instance, not interesting.
123 --echo cnf file should make this impossible
124
125 --echo Following query should have no results
126 select node_id, count(1) as instances
127 from ndbinfo.threadblocks
128 where block_name="BACKUP"
129 group by node_id
130 having instances=2;
131
132 echo ALL REPORT BACKUPSTATUS;
133 exec $mgm_cmd -e "ALL REPORT BACKUPSTATUS";
134
135 echo 1 REPORT BACKUPSTATUS;
136 exec $mgm_cmd -e "1 REPORT BACKUPSTATUS";
137
138 echo 2 REPORT BACKUPSTATUS;
139 exec $mgm_cmd -e "2 REPORT BACKUPSTATUS";
140
141 echo Testing HELP for REPORT;
142 exec $mgm_cmd -e "HELP REPORT";
143
144 #
145 # Test <ALL|nodeid> DUMP <arg>[ <argN>]
146 #
147 echo Missing dump arg;
148 --error 255
149 exec $mgm_cmd -e "ALL DUMP ";
150
151 echo Illegal argument 4294967300;
152 --error 255
153 exec $mgm_cmd -e "1 DUMP 4294967300";
154
155 echo Illegal argument -1;
156 --error 255
157 exec $mgm_cmd -e "1 DUMP -1";
158
159 echo Robustness issue with bug#14537622;
160 echo Data node must not crash here;
161 exec $mgm_cmd -e "ALL DUMP 1000 1000";
162
163 echo ALL DUMP 1;
164 exec $mgm_cmd -e "ALL DUMP 1 ";
165
166 echo 1 DUMP 1 2;
167 exec $mgm_cmd -e "1 DUMP 1 2";
168
169 echo max DUMP args;
170 exec $mgm_cmd -e "1 DUMP 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25";
171
172 echo more than max DUMP args;
173 --error 255
174 exec $mgm_cmd -e "1 DUMP 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26";
175
176 --echo test all report eventlog
177 --echo note: test within quotes...
178 --exec $mgm_cmd -e "1 report eventlog" >> $NDB_TOOLS_OUTPUT
179 --exec $mgm_cmd -e "2 report eventlog" >> $NDB_TOOLS_OUTPUT
180 --exec $mgm_cmd -e "all report eventlog" >> $NDB_TOOLS_OUTPUT
181
182 #
183 # Test CLUSTERLOG command
184 #
185 echo Missing argument;
186 --error 255
187 exec $mgm_cmd -e "CLUSTERLOG";
188
189 echo # Unknown argument;
190 --error 255
191 exec $mgm_cmd -e "CLUSTERLOG unknown_argument";
192
193 echo # CLUSTERLOG INFO;
194 exec $mgm_cmd -e "CLUSTERLOG INFO";
195
196 echo # CLUSTERLOG OFF;
197 exec $mgm_cmd -e "CLUSTERLOG OFF";
198
199 echo # Should be OFF now;
200 exec $mgm_cmd -e "CLUSTERLOG INFO";
201
202 echo # CLUSTERLOG ON;
203 exec $mgm_cmd -e "CLUSTERLOG ON";
204
205 echo # Should be ON now;
206 exec $mgm_cmd -e "CLUSTERLOG INFO";
207
208 echo # CLUSTERLOG TOGGLE;
209 exec $mgm_cmd -e "CLUSTERLOG TOGGLE";
210
211 echo # Should be OFF now;
212 exec $mgm_cmd -e "CLUSTERLOG INFO";
213
214 echo # CLUSTERLOG TOGGLE;
215 exec $mgm_cmd -e "CLUSTERLOG TOGGLE";
216
217 echo # Should be ON now;
218 exec $mgm_cmd -e "CLUSTERLOG INFO";
219
220 echo # Turn off severity INFO, ERROR and ALERT;
221 exec $mgm_cmd -e "CLUSTERLOG FILTER ALERT INFO ERROR";
222
223 echo # Should not list ALERT, INFO or ERROR;
224 exec $mgm_cmd -e "CLUSTERLOG INFO";
225
226 echo # Turn off reaining severities;
227 exec $mgm_cmd -e "CLUSTERLOG FILTER WARNING CRITICAL";
228
229 echo # Should not list anything;
230 exec $mgm_cmd -e "CLUSTERLOG INFO";
231
232 echo # Back to default severity;
233 exec $mgm_cmd -e "CLUSTERLOG FILTER WARNING CRITICAL ALERT INFO ERROR";
234
235 echo # Should list default;
236 exec $mgm_cmd -e "CLUSTERLOG INFO";
237
238 echo # Bogus severity;
239 --error 255
240 exec $mgm_cmd -e "CLUSTERLOG FILTER bogus1";
241
242 echo # Should list default;
243 exec $mgm_cmd -e "CLUSTERLOG INFO";
244
245 echo # Bug 11752837: start backup wait started should not print completion logs;
246 exec $mgm_cmd -e "START BACKUP WAIT STARTED";
247
248 echo # Bug 16585455: start backup with backup ID out of range;
249 --error 255
250 exec $mgm_cmd -e "START BACKUP 201303271430 WAIT COMPLETED";
251
252 echo # Test 1/2 for Bug#16585497: abort backup with backup ID > 2^31;
253 exec $mgm_cmd -e "ABORT BACKUP 2147483648";
254
255 echo # Test 2/2 for Bug#16585497: abort backup with backup ID out of range;
256 --error 255
257 exec $mgm_cmd -e "ABORT BACKUP 1000000000000000000";
258
259 --echo
260 --echo # Bug #22328426: NEW TEST NDB_MGM_PROMPT FAILS WITH VALGRIND
261 --echo # Test for Bug #18421338: SUPPORT SETTING THE PROMPT IN NDB_MGM
262 --exec $mgm_cmd -e "prompt test-prompt>";
263 --exec $mgm_cmd -e "prompt"
264 -- source suite/ndb/include/backup_restore_cleanup.inc
265 --remove_file $NDB_TOOLS_OUTPUT