test/tools/Durability/test005.ksh

   1 #!/bin/sh
   2 # Testing All the operation in CSQl ((After Each Operation Kill the server and Restart the server again for Another Operation)
   3 # Run this test only under csql/test or on this directory.
   4 # Otherwise, it may fail
   5 # set DURABILITY to true in csql.conf
   6 # Start csqlserver. Then create a table in CSQL Client.Insert 5 Records.
   7 # kill the currently running Server.
   8 # Again Restart the Server by setting DURABILITY=true and Open CSQL Client.
   9 # Continue The same For All Operations in CSQL.
  10 # All should work Fine
  11 #
  12
  13 CSQL_CONF=${PWD}/tools/Durability/csql.conf
  14 REL_PATH=.
  15 if [ -s "$CSQL_CONF" ]
  16 then
  17     REL_PATH=${PWD}/tools/Durability
  18 fi
  19
  20 rm -f /tmp/csql.conf
  21 rm -rf /tmp/csql/db
  22 mkdir -p /tmp/csql/db
  23 cp -f $REL_PATH/csql.conf /tmp
  24 echo SYS_DB_KEY=4444 >>/tmp/csql.conf
  25 echo USER_DB_KEY=6666 >>/tmp/csql.conf
  26 echo "DURABILITY=true" >>/tmp/csql.conf
  27 export CSQL_CONFIG_FILE=/tmp/csql.conf
  28
  29 echo "Durablity = TRUE"
  30 echo "Server Started"
  31 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  32 pid=$!
  33 sleep 2
  34 echo "CREATING TABLE"
  35 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/create_t1.sql
  36 if [ $? -ne 0 ]
  37  then
  38    kill -9 $pid
  39    ipcrm -M 4444 -M 6666
  40  exit 1;
  41 fi
  42
  43 $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
  44
  45 kill -9 $pid
  46 ipcrm -M 4444 -M 6666
  47 echo "Server Killed"
  48
  49 echo ""
  50 echo "Durablity = TRUE"
  51 echo "Checking Durability"
  52 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  53 pid=$!
  54 echo "Server Started"
  55 sleep 2
  56 $CSQL_INSTALL_ROOT/bin/csqldump >after.sql
  57 diff before.sql after.sql
  58
  59 echo "INSERTING INTO TABLE"
  60 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/insert_t1.sql
  61 if [ $? -ne 0 ]
  62  then
  63    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_t1.sql
  64    kill -9 $pid
  65    ipcrm -M 4444 -M 6666
  66  exit 3;
  67 fi
  68
  69 $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
  70 kill -9 $pid
  71 ipcrm -M 4444 -M 6666
  72 echo "Server Killed"
  73
  74 echo ""
  75 echo "Durablity = TRUE"
  76 echo "Checking Durability"
  77 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  78 pid=$!
  79 echo "Server Started"
  80 sleep 2
  81
  82 $CSQL_INSTALL_ROOT/bin/csqldump >after.sql
  83 diff before.sql after.sql
  84
  85 echo "UPDATING RECORDS IN TABLE"
  86 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/update_t1.sql
  87 if [ $? -ne 0 ]
  88  then
  89    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_t1.sql
  90    kill -9 $pid
  91    ipcrm -M 4444 -M 6666
  92  exit 5;
  93 fi
  94
  95 $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
  96
  97 kill -9 $pid
  98 ipcrm -M 4444 -M 6666
  99 echo "Server Killed"
 100
 101 echo ""
 102 echo "Durablity = TRUE"
 103 echo "Checking Durability"
 104 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
 105 pid=$!
 106 echo "Server Started"
 107 sleep 2
 108
 109 $CSQL_INSTALL_ROOT/bin/csqldump >after.sql
 110 diff before.sql after.sql
 111
 112 echo "DELETING RECORDS FROM TABLE"
 113 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/delete_t1.sql
 114 if [ $? -ne 0 ]
 115  then
 116    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_t1.sql
 117    kill -9 $pid
 118    ipcrm -M 4444 -M 6666
 119  exit 7;
 120 fi
 121
 122 $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
 123 kill -9 $pid
 124 ipcrm -M 4444 -M 6666
 125 echo "Server Killed"
 126
 127 echo ""
 128 echo "Durablity = TRUE"
 129 echo "Checking Durability"
 130 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
 131 pid=$!
 132 echo "Server Started"
 133 sleep 2
 134
 135 $CSQL_INSTALL_ROOT/bin/csqldump >after.sql
 136 diff before.sql after.sql
 137
 138 echo "DROPPING TABLE"
 139 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_t1.sql
 140 if [ $? -ne 0 ]
 141  then
 142    kill -9 $pid
 143    ipcrm -M 4444 -M 6666
 144  exit 9;
 145 fi
 146
 147 $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
 148 rm -f before.sql after.sql
 149 kill -9 $pid
 150 ipcrm -M 4444 -M 6666
 151 exit 0;