test/durability/recovery/test012.ksh

   1 #!/bin/ksh
   2 # Composite Primary Key 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 (Composite Primary Key on 3 fields) in CSQL Client.Insert 5 Records.
   6 # kill the currently running Server.
   7 # Again Restart the Server by setting DURABILITY=true and Open CSQL Client.
   8 # Continue The same For All Operations in CSQL.
   9 # All should work Fine
  10 #
  11
  12 CSQL_CONF=${PWD}/durability/recovery/csql.conf
  13 REL_PATH=.
  14 if [ -s "$CSQL_CONF" ]
  15 then
  16     REL_PATH=${PWD}/durability/recovery
  17 fi
  18
  19 rm -f /tmp/csql.conf
  20 rm -f /tmp/csql/db/*
  21 mkdir -p /tmp/csql/db
  22 cp -f $REL_PATH/csql.conf /tmp
  23 echo SYS_DB_KEY=4444 >>/tmp/csql.conf
  24 echo USER_DB_KEY=6666 >>/tmp/csql.conf
  25 echo "DURABILITY=true" >>/tmp/csql.conf
  26 export CSQL_CONFIG_FILE=/tmp/csql.conf
  27
  28 echo "Durablity = TRUE"
  29 echo "Server Started"
  30 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  31 pid=$!
  32 sleep 2
  33 echo "CREATING TABLE"
  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_pri_10.sql 2> $0.valgr
  37 else
  38    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/create_pri_10.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/csql -u root -p manager -s ${REL_PATH}/show_t1.sql 2>> $0.valgr
  50 else
  51    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/show_t1.sql
  52    if [ $? -ne 0 ]
  53     then
  54       $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql
  55       kill -9 $pid
  56       ipcrm -M 4444 -M 6666
  57     exit 2;
  58    fi
  59 fi
  60
  61 kill -9 $pid
  62 ipcrm -M 4444 -M 6666
  63 echo "Server Killed"
  64
  65 echo "Durablity = TRUE"
  66 echo "Checking Durability"
  67 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  68 pid=$!
  69 echo "Server Started"
  70 sleep 2
  71 echo "INSERTING INTO TABLE"
  72 if [ "$VALGRIND" = "true" ]
  73 then
  74     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/insert_10.sql 2>> $0.valgr
  75 else
  76    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/insert_10.sql
  77    if [ $? -ne 0 ]
  78     then
  79       $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql
  80       kill -9 $pid
  81       ipcrm -M 4444 -M 6666
  82     exit 3;
  83    fi
  84 fi
  85
  86 if [ "$VALGRIND" = "true" ]
  87 then
  88     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/select_10.sql 2>> $0.valgr
  89 else
  90    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/select_10.sql
  91    if [ $? -ne 0 ]
  92     then
  93       $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql
  94       kill -9 $pid
  95       ipcrm -M 4444 -M 6666
  96     exit 4;
  97    fi
  98 fi
  99
 100 kill -9 $pid
 101 ipcrm -M 4444 -M 6666
 102 echo "Server Killed"
 103
 104 echo "Durablity = TRUE"
 105 echo "Checking Durability"
 106 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
 107 pid=$!
 108 echo "Server Started"
 109 sleep 2
 110 echo "UPDATING RECORDS IN TABLE"
 111 if [ "$VALGRIND" = "true" ]
 112 then
 113     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/update_10.sql 2>> $0.valgr
 114 else
 115    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/update_10.sql
 116    if [ $? -ne 0 ]
 117     then
 118       $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql
 119       kill -9 $pid
 120       ipcrm -M 4444 -M 6666
 121     exit 5;
 122    fi
 123 fi
 124
 125 if [ "$VALGRIND" = "true" ]
 126 then
 127     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/select_10.sql 2>> $0.valgr
 128 else
 129    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/select_10.sql
 130    if [ $? -ne 0 ]
 131     then
 132       $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql
 133       kill -9 $pid
 134       ipcrm -M 4444 -M 6666
 135     exit 6;
 136    fi
 137 fi
 138
 139 kill -9 $pid
 140 ipcrm -M 4444 -M 6666
 141 echo "Server Killed"
 142 echo "Durablity = TRUE"
 143 echo "Checking Durability"
 144 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
 145 pid=$!
 146 echo "Server Started"
 147 sleep 2
 148 echo "DELETING RECORDS FROM TABLE"
 149 if [ "$VALGRIND" = "true" ]
 150 then
 151     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/delete_10.sql 2>> $0.valgr
 152 else
 153    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/delete_10.sql
 154    if [ $? -ne 0 ]
 155     then
 156       $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql
 157       kill -9 $pid
 158       ipcrm -M 4444 -M 6666
 159     exit 7;
 160    fi
 161 fi
 162
 163 if [ "$VALGRIND" = "true" ]
 164 then
 165     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/select_10.sql 2>> $0.valgr
 166 else
 167    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/select_10.sql
 168    if [ $? -ne 0 ]
 169     then
 170       $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql
 171       kill -9 $pid
 172       ipcrm -M 4444 -M 6666
 173     exit 8;
 174    fi
 175 fi
 176
 177 kill -9 $pid
 178 ipcrm -M 4444 -M 6666
 179 echo "Server Killed"
 180
 181 echo "Durablity = TRUE"
 182 echo "Checking Durability"
 183 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
 184 pid=$!
 185 echo "Server Started"
 186 sleep 2
 187 echo "DROPPING TABLE"
 188 if [ "$VALGRIND" = "true" ]
 189 then
 190     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql 2>> $0.valgr
 191 else
 192    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql
 193    if [ $? -ne 0 ]
 194     then
 195       kill -9 $pid
 196       ipcrm -M 4444 -M 6666
 197     exit 9;
 198    fi
 199 fi
 200
 201 kill -9 $pid
 202 ipcrm -M 4444 -M 6666
 203 exit 0;