2 # set DURABILITY = true in csql.conf
3 # Start csqlserver. Then create a table in CSQL Client.
4 # kill the currently running Server.
5 # Restart the server by setting DURABILITY = false. and Open CSQL Client.
6 # SHOW TABLES; Statement should not display any table.
8 CSQL_CONF
=${PWD}/durability
/recovery
/csql.conf
10 if [ -s "$CSQL_CONF" ]
12 REL_PATH
=${PWD}/durability
/recovery
18 cp -f $REL_PATH/csql.conf
/tmp
19 echo SYS_DB_KEY
=4444 >>/tmp
/csql.conf
20 echo USER_DB_KEY
=6666 >>/tmp
/csql.conf
21 echo DURABILITY
=true
>>/tmp
/csql.conf
22 export CSQL_CONFIG_FILE
=/tmp
/csql.conf
24 echo "Durablity = TRUE"
26 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
30 echo "CREATE TABLE laks(f1 int);" >${REL_PATH}/create.sql
31 echo "DROP TABLE laks;" >${REL_PATH}/drop.sql
33 if [ "$VALGRIND" = "true" ]
35 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/create.sql
2> $0.valgr
37 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/create.sql
42 rm -f ${REL_PATH}/create.sql
43 rm -f ${REL_PATH}/drop.sql
48 if [ "$VALGRIND" = "true" ]
50 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csqldump
2>> $0.valgr
52 $CSQL_INSTALL_ROOT/bin
/csqldump
>before.sql
59 echo DURABILITY
=false
>>/tmp
/csql.conf
60 echo "Durablity = FALSE"
61 echo "Checking Durability"
62 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
66 if [ "$VALGRIND" = "true" ]
68 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csqldump
2>> $0.valgr
70 $CSQL_INSTALL_ROOT/bin
/csqldump
>after.sql
74 diff before.sql after.sql
>>/dev
/null
2>&1
77 echo Durability Works Fine
80 rm -f ${REL_PATH}/create.sql
81 rm -f ${REL_PATH}/drop.sql
82 rm -f before.sql after.sql