restart_stream.sim 3.1 KB
Newer Older
S
slguan 已提交
1 2
system sh/stop_dnodes.sh

S
slguan 已提交
3 4

system sh/deploy.sh -n dnode1 -i 1
5
system sh/cfg.sh -n dnode1 -c walLevel -v 1
S
slguan 已提交
6 7
system sh/exec.sh -n dnode1 -s start

H
Haojun Liao 已提交
8
sleep 2000
S
slguan 已提交
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 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74
sql connect
print ======================== dnode1 start

$i = 0
$dbPrefix = rs_db
$tbPrefix = rs_tb
$mtPrefix = rs_mt
$stPrefix = rs_st
$tbNum = 10
$rowNum = 20
$totalNum = 200

$db = $dbPrefix
$tb = $tbPrefix . $i
$mt = $mtPrefix
$stm = $stPrefix . m
$stt = $stPrefix . t

print =============== step1
sql create database $db
sql use $db

sql create table $mt (ts timestamp, tbcol int, tbcol2 int ) TAGS(tgcol bool)
$i = 0
while $i < 10
  $tb = $tbPrefix . $i
  sql create table $tb using $mt tags( 0 )  

  $x = -1440
  $y = 0
  while $y < $rowNum
    $ms = $x . m 
    sql insert into $tb values (now $ms , $y , $y ) 
    $x = $x + 1
	$y = $y + 1
  endw 
  
  $i = $i + 1
endw 

print =============== step2
$i = 0
$tb = $tbPrefix . $i

sql select count(*) from $tb interval(1d)
print ===>rows $rows, data $data01
if $rows != 1 then
  return -1
endi  
if $data01 != 20 then
  return -1
endi  

sql select count(*) from $mt interval(1d)
print ===>rows $rows, data $data01
if $rows != 1 then
  return -1
endi  
if $data01 != 200 then
  return -1
endi  

print =============== step3
sql create table $stt as select count(*) from $tb interval(1d)
sql create table $stm as select count(*) from $mt interval(1d)

75 76
print sleep 120 seconds
sleep 120000 
S
slguan 已提交
77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97

sql select * from $stt
print select count(*) from $stt ===> $data00 $data01
if $rows != 1 then
  return -1
endi  
if $data01 != 20 then
  return -1
endi  

sql select * from $stm
print select * from $stm ===> $data00 $data01
if $rows != 1 then
  return -1
endi  
if $data01 != 200 then
  return -1
endi  

print =============== step4
system sh/exec.sh -n dnode1 -s stop
S
slguan 已提交
98
system sh/deploy.sh -n dnode1 -i 1
99
system sh/cfg.sh -n dnode1 -c walLevel -v 1
S
slguan 已提交
100 101 102
system sh/exec.sh -n dnode1 -s start

print =============== step5
H
Haojun Liao 已提交
103 104 105
print ==> renew cache
sql reset query cache
sleep 1000
S
slguan 已提交
106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153


print =============== step6
sql create database $db
sql use $db
sql create table $mt (ts timestamp, tbcol bigint, tbcol2 bigint  ) TAGS(tgcol int)
$i = 0
while $i < 5
  $tb = $tbPrefix . $i
  sql create table $tb using $mt tags( 0 )  
  
  $x = -1440
  $y = 0
  while $y < $rowNum
    $ms = $x . m 
    sql insert into $tb values (now $ms , $y , $y ) 
    $x = $x + 1
	$y = $y + 1
  endw 
  
  $i = $i + 1
endw 


print =============== step7

sql select count(*) from $tb interval(1d)
print ===>rows $rows, data $data01
if $rows != 1 then
  return -1
endi  
if $data01 != 20 then
  return -1
endi  

sql select count(*) from $mt interval(1d)
print ===>rows $rows, data $data01
if $rows != 1 then
  return -1
endi  
if $data01 != 100 then
  return -1
endi  

print =============== step8
sql create table $stt as select count(*) from $tb interval(1d)
sql create table $stm as select count(*) from $mt interval(1d)

154 155
print sleep 120 seconds
sleep 120000 
S
slguan 已提交
156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176

sql select * from $stt
sleep 1000
print ===>rows $rows, data $data01
if $rows != 1 then
  return -1
endi  
if $data01 != 20 then
  return -1
endi  

sql select * from $stm
print ===>rows $rows, data $data01
if $rows != 1 then
  return -1
endi  
if $data01 != 100 then
  return -1
endi