| 1 |
ndbd(s) |
| 2 |
id=1 LOCALHOST (MYSQL_VERSION NDB_VERSION, Nodegroup: 0, *) |
| 3 |
id=2 LOCALHOST (MYSQL_VERSION NDB_VERSION, Nodegroup: 0) |
| 4 |
ndb_mgmd(s) |
| 5 |
id=3 LOCALHOST (MYSQL_VERSION NDB_VERSION) |
| 6 |
mysqld(s) |
| 7 |
id=X LOCALHOST (MYSQL_VERSION NDB_VERSION) |
| 8 |
id=X LOCALHOST (MYSQL_VERSION NDB_VERSION) |
| 9 |
id=X LOCALHOST (MYSQL_VERSION NDB_VERSION) |
| 10 |
id=X LOCALHOST (MYSQL_VERSION NDB_VERSION) |
| 11 |
id=X LOCALHOST (MYSQL_VERSION NDB_VERSION) |
| 12 |
id=X LOCALHOST (MYSQL_VERSION NDB_VERSION) |
| 13 |
id=X (not connected, accepting connect from localhost) |
| 14 |
id=X (not connected, accepting connect from localhost) |
| 15 |
id=X (not connected, accepting connect from localhost) |
| 16 |
id=X (not connected, accepting connect from localhost) |
| 17 |
id=X (not connected, accepting connect from localhost) |
| 18 |
id=X (not connected, accepting connect from localhost) |
| 19 |
id=X (not connected, accepting connect from localhost) |
| 20 |
id=X (not connected, accepting connect from localhost) |
| 21 |
|
| 22 |
Missing report type specifier |
| 23 |
ERROR: missing report type specifier! |
| 24 |
|
| 25 |
Unknown report type specifier |
| 26 |
ERROR: 'something' - report type specifier unknown! |
| 27 |
|
| 28 |
ALL REPORT MEMORYUSAGE |
| 29 |
Node 1: Data usage is X%(X XK pages of total X) |
| 30 |
Node 1: Index usage is X%(X XK pages of total X) |
| 31 |
Node 2: Data usage is X%(X XK pages of total X) |
| 32 |
Node 2: Index usage is X%(X XK pages of total X) |
| 33 |
|
| 34 |
1 REPORT MEMORYUSAGE |
| 35 |
Node 1: Data usage is X%(X XK pages of total X) |
| 36 |
Node 1: Index usage is X%(X XK pages of total X) |
| 37 |
|
| 38 |
2 REPORT MEMORYUSAGE |
| 39 |
Node 2: Data usage is X%(X XK pages of total X) |
| 40 |
Node 2: Index usage is X%(X XK pages of total X) |
| 41 |
|
| 42 |
Testing abbreviated form |
| 43 |
Node 2: Data usage is X%(X XK pages of total X) |
| 44 |
Node 2: Index usage is X%(X XK pages of total X) |
| 45 |
|
| 46 |
Request memoryusage from non NDB node 3 |
| 47 |
ERROR: node 3 is not a NDB node! |
| 48 |
|
| 49 |
Request memoryusage from non existing node 17 |
| 50 |
ERROR: node 17 is not a NDB node! |
| 51 |
|
| 52 |
Request memoryusage from illegal nodeid 145 |
| 53 |
ERROR: illegal nodeid 145! |
| 54 |
|
| 55 |
For the following, we want to be running ndbmtd with multiple |
| 56 |
LQH threads |
| 57 |
NDBD (1 instance) is ok, but 2 instances indicates ndbmtd |
| 58 |
with proxy and only 1 real instance, not interesting. |
| 59 |
cnf file should make this impossible |
| 60 |
Following query should have no results |
| 61 |
select node_id, count(1) as instances |
| 62 |
from ndbinfo.threadblocks |
| 63 |
where block_name="BACKUP" |
| 64 |
group by node_id |
| 65 |
having instances=2; |
| 66 |
node_id instances |
| 67 |
ALL REPORT BACKUPSTATUS |
| 68 |
Node 1: Backup not started |
| 69 |
Node 2: Backup not started |
| 70 |
|
| 71 |
1 REPORT BACKUPSTATUS |
| 72 |
Node 1: Backup not started |
| 73 |
|
| 74 |
2 REPORT BACKUPSTATUS |
| 75 |
Node 2: Backup not started |
| 76 |
|
| 77 |
Testing HELP for REPORT |
| 78 |
--------------------------------------------------------------------------- |
| 79 |
NDB Cluster -- Management Client -- Help for REPORT command |
| 80 |
--------------------------------------------------------------------------- |
| 81 |
REPORT Displays a report of type <report-type> for the specified data |
| 82 |
node, or for all data nodes using ALL |
| 83 |
<report-type> = |
| 84 |
BackupStatus - Report backup status of respective node |
| 85 |
MemoryUsage - Report memory usage of respective node |
| 86 |
EventLog - Report events in datanodes circular event log buffer |
| 87 |
Missing dump arg |
| 88 |
ERROR: Expected argument! |
| 89 |
ERROR: Expected argument! |
| 90 |
|
| 91 |
Illegal argument 4294967300 |
| 92 |
ERROR: Illegal value '4294967300' in argument to signal. |
| 93 |
(Value must be between 0 and 0xffffffff.) |
| 94 |
|
| 95 |
Illegal argument -1 |
| 96 |
ERROR: Illegal value '-1' in argument to signal. |
| 97 |
(Value must be between 0 and 0xffffffff.) |
| 98 |
|
| 99 |
Robustness issue with bug#14537622 |
| 100 |
Data node must not crash here |
| 101 |
Sending dump signal with data: |
| 102 |
0x000003e8 0x000003e8 |
| 103 |
Sending dump signal with data: |
| 104 |
0x000003e8 0x000003e8 |
| 105 |
|
| 106 |
ALL DUMP 1 |
| 107 |
Sending dump signal with data: |
| 108 |
0x00000001 |
| 109 |
Sending dump signal with data: |
| 110 |
0x00000001 |
| 111 |
|
| 112 |
1 DUMP 1 2 |
| 113 |
Sending dump signal with data: |
| 114 |
0x00000001 0x00000002 |
| 115 |
|
| 116 |
max DUMP args |
| 117 |
Sending dump signal with data: |
| 118 |
0x00000001 0x00000002 0x00000003 0x00000004 |
| 119 |
0x00000005 0x00000006 0x00000007 0x00000008 |
| 120 |
0x00000009 0x0000000a 0x0000000b 0x0000000c |
| 121 |
0x0000000d 0x0000000e 0x0000000f 0x00000010 |
| 122 |
0x00000011 0x00000012 0x00000013 0x00000014 |
| 123 |
0x00000015 0x00000016 0x00000017 0x00000018 |
| 124 |
0x00000019 |
| 125 |
|
| 126 |
more than max DUMP args |
| 127 |
ERROR: Too many arguments, max 25 allowed |
| 128 |
|
| 129 |
test all report eventlog |
| 130 |
note: test within quotes... |
| 131 |
Missing argument |
| 132 |
ERROR: Missing argument(s). |
| 133 |
# Unknown argument |
| 134 |
Invalid argument. |
| 135 |
# CLUSTERLOG INFO |
| 136 |
Severities enabled: INFO WARNING ERROR CRITICAL ALERT |
| 137 |
# CLUSTERLOG OFF |
| 138 |
Cluster logging is disabled |
| 139 |
# Should be OFF now |
| 140 |
Cluster logging is disabled. |
| 141 |
# CLUSTERLOG ON |
| 142 |
Cluster logging is enabled. |
| 143 |
# Should be ON now |
| 144 |
Severities enabled: INFO WARNING ERROR CRITICAL ALERT |
| 145 |
# CLUSTERLOG TOGGLE |
| 146 |
Cluster logging is disabled |
| 147 |
# Should be OFF now |
| 148 |
Cluster logging is disabled. |
| 149 |
# CLUSTERLOG TOGGLE |
| 150 |
Cluster logging is enabled. |
| 151 |
# Should be ON now |
| 152 |
Severities enabled: INFO WARNING ERROR CRITICAL ALERT |
| 153 |
# Turn off severity INFO, ERROR and ALERT |
| 154 |
ALERT disabled |
| 155 |
INFO disabled |
| 156 |
ERROR disabled |
| 157 |
# Should not list ALERT, INFO or ERROR |
| 158 |
Severities enabled: WARNING CRITICAL |
| 159 |
# Turn off reaining severities |
| 160 |
WARNING disabled |
| 161 |
CRITICAL disabled |
| 162 |
# Should not list anything |
| 163 |
Severities enabled: |
| 164 |
# Back to default severity |
| 165 |
WARNING enabled |
| 166 |
CRITICAL enabled |
| 167 |
ALERT enabled |
| 168 |
INFO enabled |
| 169 |
ERROR enabled |
| 170 |
# Should list default |
| 171 |
Severities enabled: INFO WARNING ERROR CRITICAL ALERT |
| 172 |
# Bogus severity |
| 173 |
Invalid severity level: bogus1 |
| 174 |
# Should list default |
| 175 |
Severities enabled: INFO WARNING ERROR CRITICAL ALERT |
| 176 |
# Bug 11752837: start backup wait started should not print completion logs |
| 177 |
Waiting for started, this may take several minutes |
| 178 |
Node 1: Backup 1 started from node 3 |
| 179 |
# Bug 16585455: start backup with backup ID out of range |
| 180 |
Invalid command: BACKUP 201303271430 WAIT COMPLETED |
| 181 |
Backup ID out of range [1 - 4294967294] |
| 182 |
Type HELP for help. |
| 183 |
|
| 184 |
# Test 1/2 for Bug#16585497: abort backup with backup ID > 2^31 |
| 185 |
Abort of backup 2147483648 ordered |
| 186 |
# Test 2/2 for Bug#16585497: abort backup with backup ID out of range |
| 187 |
Invalid arguments: <BackupId> out of range [1-4294967294] |
| 188 |
|
| 189 |
# Bug #22328426: NEW TEST NDB_MGM_PROMPT FAILS WITH VALGRIND |
| 190 |
# Test for Bug #18421338: SUPPORT SETTING THE PROMPT IN NDB_MGM |
| 191 |
Prompt set to test-prompt> |
| 192 |
Returning to default prompt of ndb_mgm> |