dn3_mn1_vnode_delDir.sim 12.5 KB
Newer Older
H
Hui Li 已提交
1 2 3 4 5 6 7 8 9
system sh/stop_dnodes.sh
system sh/deploy.sh -n dnode1 -i 1
system sh/deploy.sh -n dnode2 -i 2
system sh/deploy.sh -n dnode3 -i 3
system sh/deploy.sh -n dnode4 -i 4

system sh/cfg.sh -n dnode1 -c numOfMnodes -v 1
system sh/cfg.sh -n dnode2 -c numOfMnodes -v 1
system sh/cfg.sh -n dnode3 -c numOfMnodes -v 1
H
Hui Li 已提交
10
system sh/cfg.sh -n dnode4 -c numOfMnodes -v 1
H
Hui Li 已提交
11 12 13 14 15 16 17 18 19 20 21

system sh/cfg.sh -n dnode1 -c walLevel -v 2
system sh/cfg.sh -n dnode2 -c walLevel -v 2
system sh/cfg.sh -n dnode3 -c walLevel -v 2
system sh/cfg.sh -n dnode4 -c walLevel -v 2

system sh/cfg.sh -n dnode1 -c balanceInterval -v 10
system sh/cfg.sh -n dnode2 -c balanceInterval -v 10
system sh/cfg.sh -n dnode3 -c balanceInterval -v 10
system sh/cfg.sh -n dnode4 -c balanceInterval -v 10

S
Shengliang Guan 已提交
22 23 24 25
system sh/cfg.sh -n dnode1 -c role -v 1
system sh/cfg.sh -n dnode2 -c role -v 2
system sh/cfg.sh -n dnode3 -c role -v 2
system sh/cfg.sh -n dnode4 -c role -v 2
H
Hui Li 已提交
26

S
scripts  
Shengliang Guan 已提交
27 28 29 30 31 32 33 34 35 36
$totalTableNum = 10
system sh/cfg.sh -n dnode1 -c maxtablesPerVnode -v $totalTableNum
system sh/cfg.sh -n dnode2 -c maxtablesPerVnode -v $totalTableNum
system sh/cfg.sh -n dnode3 -c maxtablesPerVnode -v $totalTableNum
system sh/cfg.sh -n dnode4 -c maxtablesPerVnode -v $totalTableNum

system sh/cfg.sh -n dnode1 -c maxVgroupsPerDb -v 1
system sh/cfg.sh -n dnode2 -c maxVgroupsPerDb -v 1
system sh/cfg.sh -n dnode3 -c maxVgroupsPerDb -v 1
system sh/cfg.sh -n dnode4 -c maxVgroupsPerDb -v 1
H
Hui Li 已提交
37 38 39 40

system sh/cfg.sh -n dnode1 -c arbitrator -v $arbitrator
system sh/cfg.sh -n dnode2 -c arbitrator -v $arbitrator
system sh/cfg.sh -n dnode3 -c arbitrator -v $arbitrator
H
Hui Li 已提交
41
system sh/cfg.sh -n dnode4 -c arbitrator -v $arbitrator
H
Hui Li 已提交
42 43 44 45 46 47 48 49 50

print ============== step0: start tarbitrator
system sh/exec_tarbitrator.sh -s start

print ============== step1: start dnode1, only deploy mnode
system sh/exec.sh -n dnode1 -s start
sleep 3000
sql connect

H
Hui Li 已提交
51
print ============== step2: start dnode2/dnode3/dnode4 and add into cluster , then create database with replica 3, and create table, insert data
H
Hui Li 已提交
52 53 54 55 56 57 58 59 60 61 62
system sh/exec.sh -n dnode2 -s start
system sh/exec.sh -n dnode3 -s start
system sh/exec.sh -n dnode4 -s start
sql create dnode $hostname2
sql create dnode $hostname3
sql create dnode $hostname4
sleep 3000

$sleepTimer = 3000

$db = db
S
scripts  
Shengliang Guan 已提交
63
sql create database $db replica 3
H
Hui Li 已提交
64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
sql use $db

# create table , insert data
$stb = stb
sql create table $stb (ts timestamp, c1 int) tags(t1 int)
$rowNum = 100
$tblNum = $totalTableNum
$totalRows = 0
$tsStart = 1420041600000

