test/durability/recovery/testMMAP012.ksh

   1 #!/bin/ksh
   2 # Testing Durability in MMAP architecture
   3 # Composite Primary Key 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 MMAP=true in csql.conf
   6 # Start csqlserver. Then create a table (Composite Primary Key on 3 fields) 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 "DURABILITY=true" >>/tmp/csql.conf
  26 echo "MMAP=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 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/create_pri_10.sql
  36 if [ $? -ne 0 ]
  37  then
  38    kill -9 $pid
  39    ipcrm -M 4444
  40  exit 1;
  41 fi
  42
  43 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/show_t1.sql
  44 if [ $? -ne 0 ]
  45  then
  46    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql
  47    kill -9 $pid
  48    ipcrm -M 4444
  49  exit 2;
  50 fi
  51
  52 kill -9 $pid
  53 ipcrm -M 4444
  54 echo "Server Killed"
  55
  56 echo "Durablity = TRUE"
  57 echo "Checking Durability"
  58 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  59 pid=$!
  60 echo "Server Started"
  61 sleep 2
  62 echo "INSERTING INTO TABLE"
  63 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/insert_10.sql
  64 if [ $? -ne 0 ]
  65  then
  66    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql
  67    kill -9 $pid
  68    ipcrm -M 4444
  69  exit 3;
  70 fi
  71
  72 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/select_10.sql
  73 if [ $? -ne 0 ]
  74  then
  75    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql
  76    kill -9 $pid
  77    ipcrm -M 4444
  78  exit 4;
  79 fi
  80
  81 kill -9 $pid
  82 ipcrm -M 4444
  83 echo "Server Killed"
  84
  85 echo "Durablity = TRUE"
  86 echo "Checking Durability"
  87 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  88 pid=$!
  89 echo "Server Started"
  90 sleep 2
  91 echo "UPDATING RECORDS IN TABLE"
  92 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/update_10.sql
  93 if [ $? -ne 0 ]
  94  then
  95    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql
  96    kill -9 $pid
  97    ipcrm -M 4444
  98  exit 5;
  99 fi
 100
 101 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/select_10.sql
 102 if [ $? -ne 0 ]
 103  then
 104    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql
 105    kill -9 $pid
 106    ipcrm -M 4444
 107  exit 6;
 108 fi
 109
 110 kill -9 $pid
 111 ipcrm -M 4444
 112 echo "Server Killed"
 113 echo "Durablity = TRUE"
 114 echo "Checking Durability"
 115 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
 116 pid=$!
 117 echo "Server Started"
 118 sleep 2
 119 echo "DELETING RECORDS FROM TABLE"
 120 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/delete_10.sql
 121 if [ $? -ne 0 ]
 122  then
 123    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql
 124    kill -9 $pid
 125    ipcrm -M 4444
 126  exit 7;
 127 fi
 128
 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
 135  exit 8;
 136 fi
 137
 138 kill -9 $pid
 139 ipcrm -M 4444
 140 echo "Server Killed"
 141
 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 "DROPPING TABLE"
 149 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_10.sql
 150 if [ $? -ne 0 ]
 151  then
 152    kill -9 $pid
 153    ipcrm -M 4444
 154  exit 9;
 155 fi
 156
 157 kill -9 $pid
 158 ipcrm -M 4444
 159 exit 0;