basic4.sim 3.7 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
system sh/stop_dnodes.sh
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/exec.sh -n dnode1 -s start
system sh/exec.sh -n dnode2 -s start
sql connect

print =============== step1: create dnodes
sql create dnode $hostname port 7200
sql create dnode $hostname port 7300

$x = 0
step1: 
	$x = $x + 1
	sleep 1000
	if $x == 5 then
		return -1
	endi
sql show dnodes -x step1
if $data(1)[4] != ready then
  goto step1
endi
if $data(2)[4] != ready then
  goto step1
endi

print =============== step2: create mnode 2
sql create mnode on dnode 2
sql_error create mnode on dnode 3
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
system sh/exec.sh -n dnode3 -s start

$x = 0
step2: 
	$x = $x + 1
	sleep 1000
	if $x == 5 then
		return -1
	endi
sql show dnodes -x step2
if $data(1)[4] != ready then
  goto step2
endi
if $data(2)[4] != ready then
  goto step2
endi

system sh/exec.sh -n dnode3 -s stop
sql_error create mnode on dnode 3

print =============== step3: show mnodes

$x = 0
step3: 
	$x = $x + 1
	sleep 1000
	if $x == 10 then
		return -1
	endi
sql show mnodes -x step3
print $data[0][0] $data[0][1] $data[0][2] $data[0][3] $data[0][4] 
print $data[1][0] $data[1][1] $data[1][2] $data[1][3] $data[1][4] 
print $data[2][0] $data[2][1] $data[2][2] $data[2][3] $data[2][4]

66
if $data(1)[2] != leader then
67 68
  goto step3
endi
69
if $data(2)[2] != follower then
70 71
  goto step3
endi
72
if $data(3)[2] != offline then
73 74
  goto step3
endi
75
if $data(1)[3] != ready then
76 77
  goto step3
endi
78
if $data(2)[3] != ready then
79 80
  goto step3
endi
81
if $data(3)[3] != creating then
82 83 84 85 86 87 88 89 90 91 92 93 94 95
  goto step3
endi

print =============== step4: start dnode3
system sh/exec.sh -n dnode3 -s start

$x = 0
step4: 
	$x = $x + 1
	sleep 1000
	if $x == 10 then
		return -1
	endi
sql show mnodes -x step4
96 97 98 99
print $data[0][0] $data[0][1] $data[0][2] $data[0][3] $data[0][4] 
print $data[1][0] $data[1][1] $data[1][2] $data[1][3] $data[1][4] 
print $data[2][0] $data[2][1] $data[2][2] $data[2][3] $data[2][4]

100
if $data(1)[2] != leader then
101 102
  goto step4
endi
103
if $data(2)[2] != follower then
104 105
  goto step4
endi
106
if $data(3)[2] != follower then
107 108
  goto step4
endi
109
if $data(1)[3] != ready then
110 111
  goto step4
endi
112
if $data(2)[3] != ready then
113 114
  goto step4
endi
115
if $data(3)[3] != ready then
116 117 118 119
  goto step4
endi

print =============== step5: drop mnode 3 and stop dnode3
120 121
system sh/exec.sh -n dnode3 -s stop
sql_error drop mnode on dnode 3
122 123

$x = 0
124
step5: 
125 126
	$x = $x + 1
	sleep 1000
127
	if $x == 10 then
128 129
		return -1
	endi
130 131 132 133
sql show mnodes -x step5
print $data[0][0] $data[0][1] $data[0][2] $data[0][3] $data[0][4] 
print $data[1][0] $data[1][1] $data[1][2] $data[1][3] $data[1][4] 
print $data[2][0] $data[2][1] $data[2][2] $data[2][3] $data[2][4]
134

135
if $data(1)[2] != leader then
136
  goto step5
137
endi
138
if $data(2)[2] != follower then
139
  goto step5
140
endi
141
if $data(3)[2] != offline then
142
  goto step5
143
endi
144
if $data(1)[3] != ready then
145 146
  goto step5
endi
147
if $data(2)[3] != ready then
148 149
  goto step5
endi
150
if $data(3)[3] != dropping then
151
  goto step5
152 153
endi

154 155
print =============== step6: start dnode3
system sh/exec.sh -n dnode3 -s start
156 157 158 159 160

$x = 0
step6: 
	$x = $x + 1
	sleep 1000
161
	if $x == 10 then
162 163 164
		return -1
	endi
sql show mnodes -x step6
165 166 167
print $data[0][0] $data[0][1] $data[0][2] $data[0][3] $data[0][4] 
print $data[1][0] $data[1][1] $data[1][2] $data[1][3] $data[1][4] 
print $data[2][0] $data[2][1] $data[2][2] $data[2][3] $data[2][4]
168 169

if $rows != 2 then 
170 171
  goto step6
endi
172
if $data(1)[2] != leader then
173 174
  goto step6
endi
175
if $data(2)[2] != follower then
176 177 178 179 180
  goto step6
endi
if $data(3)[2] != null then
  goto step6
endi
181
if $data(1)[3] != ready then
182 183
  goto step6
endi
184
if $data(2)[3] != ready then
185 186 187 188
  goto step6
endi
if $data(3)[3] != null then
  goto step6
189 190 191 192 193 194
endi

system sh/exec.sh -n dnode1 -s stop
system sh/exec.sh -n dnode2 -s stop
system sh/exec.sh -n dnode3 -s stop
system sh/exec.sh -n dnode4 -s stop