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/deploy.sh -n dnode4 -i 4 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 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 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 print ========= start dnodes system sh/exec.sh -n dnode1 -s start sleep 3000 sql connect sql create dnode $hostname2 system sh/exec.sh -n dnode2 -s start sql create dnode $hostname3 system sh/exec.sh -n dnode3 -s start 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 print dnode1 ==> openVnodes: $data2_1 print dnode2 ==> openVnodes: $data2_2 print dnode3 ==> openVnodes: $data2_3 if $data2_1 != 0 then return -1 endi if $data2_2 != 4 then return -1 endi if $data2_3 != 4 then return -1 endi if $data4_1 != ready then print dnode1 status should ready but is $data4_1 return -1 endi if $data4_2 != ready then return -1 endi if $data4_3 != ready then 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 system sh/exec.sh -n dnode2 -s stop -x SIGINT sleep 5000 #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) #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 ========= step4 system sh/exec.sh -n dnode2 -s start sleep 5000 system sh/exec.sh -n dnode3 -s stop -x SIGINT sleep 5000 #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) #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 ========= step5 system sh/exec.sh -n dnode3 -s start 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 if $rows != 3 then return -1 endi sql select * from d2.t2 if $rows != 3 then return -1 endi sql select * from d3.t3 if $rows != 3 then return -1 endi sql select * from d4.t4 if $rows != 3 then return -1 endi system sh/exec.sh -n dnode1 -s stop -x SIGINT system sh/exec.sh -n dnode2 -s stop -x SIGINT system sh/exec.sh -n dnode3 -s stop -x SIGINT system sh/exec.sh -n dnode4 -s stop -x SIGINT system sh/exec.sh -n dnode5 -s stop -x SIGINT system sh/exec.sh -n dnode6 -s stop -x SIGINT system sh/exec.sh -n dnode7 -s stop -x SIGINT system sh/exec.sh -n dnode8 -s stop -x SIGINT