mysql-test-run.sh 38.2 KB
Newer Older
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1
#! /bin/sh
2 3
# mysql-test-run - originally written by Matt Wagner <matt@mysql.com>
# modified by Sasha Pachev <sasha@mysql.com>
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
4
# Sligtly updated by Monty
5
# Cleaned up again by Matt
6 7
# Fixed by Sergei
# :-)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
8 9 10 11 12

#++
# Access Definitions
#--
DB=test
13
DBPASSWD=
14
VERBOSE=""
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
15
USE_MANAGER=0
16 17
MY_TZ=GMT-3
TZ=$MY_TZ; export TZ # for UNIX_TIMESTAMP tests to work
18
LOCAL_SOCKET=@MYSQL_UNIX_ADDR@
bk@work.mysql.com's avatar
bk@work.mysql.com committed
19

20 21 22
# For query_cache test
ulimit -n 1024

23 24 25 26
#++
# Program Definitions
#--

27 28
LC_COLLATE=C
export LC_COLLATE
29
PATH=/bin:/usr/bin:/usr/local/bin:/usr/bsd:/usr/X11R6/bin:/usr/openwin/bin:/usr/bin/X11:$PATH
30
MASTER_40_ARGS="--rpl-recovery-rank=1 --init-rpl-role=master"
31

32 33 34 35
# Standard functions

which ()
{
36
  IFS="${IFS=   }"; save_ifs="$IFS"; IFS=':'
37 38
  for file
  do
39
    for dir in $PATH
40
    do
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
41
      if test -f $dir/$file
42 43 44 45 46
      then
        echo "$dir/$file"
        continue 2
      fi
    done
47
    echo "Fatal error: Cannot find program $file in $PATH" 1>&2
48 49
    exit 1
  done
50
  IFS="$save_ifs"
51
  exit 0
52 53 54
}


monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
55 56
sleep_until_file_deleted ()
{
57 58
  pid=$1;
  file=$2
59
  loop=$SLEEP_TIME_FOR_DELETE
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
60 61
  while (test $loop -gt 0)
  do
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
62
    if [ ! -r $file ]
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
63
    then
64 65 66 67
      if test $pid != "0"
      then
        wait_for_pid $pid
      fi
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
68 69
      return
    fi
70
    sleep 1
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
71 72 73 74
    loop=`expr $loop - 1`
  done
}

75
sleep_until_file_created ()
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
76 77
{
  file=$1
78 79
  loop=$2
  org_time=$2
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
80 81
  while (test $loop -gt 0)
  do
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
82
    if [ -r $file ]
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
83
    then
84
      return 0
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
85
    fi
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
86
    sleep 1
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
87 88
    loop=`expr $loop - 1`
  done
89
  echo "ERROR: $file was not created in $org_time seconds;  Aborting"
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
90 91 92
  exit 1;
}

93 94 95 96 97
# For the future

wait_for_pid()
{
  pid=$1
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
98
  #$WAIT_PID pid $SLEEP_TIME_FOR_DELETE
99 100
}

101 102
# No paths below as we can't be sure where the program is!

103 104
SED=sed

105 106
BASENAME=`which basename`
if test $? != 0; then exit 1; fi
107
DIFF=`which diff | $SED q`
108
if test $? != 0; then exit 1; fi
109 110
CAT=cat
CUT=cut
monty@bitch.mysql.fi's avatar
monty@bitch.mysql.fi committed
111
HEAD=head
112 113 114 115
TAIL=tail
ECHO=echo # use internal echo if possible
EXPR=expr # use internal if possible
FIND=find
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
116
GREP=grep
117
if test $? != 0; then exit 1; fi
118 119
PRINTF=printf
RM=rm
120
if test $? != 0; then exit 1; fi
121
TR=tr
122 123
XARGS=`which xargs`
if test $? != 0; then exit 1; fi
124
SORT=sort
125 126 127 128 129

# Are we using a source or a binary distribution?

testdir=@testdir@
if [ -d bin/mysqld ] && [ -d mysql-test ] ; then
130 131
 cd mysql-test
else
132 133
 if [ -d $testdir/mysql-test ] ; then
   cd $testdir
134
 fi
135 136 137 138 139 140 141
fi

if [ ! -f ./mysql-test-run ] ; then
  $ECHO "Can't find the location for the mysql-test-run script"

  $ECHO "Go to to the mysql-test directory and execute the script as follows:"
  $ECHO "./mysql-test-run."
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
142
  exit 1
143
fi
144

bk@work.mysql.com's avatar
bk@work.mysql.com committed
145 146 147
#++
# Misc. Definitions
#--
148

149 150 151 152 153
if [ -d ../sql ] ; then
   SOURCE_DIST=1
else
   BINARY_DIST=1
fi
154

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
155
#BASEDIR is always one above mysql-test directory
bk@work.mysql.com's avatar
bk@work.mysql.com committed
156 157 158 159
CWD=`pwd`
cd ..
BASEDIR=`pwd`
cd $CWD
160
MYSQL_TEST_DIR=$BASEDIR/mysql-test
161
export MYSQL_TEST_DIR
162
STD_DATA=$MYSQL_TEST_DIR/std_data
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
163
hostname=`hostname`		# Installed in the mysql privilege table
164

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
165
MANAGER_QUIET_OPT="-q"
166
TESTDIR="$MYSQL_TEST_DIR/t"
167
TESTSUFFIX=test
168
TOT_SKIP=0
bk@work.mysql.com's avatar
bk@work.mysql.com committed
169 170 171
TOT_PASS=0
TOT_FAIL=0
TOT_TEST=0
172 173 174
USERT=0
SYST=0
REALT=0
175
FAST_START=""
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
176
MYSQL_TMP_DIR=$MYSQL_TEST_DIR/var/tmp
sasha@mysql.sashanet.com's avatar
sasha@mysql.sashanet.com committed
177
SLAVE_LOAD_TMPDIR=../../var/tmp #needs to be same length to test logging
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
178
RES_SPACE="      "
179 180
MYSQLD_SRC_DIRS="strings mysys include extra regex isam merge myisam \
 myisammrg heap sql"
181
MY_LOG_DIR="$MYSQL_TEST_DIR/var/log" 
182 183 184
#
# Set LD_LIBRARY_PATH if we are using shared libraries
#
monty@bitch.mysql.fi's avatar
monty@bitch.mysql.fi committed
185
LD_LIBRARY_PATH="$BASEDIR/lib:$BASEDIR/libmysql/.libs:$LD_LIBRARY_PATH"
186
export LD_LIBRARY_PATH
187

sasha@mysql.sashanet.com's avatar
fixed  
sasha@mysql.sashanet.com committed
188
MASTER_RUNNING=0
189
MASTER_MYPORT=9306
sasha@mysql.sashanet.com's avatar
fixed  
sasha@mysql.sashanet.com committed
190
SLAVE_RUNNING=0
191
SLAVE_MYPORT=9307
sasha@mysql.sashanet.com's avatar
sasha@mysql.sashanet.com committed
192 193 194 195
MYSQL_MANAGER_PORT=9305 # needs to be out of the way of slaves
MYSQL_MANAGER_PW_FILE=$MYSQL_TEST_DIR/var/tmp/manager.pwd
MYSQL_MANAGER_LOG=$MYSQL_TEST_DIR/var/log/manager.log
MYSQL_MANAGER_USER=root
196
NO_SLAVE=0
197
USER_TEST=
198

199
EXTRA_MASTER_OPT=""
200
EXTRA_MYSQL_TEST_OPT=""
201
USE_RUNNING_SERVER=""
202 203
DO_GCOV=""
DO_GDB=""
204
MANUAL_GDB=""
205
DO_DDD=""
206
DO_CLIENT_GDB=""
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
207
SLEEP_TIME_AFTER_RESTART=1
208
SLEEP_TIME_FOR_DELETE=10
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
209
SLEEP_TIME_FOR_FIRST_MASTER=400		# Enough time to create innodb tables
210
SLEEP_TIME_FOR_SECOND_MASTER=30
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
211
SLEEP_TIME_FOR_FIRST_SLAVE=400
212
SLEEP_TIME_FOR_SECOND_SLAVE=30
213
CHARACTER_SET=latin1
214
DBUSER=""
215 216
START_WAIT_TIMEOUT=10
STOP_WAIT_TIMEOUT=10
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
217
MYSQL_TEST_SSL_OPTS=""
218 219 220

