delete_writing.sim 1.2 KB
Newer Older
S
slguan 已提交
1
system sh/stop_dnodes.sh
S
slguan 已提交
2 3 4 5
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
slguan 已提交
6

7 8 9 10
system sh/cfg.sh -n dnode1 -c walLevel -v 1
system sh/cfg.sh -n dnode2 -c walLevel -v 1
system sh/cfg.sh -n dnode3 -c walLevel -v 1
system sh/cfg.sh -n dnode4 -c walLevel -v 1
S
slguan 已提交
11

12 13 14 15
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
slguan 已提交
16

S
Shengliang Guan 已提交
17 18 19 20
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
slguan 已提交
21 22 23 24 25 26 27 28 29 30

print ========= start dnodes
system sh/exec.sh -n dnode1 -s start
sql connect

sql create database db 
sql create table db.tb (ts timestamp, i int)
sql insert into db.tb values(now, 1)

print ======== start back
S
scripts  
slguan 已提交
31
run_back general/table/back_insert.sim
S
slguan 已提交
32 33 34 35
sleep 1000

print ======== step1 
$x = 1 	
S
Shengliang Guan 已提交
36
while $x < 15
S
slguan 已提交
37 38 39 40 41 42 43

    print drop table times $x
	sql drop table db.tb -x step1
	step1:

	sql create table db.tb (ts timestamp, i int)

H
Haojun Liao 已提交
44
	sleep 1000
S
slguan 已提交
45 46 47
	
	$x = $x + 1
endw
S
scripts  
slguan 已提交
48 49

system sh/exec.sh -n dnode1 -s stop -x SIGINT