test/durability/redologs/test001.ksh

   1 #!/bin/ksh
   2 #check stmtid start from last stmtid after recover
   3 #
   4 CSQL_CONF=${PWD}/durability/redologs/csql.conf
   5 REL_PATH=.
   6 if [ -s "$CSQL_CONF" ]
   7 then
   8     REL_PATH=${PWD}/durability/redologs
   9 fi
  10
  11 rm -f /tmp/csql.conf
  12 rm -rf /tmp/csql/db/*
  13 mkdir -p /tmp/csql/db
  14 cp -f $REL_PATH/csql.conf /tmp
  15 echo SYS_DB_KEY=4444 >>/tmp/csql.conf
  16 echo ID_SHM_KEY=6666 >>/tmp/csql.conf
  17 echo DURABILITY=true >>/tmp/csql.conf
  18 export CSQL_CONFIG_FILE=/tmp/csql.conf
  19
  20 echo "Server Started"
  21 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  22 pid=$!
  23 sleep 2
  24
  25 echo "CREATE TABLE laks(f1 int);" >${REL_PATH}/t1.sql
  26 echo "INSERT INTO laks values (10);" >>${REL_PATH}/t1.sql
  27 echo "INSERT INTO laks values (20);" >>${REL_PATH}/t1.sql
  28 echo "INSERT INTO laks values (30);" >>${REL_PATH}/t1.sql
  29
  30 if [ "$VALGRIND" = "true" ]
  31 then
  32     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/t1.sql 2> $0.valgr
  33 else
  34    $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/t1.sql
  35    if [ $? -ne 0 ]
  36     then
  37       kill -9 $pid
  38       ipcrm -M 4444 -M 6666
  39       rm -f ${REL_PATH}/t1.sql
  40     exit 1;
  41    fi
  42 fi
  43 $CSQL_INSTALL_ROOT/bin/redo -al
  44
  45 kill -9 $pid
  46 ipcrm -M 4444 -M 6666
  47 echo "Server Killed"
  48 echo ""
  49 echo "Checking Durability"
  50 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  51 pid=$!
  52 echo "Server Started"
  53 sleep 2
  54
  55 echo "INSERT INTO laks values (50);" >${REL_PATH}/t1.sql
  56 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/t1.sql
  57 $CSQL_INSTALL_ROOT/bin/redo -al
  58
  59 rm -f ${REL_PATH}/t1.sql
  60 kill -9 $pid
  61 ipcrm -M 4444 -M 6666
  62 exit 0;