delete_reusevnode2.sim 1.4 KB
Newer Older
S
slguan 已提交
1
system sh/stop_dnodes.sh
S
slguan 已提交
2
system sh/deploy.sh -n dnode1 -i 1
S
TD-1486  
Shengliang Guan 已提交
3
system sh/cfg.sh -n dnode1 -c maxTablesPerVnode -v 4
S
slguan 已提交
4 5 6

print ========= start dnodes
system sh/exec.sh -n dnode1 -s start
S
scripts  
slguan 已提交
7
sleep 3000
S
scripts  
slguan 已提交
8
sql connect
S
slguan 已提交
9 10 11

print ======== step1

R
scripts  
root 已提交
12
sql create database db;
S
slguan 已提交
13 14 15 16
sql use db

$tbPrefix = t
$i = 0
S
scripts  
slguan 已提交
17
while $i < 10
S
slguan 已提交
18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34

  sql create table st (ts timestamp, i int) tags(j int);
  $tb = $tbPrefix . $i
  $tb = $tb . a

    $tb1 = $tb . 1
    sql create table $tb1 using st tags(1)
    sql insert into  $tb1 values(now, 1);

    $tb1 = $tb . 2
    sql create table $tb1 using st tags(1)
    sql insert into  $tb1 values(now, 1);

    $tb1 = $tb . 3
    sql create table $tb1 using st tags(1)
    sql insert into  $tb1 values(now, 1);

guanshengliang's avatar
guanshengliang 已提交
35
    $tb1 = $tb . 4
S
slguan 已提交
36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56
    sql create table $tb1 using st tags(1)
    sql insert into  $tb1 values(now, 1);

    $tb1 = $tb . 5
    sql create table $tb1 using st tags(1)
    sql insert into  $tb1 values(now, 1);

    $tb1 = $tb . 6
    sql create table $tb1 using st tags(1)
    sql insert into  $tb1 values(now, 1);

    $tb1 = $tb . 7
    sql create table $tb1 using st tags(1)
    sql insert into  $tb1 values(now, 1);

    $tb1 = $tb . 8
    sql create table $tb1 using st tags(1)
    sql insert into  $tb1 values(now, 1);

  sql drop table st

guanshengliang's avatar
guanshengliang 已提交
57
  sleep 2000
S
slguan 已提交
58 59 60 61 62 63 64 65 66 67 68 69
  print times $i
  $i = $i + 1

endw

print ======== step2
sleep 1000
sql drop database db
sql show databases
if $rows != 0 then
  return -1
endi
S
scripts  
slguan 已提交
70 71

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