test/durability/recovery/test013.ksh

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