test/durability/recovery/testMMAP015.ksh

   1 #!/bin/ksh
   2 # Testing Durability in MMAP architecture
   3 # set DURABILITY = true MMAP=true in csql.conf
   4 # Start csqlserver.
   5 # Then create a table t1 in CSQL Client.
   6 # Create tree index idx1 on t1(f1);
   7 # Create the same tree index idx1 on t1(f1);
   8 # kill the currently running Server.
   9 # Restart the server.
  10 # csqldump should dump the database with table and index information
  11 #
  12 CSQL_CONF=${PWD}/durability/recovery/csql.conf
  13 REL_PATH=.
  14 if [ -s "$CSQL_CONF" ]
  15 then
  16     REL_PATH=${PWD}/durability/recovery
  17 fi
  18
  19 rm -f /tmp/csql.conf
  20 rm -rf /tmp/csql/db
  21 mkdir -p /tmp/csql/db
  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
  27
  28 echo "Durablity = TRUE"
  29 echo "Server Started"
  30 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  31 pid=$!
  32 sleep 2
  33
  34 echo "CREATE TABLE laks(f1 int);" >${REL_PATH}/create.sql
  35 echo "DROP TABLE laks;" >${REL_PATH}/drop.sql
  36
  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
  39 if [ $? -ne 0 ]
  40  then
  41    kill -9 $pid
  42    ipcrm -M 4444
  43    rm -f ${REL_PATH}/create.sql
  44    rm -f ${REL_PATH}/drop.sql
  45  exit 1;
  46 fi
  47
  48 echo "CREATE INDEX idx1 on laks(f1) TREE;" >${REL_PATH}/indexcreate.sql
  49 echo "CREATE INDEX idx1 ON laks(f1) TREE;"
  50 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/indexcreate.sql >/dev/null 2>&1
  51 if [ $? -ne 0 ]
  52  then
  53    kill -9 $pid
  54    ipcrm -M 4444
  55    rm -f ${REL_PATH}/create.sql
  56    rm -f ${REL_PATH}/drop.isql
  57    rm -f ${REL_PATH}/indexcreate.sql
  58  exit 2;
  59 fi
  60
  61 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/indexcreate.sql >/dev/null 2>&1
  62 if [ $? -ne 0 ]
  63  then
  64    kill -9 $pid
  65    ipcrm -M 4444
  66    rm -f ${REL_PATH}/create.sql
  67    rm -f ${REL_PATH}/drop.isql
  68    rm -f ${REL_PATH}/indexcreate.sql
  69  exit 3;
  70 fi
  71
  72 $CSQL_INSTALL_ROOT/bin/csqldump >${REL_PATH}/before.sql
  73
  74 kill -9 $pid
  75 ipcrm -M 4444
  76 echo "Server Killed"
  77 echo ""
  78 echo DURABILITY=true >>/tmp/csql.conf
  79 echo "Checking Durability"
  80 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  81 if [ $? -ne 0 ]
  82  then
  83    echo "Server could not be Started"
  84    rm -rf /tmp/csql/db
  85    mkdir -p /tmp/csql/db
  86    kill -9 $pid
  87    ipcrm -M 4444
  88    rm -f ${REL_PATH}/create.sql
  89    rm -f ${REL_PATH}/drop.sql
  90    rm -f ${REL_PATH}/indexcreate.sql
  91  exit 4;
  92 fi
  93 pid=$!
  94 echo "Server Started"
  95 sleep 2
  96
  97 $CSQL_INSTALL_ROOT/bin/csqldump >${REL_PATH}/after.sql
  98 echo ""
  99 diff ${REL_PATH}/before.sql ${REL_PATH}/after.sql >/dev/null 2>&1
 100 if [ $? -eq 0 ]
 101     then
 102         echo Durability Works Fine
 103 fi
 104
 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
 109 kill -9 $pid
 110 ipcrm -M 4444
 111 exit 0;