test/system/proc/test001.ksh

   1 #!/bin/sh
   2 # TestCase:
   3 # check proc slots used and free in proctable
   4 # for i = 1 to 120
   5 #    catalog
   6 # end for
   7 # check proc slots used and free in proctable
   8 # check if any proc slot holds mutexes
   9 # Note: catalog tool with no option specified connects and disconnects
  10
  11 echo "Case 1: -d option with no connections"
  12 $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -D proc |grep Slots
  13 if [ $? -ne 0 ]
  14 then
  15    exit 1;
  16 fi
  17
  18
  19 count=120
  20 while [ ${count} -gt 0 ]
  21 do
  22   count=`expr ${count} - 1`
  23   $CSQL_INSTALL_ROOT/bin/catalog >/dev/null
  24   if [ $? -ne 0 ]
  25   then
  26     echo "create table failed"
  27     exit 100;
  28   fi
  29 done
  30 echo "Case 2: -d option after 120 connect/disconnect"
  31 $CSQL_INSTALL_ROOT/bin/catalog -u root -p manager -D proc |grep Slots
  32 if [ $? -ne 0 ]
  33 then
  34    exit 1;
  35 fi
  36 exit 0