basic1.sim 996 字节
Newer Older
S
Shengliang Guan 已提交
1 2
system sh/stop_dnodes.sh
system sh/deploy.sh -n dnode1 -i 1
S
Shengliang Guan 已提交
3
system sh/exec.sh -n dnode1 -s start -v
S
Shengliang Guan 已提交
4 5
sql connect

S
Shengliang Guan 已提交
6 7 8 9 10 11 12 13 14 15 16 17 18 19
print =============== step1: create drop show dnodes
$x = 0
step1:
	$x = $x + 1
	sleep 1000
	if $x == 10 then
	  print ====> dnode not ready!
		return -1
	endi
sql show dnodes
print ===> $data00 $data01 $data02 $data03 $data04 $data05
if $rows != 1 then
  return -1
endi
S
Shengliang Guan 已提交
20

S
Shengliang Guan 已提交
21 22 23 24 25 26 27
print =============== step2: create alter drop show user
sql create user u1 pass 'taosdata'
sql show users
sql alter user u1 sysinfo 1
sql alter user u1 enable 1
sql alter user u1 pass 'taosdata'
sql drop user u1
S
Shengliang Guan 已提交
28
sql_error alter user u2 sysinfo 0
S
Shengliang Guan 已提交
29

S
Shengliang Guan 已提交
30 31 32 33 34 35 36 37 38 39 40 41
print =============== step3: create alter drop show database
sql create database db vgroups 1
sql show databases
sql show db.vgroups
sql drop database db
sql show databases

print =============== step4: create drop dnode
sql create dnode $hostname port 7200
sql drop dnode 2
sql alter dnode 1 'debugflag 143'

S
Shengliang Guan 已提交
42
_OVER:
S
Shengliang Guan 已提交
43
system sh/exec.sh -n dnode1 -s stop -x SIGINT