test/durability/recovery/test005.ksh

   1 #!/bin/ksh
   2 # Testing All the operation in CSQl ((After Each Operation Kill the server and Restart the server again for Another Operation)
   3 # set DURABILITY to true in csql.conf
   4 # Start csqlserver. Then create a table in CSQL Client.Insert 5 Records.
   5 # kill the currently running Server.
   6 # Again Restart the Server by setting DURABILITY=true and Open CSQL Client.
   7 # Continue The same For All Operations in CSQL.
   8 # All should work Fine
   9 #
  10
  11 CSQL_CONF=${PWD}/durability/recovery/csql.conf
  12 REL_PATH=.
  13 if [ -s "$CSQL_CONF" ]
  14 then
  15     REL_PATH=${PWD}/durability/recovery
  16 fi
  17
  18 rm -f /tmp/csql.conf
  19 rm -f /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 echo "Durablity = TRUE"
  28 echo "Server Started"
  29 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  30 pid=$!
  31 sleep 2
  32 echo "CREATING TABLE"
  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_t1.sql 2> $0.valgr
  37 else
  38     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/create_t1.sql
  39     if [ $? -ne 0 ]
  40     then
  41        kill -9 $pid
  42        ipcrm -M 4444 -M 6666
  43      exit 1;
  44     fi
  45 fi
  46
  47 if [ "$VALGRIND" = "true" ]
  48 then
  49     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csqldump >before.sql 2>> $0.valgr
  50 else
  51     $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
  52 fi
  53
  54 kill -9 $pid
  55 ipcrm -M 4444 -M 6666
  56 echo "Server Killed"
  57
  58 echo ""
  59 echo "Durablity = TRUE"
  60 echo "Checking Durability"
  61 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  62 pid=$!
  63 echo "Server Started"
  64 sleep 2
  65
  66 if [ "$VALGRIND" = "true" ]
  67 then
  68     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csqldump 2>> $0.valgr
  69 else
  70     $CSQL_INSTALL_ROOT/bin/csqldump >after.sql
  71 fi
  72
  73 diff before.sql after.sql >>/dev/null 2>&1
  74 if [ $? -eq 0 ]
  75      then
  76        echo Durability Works Fine
  77 fi
  78
  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}/insert_t1.sql 2>> $0.valgr
  84 else
  85     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/insert_t1.sql
  86     if [ $? -ne 0 ]
  87      then
  88        $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_t1.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 ""
 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 "UPDATING RECORDS IN TABLE"
 128
 129 if [ "$VALGRIND" = "true" ]
 130 then
 131     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/update_t1.sql 2>> $0.valgr
 132 else
 133     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/update_t1.sql
 134     if [ $? -ne 0 ]
 135      then
 136        $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_t1.sql
 137        kill -9 $pid
 138        ipcrm -M 4444 -M 6666
 139      exit 5;
 140     fi
 141 fi
 142
 143 if [ "$VALGRIND" = "true" ]
 144 then
 145     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csqldump 2>> $0.valgr
 146 else
 147     $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
 148 fi
 149
 150 kill -9 $pid
 151 ipcrm -M 4444 -M 6666
 152 echo "Server Killed"
 153
 154 echo ""
 155 echo "Durablity = TRUE"
 156 echo "Checking Durability"
 157 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
 158 pid=$!
 159 echo "Server Started"
 160 sleep 2
 161
 162 if [ "$VALGRIND" = "true" ]
 163 then
 164     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csqldump 2>> $0.valgr
 165 else
 166     $CSQL_INSTALL_ROOT/bin/csqldump >after.sql
 167 fi
 168
 169 diff before.sql after.sql >>/dev/null 2>&1
 170 if [ $? -eq 0 ]
 171      then
 172        echo Durability Works Fine
 173 fi
 174
 175 echo "DELETING RECORDS FROM TABLE"
 176 if [ "$VALGRIND" = "true" ]
 177 then
 178     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/delete_t1.sql 2>> $0.valgr
 179 else
 180     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/delete_t1.sql
 181     if [ $? -ne 0 ]
 182      then
 183        $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_t1.sql
 184        kill -9 $pid
 185        ipcrm -M 4444 -M 6666
 186      exit 7;
 187     fi
 188 fi
 189
 190 if [ "$VALGRIND" = "true" ]
 191 then
 192     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csqldump 2>> $0.valgr
 193 else
 194     $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
 195 fi
 196
 197 kill -9 $pid
 198 ipcrm -M 4444 -M 6666
 199 echo "Server Killed"
 200
 201 echo ""
 202 echo "Durablity = TRUE"
 203 echo "Checking Durability"
 204 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
 205 pid=$!
 206 echo "Server Started"
 207 sleep 2
 208
 209 if [ "$VALGRIND" = "true" ]
 210 then
 211     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csqldump 2>> $0.valgr
 212 else
 213     $CSQL_INSTALL_ROOT/bin/csqldump >after.sql
 214 fi
 215
 216 diff before.sql after.sql >>/dev/null 2>&1
 217 if [ $? -eq 0 ]
 218      then
 219        echo Durability Works Fine
 220 fi
 221
 222 echo "DROPPING TABLE"
 223 if [ "$VALGRIND" = "true" ]
 224 then
 225     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_t1.sql 2>> $0.valgr
 226 else
 227     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_t1.sql
 228     if [ $? -ne 0 ]
 229      then
 230        kill -9 $pid
 231        ipcrm -M 4444 -M 6666
 232      exit 9;
 233     fi
 234 fi
 235
 236 rm -f before.sql after.sql
 237 kill -9 $pid
 238 ipcrm -M 4444 -M 6666
 239 exit 0;