while test $# -gt 0; do
  case "$1" in
221 222
    --user=*) DBUSER=`$ECHO "$1" | $SED -e "s;--user=;;"` ;;
    --force)  FORCE=1 ;;
223
    --verbose-manager)  MANAGER_QUIET_OPT="" ;;
224 225 226 227 228
    --old-master) MASTER_40_ARGS="";;
    --master-binary=*)
      MASTER_MYSQLD=`$ECHO "$1" | $SED -e "s;--master-binary=;;"` ;;
    --slave-binary=*)
      SLAVE_MYSQLD=`$ECHO "$1" | $SED -e "s;--slave-binary=;;"` ;;
229
    --local)   USE_RUNNING_SERVER="" ;;
230
    --extern)  USE_RUNNING_SERVER="1" ;;
231
    --tmpdir=*) MYSQL_TMP_DIR=`$ECHO "$1" | $SED -e "s;--tmpdir=;;"` ;;
232 233 234 235 236
    --local-master)
      MASTER_MYPORT=3306;
      EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT --host=127.0.0.1 \
      --port=$MYSQL_MYPORT"
      LOCAL_MASTER=1 ;;
237 238
    --master_port=*) MASTER_MYPORT=`$ECHO "$1" | $SED -e "s;--master_port=;;"` ;;
    --slave_port=*) SLAVE_MYPORT=`$ECHO "$1" | $SED -e "s;--slave_port=;;"` ;;
239
    --manager-port=*) MYSQL_MANAGER_PORT=`$ECHO "$1" | $SED -e "s;--manager_port=;;"` ;;
240 241
    --with-openssl)
     EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT \
tonu@x153.internalnet's avatar
tonu@x153.internalnet committed
242 243 244
     --ssl-ca=$BASEDIR/SSL/cacert.pem \
     --ssl-cert=$BASEDIR/SSL/server-cert.pem \
     --ssl-key=$BASEDIR/SSL/server-key.pem"
245
     EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT \
tonu@x153.internalnet's avatar
tonu@x153.internalnet committed
246 247
     --ssl-ca=$BASEDIR/SSL/cacert.pem \
     --ssl-cert=$BASEDIR/SSL/server-cert.pem \
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
248 249 250 251
     --ssl-key=$BASEDIR/SSL/server-key.pem"
     MYSQL_TEST_SSL_OPTS="--ssl-ca=$BASEDIR/SSL/cacert.pem \
     --ssl-cert=$BASEDIR/SSL/client-cert.pem \
     --ssl-key=$BASEDIR/SSL/client-key.pem" ;;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
252
    --no-manager | --skip-manager) USE_MANAGER=0 ;;
253 254 255 256
    --manager)
     USE_MANAGER=1
     USE_RUNNING_SERVER=
     ;;
257 258
    --start-and-exit)
     START_AND_EXIT=1
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
259
     ;;
260
    --socket=*) LOCAL_SOCKET=`$ECHO "$1" | $SED -e "s;--socket=;;"` ;;
261
    --skip-rpl) NO_SLAVE=1 ;;
262
    --skip-test=*) SKIP_TEST=`$ECHO "$1" | $SED -e "s;--skip-test=;;"`;;
263
    --do-test=*) DO_TEST=`$ECHO "$1" | $SED -e "s;--do-test=;;"`;;
264 265 266 267
    --warnings | --log-warnings)
     EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --log-warnings"
     EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --log-warnings"
     ;;
268 269 270
    --wait-timeout=*)
     START_WAIT_TIMEOUT=`$ECHO "$1" | $SED -e "s;--wait-timeout=;;"`
     STOP_WAIT_TIMEOUT=$START_WAIT_TIMEOUT;;
271 272 273
    --record)
      RECORD=1;
      EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT $1" ;;
274 275 276
    --bench)
      DO_BENCH=1
      NO_SLAVE=1
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
277
      ;;
278 279
    --big*)			# Actually --big-test
      EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT $1" ;;
280 281
    --compress)
      EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT $1" ;;
282 283
    --sleep=*)
      EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT $1"
284
      SLEEP_TIME_AFTER_RESTART=`$ECHO "$1" | $SED -e "s;--sleep=;;"`
285
      ;;
286 287 288
    --user-test=*)
      USER_TEST=`$ECHO "$1" | $SED -e "s;--user-test=;;"`
      ;;
289
    --mysqld=*)
serg@serg.mysql.com's avatar
serg@serg.mysql.com committed
290
       TMP=`$ECHO "$1" | $SED -e "s;--mysqld=;;"`
291
       EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT $TMP"
292
       EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT $TMP"
293
       ;;
294 295 296 297 298 299
    --gcov )
      if [ x$BINARY_DIST = x1 ] ; then
	$ECHO "Cannot do coverage test without the source - please use source dist"
	exit 1
      fi
      DO_GCOV=1
300
      GCOV=`which gcov`
301
      ;;
302 303
    --gprof )
      DO_GPROF=1
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
304
      ;;
305
    --gdb )
306 307
      START_WAIT_TIMEOUT=300
      STOP_WAIT_TIMEOUT=300
308
      if [ x$BINARY_DIST = x1 ] ; then
309
	$ECHO "Note: you will get more meaningful output on a source distribution compiled with debugging option when running tests with --gdb option"
310 311
      fi
      DO_GDB=1
312 313
      # This needs to be checked properly
      # USE_MANAGER=1
314
      USE_RUNNING_SERVER=""
315
      ;;
316 317 318 319 320
    --client-gdb )
      if [ x$BINARY_DIST = x1 ] ; then
	$ECHO "Note: you will get more meaningful output on a source distribution compiled with debugging option when running tests with --client-gdb option"
      fi
      DO_CLIENT_GDB=1
321 322
      EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --gdb"
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --gdb"
323
      ;;
324 325 326 327
    --manual-gdb )
      DO_GDB=1
      MANUAL_GDB=1
      USE_RUNNING_SERVER=""
328 329
      EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --gdb"
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --gdb"
330
      ;;
331 332
    --ddd )
      if [ x$BINARY_DIST = x1 ] ; then
333
	$ECHO "Note: you will get more meaningful output on a source distribution compiled with debugging option when running tests with --ddd option"
334 335
      fi
      DO_DDD=1
336
      USE_RUNNING_SERVER=""
337 338
      EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --gdb"
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --gdb"
339
      ;;
340
    --valgrind | --valgrind-all)
guilhem@mysql.com's avatar
guilhem@mysql.com committed
341 342 343 344 345 346 347
      VALGRIND=`which valgrind` # this will print an error if not found
      # Give good warning to the user and stop
      if [ -z "$VALGRIND" ] ; then
        $ECHO "You need to have the 'valgrind' program in your PATH to run mysql-test-run with option --valgrind. Valgrind's home page is http://developer.kde.org/~sewardj ."
        exit 1
      fi
      VALGRIND="$VALGRIND --alignment=8 --leak-check=yes --num-callers=16"
348 349
      EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --skip-safemalloc --skip-bdb"
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --skip-safemalloc --skip-bdb"
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
350
      SLEEP_TIME_AFTER_RESTART=10
351
      SLEEP_TIME_FOR_DELETE=60
352
      USE_RUNNING_SERVER=""
353 354 355 356
      if test "$1" = "--valgrind-all"
      then
        VALGRIND="$VALGRIND -v --show-reachable=yes"
      fi
357 358 359 360 361
      ;;
    --valgrind-options=*)
      TMP=`$ECHO "$1" | $SED -e "s;--valgrind-options=;;"`
      VALGRIND="$VALGRIND $TMP"
      ;;
362 363 364 365
    --skip-*)
      EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT $1"
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT $1"
      ;;
366 367
    --strace-client )
      STRACE_CLIENT=1
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
368
      ;;
369
    --debug)
370
      EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT \
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
371
       --debug=d:t:i:A,$MYSQL_TEST_DIR/var/log/master.trace"
372
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT \
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
373
       --debug=d:t:i:A,$MYSQL_TEST_DIR/var/log/slave.trace"
374 375
      EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT \
       --debug=d:t:A,$MYSQL_TEST_DIR/var/log/mysqltest.trace"
376
      ;;
377 378 379
    --fast)
      FAST_START=1
      ;;
380 381 382 383 384 385
    -- )  shift; break ;;
    --* ) $ECHO "Unrecognized option: $1"; exit 1 ;;
    * ) break ;;
  esac
  shift
