maxvnodes.sim 2.0 KB
Newer Older
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 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54
system sh/stop_dnodes.sh

$totalVnodes = 20
$minVnodes = 10
$maxVnodes = 10
$maxTables = 4
$totalRows = $totalVnodes * $maxTables

system sh/deploy.sh -n dnode1 -i 1
system sh/cfg.sh -n dnode1 -c walLevel            -v 2
system sh/cfg.sh -n dnode1 -c maxVgroupsPerDb     -v $totalVnodes
system sh/cfg.sh -n dnode1 -c balanceInterval     -v 1
system sh/deploy.sh -n dnode2 -i 2
system sh/cfg.sh -n dnode2 -c walLevel            -v 2
system sh/cfg.sh -n dnode2 -c maxVgroupsPerDb    -v $totalVnodes
system sh/cfg.sh -n dnode2 -c balanceInterval     -v 1

print ==========  prepare data
system sh/exec.sh -n dnode1 -s start
sleep 2000
sql connect 
sql create database db blocks 3 cache 1 
sql use db

print ==========  step1
sql create table mt (ts timestamp, tbcol int) TAGS(tgcol int)

$x = 0
while $x < $totalRows
  $tb = t . $x
  sql create table $tb using mt tags( $x )
  sql insert into $tb values (now, $x ) 
  $x = $x + 1
endw 

print ========== step2
sql select * from mt
if $rows != $totalRows then
  return -1
endi  

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

print ==========  step3
sql create dnode $hostname2
system sh/exec.sh -n dnode2 -s start

$x = 0
show3: 
	$x = $x + 1
	sleep 2000
55
	if $x == 100 then 
56 57 58 59 60 61 62 63 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
		return -1
	endi
	
sql show dnodes
print dnode1 openvnodes $data2_1
print dnode2 openvnodes $data2_2
if $data2_1 != $minVnodes then
	goto show3
endi
if $data2_2 != $maxVnodes then
	goto show3
endi

print ========== step4
sql select * from mt
if $rows != $totalRows then
  return -1
endi  

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

return

system sh/exec.sh -n dnode1 -s stop  -x SIGINT
system sh/exec.sh -n dnode2 -s stop  -x SIGINT
system sh/exec.sh -n dnode3 -s stop  -x SIGINT
system sh/exec.sh -n dnode4 -s stop  -x SIGINT
system sh/exec.sh -n dnode5 -s stop  -x SIGINT
system sh/exec.sh -n dnode6 -s stop  -x SIGINT
system sh/exec.sh -n dnode7 -s stop  -x SIGINT
89
system sh/exec.sh -n dnode8 -s stop  -x SIGINT