test/durability/recovery/testMMAP010.ksh

   1 #!/bin/ksh
   2 # Testing Durability in MMAP architecture
   3 # Unique Index test
   4 # Testing All the operation in CSQl ((After Each Operation Kill the server and Restart the server again for Another Operation)
   5 # set DURABILITY=true and MMAP=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}/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 -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 echo "MMAP=true" >>/tmp/csql.conf
  28 export CSQL_CONFIG_FILE=/tmp/csql.conf
  29
  30 echo "Durablity = TRUE"
  31 echo "Server Started"
  32 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  33 pid=$!
  34 sleep 2
  35 echo "CREATING TABLE"
  36 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/create_10.sql >/dev/null 2>&1
  37 if [ $? -ne 0 ]
  38  then
  39    kill -9 $pid
  40    ipcrm -M 4444
  41  exit 1;
  42 fi
  43
  44 $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
  45 kill -9 $pid
  46 ipcrm -M 4444
  47 echo "Server Killed"
  48
  49 echo count=1
  50 echo "Durablity = TRUE"
  51 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  52 pid=$!
  53 echo "Checking Durability"
  54 echo "Server Started"
  55 sleep 2
  56 $CSQL_INSTALL_ROOT/bin/csqldump >after.sql
  57 diff before.sql after.sql >/dev/null 2>&1
  58 if [ $? -eq 0 ]
  59     then
  60         echo Durability Works Fine
  61 fi
  62
  63 echo "INSERTING INTO TABLE"
  64 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/index_10.sql >/dev/null 2>&1
  65 if [ $? -ne 0 ]
  66  then
  67    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql
  68    kill -9 $pid
  69    ipcrm -M 4444
  70  exit 3;
  71 fi
  72
  73 $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
  74 kill -9 $pid
  75 ipcrm -M 4444
  76 echo "Server Killed"
  77
  78 echo count=2
  79 echo "Durablity = TRUE"
  80 echo "Checking Durability"
  81 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  82 pid=$!
  83 echo "Server Started"
  84 sleep 2
  85 $CSQL_INSTALL_ROOT/bin/csqldump >after.sql
  86 diff before.sql after.sql >/dev/null 2>&1
  87 if [ $? -eq 0 ]
  88     then
  89         echo Durability Works Fine
  90 fi
  91
  92 echo "INSERTING INTO TABLE"
  93 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/insert_10.sql >/dev/null 2>&1
  94 if [ $? -ne 0 ]
  95  then
  96    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql
  97    kill -9 $pid
  98    ipcrm -M 4444
  99  exit 3;
 100 fi
 101
 102 $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
 103 kill -9 $pid
 104 ipcrm -M 4444
 105 echo "Server Killed"
 106
 107 echo count=3
 108 echo "Durablity = TRUE"
 109 echo "Checking Durability"
 110 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
 111 pid=$!
 112 echo "Server Started"
 113 sleep 2
 114 $CSQL_INSTALL_ROOT/bin/csqldump >after.sql
 115 diff before.sql after.sql >/dev/null 2>&1
 116 if [ $? -eq 0 ]
 117     then
 118         echo Durability Works Fine
 119 fi
 120
 121 echo "UPDATING RECORDS IN TABLE"
 122 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/update_10.sql >/dev/null 2>&1
 123 if [ $? -ne 0 ]
 124  then
 125    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql
 126    kill -9 $pid
 127    ipcrm -M 4444
 128  exit 5;
 129 fi
 130
 131 $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
 132 kill -9 $pid
 133 ipcrm -M 4444
 134 echo "Server Killed"
 135
 136 echo count=4
 137 echo "Durablity = TRUE"
 138 echo "Checking Durability"
 139 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
 140 pid=$!
 141 echo "Server Started"
 142 sleep 2
 143 $CSQL_INSTALL_ROOT/bin/csqldump >after.sql
 144 diff before.sql after.sql >/dev/null 2>&1
 145 if [ $? -eq 0 ]
 146     then
 147         echo Durability Works Fine
 148 fi
 149
 150 echo "DELETING RECORDS FROM TABLE"
 151 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/delete_10.sql >/dev/null 2>&1
 152 if [ $? -ne 0 ]
 153  then
 154    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql
 155    kill -9 $pid
 156    ipcrm -M 4444
 157  exit 7;
 158 fi
 159
 160 $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
 161 kill -9 $pid
 162 ipcrm -M 4444
 163 echo "Server Killed"
 164
 165 echo count=5
 166 echo "Durablity = TRUE"
 167 echo "Checking Durability"
 168 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
 169 pid=$!
 170 echo "Server Started"
 171 sleep 2
 172 $CSQL_INSTALL_ROOT/bin/csqldump >after.sql
 173 diff before.sql after.sql >/dev/null 2>&1
 174 if [ $? -eq 0 ]
 175     then
 176         echo Durability Works Fine
 177 fi
 178
 179 echo "DROPPING TABLE"
 180 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql
 181 if [ $? -ne 0 ]
 182  then
 183    kill -9 $pid
 184    ipcrm -M 4444
 185  exit 9;
 186 fi
 187
 188 rm -f before.sql after.sql
 189 kill -9 $pid
 190 ipcrm -M 4444
 191 exit 0;