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/exec.sh -n dnode1 -s start system sh/exec.sh -n dnode2 -s start system sh/exec.sh -n dnode3 -s start $loop_cnt = 0 check_dnode_ready: $loop_cnt = $loop_cnt + 1 sleep 200 if $loop_cnt == 10 then print ====> dnode not ready! return -1 endi sql show dnodes print ===> $rows $data00 $data01 $data02 $data03 $data04 $data05 if $data00 != 1 then return -1 endi if $data04 != ready then goto check_dnode_ready endi sql connect sql create dnode $hostname port 7200 sql create dnode $hostname port 7300 $loop_cnt = 0 check_dnode_ready_1: $loop_cnt = $loop_cnt + 1 sleep 200 if $loop_cnt == 10 then print ====> dnode not ready! return -1 endi sql show dnodes print ===> rows: $rows print ===> $data00 $data01 $data02 $data03 $data04 $data05 print ===> $data10 $data11 $data12 $data13 $data14 $data15 print ===> $data20 $data21 $data22 $data23 $data24 $data25 if $data00 != 1 then return -1 endi if $data01 != localhost:7100 then return -1 endi if $data04 != ready then goto check_dnode_ready_1 endi if $data14 != ready then goto check_dnode_ready_1 endi if $data24 != ready then goto check_dnode_ready_1 endi print ============= create database #database_option: { # | BUFFER value [3~16384, default: 96] # | PAGES value [64~16384, default: 256] # | CACHELAST value [0, 1, 2, 3] # | FSYNC value [0 ~ 180000 ms] # | KEEP value [days, 365000] # | REPLICA value [1 | 3] # | WAL value [1 | 2] sql create database db CACHELAST 3 COMP 0 DAYS 345600 FSYNC 1000 MAXROWS 8000 MINROWS 10 KEEP 1440000 PRECISION 'ns' REPLICA 1 WAL 2 VGROUPS 6 SINGLE_STABLE 1 sql show databases print rows: $rows print $data00 $data01 $data02 $data03 $data04 $data05 $data06 $data07 $data08 $data09 print $data10 $data11 $data12 $data13 $data14 $data15 $data16 $data17 $data18 $data19 print ====> dataX_db print $data(db)[0] $data(db)[1] $data2_db $data3_db $data4_db $data5_db $data6_db $data7_db $data8_db $data9_db $data10_db $data11_db $data12_db $data13_db $data14_db $data15_db $data16_db $data17_db if $rows != 3 then return -1 endi if $data0_db != db then # name return -1 endi if $data2_db != 6 then # vgroups return -1 endi if $data3_db != 0 then # ntables return -1 endi if $data4_db != 1 then # replica return -1 endi if $data5_db != nostrict then # strict return -1 endi if $data6_db != 345600 then # days return -1 endi if $data7_db != 1440000,1440000,1440000 then # keep return -1 endi if $data8_db != 96 then # buffer return -1 endi if $data9_db != 4 then # pagesize return -1 endi if $data10_db != 256 then # pages return -1 endi if $data11_db != 10 then # minrows return -1 endi if $data12_db != 8000 then # maxrows return -1 endi if $data13_db != 2 then # wal return -1 endi if $data14_db != 1000 then # fsync return -1 endi if $data15_db != 0 then # comp return -1 endi if $data16_db != 3 then # cachelast return -1 endi if $data17_db != ns then # precision return -1 endi sleep 3000 #sql show db.vgroups #if $data[0][4] == LEADER then # if $data[0][6] != FOLLOWER then # return -1 # endi # if $data[0][8] != FOLLOWER then # return -1 # endi #endi #if $data[0][6] == LEADER then # if $data[0][4] != FOLLOWER then # return -1 # endi # if $data[0][8] != FOLLOWER then # return -1 # endi #endi #if $data[0][8] == LEADER then # if $data[0][4] != FOLLOWER then # return -1 # endi # if $data[0][6] != FOLLOWER then # return -1 # endi #endi # #if $data[0][4] != LEADER then # if $data[0][4] != FOLLOWER then # return -1 # endi #endi #if $data[0][6] != LEADER then # if $data[0][6] != FOLLOWER then # return -1 # endi #endi #if $data[0][8] != LEADER then # if $data[0][8] != FOLLOWER then # return -1 # endi #endi print ============== not support modify options: name, create_time, vgroups, ntables sql_error alter database db name dba sql_error alter database db create_time "2022-03-03 15:08:13.329" sql_error alter database db vgroups -1 sql_error alter database db vgroups 0 sql_error alter database db vgroups 2 sql_error alter database db vgroups 20 sql_error alter database db ntables -1 sql_error alter database db ntables 0 sql_error alter database db ntables 1 sql_error alter database db ntables 10 #print ============== modify replica # TD-14409 sql_error alter database db replica 2 sql_error alter database db replica 5 sql_error alter database db replica -1 sql_error alter database db replica 0 #sql alter database db replica 1 #sql show databases #print replica: $data4_db #if $data4_db != 1 then # return -1 #endi #sql alter database db replica 3 #sql show databases #print replica: $data4_db #if $data4_db != 3 then # return -1 #endi #print ============== modify quorum #sql alter database db quorum 2 #sql show databases #print quorum $data5_db #if $data5_db != 2 then # return -1 #endi #sql alter database db quorum 1 #sql show databases #print quorum $data5_db #if $data5_db != 1 then # return -1 #endi #sql_error alter database db quorum -1 #sql_error alter database db quorum 0 #sql_error alter database db quorum 3 #sql_error alter database db quorum 4 #sql_error alter database db quorum 5 #print ============== modify days sql_error alter database db days 480 sql_error alter database db days 360 sql_error alter database db days 0 sql_error alter database db days 14400 # set over than keep print ============== modify keep sql alter database db keep 3456000 sql show databases print keep $data7_db if $data7_db != 3456000,3456000,3456000 then return -1 endi #sql alter database db keep 1000,2000 #sql show databases #print keep $data7_db #if $data7_db != 500,500,500 then # return -1 #endi #sql alter database db keep 40,50 #sql alter database db keep 30,31 #sql alter database db keep 20 #sql_error alter database db keep 10.0 #sql_error alter database db keep 9 #sql_error alter database db keep 1 sql_error alter database db keep 0 sql_error alter database db keep -1 #sql_error alter database db keep 365001 #print ============== modify cache #sql_error alter database db cache 12 #sql_error alter database db cache 1 #sql_error alter database db cache 60 #sql_error alter database db cache 50 #sql_error alter database db cache 20 #sql_error alter database db cache 3 #sql_error alter database db cache 129 #sql_error alter database db cache 300 #sql_error alter database db cache 0 #sql_error alter database db cache -1 #print ============== modify blocks #sql alter database db blocks 3 #sql show databases #print blocks $data9_db #if $data9_db != 3 then # return -1 #endi #sql alter database db blocks 11 #sql show databases #print blocks $data9_db #if $data9_db != 11 then # return -1 #endi #sql alter database db blocks 40 #sql alter database db blocks 30 #sql alter database db blocks 20 #sql alter database db blocks 10 #sql_error alter database db blocks 2 #sql_error alter database db blocks 1 #sql_error alter database db blocks 0 #sql_error alter database db blocks -1 #sql_error alter database db blocks 10001 print ============== modify minrows sql_error alter database db minrows 8 sql_error alter database db minrows 200 sql_error alter database db minrows 11 sql_error alter database db minrows 8000 sql_error alter database db minrows 8001 print ============== modify maxrows sql_error alter database db maxrows 1000 sql_error alter database db maxrows 2000 sql_error alter database db maxrows 11 # equal minrows sql_error alter database db maxrows 10 # little than minrows print ============== step wal sql alter database db wal 1 sql show databases print wal $data13_db if $data13_db != 1 then return -1 endi sql alter database db wal 2 sql show databases print wal $data13_db if $data13_db != 2 then return -1 endi sql_error alter database db wal 0 # TD-14436 sql_error alter database db wal 3 sql_error alter database db wal 100 sql_error alter database db wal -1 print ============== modify fsync sql alter database db fsync 2000 sql show databases print fsync $data14_db if $data14_db != 2000 then return -1 endi sql alter database db fsync 500 sql show databases print fsync $data14_db if $data14_db != 500 then return -1 endi sql alter database db fsync 0 sql show databases print fsync $data14_db if $data14_db != 0 then return -1 endi sql_error alter database db fsync 180001 sql_error alter database db fsync -1 print ============== modify comp sql_error alter database db comp 1 sql_error alter database db comp 2 sql_error alter database db comp 1 sql_error alter database db comp 0 sql_error alter database db comp 3 sql_error alter database db comp 4 sql_error alter database db comp 5 sql_error alter database db comp -1 print ============== modify cachelast [0, 1, 2, 3] sql alter database db cachelast 2 sql show databases print cachelast $data16_db if $data16_db != 2 then return -1 endi sql alter database db cachelast 1 sql show databases print cachelast $data16_db if $data16_db != 1 then return -1 endi sql alter database db cachelast 0 sql show databases print cachelast $data16_db if $data16_db != 0 then return -1 endi sql alter database db cachelast 2 sql show databases print cachelast $data16_db if $data16_db != 2 then return -1 endi sql alter database db cachelast 3 sql show databases print cachelast $data16_db if $data16_db != 3 then return -1 endi sql_error alter database db cachelast 4 sql_error alter database db cachelast 10 sql_error alter database db cachelast -1 print ============== modify precision sql_error alter database db precision 'ms' sql_error alter database db precision 'us' sql_error alter database db precision 'ns' sql_error alter database db precision 'ys' sql_error alter database db prec 'xs' 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