3 # set DURABILITY to true in csql.conf
4 # Start csqlserver. Then create a table in CSQL Client.Insert 5 Records.
5 # make Set autocommit off. insert another 5 records and Rollback.
7 # Again Restart the Server by setting DURABILITY=true .
8 # select should Display 1st 5 records.
11 CSQL_CONF
=${PWD}/durability
/recovery
/csql.conf
13 if [ -s "$CSQL_CONF" ]
15 REL_PATH
=${PWD}/durability
/recovery
21 cp -f $REL_PATH/csql.conf
/tmp
22 echo SYS_DB_KEY
=4444 >>/tmp
/csql.conf
23 echo USER_DB_KEY
=6666 >>/tmp
/csql.conf
24 echo "DURABILITY=true" >>/tmp
/csql.conf
25 export CSQL_CONFIG_FILE
=/tmp
/csql.conf
28 echo "SELECT * FROM t2;" >${REL_PATH}/select_t2.sql
29 echo "drop table t2;" >${REL_PATH}/drop_t2.sql
31 echo "Durablity = TRUE"
33 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
37 if [ "$VALGRIND" = "true" ]
39 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/create_t2.sql
2> $0.valgr
41 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/create_t2.sql
44 rm -f ${REL_PATH}/select_t2.sql
45 rm -f ${REL_PATH}/drop_t2.sql
52 echo "INSERTING INTO TABLE"
53 echo "DEFAULT AUTOCOMMIT MODE ON"
54 if [ "$VALGRIND" = "true" ]
56 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/ins_rollback.sql
2>> $0.valgr
58 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/ins_rollback.sql
61 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_t2.sql
62 rm -f ${REL_PATH}/select_t2.sql
63 rm -f ${REL_PATH}/drop_t2.sql
70 if [ "$VALGRIND" = "true" ]
72 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csqldump
2>> $0.valgr
74 $CSQL_INSTALL_ROOT/bin
/csqldump
>before.sql
82 echo "Durablity = TRUE"
83 echo "Checking Durability"
84 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
89 if [ "$VALGRIND" = "true" ]
91 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csqldump
2>> $0.valgr
93 $CSQL_INSTALL_ROOT/bin
/csqldump
>after.sql
96 diff before.sql after.sql
>>/dev
/null
2>&1
99 echo Durability Works Fine
102 if [ "$VALGRIND" = "true" ]
104 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_t2.sql
2>> $0.valgr
106 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/drop_t2.sql
109 rm -f ${REL_PATH}/select_t2.sql
110 rm -f ${REL_PATH}/drop_t2.sql
111 rm -f before.sql after.sql
113 ipcrm
-M 4444 -M 6666