test/durability/recovery/test001.ksh

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