test/cache/FailOver/test004a.ksh

   1 #!/bin/sh
   2
   3 #  4a) After connect, csql goes down, then all select operations should go to MySQL directly for cached tables and MySQL tables.
   4
   5 #Run this test only under csql/test or on this directory.
   6 #Otherwise, it may fail
   7
   8 CSQL_CONF=${PWD}/cache/FailOver/csql.conf
   9 input=${PWD}/cache/FailOver/csqlinputt3.sql
  10 REL_PATH=.
  11 if [ -s "$input" -a -s "$CSQL_CONF" ]
  12 then
  13     REL_PATH=${PWD}/cache/FailOver
  14 fi
  15 export CSQL_CONFIG_FILE=$REL_PATH/csql.conf
  16
  17 isql $DSN < $REL_PATH/mysqlinputtest1.sql >/dev/null 2>&1
  18 echo "table t1(to be cached) inserted into target db"
  19 # edit /tmp/csql/csqltable.conf
  20 rm -f /tmp/csql/csqltable.conf /tmp/csql/csql.db
  21 touch /tmp/csql/csqltable.conf /tmp/csql/csql.db
  22 for (( a=1; a<2; a++ ))
  23 do
  24     echo "1:t$a"
  25 done >> /tmp/csql/csqltable.conf
  26
  27 $CSQL_INSTALL_ROOT/bin/csqlserver -c >/dev/null 2>&1 &
  28 pid=$!
  29 sleep 5
  30 echo "table t1 cached into csql"
  31
  32 isql $DSN < $REL_PATH/mysqlinputtest2.sql >/dev/null 2>&1
  33 echo "table t2(not cached) inserted into target db"
  34 $CSQL_INSTALL_ROOT/bin/csql -g -s $REL_PATH/csqlinputt3.sql >/dev/null 2>&1
  35 echo "table t3 inserted into csql db"
  36
  37 $REL_PATH/selectconncsqldown &
  38 bgproc=$!
  39 kill -9 $pid
  40 ipcrm -M 1199 -M 2277
  41 echo "csql server is down"
  42 wait $bgproc
  43 isql $DSN < $REL_PATH/dropall.sql >/dev/null 2>&1
  44 rm -f /tmp/csql/csqltable.conf /tmp/csql/csql.db
  45 touch /tmp/csql/csqltable.conf /tmp/csql/csql.db
  46 exit 0;