test/durability/recovery/testMMAP019.ksh

   1 #!/bin/ksh
   2 # Testing Durability in MMAP Architecture
   3 # set DURABILITY to true and MMAP=true in csql.conf
   4 # Start csqlserver.
   5 # Then create a table t1 with record size 20.
   6 # Insert 1k Records
   7 # kill the currently running Server.
   8 # set DURABILITY to true and MMAP=false in csql.conf
   9 # Start csqlserver.
  10 # Insert another 1k Records.
  11 # All inserted records should be durable
  12 #
  13
  14 CSQL_CONF=${PWD}/durability/recovery/csql.conf
  15 REL_PATH=.
  16 if [ -s "$CSQL_CONF" ]
  17 then
  18     REL_PATH=${PWD}/durability/recovery
  19 fi
  20
  21 rm -f /tmp/csql.conf
  22 rm -f /tmp/csql/db/*
  23 mkdir -p /tmp/csql/db
  24 cp -f $REL_PATH/csql.conf /tmp
  25 echo SYS_DB_KEY=4444 >>/tmp/csql.conf
  26 echo "DURABILITY=true" >>/tmp/csql.conf
  27 echo "MMAP=true" >>/tmp/csql.conf
  28 export CSQL_CONFIG_FILE=/tmp/csql.conf
  29
  30 echo "DURABILITY=true and MMAP=true"
  31 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  32 pid=$!
  33 echo "Server Started"
  34 sleep 2
  35
  36 echo "SELECT COUNT(*) from t1;" >${REL_PATH}/sel.sql
  37 echo "CREATE TABLE t1(f1 int,f2 char(15));"
  38 echo "CREATE TABLE t1(f1 int,f2 char(15));" >${REL_PATH}/cre_t1.sql
  39 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/cre_t1.sql >/dev/null 2>&1
  40 if [ $? -ne 0 ]
  41  then
  42    rm -f ${REL_PATH}/cre_t1.sql
  43    kill -9 $pid
  44    ipcrm -M 4444
  45  exit 1;
  46 fi
  47 j=1
  48 while [[ $j -lt 1001 ]];do
  49   echo "INSERT INTO t1 VALUES($j,'CSQL$j');" >>${REL_PATH}/ins_1000.sql
  50   (( j +=1 ))
  51 done
  52 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/ins_1000.sql >/dev/null 2>&1
  53 if [ $? -ne 0 ]
  54  then
  55    rm -f ${REL_PATH}/cre_t1.sql
  56    rm -f ${REL_PATH}/ins_1000.sql
  57    kill -9 $pid
  58    ipcrm -M 4444
  59  exit 1;
  60 fi
  61 $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
  62 kill -9 $pid
  63 ipcrm -M 4444
  64 echo "Server Killed"
  65 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  66 pid=$!
  67 echo "Server Started"
  68 sleep 2
  69 $CSQL_INSTALL_ROOT/bin/csqldump >after.sql
  70 diff before.sql after.sql
  71 if [ $? -eq 0 ]
  72    then
  73        $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/sel.sql
  74        echo Durability Works Fine
  75 fi
  76 rm -f before.sql after.sql
  77
  78 $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
  79 kill -9 $pid
  80 ipcrm -M 4444
  81 echo "Server Killed"
  82
  83 echo "DURABILITY=true and MMAP=false"
  84
  85 echo SYS_DB_KEY=4444 >>/tmp/csql.conf
  86 echo USER_DB_KEY=6666 >>/tmp/csql.conf
  87 echo "DURABILITY=true" >>/tmp/csql.conf
  88 echo "MMAP=false" >>/tmp/csql.conf
  89 export CSQL_CONFIG_FILE=/tmp/csql.conf
  90
  91 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  92 pid=$!
  93 echo "Server Started"
  94 sleep 2
  95 $CSQL_INSTALL_ROOT/bin/csqldump >after.sql
  96 diff before.sql after.sql
  97 if [ $? -eq 0 ]
  98    then
  99        $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/sel.sql
 100        echo Durability Works Fine
 101 fi
 102 rm -f before.sql after.sql
 103
 104
 105 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/ins_1000.sql >/dev/null 2>&1
 106 if [ $? -ne 0 ]
 107  then
 108    rm -f ${REL_PATH}/cre_t1.sql
 109    rm -f ${REL_PATH}/ins_1000.sql
 110    kill -9 $pid
 111    ipcrm -M 4444 -M 6666
 112  exit 1;
 113 fi
 114 $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
 115 kill -9 $pid
 116 ipcrm -M 4444 -M 6666
 117 echo "Server Killed"
 118 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
 119 pid=$!
 120 echo "Server Started"
 121 sleep 2
 122 $CSQL_INSTALL_ROOT/bin/csqldump >after.sql
 123 diff before.sql after.sql
 124 if [ $? -eq 0 ]
 125    then
 126        $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/sel.sql
 127        echo Durability Works Fine
 128 fi
 129 rm -f before.sql after.sql
 130
 131 echo "DROP TABLE t1;" >drp.sql
 132 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/drp.sql >/dev/null 2>&1
 133 rm -f ${REL_PATH}/drp.sql
 134 rm -f ${REL_PATH}/sel.sql
 135 rm -f ${REL_PATH}/cre_t1.sql
 136 rm -f ${REL_PATH}/ins_1000.sql
 137 kill -9 $pid
 138 ipcrm -M 4444 -M 6666
 139 exit 0;