2 #check stmtid start from last stmtid after recover
4 CSQL_CONF
=${PWD}/durability
/redologs
/csql.conf
8 REL_PATH
=${PWD}/durability
/redologs
14 cp -f $REL_PATH/csql.conf
/tmp
15 echo SYS_DB_KEY
=4444 >>/tmp
/csql.conf
16 echo ID_SHM_KEY
=6666 >>/tmp
/csql.conf
17 echo DURABILITY
=true
>>/tmp
/csql.conf
18 export CSQL_CONFIG_FILE
=/tmp
/csql.conf
21 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
25 echo "CREATE TABLE laks(f1 int);" >${REL_PATH}/t1.sql
26 echo "INSERT INTO laks values (10);" >>${REL_PATH}/t1.sql
27 echo "INSERT INTO laks values (20);" >>${REL_PATH}/t1.sql
28 echo "INSERT INTO laks values (30);" >>${REL_PATH}/t1.sql
30 if [ "$VALGRIND" = "true" ]
32 valgrind
--tool=memcheck
--leak-check=full
$CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/t1.sql
2> $0.valgr
34 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/t1.sql
39 rm -f ${REL_PATH}/t1.sql
43 $CSQL_INSTALL_ROOT/bin
/redo
-al
49 echo "Checking Durability"
50 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
55 echo "INSERT INTO laks values (50);" >${REL_PATH}/t1.sql
56 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/t1.sql
57 $CSQL_INSTALL_ROOT/bin
/redo
-al
59 rm -f ${REL_PATH}/t1.sql