test/durability/redologs/test004a.ksh

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