2 # Testing Durability in MMAP Architecture
3 # set DURABILITY to true and MMAP=true in csql.conf
5 # Then create a table t1 with record size 20.
7 # kill the currently running Server.
8 # set DURABILITY to true and MMAP=true in csql.conf
10 # Insert another 1k Records.
11 # All inserted records should be durable
14 CSQL_CONF
=${PWD}/durability
/recovery
/csql.conf
16 if [ -s "$CSQL_CONF" ]
18 REL_PATH
=${PWD}/durability
/recovery
24 cp -f $REL_PATH/csql.conf
/tmp
25 echo SYS_DB_KEY
=4444 >>/tmp
/csql.conf
26 echo "DURABILITY=true" >>/tmp
/csql.conf
27 echo "MMAP=true" >>/tmp
/csql.conf
28 export CSQL_CONFIG_FILE
=/tmp
/csql.conf
30 echo "DURABILITY=true and MMAP=true"
31 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
36 echo "SELECT COUNT(*) from t1;" >${REL_PATH}/sel.sql
37 echo "CREATE TABLE t1(f1 int,f2 char(15));"
38 echo "CREATE TABLE t1(f1 int,f2 char(15));" >${REL_PATH}/cre_t1.sql
39 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/cre_t1.sql
>/dev
/null
2>&1
42 rm -f ${REL_PATH}/cre_t1.sql
48 while [[ $j -lt 1001 ]];do
49 echo "INSERT INTO t1 VALUES($j,'CSQL$j');" >>${REL_PATH}/ins_1000.sql
52 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/ins_1000.sql
>/dev
/null
2>&1
55 rm -f ${REL_PATH}/cre_t1.sql
56 rm -f ${REL_PATH}/ins_1000.sql
61 $CSQL_INSTALL_ROOT/bin
/csqldump
>before.sql
65 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
69 $CSQL_INSTALL_ROOT/bin
/csqldump
>after.sql
70 diff before.sql after.sql
73 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/sel.sql
74 echo Durability Works Fine
76 rm -f before.sql after.sql
77 echo "I-Pass Test over"
79 $CSQL_INSTALL_ROOT/bin
/csqldump
>before.sql
84 echo "DURABILITY=true and MMAP=true"
86 echo SYS_DB_KEY
=4444 >>/tmp
/csql.conf
87 echo USER_DB_KEY
=6666 >>/tmp
/csql.conf
88 echo "DURABILITY=true" >>/tmp
/csql.conf
89 echo "MMAP=true" >>/tmp
/csql.conf
90 export CSQL_CONFIG_FILE
=/tmp
/csql.conf
92 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
96 $CSQL_INSTALL_ROOT/bin
/csqldump
>after.sql
97 diff before.sql after.sql
100 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/sel.sql
101 echo Durability Works Fine
103 rm -f before.sql after.sql
104 echo "II-Pass Test over"
107 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/ins_1000.sql
>/dev
/null
2>&1
110 rm -f ${REL_PATH}/cre_t1.sql
111 rm -f ${REL_PATH}/ins_1000.sql
116 $CSQL_INSTALL_ROOT/bin
/csqldump
>before.sql
120 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
122 echo "Server Started"
124 $CSQL_INSTALL_ROOT/bin
/csqldump
>after.sql
125 diff before.sql after.sql
128 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/sel.sql
129 echo Durability Works Fine
131 rm -f before.sql after.sql
132 echo "III-Pass Test over"
134 echo "DROP TABLE t1;" >drp.sql
135 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/drp.sql
>/dev
/null
2>&1
136 rm -f ${REL_PATH}/drp.sql
137 rm -f ${REL_PATH}/sel.sql
138 rm -f ${REL_PATH}/cre_t1.sql
139 rm -f ${REL_PATH}/ins_1000.sql