test/durability/recovery/test011.ksh

   1 #!/bin/ksh
   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 # set DURABILITY to true in csql.conf
   5 # Start csqlserver. Then create a table in CSQL Client.Insert 5 Records.
   6 # kill the currently running Server.
   7 # Start csqlserver. Then create Composite Unique Index on two fieldse in CSQL Client.Insert 5 Records.
   8 # kill the currently running Server.
   9 # Again Restart the Server by setting DURABILITY=true and Open CSQL Client.
  10 # Continue The same For All Operations in CSQL.
  11 # All should work Fine
  12 #
  13 CSQL_CONF=${PWD}/durability/recovery/csql.conf
  14 REL_PATH=.
  15 if [ -s "$CSQL_CONF" ]
  16 then
  17     REL_PATH=${PWD}/durability/recovery
  18 fi
  19
  20 rm -f /tmp/csql.conf
  21 rm -f /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 if [ "$VALGRIND" = "true" ]
  36 then
  37     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/create_10.sql 2> $0.valgr
  38 else
  39     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/create_10.sql >/dev/null 2>&1
  40     if [ $? -ne 0 ]
  41      then
  42        kill -9 $pid
  43        ipcrm -M 4444 -M 6666
  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
  59 echo count=1
  60 echo "Durablity = TRUE"
  61 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  62 pid=$!
  63 echo "Checking Durability"
  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
  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 echo "INSERTING INTO TABLE"
  81 if [ "$VALGRIND" = "true" ]
  82 then
  83     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/compo_index2_10.sql 2>> $0.valgr
  84 else
  85     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/compo_index2_10.sql >/dev/null 2>&1
  86     if [ $? -ne 0 ]
  87      then
  88        $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql
  89        kill -9 $pid
  90        ipcrm -M 4444 -M 6666
  91      exit 3;
  92     fi
  93 fi
  94
  95 if [ "$VALGRIND" = "true" ]
  96 then
  97     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csqldump 2>> $0.valgr
  98 else
  99     $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
 100 fi
 101
 102 kill -9 $pid
 103 ipcrm -M 4444 -M 6666
 104 echo "Server Killed"
 105
 106 echo count=2
 107 echo "Durablity = TRUE"
 108 echo "Checking Durability"
 109 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
 110 pid=$!
 111 echo "Server Started"
 112 sleep 2
 113
 114 if [ "$VALGRIND" = "true" ]
 115 then
 116     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csqldump 2>> $0.valgr
 117 else
 118     $CSQL_INSTALL_ROOT/bin/csqldump >after.sql
 119 fi
 120
 121 diff before.sql after.sql >/dev/null 2>&1
 122 if [ $? -eq 0 ]
 123     then
 124         echo Durability Works Fine
 125 fi
 126
 127 echo "INSERTING INTO TABLE"
 128 if [ "$VALGRIND" = "true" ]
 129 then
 130     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/insert_10.sql 2>> $0.valgr
 131 else
 132     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/insert_10.sql >/dev/null 2>&1
 133     if [ $? -ne 0 ]
 134      then
 135        $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql
 136        kill -9 $pid
 137        ipcrm -M 4444 -M 6666
 138      exit 3;
 139     fi
 140 fi
 141
 142 if [ "$VALGRIND" = "true" ]
 143 then
 144     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csqldump 2>> $0.valgr
 145 else
 146     $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
 147 fi
 148
 149 kill -9 $pid
 150 ipcrm -M 4444 -M 6666
 151 echo "Server Killed"
 152
 153 echo count=3
 154 echo "Durablity = TRUE"
 155 echo "Checking Durability"
 156 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
 157 pid=$!
 158 echo "Server Started"
 159 sleep 2
 160
 161 if [ "$VALGRIND" = "true" ]
 162 then
 163     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csqldump 2>> $0.valgr
 164 else
 165     $CSQL_INSTALL_ROOT/bin/csqldump >after.sql
 166 fi
 167
 168 diff before.sql after.sql >/dev/null 2>&1
 169 if [ $? -eq 0 ]
 170     then
 171         echo Durability Works Fine
 172 fi
 173
 174 echo "UPDATING RECORDS IN TABLE"
 175 if [ "$VALGRIND" = "true" ]
 176 then
 177     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/update_10.sql 2>> $0.valgr
 178 else
 179     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/update_10.sql >/dev/null 2>&1
 180     if [ $? -ne 0 ]
 181      then
 182        $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql
 183        kill -9 $pid
 184        ipcrm -M 4444 -M 6666
 185      exit 5;
 186     fi
 187 fi
 188
 189 if [ "$VALGRIND" = "true" ]
 190 then
 191     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csqldump 2>> $0.valgr
 192 else
 193     $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
 194 fi
 195
 196 kill -9 $pid
 197 ipcrm -M 4444 -M 6666
 198 echo "Server Killed"
 199
 200 echo count=4
 201 echo "Durablity = TRUE"
 202 echo "Checking Durability"
 203 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
 204 pid=$!
 205 echo "Server Started"
 206 sleep 2
 207
 208 if [ "$VALGRIND" = "true" ]
 209 then
 210     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csqldump 2>> $0.valgr
 211 else
 212     $CSQL_INSTALL_ROOT/bin/csqldump >after.sql
 213 fi
 214
 215 diff before.sql after.sql >/dev/null 2>&1
 216 if [ $? -eq 0 ]
 217     then
 218         echo Durability Works Fine
 219 fi
 220
 221 echo "DELETING RECORDS FROM TABLE"
 222 if [ "$VALGRIND" = "true" ]
 223 then
 224     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/delete_10.sql 2>> $0.valgr
 225     else
 226     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/delete_10.sql >/dev/null 2>&1
 227     if [ $? -ne 0 ]
 228      then
 229        $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql
 230        kill -9 $pid
 231        ipcrm -M 4444 -M 6666
 232      exit 7;
 233     fi
 234 fi
 235
 236 if [ "$VALGRIND" = "true" ]
 237 then
 238     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csqldump 2>> $0.valgr
 239 else
 240     $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
 241 fi
 242
 243 kill -9 $pid
 244 ipcrm -M 4444 -M 6666
 245 echo "Server Killed"
 246
 247 echo count=5
 248 echo "Durablity = TRUE"
 249 echo "Checking Durability"
 250 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
 251 pid=$!
 252 echo "Server Started"
 253 sleep 2
 254
 255 if [ "$VALGRIND" = "true" ]
 256 then
 257     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csqldump 2>> $0.valgr
 258 else
 259     $CSQL_INSTALL_ROOT/bin/csqldump >after.sql
 260 fi
 261
 262 diff before.sql after.sql >/dev/null 2>&1
 263 if [ $? -eq 0 ]
 264     then
 265         echo Durability Works Fine
 266 fi
 267
 268 echo "DROPPING TABLE"
 269 if [ "$VALGRIND" = "true" ]
 270 then
 271     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql 2>> $0.valgr
 272 else
 273     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql
 274     if [ $? -ne 0 ]
 275      then
 276        kill -9 $pid
 277        ipcrm -M 4444 -M 6666
 278      exit 9;
 279     fi
 280 fi
 281
 282 rm -f before.sql after.sql
 283 kill -9 $pid
 284 ipcrm -M 4444 -M 6666
 285 exit 0;