replica2_basic2.sim 3.9 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
slguan 已提交
7

S
scripts  
slguan 已提交
8 9 10 11
system sh/cfg.sh -n dnode1 -c clog -v 2
system sh/cfg.sh -n dnode2 -c clog -v 2
system sh/cfg.sh -n dnode3 -c clog -v 2
system sh/cfg.sh -n dnode4 -c clog -v 2
S
slguan 已提交
12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

system sh/cfg.sh -n dnode1 -c numOfMPeers -v 1
system sh/cfg.sh -n dnode2 -c numOfMPeers -v 1
system sh/cfg.sh -n dnode3 -c numOfMPeers -v 1
system sh/cfg.sh -n dnode4 -c numOfMPeers -v 1

system sh/cfg.sh -n dnode1 -c mgmtEqualVnodeNum -v 4
system sh/cfg.sh -n dnode2 -c mgmtEqualVnodeNum -v 4
system sh/cfg.sh -n dnode3 -c mgmtEqualVnodeNum -v 4
system sh/cfg.sh -n dnode4 -c mgmtEqualVnodeNum -v 4

system sh/cfg.sh -n dnode1 -c numOfTotalVnodes -v 4
system sh/cfg.sh -n dnode2 -c numOfTotalVnodes -v 4
system sh/cfg.sh -n dnode3 -c numOfTotalVnodes -v 4
system sh/cfg.sh -n dnode4 -c numOfTotalVnodes -v 4

print ========= start dnodes
S
scripts  
slguan 已提交
29
system sh/exec_up.sh -n dnode1 -s start
S
slguan 已提交
30
sql connect
S
slguan 已提交
31
sql create dnode $hostname2
S
scripts  
slguan 已提交
32
system sh/exec_up.sh -n dnode2 -s start
S
slguan 已提交
33
sql create dnode $hostname3
S
scripts  
slguan 已提交
34
system sh/exec_up.sh -n dnode3 -s start
S
slguan 已提交
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 75
sleep 3000

sql reset query cache

print ========= step1 
sql create database d1 replica 2
sql create database d2 replica 2
sql create database d3 replica 2
sql create database d4 replica 2

sql create table d1.t1 (ts timestamp, i int)
sql create table d2.t2 (ts timestamp, i int)
sql create table d3.t3 (ts timestamp, i int)
sql create table d4.t4 (ts timestamp, i int)

sql insert into d1.t1 values(now, 1)
sql insert into d2.t2 values(now, 1)
sql insert into d3.t3 values(now, 1)
sql insert into d4.t4 values(now, 1)

sql select * from d1.t1
if $rows != 1 then
	return -1
endi

sql select * from d2.t2
if $rows != 1 then
	return -1
endi

sql select * from d3.t3
if $rows != 1 then
	return -1
endi

sql select * from d4.t4
if $rows != 1 then
	return -1
endi

sql show dnodes
S
scripts  
slguan 已提交
76 77 78
print dnode1 ==> openVnodes: $data2_1
print dnode2 ==> openVnodes: $data2_2
print dnode3 ==> openVnodes: $data2_3
S
slguan 已提交
79

S
scripts  
slguan 已提交
80
if $data2_1 != 0 then
S
slguan 已提交
81 82 83
  return -1
endi

S
scripts  
slguan 已提交
84
if $data2_2 != 4 then
S
slguan 已提交
85 86 87
  return -1
endi

S
scripts  
slguan 已提交
88
if $data2_3 != 4 then
S
slguan 已提交
89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118
  return -1
endi

print ========= step2
sql insert into d1.t1 values(now, 2)
sql insert into d2.t2 values(now, 2)
sql insert into d3.t3 values(now, 2)
sql insert into d4.t4 values(now, 2)

sql select * from d1.t1
if $rows != 2 then
	return -1
endi

sql select * from d2.t2
if $rows != 2 then
	return -1
endi

sql select * from d3.t3
if $rows != 2 then
	return -1
endi

sql select * from d4.t4
if $rows != 2 then
	return -1
endi

print ========= step3 
S
scripts  
slguan 已提交
119 120
system sh/exec_up.sh -n dnode2 -s stop -x SIGINT
sleep 5000
S
slguan 已提交
121

S
scripts  
slguan 已提交
122 123 124 125
#sql insert into d1.t1 values(now, 3)
#sql insert into d2.t2 values(now, 3)
#sql insert into d3.t3 values(now, 3)
#sql insert into d4.t4 values(now, 3)
S
slguan 已提交
126 127

sql select * from d1.t1
S
scripts  
slguan 已提交
128
if $rows != 2 then
S
slguan 已提交
129 130 131 132
	return -1
endi

sql select * from d2.t2
S
scripts  
slguan 已提交
133
if $rows != 2 then
S
slguan 已提交
134 135 136 137
	return -1
endi

sql select * from d3.t3
S
scripts  
slguan 已提交
138
if $rows != 2 then
S
slguan 已提交
139 140 141 142
	return -1
endi

sql select * from d4.t4
S
scripts  
slguan 已提交
143
if $rows != 2 then
S
slguan 已提交
144 145 146 147
	return -1
endi

print ========= step4
S
scripts  
slguan 已提交
148 149 150
system sh/exec_up.sh -n dnode2 -s start
sleep 5000
system sh/exec_up.sh -n dnode3 -s stop -x SIGINT
S
slguan 已提交
151 152
sleep 5000

S
scripts  
slguan 已提交
153 154 155 156
#sql insert into d1.t1 values(now, 4)
#sql insert into d2.t2 values(now, 4)
#sql insert into d3.t3 values(now, 4)
#sql insert into d4.t4 values(now, 4)
S
slguan 已提交
157 158

sql select * from d1.t1
S
scripts  
slguan 已提交
159
if $rows != 2 then
S
slguan 已提交
160 161 162 163
	return -1
endi

sql select * from d2.t2
S
scripts  
slguan 已提交
164
if $rows != 2 then
S
slguan 已提交
165 166 167 168
	return -1
endi

sql select * from d3.t3
S
scripts  
slguan 已提交
169
if $rows != 2 then
S
slguan 已提交
170 171 172 173
	return -1
endi

sql select * from d4.t4
S
scripts  
slguan 已提交
174
if $rows != 2 then
S
slguan 已提交
175 176 177 178
	return -1
endi

print ========= step5
S
scripts  
slguan 已提交
179
system sh/exec_up.sh -n dnode3 -s start
S
slguan 已提交
180 181 182 183 184 185 186 187
sleep 5000

sql insert into d1.t1 values(now, 5)
sql insert into d2.t2 values(now, 5)
sql insert into d3.t3 values(now, 5)
sql insert into d4.t4 values(now, 5)

sql select * from d1.t1
S
scripts  
slguan 已提交
188
if $rows != 3 then
S
slguan 已提交
189 190 191 192
	return -1
endi

sql select * from d2.t2
S
scripts  
slguan 已提交
193
if $rows != 3 then
S
slguan 已提交
194 195 196 197
	return -1
endi

sql select * from d3.t3
S
scripts  
slguan 已提交
198
if $rows != 3 then
S
slguan 已提交
199 200 201 202
	return -1
endi

sql select * from d4.t4
S
scripts  
slguan 已提交
203
if $rows != 3 then
S
slguan 已提交
204 205
	return -1
endi