done
sasha@mysql.sashanet.com's avatar
fixed  
sasha@mysql.sashanet.com committed
386

bk@work.mysql.com's avatar
bk@work.mysql.com committed
387 388 389
#++
# mysqld Environment Parameters
#--
390

monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
391
MYRUN_DIR=$MYSQL_TEST_DIR/var/run
392 393
MANAGER_PID_FILE="$MYRUN_DIR/manager.pid"

394
MASTER_MYDDIR="$MYSQL_TEST_DIR/var/master-data"
395
MASTER_MYSOCK="$MYSQL_TMP_DIR/master.sock"
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
396 397 398
MASTER_MYPID="$MYRUN_DIR/master.pid"
MASTER_MYLOG="$MYSQL_TEST_DIR/var/log/master.log"
MASTER_MYERR="$MYSQL_TEST_DIR/var/log/master.err"
399 400

SLAVE_MYDDIR="$MYSQL_TEST_DIR/var/slave-data"
401
SLAVE_MYSOCK="$MYSQL_TMP_DIR/slave.sock"
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
402 403 404
SLAVE_MYPID="$MYRUN_DIR/slave.pid"
SLAVE_MYLOG="$MYSQL_TEST_DIR/var/log/slave.log"
SLAVE_MYERR="$MYSQL_TEST_DIR/var/log/slave.err"
405

406
CURRENT_TEST="$MYSQL_TEST_DIR/var/log/current_test"
407
SMALL_SERVER="--key_buffer_size=1M --sort_buffer=256K --max_heap_table_size=1M"
408

sasha@mysql.sashanet.com's avatar
sasha@mysql.sashanet.com committed
409 410 411
export MASTER_MYPORT
export SLAVE_MYPORT

412 413 414 415
if [ x$SOURCE_DIST = x1 ] ; then
 MY_BASEDIR=$MYSQL_TEST_DIR
else
 MY_BASEDIR=$BASEDIR
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
416
fi
bk@work.mysql.com's avatar
bk@work.mysql.com committed
417

monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
418 419 420 421 422 423 424 425
# Create the directories

# This should be fixed to be not be dependent on the contence of MYSQL_TMP_DIR
# or MYRUN_DIR
# (mkdir -p is not portable)
[ -d $MYSQL_TEST_DIR/var ] || mkdir $MYSQL_TEST_DIR/var
[ -d $MYSQL_TEST_DIR/var/tmp ] || mkdir $MYSQL_TEST_DIR/var/tmp
[ -d $MYSQL_TEST_DIR/var/run ] || mkdir $MYSQL_TEST_DIR/var/run
426
[ -d $MYSQL_TEST_DIR/var/log ] || mkdir $MYSQL_TEST_DIR/var/log
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
427

428
if test ${COLUMNS:-0} -lt 80 ; then COLUMNS=80 ; fi
429
E=`$EXPR $COLUMNS - 8`
430
DASH72=`$ECHO '------------------------------------------'|$CUT -c 1-$E`
431

432 433 434
# on source dist, we pick up freshly build executables
# on binary, use what is installed
if [ x$SOURCE_DIST = x1 ] ; then
435
 MYSQLD="$VALGRIND $BASEDIR/sql/mysqld"
436
 if [ -f "$BASEDIR/client/.libs/lt-mysqltest" ] ; then
437
   MYSQL_TEST="$BASEDIR/client/.libs/lt-mysqltest"
monty@bitch.mysql.fi's avatar
monty@bitch.mysql.fi committed
438 439
 elif [ -f "$BASEDIR/client/.libs/mysqltest" ] ; then
   MYSQL_TEST="$BASEDIR/client/.libs/mysqltest"
440 441 442
 else
   MYSQL_TEST="$BASEDIR/client/mysqltest"
 fi
443
 if [ -f "$BASEDIR/client/.libs/mysqldump" ] ; then
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
444
   MYSQL_DUMP="$BASEDIR/client/.libs/mysqldump"
445
 else
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
446
   MYSQL_DUMP="$BASEDIR/client/mysqldump"
447
 fi
448
 if [ -f "$BASEDIR/client/.libs/mysqlbinlog" ] ; then
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
449
   MYSQL_BINLOG="$BASEDIR/client/.libs/mysqlbinlog"
450
 else
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
451
   MYSQL_BINLOG="$BASEDIR/client/mysqlbinlog"
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
452
 fi
453 454 455
 if [ -n "$STRACE_CLIENT" ]; then
  MYSQL_TEST="strace -o $MYSQL_TEST_DIR/var/log/mysqltest.strace $MYSQL_TEST"
 fi
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
456

457
 MYSQLADMIN="$BASEDIR/client/mysqladmin"
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
458
 WAIT_PID="$BASEDIR/extra/mysql_waitpid"
459 460 461
 MYSQL_MANAGER_CLIENT="$BASEDIR/client/mysqlmanagerc"
 MYSQL_MANAGER="$BASEDIR/tools/mysqlmanager"
 MYSQL_MANAGER_PWGEN="$BASEDIR/client/mysqlmanager-pwgen"
462
 MYSQL="$BASEDIR/client/mysql"
463
 LANGUAGE="$BASEDIR/sql/share/english/"
464
 CHARSETSDIR="$BASEDIR/sql/share/charsets"
465 466
 INSTALL_DB="./install_test_db"
else
467 468
 if test -x "$BASEDIR/libexec/mysqld"
 then
469
   MYSQLD="$VALGRIND $BASEDIR/libexec/mysqld"
470
 else
471
   MYSQLD="$VALGRIND $BASEDIR/bin/mysqld"
472
 fi
473
 MYSQL_TEST="$BASEDIR/bin/mysqltest"
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
474 475
 MYSQL_DUMP="$BASEDIR/bin/mysqldump"
 MYSQL_BINLOG="$BASEDIR/bin/mysqlbinlog"
476
 MYSQLADMIN="$BASEDIR/bin/mysqladmin"
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
477
 WAIT_PID="$BASEDIR/bin/mysql_waitpid"
478 479 480
 MYSQL_MANAGER="$BASEDIR/bin/mysqlmanager"
 MYSQL_MANAGER_CLIENT="$BASEDIR/bin/mysqlmanagerc"
 MYSQL_MANAGER_PWGEN="$BASEDIR/bin/mysqlmanager-pwgen"
481
 MYSQL="$BASEDIR/bin/mysql"
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
482
 INSTALL_DB="./install_test_db -bin"
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
483
 if test -d "$BASEDIR/share/mysql/english"
484 485
 then
   LANGUAGE="$BASEDIR/share/mysql/english/"
486
   CHARSETSDIR="$BASEDIR/share/mysql/charsets"
487 488
 else
   LANGUAGE="$BASEDIR/share/english/"
489
   CHARSETSDIR="$BASEDIR/share/charsets"
490
  fi
491 492
fi

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
493 494
MYSQL_DUMP="$MYSQL_DUMP --no-defaults -uroot --socket=$MASTER_MYSOCK"
MYSQL_BINLOG="$MYSQL_BINLOG --no-defaults --local-load=$MYSQL_TMP_DIR"
495
export MYSQL_DUMP
496
export MYSQL_BINLOG
497

498 499 500 501 502 503 504 505 506 507
if [ -z "$MASTER_MYSQLD" ]
then
MASTER_MYSQLD=$MYSQLD
fi

if [ -z "$SLAVE_MYSQLD" ]
then
SLAVE_MYSQLD=$MYSQLD
fi

508 509 510 511 512 513
# If we should run all tests cases, we will use a local server for that

if [ -z "$1" ]
then
   USE_RUNNING_SERVER=""
fi
514 515
if [ -n "$USE_RUNNING_SERVER" ]
then
516
   MASTER_MYSOCK=$LOCAL_SOCKET;
517
   DBUSER=${DBUSER:-test}
518
else
519
   DBUSER=${DBUSER:-root}		# We want to do FLUSH xxx commands
520
fi
521 522 523 524 525 526 527 528

if [ -w / ]
then
    # We are running as root;  We need to add the --root argument
    EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --user=root"
    EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --user=root"
fi

529

530
MYSQL_TEST_ARGS="--no-defaults --socket=$MASTER_MYSOCK --database=$DB \
531
 --user=$DBUSER --password=$DBPASSWD --silent -v --skip-safemalloc \
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
532
 --tmpdir=$MYSQL_TMP_DIR --port=$MASTER_MYPORT $MYSQL_TEST_SSL_OPTS"
