2 # Set DURABILITY to true in csql.conf
3 # Start csqlserver. in CSQl client create a table and insert 5 recored
4 # 50 times kill and start the server
5 # Restart csqlserver again.
6 # Select Should fetch those inserted 5 records
9 CSQL_CONF
=${PWD}/durability
/recovery
/csql.conf
11 if [ -s "$CSQL_CONF" ]
13 REL_PATH
=${PWD}/durability
/recovery
19 cp -f $REL_PATH/csql.conf
/tmp
20 echo SYS_DB_KEY
=4444 >>/tmp
/csql.conf
21 echo USER_DB_KEY
=6666 >>/tmp
/csql.conf
22 echo "DURABILITY=true" >>/tmp
/csql.conf
23 export CSQL_CONFIG_FILE
=/tmp
/csql.conf
26 echo "drop table t2;" >${REL_PATH}/drop_t2.sql
28 echo "Durablity = TRUE"
30 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
34 if [ "$VALGRIND" = "true" ]
36 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/create_t2.sql
2> $0.valgr
38 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/create_t2.sql
>/dev
/null
2>&1
41 rm -f ${REL_PATH}/drop_t2.sql
48 echo "INSERTING INTO TABLE"
49 echo "DEFAULT AUTOCOMMIT MODE ON"
50 if [ "$VALGRIND" = "true" ]
52 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/insert_a.sql
2>> $0.valgr
54 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/insert_a.sql
>/dev
/null
2>&1
57 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_t2.sql
58 rm -f ${REL_PATH}/drop_t2.sql
65 if [ "$VALGRIND" = "true" ]
67 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csqldump
2>> $0.valgr
69 $CSQL_INSTALL_ROOT/bin
/csqldump
>before.sql
76 while [[ $i -lt 51 ]];do
78 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
82 echo "Checking Durability"
83 if [ "$VALGRIND" = "true" ]
85 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csqldump
2>> $0.valgr
87 $CSQL_INSTALL_ROOT/bin
/csqldump
>after.sql
90 diff before.sql after.sql
>/dev
/null
2>&1
93 echo Durability Works Fine
96 echo "INSERTING INTO TABLE"
97 echo "DEFAULT AUTOCOMMIT MODE ON"
98 if [ "$VALGRIND" = "true" ]
100 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/insert_a.sql
2>> $0.valgr
102 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/insert_a.sql
>/dev
/null
2>&1
105 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_t2.sql
106 rm -f ${REL_PATH}/drop_t2.sql
108 ipcrm
-M 4444 -M 6666
113 if [ "$VALGRIND" = "true" ]
115 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csqldump
2>> $0.valgr
117 $CSQL_INSTALL_ROOT/bin
/csqldump
>before.sql
121 ipcrm
-M 4444 -M 6666
126 echo "Durablity = TRUE"
127 echo "Checking Durability"
128 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
130 echo "Server Started"
132 echo "Checking Durability"
133 $CSQL_INSTALL_ROOT/bin
/csqldump
>after.sql
134 diff before.sql after.sql
>/dev
/null
2>&1
137 echo Durability Works Fine
140 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_t2.sql
141 rm -f ${REL_PATH}/drop_t2.sql
142 rm -f ${REL_PATH}/select_t2.sql
144 ipcrm
-M 4444 -M 6666