test/tools/csql/test131.ksh

   1 #!/bin/ksh
   2 # Testing tree undolog
   3 #
   4 QUITFILE=${PWD}/tools/csql/quit.sql
   5 REL_PATH=.
   6 if [ -s "$QUITFILE" ]
   7 then
   8     REL_PATH=`pwd`/tools/csql
   9 fi
  10
  11 rm -f /tmp/csql.conf
  12 cp -f $REL_PATH/csql.conf /tmp
  13 echo SYS_DB_KEY=4444 >>/tmp/csql.conf
  14 echo USER_DB_KEY=6666 >>/tmp/csql.conf
  15 export CSQL_CONFIG_FILE=/tmp/csql.conf
  16 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  17 pid=$!
  18 sleep 2
  19
  20 echo "drop table t1;" > ${REL_PATH}/dropp_t1.sql
  21 if [ "$VALGRIND" = "true" ]
  22 then
  23     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/treeundolog1.sql 2> $0.valgr
  24 else
  25     $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/treeundolog1.sql
  26     if [ $? -ne 0 ]
  27     then
  28        $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropp_t1.sql
  29        rm -f ${REL_PATH}/dropp_t1.sql
  30        kill -9 $pid
  31        ipcrm -M 4444 -M 6666
  32        exit 1;
  33     fi
  34 fi
  35
  36 if [ "$VALGRIND" = "true" ]
  37 then
  38     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -D chunk 2>> $0.valgr
  39 else
  40     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -D chunk
  41     if [ $? -ne 0 ]
  42     then
  43        $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropp_t1.sql
  44        rm -f ${REL_PATH}/dropp_t1.sql
  45        kill -9 $pid
  46        ipcrm -M 4444 -M 6666
  47        exit 2;
  48     fi
  49 fi
  50
  51 if [ "$VALGRIND" = "true" ]
  52 then
  53     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/treeundolog2.sql 2>> $0.valgr
  54 else
  55     $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/treeundolog2.sql
  56     if [ $? -ne 0 ]
  57     then
  58        $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropp_t1.sql
  59        rm -f ${REL_PATH}/dropp_t1.sql
  60        kill -9 $pid
  61        ipcrm -M 4444 -M 6666
  62        exit 3;
  63     fi
  64 fi
  65
  66 if [ "$VALGRIND" = "true" ]
  67 then
  68     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -D chunk 2>> $0.valgr
  69 else
  70     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -D chunk
  71     if [ $? -ne 0 ]
  72     then
  73        $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropp_t1.sql
  74        rm -f ${REL_PATH}/dropp_t1.sql
  75        kill -9 $pid
  76        ipcrm -M 4444 -M 6666
  77        exit 4;
  78     fi
  79 fi
  80
  81 $CSQL_INSTALL_ROOT/bin/csql -s ${REL_PATH}/dropp_t1.sql
  82 if [ $? -ne 0 ]
  83 then
  84    rm -f ${REL_PATH}/dropp_t1.sql
  85    exit 5;
  86 fi
  87 rm -f ${REL_PATH}/dropp_t1.sql
  88 kill -9 $pid
  89 ipcrm -M 4444 -M 6666
  90 exit 0;