533 534 535
MYSQL_TEST_BIN=$MYSQL_TEST
MYSQL_TEST="$MYSQL_TEST $MYSQL_TEST_ARGS"
GDB_CLIENT_INIT=$MYSQL_TMP_DIR/gdbinit.client
536 537 538
GDB_MASTER_INIT=$MYSQL_TMP_DIR/gdbinit.master
GDB_SLAVE_INIT=$MYSQL_TMP_DIR/gdbinit.slave
GCOV_MSG=$MYSQL_TMP_DIR/mysqld-gcov.out
539 540 541 542
GCOV_ERR=$MYSQL_TMP_DIR/mysqld-gcov.err
GPROF_DIR=$MYSQL_TMP_DIR/gprof
GPROF_MASTER=$GPROF_DIR/master.gprof
GPROF_SLAVE=$GPROF_DIR/slave.gprof
543
TIMEFILE="$MYSQL_TEST_DIR/var/log/mysqltest-time"
544 545 546
if [ -n "$DO_CLIENT_GDB" -o -n "$DO_GDB" ] ; then
  XTERM=`which xterm`
fi
547

bk@work.mysql.com's avatar
bk@work.mysql.com committed
548 549 550 551
#++
# Function Definitions
#--

552 553
prompt_user ()
{
554
 $ECHO $1
555
 read unused
556 557
}

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
558
# We can't use diff -u or diff -a as these are not portable
559

560 561 562 563
show_failed_diff ()
{
  reject_file=r/$1.reject
  result_file=r/$1.result
564
  eval_file=r/$1.eval
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
565

566 567 568 569
  if [ -f $eval_file ]
  then
    result_file=$eval_file
  fi
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
570

571 572 573 574
  if [ -x "$DIFF" ] && [ -f $reject_file ]
  then
    echo "Below are the diffs between actual and expected results:"
    echo "-------------------------------------------------------"
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
575
    $DIFF -c $result_file $reject_file
576
    echo "-------------------------------------------------------"
577
    echo "Please follow the instructions outlined at"
578
    echo "http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html"
579
    echo "to find the reason to this problem and how to report this."
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
580
  fi
581
}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
582

583 584 585 586 587 588
do_gdb_test ()
{
  mysql_test_args="$MYSQL_TEST_ARGS $1"
  $ECHO "set args $mysql_test_args < $2" > $GDB_CLIENT_INIT
  echo "Set breakpoints ( if needed) and type 'run' in gdb window"
  #this xterm should not be backgrounded
monty@bitch.mysql.fi's avatar
monty@bitch.mysql.fi committed
589
  $XTERM -title "Client" -e gdb -x $GDB_CLIENT_INIT $MYSQL_TEST_BIN
590 591
}

bk@work.mysql.com's avatar
bk@work.mysql.com committed
592
error () {
593
    $ECHO  "Error:  $1"
bk@work.mysql.com's avatar
bk@work.mysql.com committed
594 595 596
    exit 1
}

597
error_is () {
598 599 600
    $ECHO "Errors are (from $TIMEFILE) :"
    $CAT < $TIMEFILE
    $ECHO "(the last line(s) may be the ones that caused the die() in mysqltest)"
601 602
}

monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
603
prefix_to_8() {
604
 $ECHO "        $1" | $SED -e 's:.*\(........\)$:\1:'
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
605 606
}

bk@work.mysql.com's avatar
bk@work.mysql.com committed
607
pass_inc () {
608
    TOT_PASS=`$EXPR $TOT_PASS + 1`
bk@work.mysql.com's avatar
bk@work.mysql.com committed
609 610 611
}

fail_inc () {
612
    TOT_FAIL=`$EXPR $TOT_FAIL + 1`
bk@work.mysql.com's avatar
bk@work.mysql.com committed
613 614
}

615 616 617 618
skip_inc () {
    TOT_SKIP=`$EXPR $TOT_SKIP + 1`
}

bk@work.mysql.com's avatar
bk@work.mysql.com committed
619
total_inc () {
620
    TOT_TEST=`$EXPR $TOT_TEST + 1`
bk@work.mysql.com's avatar
bk@work.mysql.com committed
621 622
}

623 624 625 626 627 628

skip_test() {
   USERT="    ...."
   SYST="    ...."
   REALT="    ...."
   pname=`$ECHO "$1                        "|$CUT -c 1-24`
629
   RES="$pname"
630 631 632 633
   skip_inc
   $ECHO "$RES$RES_SPACE [ skipped ]"
}