$i = 0
while $i < $tblNum
  $tb = tb . $i
  sql create table $tb using $stb tags( $i )
 
  $x = 0
  while $x < $rowNum
    $ts = $tsStart + $x
    sql insert into $tb values ( $ts + 0a , $x ) ( $ts + 1a , $x ) ( $ts + 2a , $x ) ( $ts + 3a , $x ) ( $ts + 4a , $x ) ( $ts + 5a , $x ) ( $ts + 6a , $x ) ( $ts + 7a , $x ) ( $ts + 8a , $x ) ( $ts + 9a , $x ) ( $ts + 10a , $x ) ( $ts + 11a , $x ) ( $ts + 12a , $x ) ( $ts + 13a , $x ) ( $ts + 14a , $x ) ( $ts + 15a , $x ) ( $ts + 16a , $x ) ( $ts + 17a , $x ) ( $ts + 18a , $x ) ( $ts + 19a , $x ) ( $ts + 20a , $x ) ( $ts + 21a , $x ) ( $ts + 22a , $x ) ( $ts + 23a , $x ) ( $ts + 24a , $x ) ( $ts + 25a , $x ) ( $ts + 26a , $x ) ( $ts + 27a , $x ) ( $ts + 28a , $x ) ( $ts + 29a , $x ) ( $ts + 30a , $x ) ( $ts + 31a , $x ) ( $ts + 32a , $x ) ( $ts + 33a , $x ) ( $ts + 34a , $x ) ( $ts + 25a , $x ) ( $ts + 26a , $x ) ( $ts + 27a , $x ) ( $ts + 28a , $x ) ( $ts + 29a , $x ) ( $ts + 30a , $x ) ( $ts + 31a , $x ) ( $ts + 32a , $x ) ( $ts + 33a , $x ) ( $ts + 34a , $x ) ( $ts + 35a , $x ) ( $ts + 36a , $x ) ( $ts + 37a , $x ) ( $ts + 38a , $x ) ( $ts + 39a , $x ) ( $ts + 40a , $x ) ( $ts + 41a , $x ) ( $ts + 42a , $x ) ( $ts + 43a , $x ) ( $ts + 44a , $x ) ( $ts + 45a , $x ) ( $ts + 46a , $x ) ( $ts + 47a , $x ) ( $ts + 48a , $x ) ( $ts + 49a , $x ) ( $ts + 50a , $x ) ( $ts + 51a , $x ) ( $ts + 52a , $x ) ( $ts + 53a , $x ) ( $ts + 54a , $x ) ( $ts + 55a , $x ) ( $ts + 56a , $x ) ( $ts + 57a , $x ) ( $ts + 58a , $x ) ( $ts + 59a , $x ) 
    $x = $x + 60
  endw 
  $totalRows = $totalRows + $x
  print       info: inserted $x rows into $tb and totalRows: $totalRows
  $i = $i + 1
endw 

sql select count(*) from $stb
sleep 1000
print data00 $data00
if $data00 != $totalRows then
	return -1
endi

print ============== step3: stop dnode4, and remove its vnodeX subdirector 
system sh/exec.sh -n dnode4 -s stop -x SIGINT
sleep $sleepTimer
H
Hui Li 已提交
100 101

$loopCnt = 0
H
Hui Li 已提交
102
wait_dnode4_offline_0:
H
Hui Li 已提交
103 104 105 106 107
$loopCnt = $loopCnt + 1
if $loopCnt == 10 then 
  return -1
endi

H
Hui Li 已提交
108 109 110 111 112 113 114 115
sql show dnodes
if $rows != 4 then
  sleep 2000
  goto wait_dnode4_offline_0
endi
print $data0_1  $data1_1  $data2_1  $data3_1  $data4_1
print $data0_2  $data1_2  $data2_2  $data3_2  $data4_2
print $data0_3  $data1_3  $data2_3  $data3_3  $data4_3
H
Hui Li 已提交
116 117
print $data0_4  $data1_4  $data2_4  $data3_4  $data4_4
$dnode1Status = $data4_1  
H
Hui Li 已提交
118 119 120 121 122 123 124 125 126
$dnode2Status = $data4_2
$dnode3Status = $data4_3  
$dnode4Status = $data4_4 

if $dnode4Status != offline then
  sleep 2000
  goto wait_dnode4_offline_0
endi

H
Hui Li 已提交
127 128

