system sh/stop_dnodes.sh system sh/deploy.sh -n dnode1 -i 1 system sh/deploy.sh -n dnode2 -i 2 system sh/exec.sh -n dnode1 -s start system sh/exec.sh -n dnode2 -s start sql connect print =============== show dnodes sql show mnodes; if $rows != 1 then return -1 endi if $data00 != 1 then return -1 endi if $data02 != LEADER then return -1 endi print =============== create dnodes sql create dnode $hostname port 7200 $x = 0 step1: $x = $x + 1 sleep 500 if $x == 20 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 =============== create drop mnode 1 sql_error create mnode on dnode 1 sql_error drop mnode on dnode 1 sql create mnode on dnode 2 $x = 0 step1: $x = $x + 1 sleep 1000 if $x == 20 then return -1 endi sql show mnodes print $data(1)[0] $data(1)[1] $data(1)[2] print $data(2)[0] $data(2)[1] $data(2)[2] if $rows != 2 then return -1 endi if $data(1)[0] != 1 then return -1 endi if $data(1)[2] != LEADER then return -1 endi if $data(2)[0] != 2 then return -1 endi if $data(2)[2] != FOLLOWER then goto step1 endi sleep 2000 print ============ drop mnodes sql drop mnode on dnode 2 sql show mnodes if $rows != 1 then return -1 endi sql_error drop mnode on dnode 2 $x = 0 step2: $x = $x + 1 sleep 1000 if $x == 20 then return -1 endi sql show mnodes print $data(1)[0] $data(1)[1] $data(1)[2] print $data(2)[0] $data(2)[1] $data(2)[2] if $rows != 2 then return -1 endi if $data(1)[0] != 1 then return -1 endi if $data(1)[2] != LEADER then return -1 endi if $data(2)[0] != NULL then goto step2 endi if $data(2)[2] != NULL then goto step2 endi sleep 2000 print =============== create drop mnodes sql create mnode on dnode 2 sql show mnodes if $rows != 2 then return -1 endi $x = 0 step3: $x = $x + 1 sleep 1000 if $x == 20 then return -1 endi sql show mnodes print $data(1)[0] $data(1)[1] $data(1)[2] print $data(2)[0] $data(2)[1] $data(2)[2] if $rows != 2 then return -1 endi if $data(1)[0] != 1 then return -1 endi if $data(1)[2] != LEADER then return -1 endi if $data(2)[0] != 2 then return -1 endi if $data(2)[2] != FOLLOWER then goto step3 endi system sh/exec.sh -n dnode1 -s stop -x SIGINT system sh/exec.sh -n dnode2 -s stop -x SIGINT