test/durability/recovery/testMMAP005.ksh

   1 #!/bin/ksh
   2 # Testing Durability in MMAP architecture
   3 # Testing All the operation in CSQl ((After Each Operation Kill the server and Restart the server again for Another Operation)
   4 # set DURABILITY=true and MMAP=true in csql.conf
   5 # Start csqlserver. Then create a table 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 "DURABILITY=true" >>/tmp/csql.conf
  25 echo "MMAP=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 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/create_t1.sql
  35 if [ $? -ne 0 ]
  36  then
  37    kill -9 $pid
  38    ipcrm -M 4444
  39  exit 1;
  40 fi
  41
  42 $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
  43
  44 kill -9 $pid
  45 ipcrm -M 4444
  46 echo "Server Killed"
  47
  48 echo ""
  49 echo "Durablity = TRUE"
  50 echo "Checking Durability"
  51 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  52 pid=$!
  53 echo "Server Started"
  54 sleep 2
  55 $CSQL_INSTALL_ROOT/bin/csqldump >after.sql
  56 diff before.sql after.sql >>/dev/null 2>&1
  57 if [ $? -eq 0 ]
  58      then
  59        echo Durability Works Fine
  60 fi
  61
  62 echo "INSERTING INTO TABLE"
  63 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/insert_t1.sql
  64 if [ $? -ne 0 ]
  65  then
  66    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_t1.sql
  67    kill -9 $pid
  68    ipcrm -M 4444
  69  exit 3;
  70 fi
  71
  72 $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
  73 kill -9 $pid
  74 ipcrm -M 4444
  75 echo "Server Killed"
  76
  77 echo ""
  78 echo "Durablity = TRUE"
  79 echo "Checking Durability"
  80 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  81 pid=$!
  82 echo "Server Started"
  83 sleep 2
  84
  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 "UPDATING RECORDS IN TABLE"
  93 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/update_t1.sql
  94 if [ $? -ne 0 ]
  95  then
  96    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_t1.sql
  97    kill -9 $pid
  98    ipcrm -M 4444
  99  exit 5;
 100 fi
 101
 102 $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
 103
 104 kill -9 $pid
 105 ipcrm -M 4444
 106 echo "Server Killed"
 107
 108 echo ""
 109 echo "Durablity = TRUE"
 110 echo "Checking Durability"
 111 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
 112 pid=$!
 113 echo "Server Started"
 114 sleep 2
 115
 116 $CSQL_INSTALL_ROOT/bin/csqldump >after.sql
 117 diff before.sql after.sql >>/dev/null 2>&1
 118 if [ $? -eq 0 ]
 119      then
 120        echo Durability Works Fine
 121 fi
 122
 123 echo "DELETING RECORDS FROM TABLE"
 124 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/delete_t1.sql
 125 if [ $? -ne 0 ]
 126  then
 127    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_t1.sql
 128    kill -9 $pid
 129    ipcrm -M 4444
 130  exit 7;
 131 fi
 132
 133 $CSQL_INSTALL_ROOT/bin/csqldump >before.sql
 134 kill -9 $pid
 135 ipcrm -M 4444
 136 echo "Server Killed"
 137
 138 echo ""
 139 echo "Durablity = TRUE"
 140 echo "Checking Durability"
 141 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
 142 pid=$!
 143 echo "Server Started"
 144 sleep 2
 145
 146 $CSQL_INSTALL_ROOT/bin/csqldump >after.sql
 147 diff before.sql after.sql >>/dev/null 2>&1
 148 if [ $? -eq 0 ]
 149      then
 150        echo Durability Works Fine
 151 fi
 152
 153 echo "DROPPING TABLE"
 154 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drop_t1.sql
 155 if [ $? -ne 0 ]
 156  then
 157    kill -9 $pid
 158    ipcrm -M 4444
 159  exit 9;
 160 fi
 161
 162 rm -f before.sql after.sql
 163 kill -9 $pid
 164 ipcrm -M 4444
 165 exit 0;