$loopCnt = 0
H
Hui Li 已提交
129
wait_dnode4_vgroup_offline:
H
Hui Li 已提交
130 131 132 133 134
$loopCnt = $loopCnt + 1
if $loopCnt == 10 then 
  return -1
endi

H
Hui Li 已提交
135 136 137 138 139 140 141 142 143
sql show vgroups
if $rows != 1 then
  sleep 2000
  goto wait_dnode4_vgroup_offline
endi
print show vgroups:
print $data0_1  $data1_1  $data2_1  $data3_1  $data4_1  $data5_1  $data6_1  $data7_1  $data8_1  $data9_1
print $data0_2  $data1_2  $data2_2  $data3_2  $data4_2  $data5_2  $data6_2  $data7_2  $data8_2  $data9_2
print $data0_3  $data1_3  $data2_3  $data3_3  $data4_3  $data5_3  $data6_3  $data7_3  $data8_3  $data9_3
S
scripts  
Shengliang Guan 已提交
144 145
$dnode4Vtatus = $data6_2
$dnode3Vtatus = $data9_2
H
Hui Li 已提交
146 147 148 149 150 151 152 153 154 155 156 157 158 159 160

if $dnode4Vtatus != offline then
  sleep 2000
  goto wait_dnode4_vgroup_offline
endi
if $dnode3Vtatus != master then
  sleep 2000
  goto wait_dnode4_vgroup_offline
endi

