test/tools/Durability/test008.ksh

   1 #!/bin/sh
   2 # Set DURABILITY to true in csql.conf
   3 # Start csqlserver. in CSQl client create a table and insert 5 recored
   4 # Kill the server
   5 # Restart csqlserver again. set Autocommit Off mode.insert another 5 record.and  Rollback the transaction.
   6 # Kill the server
   7 # Again Restart The server
   8 # Select Should fetch only 1st 5 records
   9 #
  10
  11 CSQL_CONF=${PWD}/tools/Durability/csql.conf
  12 REL_PATH=.
  13 if [ -s "$CSQL_CONF" ]
  14 then
  15     REL_PATH=${PWD}/tools/Durability
  16 fi
  17
  18 rm -f /tmp/csql.conf
  19 rm -rf /tmp/csql/db
  20 mkdir -p /tmp/csql/db
  21 cp -f $REL_PATH/csql.conf /tmp
  22 echo SYS_DB_KEY=4444 >>/tmp/csql.conf
  23 echo USER_DB_KEY=6666 >>/tmp/csql.conf
  24 echo "DURABILITY=true" >>/tmp/csql.conf
  25 export CSQL_CONFIG_FILE=/tmp/csql.conf
  26
  27
  28 echo "SELECT * FROM t2;" >${REL_PATH}/select_t2.sql
  29 echo "drop table t2;" >${REL_PATH}/drop_t2.sql
  30
  31 echo "Durablity = TRUE"
  32 echo "Server Started"
  33 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  34 pid=$!
  35 sleep 2
  36 echo "CREATING TABLE"
  37 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/create_t2.sql
  38 if [ $? -ne 0 ]
  39  then
  40    rm -f ${REL_PATH}/select_t2.sql
  41    rm -f ${REL_PATH}/drop_t2.sql
  42    kill -9 $pid
  43    ipcrm -M 4444 -M 6666
  44  exit 1;
  45 fi
  46
  47 echo "INSERTING INTO TABLE"
  48 echo "DEFAULT AUTOCOMMIT MODE ON"
  49 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/insert_a.sql
  50 if [ $? -ne 0 ]
  51  then
  52    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_t2.sql
  53    rm -f ${REL_PATH}/select_t2.sql
  54    rm -f ${REL_PATH}/drop_t2.sql
  55    kill -9 $pid
  56    ipcrm -M 4444 -M 6666
  57  exit 2;
  58 fi
  59
  60 $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
  61 kill -9 $pid
  62 ipcrm -M 4444 -M 6666
  63 echo "Server Killed"
  64
  65 echo ""
  66 echo "Durablity = TRUE"
  67 echo "Server Started"
  68 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  69 pid=$!
  70 sleep 2
  71 echo "Checking Durability"
  72 $CSQL_INSTALL_ROOT/bin/csqldump >after.sql
  73 diff before.sql after.sql
  74 if [ $? -eq 0 ]
  75  then
  76    echo Durability Works Fine
  77 fi
  78
  79 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/insert_b.sql
  80 if [ $? -ne 0 ]
  81  then
  82    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_t2.sql
  83    rm -f ${REL_PATH}/select_t2.sql
  84    rm -f ${REL_PATH}/drop_t2.sql
  85    kill -9 $pid
  86    ipcrm -M 4444 -M 6666
  87  exit 3;
  88 fi
  89
  90 $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
  91 kill -9 $pid
  92 ipcrm -M 4444 -M 6666
  93 echo "Server Killed"
  94
  95 echo ""
  96 echo "Durablity = TRUE"
  97 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  98 pid=$!
  99 echo "Server Started"
 100 sleep 2
 101 echo "Checking Durability"
 102 $CSQL_INSTALL_ROOT/bin/csqldump >after.sql
 103 diff before.sql after.sql
 104 if [ $? -eq 0 ]
 105  then
 106    echo Durability Works Fine
 107 fi
 108
 109 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_t2.sql
 110 rm -f ${REL_PATH}/select_t2.sql
 111 rm -f ${REL_PATH}/drop_t2.sql
 112 rm -f before.sql after.sql
 113 kill -9 $pid
 114 ipcrm -M 4444 -M 6666
 115 exit 0;