test/durability/recovery/test003.ksh

   1 #!/bin/ksh
   2 # set DURABILITY = true in csql.conf
   3 # Start csqlserver. Then create a table in CSQL Client.
   4 # kill the currently running Server.
   5 # Restart the server by setting DURABILITY = false. and Open CSQL Client.
   6 # SHOW TABLES; Statement  should not display any table.
   7 #
   8 CSQL_CONF=${PWD}/durability/recovery/csql.conf
   9 REL_PATH=.
  10 if [ -s "$CSQL_CONF" ]
  11 then
  12     REL_PATH=${PWD}/durability/recovery
  13 fi
  14
  15 rm -f /tmp/csql.conf
  16 rm -f /tmp/csql/db/*
  17 mkdir -p /tmp/csql/db
  18 cp -f $REL_PATH/csql.conf /tmp
  19 echo SYS_DB_KEY=4444 >>/tmp/csql.conf
  20 echo USER_DB_KEY=6666 >>/tmp/csql.conf
  21 echo DURABILITY=true >>/tmp/csql.conf
  22 export CSQL_CONFIG_FILE=/tmp/csql.conf
  23
  24 echo "Durablity = TRUE"
  25 echo "Server Started"
  26 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  27 pid=$!
  28 sleep 2
  29
  30 echo "CREATE TABLE laks(f1 int);" >${REL_PATH}/create.sql
  31 echo "DROP TABLE laks;" >${REL_PATH}/drop.sql
  32
  33 if [ "$VALGRIND" = "true" ]
  34 then
  35     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/create.sql 2> $0.valgr
  36 else
  37     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/create.sql
  38     if [ $? -ne 0 ]
  39      then
  40        kill -9 $pid
  41        ipcrm -M 4444 -M 6666
  42        rm -f ${REL_PATH}/create.sql
  43        rm -f ${REL_PATH}/drop.sql
  44      exit 1;
  45 fi
  46 fi
  47
  48 if [ "$VALGRIND" = "true" ]
  49 then
  50     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csqldump 2>> $0.valgr
  51 else
  52     $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
  53 fi
  54
  55 kill -9 $pid
  56 ipcrm -M 4444 -M 6666
  57 echo "Server Killed"
  58 echo ""
  59 echo DURABILITY=false >>/tmp/csql.conf
  60 echo "Durablity = FALSE"
  61 echo "Checking Durability"
  62 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  63 pid=$!
  64 echo "Server Started"
  65 sleep 2
  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 >after.sql
  71 fi
  72
  73 echo ""
  74 diff before.sql after.sql >>/dev/null 2>&1
  75 if [ $? -eq 0 ]
  76      then
  77        echo Durability Works Fine
  78 fi
  79
  80 rm -f ${REL_PATH}/create.sql
  81 rm -f ${REL_PATH}/drop.sql
  82 rm -f before.sql after.sql
  83 kill -9 $pid
  84 ipcrm -M 4444 -M 6666
  85 exit 0;