system rm -rf ../../../sim/dnode4/data/vnode/*

print ============== step4: restart dnode4, waiting sync end 
system sh/exec.sh -n dnode4 -s start
sleep $sleepTimer
H
Hui Li 已提交
161 162

$loopCnt = 0
H
Hui Li 已提交
163
wait_dnode4_reready:
H
Hui Li 已提交
164 165 166 167 168
$loopCnt = $loopCnt + 1
if $loopCnt == 10 then 
  return -1
endi

H
Hui Li 已提交
169 170 171 172 173 174 175 176
sql show dnodes
if $rows != 4 then
  sleep 2000
  goto wait_dnode4_reready
endi
print $data0_1  $data1_1  $data2_1  $data3_1  $data4_1
print $data0_2  $data1_2  $data2_2  $data3_2  $data4_2
print $data0_3  $data1_3  $data2_3  $data3_3  $data4_3
H
Hui Li 已提交
177 178
print $data0_4  $data1_4  $data2_4  $data3_4  $data4_4
$dnode1Status = $data4_1  
H
Hui Li 已提交
179 180 181 182 183 184 185 186 187
$dnode2Status = $data4_2
$dnode3Status = $data4_3  
$dnode4Status = $data4_4 

if $dnode4Status != ready then
  sleep 2000
  goto wait_dnode4_reready
endi

H
Hui Li 已提交
188
$loopCnt = 0
H
Hui Li 已提交
189
wait_dnode4_vgroup_slave:
H
Hui Li 已提交
190 191 192 193 194
$loopCnt = $loopCnt + 1
if $loopCnt == 10 then 
  return -1
endi

H
Hui Li 已提交
195 196 197 198 199 200 201 202 203
sql show vgroups
if $rows != 1 then
  sleep 2000
  goto wait_dnode4_vgroup_slave
endi
print show vgroups:
print $data0_1  $data1_1  $data2_1  $data3_1  $data4_1  $data5_1  $data6_1  $data7_1  $data8_1  $data9_1
print $data0_2  $data1_2  $data2_2  $data3_2  $data4_2  $data5_2  $data6_2  $data7_2  $data8_2  $data9_2
print $data0_3  $data1_3  $data2_3  $data3_3  $data4_3  $data5_3  $data6_3  $data7_3  $data8_3  $data9_3
S
scripts  
Shengliang Guan 已提交
204 205
$dnode4Vtatus = $data6_2
$dnode3Vtatus = $data9_2
H
Hui Li 已提交
206 207 208 209 210 211 212 213 214 215 216 217

print dnode4Vtatus: $dnode4Vtatus
print dnode3Vtatus: $dnode3Vtatus 
if $dnode4Vtatus != slave then
  sleep 2000
  goto wait_dnode4_vgroup_slave
endi
if $dnode3Vtatus != master then
  sleep 2000
  goto wait_dnode4_vgroup_slave
endi

H
Hui Li 已提交
218 219
print ============== step5: stop dnode3, and remove its vnodeX subdirector 
system sh/exec.sh -n dnode3 -s stop -x SIGINT
H
Hui Li 已提交
220 221
sleep $sleepTimer

H
Hui Li 已提交
222 223 224 225 226 227 228
$loopCnt = 0
wait_dnode3_offline:
$loopCnt = $loopCnt + 1
if $loopCnt == 10 then 
  return -1
endi

H
Hui Li 已提交
229 230 231
sql show dnodes
if $rows != 4 then
  sleep 2000
H
Hui Li 已提交
232
  goto wait_dnode3_offline
H
Hui Li 已提交
233 234 235 236 237
endi
print $data0_1  $data1_1  $data2_1  $data3_1  $data4_1
print $data0_2  $data1_2  $data2_2  $data3_2  $data4_2
print $data0_3  $data1_3  $data2_3  $data3_3  $data4_3
print $data0_4  $data1_4  $data2_4  $data3_4  $data4_4
H
Hui Li 已提交
238
$dnode1Status = $data4_1  
H
Hui Li 已提交
239 240 241 242
$dnode2Status = $data4_2
$dnode3Status = $data4_3  
$dnode4Status = $data4_4 

H
Hui Li 已提交
243
if $dnode2Status != ready then
H
Hui Li 已提交
244
  sleep 2000
H
Hui Li 已提交
245
  goto wait_dnode3_offline
H
Hui Li 已提交
246 247 248
endi
if $dnode3Status != offline then
  sleep 2000
H
Hui Li 已提交
249
  goto wait_dnode3_offline
H
Hui Li 已提交
250 251 252
endi
if $dnode4Status != ready then
  sleep 2000
H
Hui Li 已提交
253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292
  goto wait_dnode3_offline
endi

system rm -rf ../../../sim/dnode3/data/vnode/*

print ============== step6: restart dnode3, and check rows
system sh/exec.sh -n dnode3 -s start
sleep $sleepTimer

$loopCnt = 0
wait_dnode3_reready:
$loopCnt = $loopCnt + 1
if $loopCnt == 10 then 
  return -1
endi

sql show dnodes
if $rows != 4 then
  sleep 2000
  goto wait_dnode3_reready
endi
print $data0_1  $data1_1  $data2_1  $data3_1  $data4_1
print $data0_2  $data1_2  $data2_2  $data3_2  $data4_2
print $data0_3  $data1_3  $data2_3  $data3_3  $data4_3
print $data0_4  $data1_4  $data2_4  $data3_4  $data4_4
$dnode1Status = $data4_1  
$dnode2Status = $data4_2
$dnode3Status = $data4_3  
$dnode4Status = $data4_4 

if $dnode3Status != ready then
  sleep 2000
  goto wait_dnode3_reready
endi

$loopCnt = 0
wait_dnode3_vgroup_slave:
$loopCnt = $loopCnt + 1
if $loopCnt == 10 then 
  return -1
H
Hui Li 已提交
293 294 295 296 297
endi

sql show vgroups
if $rows != 1 then
  sleep 2000
H
Hui Li 已提交
298
  goto wait_dnode3_vgroup_slave
H
Hui Li 已提交
299 300 301 302 303
endi
print show vgroups:
print $data0_1  $data1_1  $data2_1  $data3_1  $data4_1  $data5_1  $data6_1  $data7_1  $data8_1  $data9_1
print $data0_2  $data1_2  $data2_2  $data3_2  $data4_2  $data5_2  $data6_2  $data7_2  $data8_2  $data9_2
print $data0_3  $data1_3  $data2_3  $data3_3  $data4_3  $data5_3  $data6_3  $data7_3  $data8_3  $data9_3
S
scripts  
Shengliang Guan 已提交
304 305
$dnode4Vtatus = $data6_2
$dnode3Vtatus = $data9_2
H
Hui Li 已提交
306 307 308 309 310

print dnode4Vtatus: $dnode4Vtatus
print dnode3Vtatus: $dnode3Vtatus 
if $dnode4Vtatus != master then
  sleep 2000
H
Hui Li 已提交
311
  goto wait_dnode3_vgroup_slave
H
Hui Li 已提交
312
endi
H
Hui Li 已提交
313
if $dnode3Vtatus != slave then
H
Hui Li 已提交
314
  sleep 2000
H
Hui Li 已提交
315
  goto wait_dnode3_vgroup_slave
H
Hui Li 已提交
316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333
endi

# check using select
sql select count(*) from $stb
print data00 $data00
if $data00 != $totalRows then
	return -1
endi

sql insert into $tb values ( now , 20000 ) ( now + 1a, 20001 ) ( now + 2a, 20002 )
$totalRows = $totalRows + 3

sql select count(*) from $stb
print data00 $data00
if $data00 != $totalRows then
	return -1
endi

H
Hui Li 已提交
334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419
print ============== step7: stop dnode2, and remove its vnodeX subdirector 
system sh/exec.sh -n dnode2 -s stop -x SIGINT
sleep $sleepTimer

$loopCnt = 0
wait_dnode2_offline:
$loopCnt = $loopCnt + 1
if $loopCnt == 10 then 
  return -1
endi

sql show dnodes
if $rows != 4 then
  sleep 2000
  goto wait_dnode2_offline
endi
print $data0_1  $data1_1  $data2_1  $data3_1  $data4_1
print $data0_2  $data1_2  $data2_2  $data3_2  $data4_2
print $data0_3  $data1_3  $data2_3  $data3_3  $data4_3
print $data0_4  $data1_4  $data2_4  $data3_4  $data4_4
$dnode1Status = $data4_1  
$dnode2Status = $data4_2
$dnode3Status = $data4_3  
$dnode4Status = $data4_4 

if $dnode2Status != offline then
  sleep 2000
  goto wait_dnode2_offline
endi
if $dnode3Status != ready then
  sleep 2000
  goto wait_dnode2_offline
endi
if $dnode4Status != ready then
  sleep 2000
  goto wait_dnode2_offline
endi

system rm -rf ../../../sim/dnode2/data/vnode/*

print ============== step8: restart dnode2, and check rows
system sh/exec.sh -n dnode2 -s start
sleep $sleepTimer

$loopCnt = 0
wait_dnode2_reready:
$loopCnt = $loopCnt + 1
if $loopCnt == 10 then 
  return -1
endi

sql show dnodes
if $rows != 4 then
  sleep 2000
  goto wait_dnode2_reready
endi
print $data0_1  $data1_1  $data2_1  $data3_1  $data4_1
print $data0_2  $data1_2  $data2_2  $data3_2  $data4_2
print $data0_3  $data1_3  $data2_3  $data3_3  $data4_3
print $data0_4  $data1_4  $data2_4  $data3_4  $data4_4
$dnode1Status = $data4_1  
$dnode2Status = $data4_2
$dnode3Status = $data4_3  
$dnode4Status = $data4_4 

if $dnode2Status != ready then
  sleep 2000
  goto wait_dnode2_reready
endi

$loopCnt = 0
wait_dnode2_vgroup_slave:
$loopCnt = $loopCnt + 1
if $loopCnt == 10 then 
  return -1
endi

sql show vgroups
if $rows != 1 then
  sleep 2000
  goto wait_dnode2_vgroup_slave
endi
print show vgroups:
print $data0_1  $data1_1  $data2_1  $data3_1  $data4_1  $data5_1  $data6_1  $data7_1  $data8_1  $data9_1
print $data0_2  $data1_2  $data2_2  $data3_2  $data4_2  $data5_2  $data6_2  $data7_2  $data8_2  $data9_2
print $data0_3  $data1_3  $data2_3  $data3_3  $data4_3  $data5_3  $data6_3  $data7_3  $data8_3  $data9_3
S
scripts  
Shengliang Guan 已提交
420 421
$dnode4Vtatus = $data6_2
$dnode3Vtatus = $data9_2
H
Hui Li 已提交
422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458

print dnode4Vtatus: $dnode4Vtatus
print dnode3Vtatus: $dnode3Vtatus 
if $dnode4Vtatus != master then
  sleep 2000
  goto wait_dnode2_vgroup_slave
endi
if $dnode3Vtatus != slave then
  sleep 2000
  goto wait_dnode2_vgroup_slave
endi

# check using select
sql select count(*) from $stb
print data00 $data00
if $data00 != $totalRows then
	return -1
endi

sql insert into $tb values ( now , 20000 ) ( now + 1a, 20001 ) ( now + 2a, 20002 )
$totalRows = $totalRows + 3

sql select count(*) from $stb
print data00 $data00
if $data00 != $totalRows then
	return -1
endi