| 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 |