test/tools/Durability/test011.ksh

   1 #!/bin/sh
   2 # Composite index test
   3 # Testing All the operation in CSQl ((After Each Operation Kill the server and Restart the server again for Another Operation)
   4 # Run this test only under csql/test or on this directory.
   5 # Otherwise, it may fail
   6 # set DURABILITY to true in csql.conf
   7 # Start csqlserver. Then create a table in CSQL Client.Insert 5 Records.
   8 # kill the currently running Server.
   9 # Start csqlserver. Then create Composite Unique Index on two fieldse in CSQL Client.Insert 5 Records.
  10 # kill the currently running Server.
  11 # Again Restart the Server by setting DURABILITY=true and Open CSQL Client.
  12 # Continue The same For All Operations in CSQL.
  13 # All should work Fine
  14 #
  15 CSQL_CONF=${PWD}/tools/Durability/csql.conf
  16 REL_PATH=.
  17 if [ -s "$CSQL_CONF" ]
  18 then
  19     REL_PATH=${PWD}/tools/Durability
  20 fi
  21
  22 rm -f /tmp/csql.conf
  23 rm -rf /tmp/csql/db
  24 mkdir -p /tmp/csql/db
  25 cp -f $REL_PATH/csql.conf /tmp
  26 echo SYS_DB_KEY=4444 >>/tmp/csql.conf
  27 echo USER_DB_KEY=6666 >>/tmp/csql.conf
  28 echo "DURABILITY=true" >>/tmp/csql.conf
  29 export CSQL_CONFIG_FILE=/tmp/csql.conf
  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_10.sql
  38 if [ $? -ne 0 ]
  39  then
  40    kill -9 $pid
  41    ipcrm -M 4444 -M 6666
  42  exit 1;
  43 fi
  44
  45 $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
  46 kill -9 $pid
  47 ipcrm -M 4444 -M 6666
  48 echo "Server Killed"
  49
  50 echo count=1
  51 echo "Durablity = TRUE"
  52 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  53 pid=$!
  54 echo "Checking Durability"
  55 echo "Server Started"
  56 sleep 2
  57 $CSQL_INSTALL_ROOT/bin/csqldump >after.sql
  58 diff before.sql after.sql
  59 if [ $? -eq 0 ]
  60     then
  61         echo Durability Works Fine
  62 fi
  63
  64 echo "INSERTING INTO TABLE"
  65 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/compo_index2_10.sql
  66 if [ $? -ne 0 ]
  67  then
  68    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql
  69    kill -9 $pid
  70    ipcrm -M 4444 -M 6666
  71  exit 3;
  72 fi
  73
  74 $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
  75 kill -9 $pid
  76 ipcrm -M 4444 -M 6666
  77 echo "Server Killed"
  78
  79 echo count=2
  80 echo "Durablity = TRUE"
  81 echo "Checking Durability"
  82 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  83 pid=$!
  84 echo "Server Started"
  85 sleep 2
  86 $CSQL_INSTALL_ROOT/bin/csqldump >after.sql
  87 diff before.sql after.sql
  88 if [ $? -eq 0 ]
  89     then
  90         echo Durability Works Fine
  91 fi
  92
  93 echo "INSERTING INTO TABLE"
  94 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/insert_10.sql
  95 if [ $? -ne 0 ]
  96  then
  97    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql
  98    kill -9 $pid
  99    ipcrm -M 4444 -M 6666
 100  exit 3;
 101 fi
 102
 103 $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
 104 kill -9 $pid
 105 ipcrm -M 4444 -M 6666
 106 echo "Server Killed"
 107
 108 echo count=3
 109 echo "Durablity = TRUE"
 110 echo "Checking Durability"
 111 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
 112 pid=$!
 113 echo "Server Started"
 114 sleep 2
 115 $CSQL_INSTALL_ROOT/bin/csqldump >after.sql
 116 diff before.sql after.sql
 117 if [ $? -eq 0 ]
 118     then
 119         echo Durability Works Fine
 120 fi
 121
 122 echo "UPDATING RECORDS IN TABLE"
 123 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/update_10.sql
 124 if [ $? -ne 0 ]
 125  then
 126    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql
 127    kill -9 $pid
 128    ipcrm -M 4444 -M 6666
 129  exit 5;
 130 fi
 131
 132 $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
 133 kill -9 $pid
 134 ipcrm -M 4444 -M 6666
 135 echo "Server Killed"
 136
 137 echo count=4
 138 echo "Durablity = TRUE"
 139 echo "Checking Durability"
 140 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
 141 pid=$!
 142 echo "Server Started"
 143 sleep 2
 144 $CSQL_INSTALL_ROOT/bin/csqldump >after.sql
 145 diff before.sql after.sql
 146 if [ $? -eq 0 ]
 147     then
 148         echo Durability Works Fine
 149 fi
 150
 151 echo "DELETING RECORDS FROM TABLE"
 152 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/delete_10.sql
 153 if [ $? -ne 0 ]
 154  then
 155    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql
 156    kill -9 $pid
 157    ipcrm -M 4444 -M 6666
 158  exit 7;
 159 fi
 160
 161 $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
 162 kill -9 $pid
 163 ipcrm -M 4444 -M 6666
 164 echo "Server Killed"
 165
 166 echo count=5
 167 echo "Durablity = TRUE"
 168 echo "Checking Durability"
 169 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
 170 pid=$!
 171 echo "Server Started"
 172 sleep 2
 173 $CSQL_INSTALL_ROOT/bin/csqldump >after.sql
 174 diff before.sql after.sql
 175 if [ $? -eq 0 ]
 176     then
 177         echo Durability Works Fine
 178 fi
 179
 180 echo "DROPPING TABLE"
 181 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql
 182 if [ $? -ne 0 ]
 183  then
 184    kill -9 $pid
 185    ipcrm -M 4444 -M 6666
 186  exit 9;
 187 fi
 188
 189 rm -f before.sql after.sql
 190 kill -9 $pid
 191 ipcrm -M 4444 -M 6666
 192 exit 0;