replica2_repeat.sim 2.2 KB
Newer Older
S
slguan 已提交
1
system sh/stop_dnodes.sh
S
slguan 已提交
2 3 4 5 6

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
S
scripts  
slguan 已提交
7 8 9 10
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
11 12 13 14
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
system sh/cfg.sh -n dnode4 -c numOfMnodes -v 1
S
Shengliang Guan 已提交
15 16 17 18
system sh/cfg.sh -n dnode1 -c mnodeEqualVnodeNum -v 4
system sh/cfg.sh -n dnode2 -c mnodeEqualVnodeNum -v 4
system sh/cfg.sh -n dnode3 -c mnodeEqualVnodeNum -v 4
system sh/cfg.sh -n dnode4 -c mnodeEqualVnodeNum -v 4
S
scripts  
slguan 已提交
19
system sh/exec_up.sh -n dnode1 -s start
S
slguan 已提交
20 21

sql connect
S
slguan 已提交
22 23
sql create dnode $hostname2
sql create dnode $hostname3
S
scripts  
slguan 已提交
24 25
system sh/exec_up.sh -n dnode2 -s start
system sh/exec_up.sh -n dnode3 -s start
S
slguan 已提交
26 27 28 29 30 31 32 33 34 35
sleep 3000

print ========= step1
sql create database db replica 2 
sql create table db.tb (ts timestamp, i int)
sql insert into db.tb values(now, 1)
sql select count(*) from db.tb
$lastRows = $rows

print ======== step2
S
scripts  
Shengliang Guan 已提交
36
run_back unique/vnode/back_insert.sim
S
slguan 已提交
37 38 39
sleep 3000

print ======== step3
S
scripts  
slguan 已提交
40
system sh/exec_up.sh -n dnode2 -s stop
S
slguan 已提交
41 42 43 44 45 46
sleep 5000

$x = 0
loop:

print ======== step4
S
scripts  
slguan 已提交
47
system sh/exec_up.sh -n dnode2 -s start
S
slguan 已提交
48
sleep 5000
S
scripts  
slguan 已提交
49
system sh/exec_up.sh -n dnode3 -s stop
S
slguan 已提交
50 51 52
sleep 5000

print ======== step5
S
scripts  
slguan 已提交
53
system sh/exec_up.sh -n dnode3 -s start
S
slguan 已提交
54
sleep 5000
S
scripts  
slguan 已提交
55
system sh/exec_up.sh -n dnode2 -s stop
S
slguan 已提交
56 57 58 59 60 61 62 63 64 65 66 67 68
sleep 5000

print ======== step6
sql select count(*) from db.tb
print select count(*) from db.tb ==> $data00 $lastRows 
if $data00 <= $lastRows then
  return -1
endi

print ======== step7
$lastRows = $data00
print ======== loop Times $x

S
scripts  
Shengliang Guan 已提交
69
if $x < 2 then
S
slguan 已提交
70 71 72 73
  $x = $x + 1
  goto loop
endi

guanshengliang's avatar
scripts  
guanshengliang 已提交
74 75 76 77 78 79 80 81
system sh/exec_up.sh -n dnode1 -s stop  -x SIGINT
system sh/exec_up.sh -n dnode2 -s stop  -x SIGINT
system sh/exec_up.sh -n dnode3 -s stop  -x SIGINT
system sh/exec_up.sh -n dnode4 -s stop  -x SIGINT
system sh/exec_up.sh -n dnode5 -s stop  -x SIGINT
system sh/exec_up.sh -n dnode6 -s stop  -x SIGINT
system sh/exec_up.sh -n dnode7 -s stop  -x SIGINT
system sh/exec_up.sh -n dnode8 -s stop  -x SIGINT