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=false 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
78 $CSQL_INSTALL_ROOT/bin
/csqldump
>before.sql
83 echo "DURABILITY=true and MMAP=false"
85 echo SYS_DB_KEY
=4444 >>/tmp
/csql.conf
86 echo USER_DB_KEY
=6666 >>/tmp
/csql.conf
87 echo "DURABILITY=true" >>/tmp
/csql.conf
88 echo "MMAP=false" >>/tmp
/csql.conf
89 export CSQL_CONFIG_FILE
=/tmp
/csql.conf
91 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
95 $CSQL_INSTALL_ROOT/bin
/csqldump
>after.sql
96 diff before.sql after.sql
99 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/sel.sql
100 echo Durability Works Fine
102 rm -f before.sql after.sql
105 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/ins_1000.sql
>/dev
/null
2>&1
108 rm -f ${REL_PATH}/cre_t1.sql
109 rm -f ${REL_PATH}/ins_1000.sql
111 ipcrm
-M 4444 -M 6666
114 $CSQL_INSTALL_ROOT/bin
/csqldump
>before.sql
116 ipcrm
-M 4444 -M 6666
118 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
120 echo "Server Started"
122 $CSQL_INSTALL_ROOT/bin
/csqldump
>after.sql
123 diff before.sql after.sql
126 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/sel.sql
127 echo Durability Works Fine
129 rm -f before.sql after.sql
131 echo "DROP TABLE t1;" >drp.sql
132 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/drp.sql
>/dev
/null
2>&1
133 rm -f ${REL_PATH}/drp.sql
134 rm -f ${REL_PATH}/sel.sql
135 rm -f ${REL_PATH}/cre_t1.sql
136 rm -f ${REL_PATH}/ins_1000.sql
138 ipcrm
-M 4444 -M 6666