basic1.sim 2.3 KB
Newer Older
1 2 3 4 5 6 7
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

X
Xiaoyu Wang 已提交
8 9
print =============== select * from information_schema.ins_dnodes
sql select * from information_schema.ins_dnodes;
10 11 12 13 14 15 16 17
if $rows != 1 then 
  return -1
endi

if $data00 != 1 then 
  return -1
endi

X
Xiaoyu Wang 已提交
18
sql select * from information_schema.ins_mnodes;
19 20 21 22 23 24 25 26
if $rows != 1 then 
  return -1
endi

if $data00 != 1 then 
  return -1
endi

27
if $data02 != leader then 
28 29 30 31 32 33 34
  return -1
endi

print =============== create dnodes
sql create dnode $hostname port 7200
sleep 2000

X
Xiaoyu Wang 已提交
35
sql select * from information_schema.ins_dnodes;
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
if $rows != 2 then 
  return -1
endi

if $data00 != 1 then 
  return -1
endi

if $data10 != 2 then 
  return -1
endi

print $data02
if $data02 != 0 then 
  return -1
endi

if $data12 != 0 then 
  return -1
endi

if $data04 != ready then 
  return -1
endi

if $data14 != ready then 
  return -1
endi

X
Xiaoyu Wang 已提交
65
sql select * from information_schema.ins_mnodes;
66 67 68 69 70 71 72 73
if $rows != 1 then 
  return -1
endi

if $data00 != 1 then 
  return -1
endi

74
if $data02 != leader then 
75 76 77
  return -1
endi

D
dapan1121 已提交
78 79 80 81 82 83 84 85 86 87 88 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 119 120 121 122 123 124 125 126 127 128 129 130 131 132
#print =============== create drop bnode 1
#sql create bnode on dnode 1
#sql show bnodes
#if $rows != 1 then 
#  return -1
#endi
#if $data00 != 1 then 
#  return -1
#endi
#sql_error create bnode on dnode 1
#
#sql drop bnode on dnode 1
#sql show bnodes
#if $rows != 0 then 
#  return -1
#endi
#sql_error drop bnode on dnode 1
#
#print =============== create drop bnode 2
#sql create bnode on dnode 2
#sql show bnodes
#if $rows != 1 then 
#  return -1
#endi
#if $data00 != 2 then 
#  return -1
#endi
#sql_error create bnode on dnode 2
#
#sql drop bnode on dnode 2
#sql show bnodes
#if $rows != 0 then 
#  return -1
#endi
#sql_error drop bnode on dnode 2
#
#print =============== create drop bnodes
#sql create bnode on dnode 1
#sql create bnode on dnode 2
#sql show bnodes
#if $rows != 2 then 
#  return -1
#endi

#print =============== restart
#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 dnode1 -s start
#system sh/exec.sh -n dnode2 -s start
#
#sleep 2000
#sql show bnodes
#if $rows != 2 then 
#  return -1
#endi
133 134 135

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