2 # Testing Durability in MMAP architectur
3 # set DURABILITY = true and MMAP=true in csql.conf
5 # Then create a table t1 in CSQL Client.
6 # Create index idx1 on t1(f1);
7 # Create the same index idx1 on t1(f1);
8 # kill the currently running Server.
10 # csqldump should dump the database with table and index information
12 CSQL_CONF
=${PWD}/durability
/recovery
/csql.conf
14 if [ -s "$CSQL_CONF" ]
16 REL_PATH
=${PWD}/durability
/recovery
22 cp -f $REL_PATH/csql.conf
/tmp
23 echo SYS_DB_KEY
=4444 >>/tmp
/csql.conf
24 echo DURABILITY
=true
>>/tmp
/csql.conf
25 echo MMAP
=true
>>/tmp
/csql.conf
26 export CSQL_CONFIG_FILE
=/tmp
/csql.conf
28 echo "Durablity = TRUE"
30 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
34 echo "CREATE TABLE laks(f1 int);" >${REL_PATH}/create.sql
35 echo "DROP TABLE laks;" >${REL_PATH}/drop.sql
37 echo "CREATE TABLE laks(f1 int);"
38 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/create.sql
>/dev
/null
2>&1
43 rm -f ${REL_PATH}/create.sql
44 rm -f ${REL_PATH}/drop.sql
48 echo "CREATE INDEX idx1 on laks(f1);" >${REL_PATH}/indexcreate.sql
49 echo "CREATE INDEX idx1 ON laks(f1);"
50 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/indexcreate.sql
>/dev
/null
2>&1
55 rm -f ${REL_PATH}/create.sql
56 rm -f ${REL_PATH}/drop.isql
57 rm -f ${REL_PATH}/indexcreate.sql
61 $CSQL_INSTALL_ROOT/bin
/csql
-u root
-p manager
-s ${REL_PATH}/indexcreate.sql
>/dev
/null
2>&1
66 rm -f ${REL_PATH}/create.sql
67 rm -f ${REL_PATH}/drop.isql
68 rm -f ${REL_PATH}/indexcreate.sql
72 $CSQL_INSTALL_ROOT/bin
/csqldump
>${REL_PATH}/before.sql
78 echo DURABILITY
=true
>>/tmp
/csql.conf
79 echo "Checking Durability"
80 $CSQL_INSTALL_ROOT/bin
/csqlserver
>/dev
/null
2>&1 &
83 echo "Server could not be Started"
88 rm -f ${REL_PATH}/create.sql
89 rm -f ${REL_PATH}/drop.sql
90 rm -f ${REL_PATH}/indexcreate.sql
97 $CSQL_INSTALL_ROOT/bin
/csqldump
>${REL_PATH}/after.sql
99 diff ${REL_PATH}/before.sql
${REL_PATH}/after.sql
>/dev
/null
2>&1
102 echo Durability Works Fine
105 rm -f ${REL_PATH}/create.sql
106 rm -f ${REL_PATH}/drop.sql
107 rm -f ${REL_PATH}/before.sql
${REL_PATH}/after.sql
108 rm -f ${REL_PATH}/indexcreate.sql