bk@work.mysql.com's avatar
bk@work.mysql.com committed
634
report_stats () {
635
    if [ $TOT_FAIL = 0 ]; then
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
636
	$ECHO "All $TOT_TEST tests were successful."
bk@work.mysql.com's avatar
bk@work.mysql.com committed
637
    else
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
638 639 640 641 642 643
	xten=`$EXPR $TOT_PASS \* 10000`
	raw=`$EXPR $xten / $TOT_TEST`
	raw=`$PRINTF %.4d $raw`
	whole=`$PRINTF %.2s $raw`
	xwhole=`$EXPR $whole \* 100`
	deci=`$EXPR $raw - $xwhole`
644
	$ECHO  "Failed ${TOT_FAIL}/${TOT_TEST} tests, ${whole}.${deci}% successful."
645
	$ECHO ""
646
        $ECHO "The log files in $MY_LOG_DIR may give you some hint"
647 648 649
	$ECHO "of what when wrong."
	$ECHO "If you want to report this error, please read first the documentation at"
        $ECHO "http://www.mysql.com/doc/M/y/MySQL_test_suite.html"
bk@work.mysql.com's avatar
bk@work.mysql.com committed
650
    fi
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
651

652 653 654
    if test -z "$USE_RUNNING_SERVER"
    then

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
655 656 657 658 659
    # Report if there was any fatal warnings/errors in the log files
    #
    $RM -f $MY_LOG_DIR/warnings $MY_LOG_DIR/warnings.tmp
    # Remove some non fatal warnings from the log files
    $SED -e 's!Warning:  Table:.* on delete!!g' \
660 661 662
        $MY_LOG_DIR/*.err \
        | $SED -e 's!Warning:  Table:.* on rename!!g' \
        > $MY_LOG_DIR/warnings.tmp
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
663 664 665 666 667

    found_error=0
    # Find errors
    for i in "^Warning:" "^Error:" "^==.* at 0x"
    do
668
      if $GREP "$i" $MY_LOG_DIR/warnings.tmp >> $MY_LOG_DIR/warnings
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
669 670 671 672 673 674 675 676 677 678
      then
        found_error=1
      fi
    done
    $RM -f $MY_LOG_DIR/warnings.tmp
    if [ $found_error = "1" ]
    then
      echo "WARNING: Got errors/warnings while running tests. Please examine"
      echo "$MY_LOG_DIR/warnings for details."
    fi
679
    fi
bk@work.mysql.com's avatar
bk@work.mysql.com committed
680
}
681

bk@work.mysql.com's avatar
bk@work.mysql.com committed
682
mysql_install_db () {
683
    $ECHO "Removing Stale Files"
684
    $RM -rf $MASTER_MYDDIR $SLAVE_MYDDIR $MY_LOG_DIR/* 
685
    $ECHO "Installing Master Databases"
686 687 688 689 690
    $INSTALL_DB
    if [ $? != 0 ]; then
	error "Could not install master test DBs"
	exit 1
    fi
691
    $ECHO "Installing Slave Databases"
692
    $INSTALL_DB -slave
693
    if [ $? != 0 ]; then
694
	error "Could not install slave test DBs"
695
	exit 1
bk@work.mysql.com's avatar
bk@work.mysql.com committed
696
    fi
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
697

698 699
    for slave_num in 1 2 ;
    do
700
      $RM -rf var/slave$slave_num-data
701 702 703
      mkdir -p var/slave$slave_num-data/mysql
      mkdir -p var/slave$slave_num-data/test
      cp var/slave-data/mysql/* var/slave$slave_num-data/mysql
704
    done
bk@work.mysql.com's avatar
bk@work.mysql.com committed
705 706 707
    return 0
}

708 709
gprof_prepare ()
{
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
710 711
 $RM -rf $GPROF_DIR
 mkdir -p $GPROF_DIR
712 713 714 715 716
}

gprof_collect ()
{
 if [ -f $MASTER_MYDDIR/gmon.out ]; then
717
   gprof $MASTER_MYSQLD $MASTER_MYDDIR/gmon.out > $GPROF_MASTER
718 719 720
   echo "Master execution profile has been saved in $GPROF_MASTER"
 fi
 if [ -f $SLAVE_MYDDIR/gmon.out ]; then
721
   gprof $SLAVE_MYSQLD $SLAVE_MYDDIR/gmon.out > $GPROF_SLAVE
722 723 724 725
   echo "Slave execution profile has been saved in $GPROF_SLAVE"
 fi
}

726
gcov_prepare () {
727 728
    $FIND $BASEDIR -name \*.gcov \
    -or -name \*.da | $XARGS $RM
729 730 731
}

gcov_collect () {
732
    $ECHO "Collecting source coverage info..."
733 734
    [ -f $GCOV_MSG ] && $RM $GCOV_MSG
    [ -f $GCOV_ERR ] && $RM $GCOV_ERR
735 736 737
    for d in $MYSQLD_SRC_DIRS; do
	cd $BASEDIR/$d
	for f in *.h *.cc *.c; do
738
	    $GCOV $f 2>>$GCOV_ERR  >>$GCOV_MSG
739
	done
740
	cd $MYSQL_TEST_DIR
741 742
    done

monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
743
    $ECHO "gcov info in $GCOV_MSG, errors in $GCOV_ERR"
744 745
}

746 747 748 749 750
abort_if_failed()
{
 if [ ! $? = 0 ] ; then
  echo $1
  exit 1
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
751
 fi
752 753 754 755
}

start_manager()
{
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
756
 if [ $USE_MANAGER = 0 ] ; then
757 758
   echo "Manager disabled, skipping manager start."
   $RM -f $MYSQL_MANAGER_LOG
759 760
  return
 fi
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
761
 $ECHO "Starting MySQL Manager"
762 763 764 765 766 767 768 769 770
 if [ -f "$MANAGER_PID_FILE" ] ; then
    kill `cat $MANAGER_PID_FILE`
    sleep 1
    if [ -f "$MANAGER_PID_FILE" ] ; then
     kill -9 `cat $MANAGER_PID_FILE`
     sleep 1
    fi
 fi

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
771
 $RM -f $MANAGER_PID_FILE
772 773
 MYSQL_MANAGER_PW=`$MYSQL_MANAGER_PWGEN -u $MYSQL_MANAGER_USER \
 -o $MYSQL_MANAGER_PW_FILE`
774
 $MYSQL_MANAGER --log=$MYSQL_MANAGER_LOG --port=$MYSQL_MANAGER_PORT \
775
  --password-file=$MYSQL_MANAGER_PW_FILE --pid-file=$MANAGER_PID_FILE
776
  abort_if_failed "Could not start MySQL manager"
777 778
  mysqltest_manager_args="--manager-host=localhost \
  --manager-user=$MYSQL_MANAGER_USER \
779 780 781 782 783
  --manager-password=$MYSQL_MANAGER_PW \
  --manager-port=$MYSQL_MANAGER_PORT \
  --manager-wait-timeout=$START_WAIT_TIMEOUT"
  MYSQL_TEST="$MYSQL_TEST $mysqltest_manager_args"
  MYSQL_TEST_ARGS="$MYSQL_TEST_ARGS $mysqltest_manager_args"
784 785 786 787
  while [ ! -f $MANAGER_PID_FILE ] ; do
   sleep 1
  done
  echo "Manager started"
788 789
}

790 791
stop_manager()
{
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
792
 if [ $USE_MANAGER = 0 ] ; then
793 794
  return
 fi
795 796 797 798
 $MYSQL_MANAGER_CLIENT $MANAGER_QUIET_OPT -u$MYSQL_MANAGER_USER \
  -p$MYSQL_MANAGER_PW -P $MYSQL_MANAGER_PORT <<EOF
shutdown
EOF
799 800
 echo "Manager terminated"

801 802 803
}

manager_launch()
804
{
805 806
  ident=$1
  shift
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
807
  if [ $USE_MANAGER = 0 ] ; then
808
    $@  >> $CUR_MYERR 2>&1 &
809 810
    sleep 2 #hack
    return
811
  fi
812
  $MYSQL_MANAGER_CLIENT $MANAGER_QUIET_OPT --user=$MYSQL_MANAGER_USER \
813
   --password=$MYSQL_MANAGER_PW  --port=$MYSQL_MANAGER_PORT <<EOF
814
def_exec $ident "$@"
815 816 817 818
set_exec_stdout $ident $CUR_MYERR
set_exec_stderr $ident $CUR_MYERR
set_exec_con $ident root localhost $CUR_MYSOCK
start_exec $ident $START_WAIT_TIMEOUT
819
EOF
820
  abort_if_failed "Could not execute manager command"
821
}
822

823 824
manager_term()
{
825 826
  pid=$1
  ident=$2
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
827
  if [ $USE_MANAGER = 0 ] ; then
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
828 829
    # Shutdown time must be high as slave may be in reconnect
    $MYSQLADMIN --no-defaults -uroot --socket=$MYSQL_TMP_DIR/$ident.sock --connect_timeout=5 --shutdown_timeout=70 shutdown >> $MYSQL_MANAGER_LOG 2>&1
830 831 832 833 834 835 836 837
    res=$?
    # Some systems require an extra connect
    $MYSQLADMIN --no-defaults -uroot --socket=$MYSQL_TMP_DIR/$ident.sock --connect_timeout=1 ping >> $MYSQL_MANAGER_LOG 2>&1
    if test $res = 0
    then
      wait_for_pid $pid
    fi
    return $res
838
  fi
839 840
  $MYSQL_MANAGER_CLIENT $MANAGER_QUIET_OPT --user=$MYSQL_MANAGER_USER \
   --password=$MYSQL_MANAGER_PW  --port=$MYSQL_MANAGER_PORT <<EOF
841
stop_exec $ident $STOP_WAIT_TIMEOUT
842 843 844 845 846
EOF
 abort_if_failed "Could not execute manager command"
}


847 848
start_master()
{
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
849 850 851 852 853
  if [ x$MASTER_RUNNING = x1 ] || [ x$LOCAL_MASTER = x1 ] ; then
    return
  fi
  # Remove stale binary logs
  $RM -f $MYSQL_TEST_DIR/var/log/master-bin.*
854 855
  # Remove old master.info and relay-log.info files
  $RM -f $MYSQL_TEST_DIR/var/master-data/master.info $MYSQL_TEST_DIR/var/master-data/relay-log.info
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
856 857 858 859 860 861 862 863 864 865 866

  #run master initialization shell script if one exists

  if [ -f "$master_init_script" ] ;
  then
      /bin/sh $master_init_script
  fi
  cd $BASEDIR # for gcov
  if [ -z "$DO_BENCH" ]
  then
    master_args="--no-defaults --log-bin=$MYSQL_TEST_DIR/var/log/master-bin \
867 868
  	    --server-id=1  \
          --basedir=$MY_BASEDIR \
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
869
          --port=$MASTER_MYPORT \
870
          --local-infile \
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
871 872 873 874 875 876 877 878 879 880 881
          --exit-info=256 \
          --core \
          --datadir=$MASTER_MYDDIR \
          --pid-file=$MASTER_MYPID \
          --socket=$MASTER_MYSOCK \
          --log=$MASTER_MYLOG \
          --character-sets-dir=$CHARSETSDIR \
          --default-character-set=$CHARACTER_SET \
          --tmpdir=$MYSQL_TMP_DIR \
          --language=$LANGUAGE \
          --innodb_data_file_path=ibdata1:50M \
882
	  --open-files-limit=1024 \
883
	   $MASTER_40_ARGS \
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
884 885 886 887 888 889 890
           $SMALL_SERVER \
           $EXTRA_MASTER_OPT $EXTRA_MASTER_MYSQLD_OPT"
  else
    master_args="--no-defaults --log-bin=$MYSQL_TEST_DIR/var/log/master-bin \
          --server-id=1 --rpl-recovery-rank=1 \
          --basedir=$MY_BASEDIR --init-rpl-role=master \
          --port=$MASTER_MYPORT \
891
          --local-infile \
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
892 893 894 895 896 897 898 899 900
          --datadir=$MASTER_MYDDIR \
          --pid-file=$MASTER_MYPID \
          --socket=$MASTER_MYSOCK \
          --character-sets-dir=$CHARSETSDIR \
          --default-character-set=$CHARACTER_SET \
          --core \
          --tmpdir=$MYSQL_TMP_DIR \
          --language=$LANGUAGE \
          --innodb_data_file_path=ibdata1:50M \
901
	   $MASTER_40_ARGS \
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
902 903 904 905 906 907 908 909 910 911 912
           $SMALL_SERVER \
           $EXTRA_MASTER_OPT $EXTRA_MASTER_MYSQLD_OPT"
  fi

  CUR_MYERR=$MASTER_MYERR
  CUR_MYSOCK=$MASTER_MYSOCK

  if [ x$DO_DDD = x1 ]
  then
    $ECHO "set args $master_args" > $GDB_MASTER_INIT
    manager_launch master ddd -display $DISPLAY --debugger \
913
    "gdb -x $GDB_MASTER_INIT" $MASTER_MYSQLD
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
914 915
  elif [ x$DO_GDB = x1 ]
  then
916 917 918 919
    if [ x$MANUAL_GDB = x1 ]
    then
      $ECHO "set args $master_args" > $GDB_MASTER_INIT
      $ECHO "To start gdb for the master , type in another window:"
920
      $ECHO "cd $CWD ; gdb -x $GDB_MASTER_INIT $MASTER_MYSQLD"
921 922 923 924
      wait_for_master=1500
    else
      ( $ECHO set args $master_args;
      if [ $USE_MANAGER = 0 ] ; then
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
925
    cat <<EOF
serg@serg.mysql.com's avatar
serg@serg.mysql.com committed
926 927
b mysql_parse
commands 1
928
disa 1
serg@serg.mysql.com's avatar
serg@serg.mysql.com committed
929
end
930 931
r
EOF
932 933
      fi )  > $GDB_MASTER_INIT
      manager_launch master $XTERM -display $DISPLAY \
934
      -title "Master" -e gdb -x $GDB_MASTER_INIT $MASTER_MYSQLD
935
    fi
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
936
  else
937
    manager_launch master $MASTER_MYSQLD $master_args
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
938
  fi
939
  sleep_until_file_created $MASTER_MYPID $wait_for_master
940
  wait_for_master=$SLEEP_TIME_FOR_SECOND_MASTER
941 942 943 944 945
  MASTER_RUNNING=1
}

start_slave()
{
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
946 947 948
  [ x$SKIP_SLAVE = x1 ] && return
  eval "this_slave_running=\$SLAVE$1_RUNNING"
  [ x$this_slave_running = 1 ] && return
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
949 950
  # When testing fail-safe replication, we will have more than one slave
  # in this case, we start secondary slaves with an argument
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
951 952 953 954 955 956 957 958
  slave_ident="slave$1"
  if [ -n "$1" ] ;
  then
   slave_server_id=`$EXPR 2 + $1`
   slave_rpl_rank=$slave_server_id
   slave_port=`expr $SLAVE_MYPORT + $1`
   slave_log="$SLAVE_MYLOG.$1"
   slave_err="$SLAVE_MYERR.$1"
959
   slave_datadir="$SLAVE_MYDDIR/../$slave_ident-data/"
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
960 961 962 963 964 965 966 967 968 969 970 971
   slave_pid="$MYRUN_DIR/mysqld-$slave_ident.pid"
   slave_sock="$SLAVE_MYSOCK-$1"
  else
   slave_server_id=2
   slave_rpl_rank=2
   slave_port=$SLAVE_MYPORT
   slave_log=$SLAVE_MYLOG
   slave_err=$SLAVE_MYERR
   slave_datadir=$SLAVE_MYDDIR
   slave_pid=$SLAVE_MYPID
   slave_sock="$SLAVE_MYSOCK"
 fi
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
972 973
  # Remove stale binary logs and old master.info files
  $RM -f $MYSQL_TEST_DIR/var/log/$slave_ident-*bin.*
974
  $RM -f $slave_datadir/master.info $slave_datadir/relay-log.info
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
975 976 977 978 979 980 981 982 983 984 985

  #run slave initialization shell script if one exists
  if [ -f "$slave_init_script" ] ;
  then
        /bin/sh $slave_init_script
  fi

  if [ -z "$SLAVE_MASTER_INFO" ] ; then
    master_info="--master-user=root \
          --master-connect-retry=1 \
          --master-host=127.0.0.1 \
986
          --master-password="" \
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
987 988 989 990 991 992 993 994 995 996
          --master-port=$MASTER_MYPORT \
          --server-id=$slave_server_id --rpl-recovery-rank=$slave_rpl_rank"
 else
   master_info=$SLAVE_MASTER_INFO
 fi

  $RM -f $slave_datadir/log.*
  slave_args="--no-defaults $master_info \
  	    --exit-info=256 \
          --log-bin=$MYSQL_TEST_DIR/var/log/$slave_ident-bin \
997
          --relay-log=$MYSQL_TEST_DIR/var/log/$slave_ident-relay-bin \
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
998 999 1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013
          --log-slave-updates \
          --log=$slave_log \
          --basedir=$MY_BASEDIR \
          --datadir=$slave_datadir \
          --pid-file=$slave_pid \
          --port=$slave_port \
          --socket=$slave_sock \
          --character-sets-dir=$CHARSETSDIR \
          --default-character-set=$CHARACTER_SET \
          --core --init-rpl-role=slave \
          --tmpdir=$MYSQL_TMP_DIR \
          --language=$LANGUAGE \
          --skip-innodb --skip-slave-start \
          --slave-load-tmpdir=$SLAVE_LOAD_TMPDIR \
          --report-host=127.0.0.1 --report-user=root \
          --report-port=$slave_port \
1014
          --master-retry-count=10 \
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1015
          -O slave_net_timeout=10 \
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1016 1017 1018 1019 1020 1021 1022
           $SMALL_SERVER \
           $EXTRA_SLAVE_OPT $EXTRA_SLAVE_MYSQLD_OPT"
  CUR_MYERR=$slave_err
  CUR_MYSOCK=$slave_sock

  if [ x$DO_DDD = x1 ]
  then
1023
    $ECHO "set args $slave_args" > $GDB_SLAVE_INIT
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1024 1025 1026 1027
    manager_launch $slave_ident ddd -display $DISPLAY --debugger \
     "gdb -x $GDB_SLAVE_INIT" $SLAVE_MYSQLD
  elif [ x$DO_GDB = x1 ]
  then
1028 1029
    if [ x$MANUAL_GDB = x1 ]
    then
1030
      $ECHO "set args $slave_args" > $GDB_SLAVE_INIT
1031
      echo "To start gdb for the slave, type in another window:"
1032
      echo "cd $CWD ; gdb -x $GDB_SLAVE_INIT $SLAVE_MYSQLD"
1033 1034
      wait_for_slave=1500
    else
1035 1036 1037 1038 1039 1040 1041 1042 1043 1044
      ( $ECHO set args $slave_args;
      if [ $USE_MANAGER = 0 ] ; then
    cat <<EOF
b mysql_parse
commands 1
disa 1
end
r
EOF
      fi )  > $GDB_SLAVE_INIT
1045 1046 1047
      manager_launch $slave_ident $XTERM -display $DISPLAY -title "Slave" -e \
      gdb -x $GDB_SLAVE_INIT $SLAVE_MYSQLD
    fi
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1048 1049 1050 1051
  else
    manager_launch $slave_ident $SLAVE_MYSQLD $slave_args
  fi
  eval "SLAVE$1_RUNNING=1"
1052
  sleep_until_file_created $slave_pid $wait_for_slave
1053
  wait_for_slave=$SLEEP_TIME_FOR_SECOND_SLAVE
1054 1055
}

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1056 1057
mysql_start ()
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1058
# We should not start the daemon here as we don't know the arguments
paul@ice.snake.net's avatar
paul@ice.snake.net committed
1059
# for the test.  Better to let the test start the daemon
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1060 1061 1062 1063

#  $ECHO "Starting MySQL daemon"
#  start_master
#  start_slave
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1064 1065
  cd $MYSQL_TEST_DIR
  return 1
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1066 1067
}

1068 1069
stop_slave ()
{
1070 1071 1072
  eval "this_slave_running=\$SLAVE$1_RUNNING"
  slave_ident="slave$1"
  if [ -n "$1" ] ;
1073
  then
1074 1075 1076
   slave_pid="$MYRUN_DIR/mysqld-$slave_ident.pid"
  else
   slave_pid=$SLAVE_MYPID
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1077
  fi
1078 1079
  if [ x$this_slave_running = x1 ]
  then
1080 1081
    pid=`$CAT $slave_pid`
    manager_term $pid $slave_ident
1082
    if [ $? != 0 ] && [ -f $slave_pid ]
1083
    then # try harder!
1084
      $ECHO "slave not cooperating with mysqladmin, will try manual kill"
1085 1086
      kill $pid
      sleep_until_file_deleted $pid $slave_pid
1087 1088 1089 1090 1091 1092 1093 1094 1095
      if [ -f $slave_pid ] ; then
        $ECHO "slave refused to die. Sending SIGKILL"
        kill -9 `$CAT $slave_pid`
        $RM -f $slave_pid
      else
        $ECHO "slave responded to SIGTERM "
      fi
    else
      sleep $SLEEP_TIME_AFTER_RESTART
1096
    fi
1097
    eval "SLAVE$1_RUNNING=0"
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1098
  fi
1099
}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1100

1101 1102 1103 1104 1105 1106 1107 1108 1109 1110
stop_slave_threads ()
{
  eval "this_slave_running=\$SLAVE$1_RUNNING"
  slave_ident="slave$1"
  if [ x$this_slave_running = x1 ]
  then
    $MYSQLADMIN --no-defaults -uroot --socket=$MYSQL_TMP_DIR/$slave_ident.sock stop-slave > /dev/null 2>&1
  fi
}

1111 1112 1113 1114
stop_master ()
{
  if [ x$MASTER_RUNNING = x1 ]
  then
1115 1116
    pid=`$CAT $MASTER_MYPID`
    manager_term $pid master
1117 1118
    if [ $? != 0 ] && [ -f $MASTER_MYPID ]
    then # try harder!
1119
      $ECHO "master not cooperating with mysqladmin, will try manual kill"
1120 1121
      kill $pid
      sleep_until_file_deleted $pid $MASTER_MYPID
1122 1123 1124 1125 1126 1127 1128 1129 1130
      if [ -f $MASTER_MYPID ] ; then
        $ECHO "master refused to die. Sending SIGKILL"
        kill -9 `$CAT $MASTER_MYPID`
        $RM -f $MASTER_MYPID
      else
        $ECHO "master responded to SIGTERM "
      fi
    else
      sleep $SLEEP_TIME_AFTER_RESTART
1131
    fi
1132 1133 1134
    MASTER_RUNNING=0
  fi
}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1135

1136 1137
mysql_stop ()
{
1138 1139
 $ECHO  "Ending Tests"
 $ECHO  "Shutting-down MySQL daemon"
1140
 $ECHO  ""
1141
 stop_master
1142
 $ECHO "Master shutdown finished"
1143
 stop_slave
1144 1145
 stop_slave 1
 stop_slave 2
1146
 $ECHO "Slave shutdown finished"
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1147

1148
 return 1
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1149 1150
}

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1151 1152 1153 1154 1155
mysql_restart ()
{
  mysql_stop
  mysql_start
  return 1
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1156 1157 1158
}

mysql_loadstd () {
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1159 1160

    # cp $STD_DATA/*.frm $STD_DATA/*.MRG $MASTER_MYDDIR/test
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1161 1162 1163
    return 1
}

1164 1165 1166
run_testcase ()
{
 tf=$1
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1167
 tname=`$BASENAME $tf .test`
1168 1169
 master_opt_file=$TESTDIR/$tname-master.opt
 slave_opt_file=$TESTDIR/$tname-slave.opt
1170 1171
 master_init_script=$TESTDIR/$tname-master.sh
 slave_init_script=$TESTDIR/$tname-slave.sh
1172
 slave_master_info_file=$TESTDIR/$tname.slave-mi
1173
 echo $tname > $CURRENT_TEST
1174
 SKIP_SLAVE=`$EXPR \( $tname : rpl \) = 0`
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1175
 if [ $USE_MANAGER = 1 ] ; then
guilhem@mysql.com's avatar
guilhem@mysql.com committed
1176
  many_slaves=`$EXPR \( \( $tname : rpl_failsafe \) != 0 \) \| \( \( $tname : rpl_chain_temp_table \) != 0 \)`
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1177 1178 1179
 fi

 if [ -n "$SKIP_TEST" ] ; then
1180
   SKIP_THIS_TEST=`$EXPR \( $tname : "$SKIP_TEST" \) != 0`
1181 1182
   if [ x$SKIP_THIS_TEST = x1 ] ;
   then
1183 1184
     skip_test $tname;
     return;
1185 1186
   fi
  fi
1187

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1188
 if [ -n "$DO_TEST" ] ; then
1189 1190 1191
   DO_THIS_TEST=`$EXPR \( $tname : "$DO_TEST" \) != 0`
   if [ x$DO_THIS_TEST = x0 ] ;
   then
1192 1193
     skip_test $tname;
     return;
1194 1195 1196 1197
   fi
  fi


1198 1199
 if [ x${NO_SLAVE}x$SKIP_SLAVE = x1x0 ] ;
 then
1200
   skip_test $tname;
1201 1202 1203
   return
 fi

1204 1205 1206 1207 1208 1209
 # Stop all slave threads, so that we don't have useless reconnection attempts
 # and error messages in case the slave and master servers restart.
 stop_slave_threads
 stop_slave_threads 1
 stop_slave_threads 2

1210
 if [ -z "$USE_RUNNING_SERVER" ] ;
1211
 then
1212 1213
   if [ -f $master_opt_file ] ;
   then
1214
     EXTRA_MASTER_OPT=`$CAT $master_opt_file | $SED -e "s;\\$MYSQL_TEST_DIR;$MYSQL_TEST_DIR;"`
1215 1216 1217 1218 1219 1220 1221 1222
     case "$EXTRA_MASTER_OPT" in
       --timezone=*)
	 TZ=`$ECHO "$EXTRA_MASTER_OPT" | $SED -e "s;--timezone=;;"`
	 export TZ
	 # Note that this must be set to space, not "" for test-reset to work
	 EXTRA_MASTER_OPT=" "
	 ;;
     esac
1223
     stop_master
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1224
     echo "CURRENT_TEST: $tname" >> $MASTER_MYERR
1225
     start_master
1226
     TZ=$MY_TZ; export TZ
1227
   else
1228
     if [ ! -z "$EXTRA_MASTER_OPT" ] || [ x$MASTER_RUNNING != x1 ] || [ -f $master_init_script ]
1229 1230 1231
     then
       EXTRA_MASTER_OPT=""
       stop_master
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1232
       echo "CURRENT_TEST: $tname" >> $MASTER_MYERR
1233
       start_master
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1234 1235
     else
       echo "CURRENT_TEST: $tname" >> $MASTER_MYERR
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1236
     fi
1237
   fi
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1238

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1239
   do_slave_restart=0
1240 1241
   if [ -f $slave_opt_file ] ;
   then
1242
     EXTRA_SLAVE_OPT=`$CAT $slave_opt_file | $SED -e "s;\\$MYSQL_TEST_DIR;$MYSQL_TEST_DIR;"`
1243 1244 1245 1246 1247
     do_slave_restart=1
   else
    if [ ! -z "$EXTRA_SLAVE_OPT" ] || [ x$SLAVE_RUNNING != x1 ] ;
    then
      EXTRA_SLAVE_OPT=""
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1248 1249
      do_slave_restart=1
    fi
1250
   fi
sasha@mysql.sashanet.com's avatar
fixed  
sasha@mysql.sashanet.com committed
1251

1252 1253 1254 1255 1256 1257 1258
   if [ -f $slave_master_info_file ] ; then
     SLAVE_MASTER_INFO=`$CAT $slave_master_info_file`
     do_slave_restart=1
   else
     if [ ! -z "$SLAVE_MASTER_INFO" ] || [ x$SLAVE_RUNNING != x1 ] ;
     then
       SLAVE_MASTER_INFO=""
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1259 1260
       do_slave_restart=1
     fi
1261 1262 1263 1264
   fi

   if [ x$do_slave_restart = x1 ] ; then
     stop_slave
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1265
     echo "CURRENT_TEST: $tname" >> $SLAVE_MYERR
1266
     start_slave
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1267 1268
   else
     echo "CURRENT_TEST: $tname" >> $SLAVE_MYERR
1269
   fi
1270 1271 1272 1273
   if [ x$many_slaves = x1 ]; then
    start_slave 1
    start_slave 2
   fi
sasha@mysql.sashanet.com's avatar
fixed  
sasha@mysql.sashanet.com committed
1274
 fi
1275
 cd $MYSQL_TEST_DIR
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1276

1277
 if [ -f $tf ] ; then
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1278
    $RM -f r/$tname.*reject
1279
    mysql_test_args="-R r/$tname.result $EXTRA_MYSQL_TEST_OPT"
1280
    if [ -z "$DO_CLIENT_GDB" ] ; then
1281
      `$MYSQL_TEST  $mysql_test_args < $tf 2> $TIMEFILE`;
1282
    else
1283
      do_gdb_test "$mysql_test_args" "$tf"
1284
    fi
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1285

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1286 1287
    res=$?

1288
    pname=`$ECHO "$tname                        "|$CUT -c 1-24`
1289
    RES="$pname"
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1290

1291 1292 1293 1294
    if [ x$many_slaves = x1 ] ; then
     stop_slave 1
     stop_slave 2
    fi
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1295

monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1296
    if [ $res = 0 ]; then
1297 1298
      total_inc
      pass_inc
1299
      $ECHO "$RES$RES_SPACE [ pass ]"
1300
    else
1301
      # why the following ``if'' ? That is why res==1 is special ?
1302 1303 1304 1305
      if [ $res = 2 ]; then
        skip_inc
	$ECHO "$RES$RES_SPACE [ skipped ]"
      else
1306
	total_inc
1307
        fail_inc
1308
	$ECHO "$RES$RES_SPACE [ fail ]"
1309 1310
        $ECHO
	error_is
1311
	show_failed_diff $tname
1312
	$ECHO
1313
	if [ x$FORCE != x1 ] ; then
1314
	 $ECHO "Aborting: $tname failed. To continue, re-run with '--force'."
1315
	 $ECHO
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1316 1317 1318
         if [ -z "$DO_GDB" ] && [ -z "$USE_RUNNING_SERVER" ] && [ -z "$DO_DDD" ]
	 then
	   mysql_stop
1319
	   stop_manager
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1320
   	 fi
1321 1322
	 exit 1
	fi
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1323

monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1324 1325 1326 1327
        if [ -z "$DO_GDB" ] && [ -z "$USE_RUNNING_SERVER" ] && [ -z "$DO_DDD" ]
	then
	  mysql_restart
	fi
1328
	$ECHO "Resuming Tests"
1329
	$ECHO ""
1330
      fi
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1331
    fi
1332
  fi
1333 1334
}

monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1335 1336 1337 1338
######################################################################
# Main script starts here
######################################################################

1339 1340
[ "$DO_GCOV" -a ! -x "$GCOV" ] && error "No gcov found"

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1341 1342
[ "$DO_GCOV" ] && gcov_prepare
[ "$DO_GPROF" ] && gprof_prepare
1343

1344 1345
if [ -z "$USE_RUNNING_SERVER" ]
then
1346 1347 1348 1349 1350 1351 1352 1353 1354 1355 1356 1357 1358
  if [ -z "$FAST_START" ]
  then
    # Ensure that no old mysqld test servers are running
    $MYSQLADMIN --no-defaults --socket=$MASTER_MYSOCK -u root -O connect_timeout=5 -O shutdown_timeout=20 shutdown > /dev/null 2>&1
    $MYSQLADMIN --no-defaults --socket=$SLAVE_MYSOCK -u root -O connect_timeout=5 -O shutdown_timeout=20 shutdown > /dev/null 2>&1
    $MYSQLADMIN --no-defaults --host=$hostname --port=$MASTER_MYPORT -u root -O connect_timeout=5 -O shutdown_timeout=20 shutdown > /dev/null 2>&1
    $MYSQLADMIN --no-defaults --host=$hostname --port=$SLAVE_MYPORT -u root -O connect_timeout=5 -O shutdown_timeout=20 shutdown > /dev/null 2>&1
    $MYSQLADMIN --no-defaults --host=$hostname --port=`expr $SLAVE_MYPORT + 1` -u root -O connect_timeout=5 -O shutdown_timeout=20 shutdown > /dev/null 2>&1
    sleep_until_file_deleted 0 $MASTER_MYPID
    sleep_until_file_deleted 0 $SLAVE_MYPID
  else
    rm $MASTER_MYPID $SLAVE_MYPID
  fi
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1359 1360 1361 1362 1363 1364 1365 1366 1367 1368 1369 1370 1371 1372 1373 1374

  # Kill any running managers
  if [ -f "$MANAGER_PID_FILE" ]
  then
    kill `cat $MANAGER_PID_FILE`
    sleep 1
    if [ -f "$MANAGER_PID_FILE" ]
    then
      kill -9 `cat $MANAGER_PID_FILE`
      sleep 1
    fi
  fi

  # Remove files that can cause problems
  $RM -f $MYSQL_TEST_DIR/var/run/* $MYSQL_TEST_DIR/var/tmp/*

1375 1376 1377
  # Remove old berkeley db log files that can confuse the server
  $RM -f $MASTER_MYDDIR/log.*

1378 1379
  wait_for_master=$SLEEP_TIME_FOR_FIRST_MASTER
  wait_for_slave=$SLEEP_TIME_FOR_FIRST_SLAVE
1380 1381
  $ECHO "Installing Test Databases"
  mysql_install_db
1382
  start_manager
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1383

paul@ice.snake.net's avatar
paul@ice.snake.net committed
1384
# Do not automagically start daemons if we are in gdb or running only one test
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1385
# case
1386 1387 1388 1389 1390 1391
  if [ -z "$DO_GDB" ] && [ -z "$DO_DDD" ]
  then
    mysql_start
  fi
  $ECHO  "Loading Standard Test Databases"
  mysql_loadstd
1392 1393
fi

1394 1395 1396 1397
if [ "x$START_AND_EXIT" = "x1" ] ; then
 echo "Servers started, exiting"
 exit
fi
1398

1399
$ECHO  "Starting Tests"
1400

1401 1402 1403
#
# This can probably be deleted
#
1404 1405
if [ "$DO_BENCH" = 1 ]
then
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1406 1407 1408 1409
  BENCHDIR=$BASEDIR/sql-bench/
  savedir=`pwd`
  cd $BENCHDIR
  if [ -z "$1" ]
1410
  then
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1411
    ./run-all-tests --socket=$MASTER_MYSOCK --user=root
1412
  else
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1413 1414 1415 1416 1417 1418
    if [ -x "./$1" ]
    then
       ./$1 --socket=$MASTER_MYSOCK --user=root
    else
      echo "benchmark $1 not found"
    fi
1419
  fi
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1420 1421 1422 1423
  cd $savedir
  mysql_stop
  stop_manager
  exit
1424 1425
fi

1426
$ECHO
1427
$ECHO " TEST                           RESULT"
1428 1429
$ECHO $DASH72

1430
if [ -z "$1" ] ;
1431
then
1432 1433 1434
  if [ x$RECORD = x1 ]; then
    $ECHO "Will not run in record mode without a specific test case."
  else
1435 1436 1437 1438
    for tf in $TESTDIR/*.$TESTSUFFIX
    do
      run_testcase $tf
    done
1439 1440
    $RM -f $TIMEFILE	# Remove for full test
  fi
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1441
else
1442 1443 1444 1445 1446 1447 1448 1449 1450 1451
  while [ ! -z "$1" ]; do
    tname=`$BASENAME $1 .test`
    tf=$TESTDIR/$tname.$TESTSUFFIX
    if [ -f $tf ] ; then
      run_testcase $tf
    else
      $ECHO "Test case $tf does not exist."
    fi
    shift
  done
1452
fi
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1453

1454 1455
$ECHO $DASH72
$ECHO
1456

1457
if [ -z "$DO_GDB" ] && [ -z "$USE_RUNNING_SERVER" ] && [ -z "$DO_DDD" ]
1458 1459 1460
then
    mysql_stop
fi
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1461

1462
stop_manager
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1463
report_stats
1464
$ECHO
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1465

1466
[ "$DO_GCOV" ] && gcov_collect # collect coverage information
1467
[ "$DO_GPROF" ] && gprof_collect # collect coverage information
1468

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1469
exit 0