test/tools/csql/test099.ksh

   1 #!/bin/ksh
   2 # Test Case
   3 # Testing on large size allocate
   4 #
   5 QUITFILE=${PWD}/tools/csql/quit.sql
   6 REL_PATH=.
   7 if [ -s "$QUITFILE" ]
   8 then
   9     REL_PATH=${PWD}/tools/csql
  10 fi
  11
  12 rm -f /tmp/csql.conf
  13 #rm -f /tmp/csql/db/*
  14 #mkdir -p /tmp/csql/db
  15 cp -f $REL_PATH/csql.conf /tmp
  16 echo SYS_DB_KEY=4444 >>/tmp/csql.conf
  17 echo USER_DB_KEY=6666 >>/tmp/csql.conf
  18 export CSQL_CONFIG_FILE=/tmp/csql.conf
  19 $CSQL_INSTALL_ROOT/bin/csqlserver >/dev/null 2>&1 &
  20 pid=$!
  21 sleep 2
  22
  23 if [ "$VALGRIND" = "true" ]
  24 then
  25     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/largetable.sql 2> $0.valgr
  26 else
  27     $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/largetable.sql
  28     if [ $? -ne 0 ]
  29     then
  30        $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drt1.sql
  31        kill -9 $pid
  32        ipcrm -M 4444 -M 6666
  33        exit 1;
  34     fi
  35 fi
  36
  37 if [ "$VALGRIND" = "true" ]
  38 then
  39     valgrind --tool=memcheck --leak-check=full $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -D chunk 2>> $0.valgr
  40 else
  41     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -D chunk
  42     if [ $? -ne 0 ]
  43     then
  44        $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drt1.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/catalog -u root -p manager -d 2>> $0.valgr
  54 else
  55     $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -d
  56     if [ $? -ne 0 ]
  57     then
  58        $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drt1.sql
  59        kill -9 $pid
  60        ipcrm -M 4444 -M 6666
  61        exit 3;
  62     fi
  63 fi
  64
  65 $CSQL_INSTALL_ROOT/bin/csql -u root -p manager -s ${REL_PATH}/drt1.sql
  66 if [ $? -ne 0 ]
  67 then
  68    exit 4;
  69 fi
  70
  71 kill -9 $pid
  72 ipcrm -M 4444 -M 6666
  73 exit 0;