mysql-test-run.sh 66.2 KB
Newer Older
1
#!/bin/sh
2 3
# mysql-test-run - originally written by Matt Wagner <matt@mysql.com>
# modified by Sasha Pachev <sasha@mysql.com>
unknown's avatar
Typo.  
unknown committed
4
# Slightly updated by Monty
5
# Cleaned up again by Matt
unknown's avatar
unknown committed
6
# Fixed by Sergei
7
# List of failed cases (--force) backported from 4.1 by Joerg
unknown's avatar
unknown committed
8
# :-)
unknown's avatar
unknown committed
9

10 11 12 13 14
#echo "##################################################";
#echo "This script is deprecated and will soon be removed";
#echo "Use mysql-test-run.pl instead";
#echo "##################################################";
#echo
15

unknown's avatar
unknown committed
16 17 18 19
#++
# Access Definitions
#--
DB=test
unknown's avatar
unknown committed
20
DBPASSWD=""
21
VERBOSE=""
unknown's avatar
unknown committed
22
USE_MANAGER=0
23 24
MY_TZ=GMT-3
TZ=$MY_TZ; export TZ # for UNIX_TIMESTAMP tests to work
25
LOCAL_SOCKET=@MYSQL_UNIX_ADDR@
26
MYSQL_TCP_PORT=@MYSQL_TCP_PORT@
unknown's avatar
unknown committed
27

unknown's avatar
unknown committed
28 29
umask 022

30
# For query_cache test
unknown's avatar
unknown committed
31
case `uname` in
32 33 34
    SCO_SV | UnixWare | OpenUNIX )
        # do nothing (Causes strange behavior)
        ;;
unknown's avatar
unknown committed
35 36 37
    QNX)
        # do nothing (avoid error message)
        ;;
38 39 40 41
    * )
        ulimit -n 1024
        ;;
esac
42

43 44 45 46
#++
# Program Definitions
#--

unknown's avatar
unknown committed
47 48
LC_COLLATE=C
export LC_COLLATE
49
PATH=/bin:/usr/bin:/usr/local/bin:/usr/bsd:/usr/X11R6/bin:/usr/openwin/bin:/usr/bin/X11:$PATH
50
MASTER_40_ARGS="--rpl-recovery-rank=1 --init-rpl-role=master"
51

52 53 54 55
# Standard functions

which ()
{
56
  IFS="${IFS=   }"; save_ifs="$IFS"; IFS=':'
57 58
  for file
  do
59
    for dir in $PATH
60
    do
unknown's avatar
unknown committed
61
      if test -f $dir/$file
62 63 64 65 66
      then
        echo "$dir/$file"
        continue 2
      fi
    done
67
    echo "Fatal error: Cannot find program $file in $PATH" 1>&2
68 69
    exit 1
  done
70
  IFS="$save_ifs"
71
  exit 0
72 73 74
}


unknown's avatar
unknown committed
75 76
sleep_until_file_deleted ()
{
77 78
  pid=$1;
  file=$2
unknown's avatar
unknown committed
79
  loop=$SLEEP_TIME_FOR_DELETE
unknown's avatar
unknown committed
80 81
  while (test $loop -gt 0)
  do
unknown's avatar
unknown committed
82
    if [ ! -r $file ]
unknown's avatar
unknown committed
83
    then
84 85 86 87
      if test $pid != "0"
      then
        wait_for_pid $pid
      fi
unknown's avatar
unknown committed
88 89
      return
    fi
unknown's avatar
unknown committed
90
    sleep 1
unknown's avatar
unknown committed
91 92 93 94
    loop=`expr $loop - 1`
  done
}

95
sleep_until_file_created ()
unknown's avatar
unknown committed
96 97
{
  file=$1
unknown's avatar
unknown committed
98 99
  loop=$2
  org_time=$2
unknown's avatar
unknown committed
100 101
  while (test $loop -gt 0)
  do
unknown's avatar
unknown committed
102
    if [ -r $file ]
unknown's avatar
unknown committed
103
    then
104
      return 0
unknown's avatar
unknown committed
105
    fi
unknown's avatar
unknown committed
106
    sleep 1
unknown's avatar
unknown committed
107 108
    loop=`expr $loop - 1`
  done
unknown's avatar
unknown committed
109
  echo "ERROR: $file was not created in $org_time seconds;  Aborting"
unknown's avatar
unknown committed
110 111 112
  exit 1;
}

113 114 115 116 117
# For the future

wait_for_pid()
{
  pid=$1
unknown's avatar
unknown committed
118
  #$WAIT_PID pid $SLEEP_TIME_FOR_DELETE
119 120
}

unknown's avatar
unknown committed
121 122 123 124 125 126 127 128 129 130 131 132 133 134
# Check that valgrind is installed
find_valgrind()
{
  FIND_VALGRIND=`which valgrind` # this will print an error if not found
  # Give good warning to the user and stop
  if [ -z "$FIND_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://valgrind.kde.org ."
    exit 1
  fi
  # >=2.1.2 requires the --tool option, some versions write to stdout, some to stderr
  valgrind --help 2>&1 | grep "\-\-tool" > /dev/null && FIND_VALGRIND="$FIND_VALGRIND --tool=memcheck"
  FIND_VALGRIND="$FIND_VALGRIND --alignment=8 --leak-check=yes --num-callers=16 --suppressions=$CWD/valgrind.supp"
}

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

unknown's avatar
unknown committed
137 138
SED=sed

139 140
BASENAME=`which basename`
if test $? != 0; then exit 1; fi
unknown's avatar
unknown committed
141
DIFF=`which diff | $SED q`
142
if test $? != 0; then exit 1; fi
143 144
CAT=cat
CUT=cut
unknown's avatar
unknown committed
145
HEAD=head
146 147 148 149
TAIL=tail
ECHO=echo # use internal echo if possible
EXPR=expr # use internal if possible
FIND=find
unknown's avatar
unknown committed
150
GREP=grep
151
if test $? != 0; then exit 1; fi
152 153
PRINTF=printf
RM=rm
154
if test $? != 0; then exit 1; fi
155
TR=tr
156 157
XARGS=`which xargs`
if test $? != 0; then exit 1; fi
158
SORT=sort
159 160 161 162 163

# Are we using a source or a binary distribution?

testdir=@testdir@
if [ -d bin/mysqld ] && [ -d mysql-test ] ; then
164 165
 cd mysql-test
else
166 167
 if [ -d $testdir/mysql-test ] ; then
   cd $testdir
168
 fi
169 170 171 172 173 174 175
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."
unknown's avatar
unknown committed
176
  exit 1
177
fi
178

unknown's avatar
unknown committed
179 180 181
#++
# Misc. Definitions
#--
182

183 184 185 186 187
if [ -d ../sql ] ; then
   SOURCE_DIST=1
else
   BINARY_DIST=1
fi
188

unknown's avatar
unknown committed
189
#BASEDIR is always one above mysql-test directory
unknown's avatar
unknown committed
190 191 192 193
CWD=`pwd`
cd ..
BASEDIR=`pwd`
cd $CWD
194
MYSQL_TEST_DIR=$BASEDIR/mysql-test
unknown's avatar
unknown committed
195
MYSQL_TEST_WINDIR=$MYSQL_TEST_DIR
196 197
MYSQLTEST_VARDIR=$MYSQL_TEST_DIR/var
export MYSQL_TEST_DIR MYSQL_TEST_WINDIR MYSQLTEST_VARDIR
198
STD_DATA=$MYSQL_TEST_DIR/std_data
unknown's avatar
unknown committed
199
hostname=`hostname`		# Installed in the mysql privilege table
unknown's avatar
unknown committed
200

unknown's avatar
unknown committed
201
MANAGER_QUIET_OPT="-q"
202
TESTDIR="$MYSQL_TEST_DIR/t"
unknown's avatar
unknown committed
203
TESTSUFFIX=test
204
TOT_SKIP=0
unknown's avatar
unknown committed
205 206 207
TOT_PASS=0
TOT_FAIL=0
TOT_TEST=0
unknown's avatar
unknown committed
208
GOT_WARNINGS=0
209 210 211
USERT=0
SYST=0
REALT=0
212
FAST_START=""
unknown's avatar
unknown committed
213
MYSQL_TMP_DIR=$MYSQL_TEST_DIR/var/tmp
214
export MYSQL_TMP_DIR
unknown's avatar
unknown committed
215 216 217 218 219 220 221 222

# Use a relative path for where the slave will find the dumps
# generated by "LOAD DATA" on the master. The path is relative
# since it must have fixed length to test logging
# i.e otherwise the output from "SHOW MASTER STATUS" will vary
# with the strlen() of MYSQL_TEST_DIR
SLAVE_LOAD_TMPDIR=../tmp

unknown's avatar
unknown committed
223
RES_SPACE="      "
224
MYSQLD_SRC_DIRS="strings mysys include extra regex myisam \
unknown's avatar
unknown committed
225
 myisammrg heap sql"
226
MY_LOG_DIR="$MYSQL_TEST_DIR/var/log" 
227 228 229
#
# Set LD_LIBRARY_PATH if we are using shared libraries
#
unknown's avatar
unknown committed
230 231
LD_LIBRARY_PATH="$BASEDIR/lib:$BASEDIR/libmysql/.libs:$BASEDIR/libmysql_r/.libs:$BASEDIR/zlib/.libs:$LD_LIBRARY_PATH"
DYLD_LIBRARY_PATH="$BASEDIR/lib:$BASEDIR/libmysql/.libs:$BASEDIR/libmysql_r/.libs:$BASEDIR/zlib/.libs:$DYLD_LIBRARY_PATH"
unknown's avatar
unknown committed
232
export LD_LIBRARY_PATH DYLD_LIBRARY_PATH
233

unknown's avatar
unknown committed
234 235 236 237 238 239 240
#
# Allow anyone in the group to see the generated database files
#
UMASK=0660
UMASK_DIR=0770
export UMASK UMASK_DIR

unknown's avatar
fixed  
unknown committed
241
MASTER_RUNNING=0
unknown's avatar
unknown committed
242
MASTER1_RUNNING=0
unknown's avatar
unknown committed
243
MASTER_MYHOST=127.0.0.1
244
MASTER_MYPORT=9306
unknown's avatar
fixed  
unknown committed
245
SLAVE_RUNNING=0
unknown's avatar
unknown committed
246
SLAVE_MYHOST=127.0.0.1
unknown's avatar
unknown committed
247
SLAVE_MYPORT=9308 # leave room for 2 masters for cluster tests
248
MYSQL_MANAGER_LOG=$MYSQL_TEST_DIR/var/log/manager.log
249
NDBCLUSTER_PORT=9350
unknown's avatar
unknown committed
250
NDBCLUSTER_PORT_SLAVE=9358
unknown's avatar
unknown committed
251 252 253 254 255 256

#
# To make it easier for different devs to work on the same host,
# an environment variable can be used to control all ports. A small
# number is to be used, 0 - 16 or similar.
#
unknown's avatar
unknown committed
257 258 259 260 261
# Note the MASTER_MYPORT has to be set the same in all 4.x and 5.x
# versions of this script, else a 4.0 test run might conflict with a
# 5.1 test run, even if different MTR_BUILD_THREAD is used. This means
# all port numbers might not be used in this version of the script.
#
unknown's avatar
unknown committed
262
if [ -n "$MTR_BUILD_THREAD" ] ; then
unknown's avatar
unknown committed
263
  MASTER_MYPORT=`expr $MTR_BUILD_THREAD '*' 10 + 10000`
264
  SLAVE_MYPORT=`expr $MASTER_MYPORT + 3`
unknown's avatar
unknown committed
265
  NDBCLUSTER_PORT=`expr $MASTER_MYPORT + 6`
unknown's avatar
unknown committed
266
  NDBCLUSTER_PORT_SLAVE=`expr $MASTER_MYPORT + 7`
unknown's avatar
unknown committed
267

268 269 270 271 272
  echo "Using MTR_BUILD_THREAD      = $MTR_BUILD_THREAD"
  echo "Using MASTER_MYPORT         = $MASTER_MYPORT"
  echo "Using SLAVE_MYPORT          = $SLAVE_MYPORT"
  echo "Using NDBCLUSTER_PORT       = $NDBCLUSTER_PORT"
  echo "Using NDBCLUSTER_PORT_SLAVE = $NDBCLUSTER_PORT_SLAVE"
unknown's avatar
unknown committed
273 274
fi

275
NO_SLAVE=0
unknown's avatar
unknown committed
276
USER_TEST=
unknown's avatar
unknown committed
277
FAILED_CASES=
278

279
EXTRA_MASTER_OPT=""
280
EXTRA_MYSQL_TEST_OPT=""
281
EXTRA_MYSQLCHECK_OPT=""
282
EXTRA_MYSQLDUMP_OPT=""
283
EXTRA_MYSQLSLAP_OPT=""
284
EXTRA_MYSQLSHOW_OPT=""
285
EXTRA_MYSQLBINLOG_OPT=""
286
USE_RUNNING_SERVER=0
287
USE_NDBCLUSTER=@USE_NDBCLUSTER@
unknown's avatar
unknown committed
288
USE_NDBCLUSTER_SLAVE=@USE_NDBCLUSTER@
289
USE_NDBCLUSTER_ALL=0
290
USE_NDBCLUSTER_ONLY=0
unknown's avatar
unknown committed
291
USE_RUNNING_NDBCLUSTER=""
unknown's avatar
unknown committed
292 293
USE_RUNNING_NDBCLUSTER_SLAVE=""
NDB_EXTRA_TEST=0
294
NDB_VERBOSE=0
unknown's avatar
unknown committed
295
NDBCLUSTER_EXTRA_OPTS=""
unknown's avatar
unknown committed
296 297
USE_PURIFY=""
PURIFY_LOGS=""
298 299
DO_GCOV=""
DO_GDB=""
unknown's avatar
unknown committed
300
MANUAL_GDB=""
301
DO_DDD=""
302
DO_CLIENT_GDB=""
unknown's avatar
unknown committed
303
SLEEP_TIME_AFTER_RESTART=1
unknown's avatar
unknown committed
304
SLEEP_TIME_FOR_DELETE=10
unknown's avatar
unknown committed
305
SLEEP_TIME_FOR_FIRST_MASTER=400		# Enough time to create innodb tables
unknown's avatar
unknown committed
306
SLEEP_TIME_FOR_SECOND_MASTER=400
unknown's avatar
unknown committed
307
SLEEP_TIME_FOR_FIRST_SLAVE=400
308
SLEEP_TIME_FOR_SECOND_SLAVE=300
unknown's avatar
unknown committed
309
CHARACTER_SET=latin1
310
DBUSER=""
311 312
START_WAIT_TIMEOUT=10
STOP_WAIT_TIMEOUT=10
unknown's avatar
unknown committed
313
MYSQL_TEST_SSL_OPTS=""
unknown's avatar
unknown committed
314
USE_TIMER=""
unknown's avatar
unknown committed
315
USE_EMBEDDED_SERVER=""
unknown's avatar
unknown committed
316
TEST_MODE=""
317

318
NDB_MGM_EXTRA_OPTS=
319 320
NDB_MGMD_EXTRA_OPTS=
NDBD_EXTRA_OPTS=
321
MASTER_MYSQLDBINLOG=1
unknown's avatar
unknown committed
322
SLAVE_MYSQLDBINLOG=1
323

unknown's avatar
unknown committed
324
DO_STRESS=""
325 326 327
STRESS_SUITE="main"
STRESS_MODE="random"
STRESS_THREADS=5
328
STRESS_TEST_COUNT=""
329 330 331 332 333 334
STRESS_LOOP_COUNT=""
STRESS_TEST_DURATION=""
STRESS_INIT_FILE=""
STRESS_TEST_FILE=""
STRESS_TEST=""

335 336
$ECHO "Logging: $0 $*"   # To ensure we see all arguments in the output, for the test analysis tool

337 338
while test $# -gt 0; do
  case "$1" in
unknown's avatar
unknown committed
339 340 341
    --embedded-server)
      USE_EMBEDDED_SERVER=1
      USE_MANAGER=0 NO_SLAVE=1
unknown's avatar
unknown committed
342
      USE_RUNNING_SERVER=0
343 344
      USE_NDBCLUSTER=""
      USE_NDBCLUSTER_SLAVE=""
unknown's avatar
unknown committed
345 346 347 348
      TEST_MODE="$TEST_MODE embedded" ;;
    --purify)
      USE_PURIFY=1
      USE_MANAGER=0
unknown's avatar
unknown committed
349
      USE_RUNNING_SERVER=0
unknown's avatar
unknown committed
350
      TEST_MODE="$TEST_MODE purify" ;;
351 352
    --user=*) DBUSER=`$ECHO "$1" | $SED -e "s;--user=;;"` ;;
    --force)  FORCE=1 ;;
unknown's avatar
unknown committed
353
    --timer)  USE_TIMER=1 ;;
354 355 356 357 358
    --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=;;"` ;;
359 360
    --local)   USE_RUNNING_SERVER=0 ;;
    --extern)  USE_RUNNING_SERVER=1 ;;
unknown's avatar
unknown committed
361
    --with-ndbcluster)
362
      USE_NDBCLUSTER="--ndbcluster" ;;
unknown's avatar
unknown committed
363 364
    --with-ndbcluster-slave)
      USE_NDBCLUSTER_SLAVE="--ndbcluster" ;;
365 366 367 368
    --with-ndbcluster-all)
      USE_NDBCLUSTER="--ndbcluster"
      USE_NDBCLUSTER_SLAVE="--ndbcluster"
      USE_NDBCLUSTER_ALL=1 ;;
369 370 371 372
    --with-ndbcluster-only)
      USE_NDBCLUSTER="--ndbcluster"
      USE_NDBCLUSTER_SLAVE="--ndbcluster"
      USE_NDBCLUSTER_ONLY=1 ;;
unknown's avatar
unknown committed
373
    --ndb-connectstring=*)
374
      USE_NDBCLUSTER="--ndbcluster" ;
unknown's avatar
unknown committed
375
      USE_RUNNING_NDBCLUSTER=`$ECHO "$1" | $SED -e "s;--ndb-connectstring=;;"` ;;
unknown's avatar
unknown committed
376 377 378 379 380 381 382
    --ndb-connectstring-slave=*)
      USE_NDBCLUSTER_SLAVE="--ndbcluster" ;
      USE_RUNNING_NDBCLUSTER_SLAVE=`$ECHO "$1" | $SED -e "s;--ndb-connectstring-slave=;;"` ;;
    --ndb-extra-test)
      NDBCLUSTER_EXTRA_OPTS=" "
      NDB_EXTRA_TEST=1 ;
      ;;
383 384
    --ndb-verbose)
      NDB_VERBOSE=2 ;;
385 386
    --ndb_mgm-extra-opts=*)
      NDB_MGM_EXTRA_OPTS=`$ECHO "$1" | $SED -e "s;--ndb_mgm-extra-opts=;;"` ;;
387 388 389 390
    --ndb_mgmd-extra-opts=*)
      NDB_MGMD_EXTRA_OPTS=`$ECHO "$1" | $SED -e "s;--ndb_mgmd-extra-opts=;;"` ;;
    --ndbd-extra-opts=*)
      NDBD_EXTRA_OPTS=`$ECHO "$1" | $SED -e "s;--ndbd-extra-opts=;;"` ;;
391
    --tmpdir=*) MYSQL_TMP_DIR=`$ECHO "$1" | $SED -e "s;--tmpdir=;;"` ;;
392 393 394 395 396
    --local-master)
      MASTER_MYPORT=3306;
      EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT --host=127.0.0.1 \
      --port=$MYSQL_MYPORT"
      LOCAL_MASTER=1 ;;
397 398
    --master_port=*) MASTER_MYPORT=`$ECHO "$1" | $SED -e "s;--master_port=;;"` ;;
    --slave_port=*) SLAVE_MYPORT=`$ECHO "$1" | $SED -e "s;--slave_port=;;"` ;;
399
    --ndbcluster_port=*) NDBCLUSTER_PORT=`$ECHO "$1" | $SED -e "s;--ndbcluster_port=;;"` ;;
unknown's avatar
unknown committed
400 401
    --ndbcluster-port=*) NDBCLUSTER_PORT=`$ECHO "$1" | $SED -e "s;--ndbcluster-port=;;"` ;;
    --ndbcluster-port-slave=*) NDBCLUSTER_PORT_SLAVE=`$ECHO "$1" | $SED -e "s;--ndbcluster-port-slave=;;"` ;;
unknown's avatar
unknown committed
402 403
    --with-openssl)
     EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT \
404 405 406
     --ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem \
     --ssl-cert=$MYSQL_TEST_DIR/std_data/server-cert.pem \
     --ssl-key=$MYSQL_TEST_DIR/std_data/server-key.pem"
unknown's avatar
unknown committed
407
     EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT \
408 409 410
     --ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem \
     --ssl-cert=$MYSQL_TEST_DIR/std_data/server-cert.pem \
     --ssl-key=$MYSQL_TEST_DIR/std_data/server-key.pem"
unknown's avatar
unknown committed
411
     MYSQL_TEST_SSL_OPTS="--ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem \
412 413
     --ssl-cert=$MYSQL_TEST_DIR/std_data/client-cert.pem \
     --ssl-key=$MYSQL_TEST_DIR/std_data/client-key.pem" ;;
414 415
    --start-and-exit)
     START_AND_EXIT=1
unknown's avatar
unknown committed
416
     ;;
417
    --socket=*) LOCAL_SOCKET=`$ECHO "$1" | $SED -e "s;--socket=;;"` ;;
418
    --skip-rpl) NO_SLAVE=1 ;;
unknown's avatar
unknown committed
419
    --skip-test=*) SKIP_TEST=`$ECHO "$1" | $SED -e "s;--skip-test=;;"`;;
420
    --do-test=*) DO_TEST=`$ECHO "$1" | $SED -e "s;--do-test=;;"`;;
421
    --start-from=* ) START_FROM=`$ECHO "$1" | $SED -e "s;--start-from=;;"` ;;
422 423 424 425
    --warnings | --log-warnings)
     EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --log-warnings"
     EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --log-warnings"
     ;;
unknown's avatar
unknown committed
426 427 428
    --wait-timeout=*)
     START_WAIT_TIMEOUT=`$ECHO "$1" | $SED -e "s;--wait-timeout=;;"`
     STOP_WAIT_TIMEOUT=$START_WAIT_TIMEOUT;;
429 430 431
    --record)
      RECORD=1;
      EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT $1" ;;
432 433 434 435 436
    --small-bench)
      DO_SMALL_BENCH=1
      DO_BENCH=1
      NO_SLAVE=1
      ;;
unknown's avatar
unknown committed
437 438 439
    --bench)
      DO_BENCH=1
      NO_SLAVE=1
unknown's avatar
unknown committed
440
      ;;
441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469
    --stress)
      DO_STRESS=1
      NO_SLAVE=1
      SKIP_SLAVE=1
      ;;
    --stress-suite=*)
      STRESS_SUITE=`$ECHO "$1" | $SED -e "s;--stress-suite=;;"`
      ;;
    --stress-threads=*)
      STRESS_THREADS=`$ECHO "$1" | $SED -e "s;--stress-threads=;;"`
      ;;
    --stress-test-file=*)
      STRESS_TEST_FILE=`$ECHO "$1" | $SED -e "s;--stress-test-file=;;"`
      ;;
    --stress-init-file=*)
      STRESS_INIT_FILE=`$ECHO "$1" | $SED -e "s;--stress-init-file=;;"`
      ;; 
    --stress-mode=*)
      STRESS_MODE=`$ECHO "$1" | $SED -e "s;--stress-mode=;;"`
      ;;
    --stress-loop-count=*)
      STRESS_LOOP_COUNT=`$ECHO "$1" | $SED -e "s;--stress-loop-count=;;"`
      ;;
    --stress-test-count=*)
      STRESS_TEST_COUNT=`$ECHO "$1" | $SED -e "s;--stress-test-count=;;"`
      ;;      
    --stress-test-duration=*)
      STRESS_TEST_DURATION=`$ECHO "$1" | $SED -e "s;--stress-test-duration=;;"`
      ;;
470 471
    --big*)			# Actually --big-test
      EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT $1" ;;
unknown's avatar
unknown committed
472 473
    --compress)
      EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT $1" ;;
474 475
    --sleep=*)
      EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT $1"
unknown's avatar
unknown committed
476
      SLEEP_TIME_AFTER_RESTART=`$ECHO "$1" | $SED -e "s;--sleep=;;"`
477
      ;;
478
    --ps-protocol)
unknown's avatar
unknown committed
479
      TEST_MODE="$TEST_MODE ps-protocol" EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT $1" ;;
unknown's avatar
unknown committed
480 481 482
    --user-test=*)
      USER_TEST=`$ECHO "$1" | $SED -e "s;--user-test=;;"`
      ;;
483
    --mysqld=*)
unknown's avatar
unknown committed
484
       TMP=`$ECHO "$1" | $SED -e "s;--mysqld=;;"`
unknown's avatar
unknown committed
485
       EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT $TMP"
486
       EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT $TMP"
487
       ;;
488 489 490 491 492 493
    --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
494
      GCOV=`which gcov`
495
      ;;
unknown's avatar
unknown committed
496 497
    --gprof )
      DO_GPROF=1
unknown's avatar
unknown committed
498
      ;;
499
    --gdb )
unknown's avatar
unknown committed
500 501
      START_WAIT_TIMEOUT=300
      STOP_WAIT_TIMEOUT=300
502
      if [ x$BINARY_DIST = x1 ] ; then
503
	$ECHO "Note: you will get more meaningful output on a source distribution compiled with debugging option when running tests with --gdb option"
504 505
      fi
      DO_GDB=1
506 507
      EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --gdb"
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --gdb"
unknown's avatar
unknown committed
508 509
      # This needs to be checked properly
      # USE_MANAGER=1
510
      USE_RUNNING_SERVER=0
511
      ;;
512 513 514 515 516
    --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
517 518
      EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --gdb"
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --gdb"
519
      ;;
unknown's avatar
unknown committed
520 521 522
    --manual-gdb )
      DO_GDB=1
      MANUAL_GDB=1
523
      USE_RUNNING_SERVER=0
524 525
      EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --gdb"
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --gdb"
unknown's avatar
unknown committed
526
      ;;
527 528
    --ddd )
      if [ x$BINARY_DIST = x1 ] ; then
529
	$ECHO "Note: you will get more meaningful output on a source distribution compiled with debugging option when running tests with --ddd option"
530 531
      fi
      DO_DDD=1
532
      USE_RUNNING_SERVER=0
533 534
      EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --gdb"
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --gdb"
535
      ;;
536
    --valgrind | --valgrind-all)
unknown's avatar
unknown committed
537 538
      find_valgrind;
      VALGRIND=$FIND_VALGRIND
539 540
      EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --skip-safemalloc --skip-bdb"
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --skip-safemalloc --skip-bdb"
unknown's avatar
unknown committed
541
      SLEEP_TIME_AFTER_RESTART=10
542
      SLEEP_TIME_FOR_DELETE=60
543
      USE_RUNNING_SERVER=0
544 545 546 547
      if test "$1" = "--valgrind-all"
      then
        VALGRIND="$VALGRIND -v --show-reachable=yes"
      fi
unknown's avatar
unknown committed
548 549 550 551 552
      ;;
    --valgrind-options=*)
      TMP=`$ECHO "$1" | $SED -e "s;--valgrind-options=;;"`
      VALGRIND="$VALGRIND $TMP"
      ;;
unknown's avatar
unknown committed
553 554 555 556
    --skip-ndbcluster-slave | --skip-ndb-slave)
      USE_NDBCLUSTER_SLAVE=""
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --skip-ndbcluster"
      ;;
unknown's avatar
unknown committed
557 558 559 560 561 562 563
    --valgrind-mysqltest | --valgrind-mysqltest-all)
      find_valgrind;
      VALGRIND_MYSQLTEST=$FIND_VALGRIND
      if test "$1" = "--valgrind-mysqltest-all"
      then
        VALGRIND_MYSQLTEST="$VALGRIND_MYSQLTEST -v --show-reachable=yes"
      fi
564
      ;;
565
    --skip-ndbcluster | --skip-ndb)
unknown's avatar
unknown committed
566
      USE_NDBCLUSTER=""
unknown's avatar
unknown committed
567
      USE_NDBCLUSTER_SLAVE=""
unknown's avatar
unknown committed
568 569
      EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --skip-ndbcluster"
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --skip-ndbcluster"
unknown's avatar
unknown committed
570
      ;;
571
    --skip-master-binlog) MASTER_MYSQLDBINLOG=0 ;;
unknown's avatar
unknown committed
572
    --skip-slave-binlog) SLAVE_MYSQLDBINLOG=0 ;;
573 574 575 576
    --skip-*)
      EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT $1"
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT $1"
      ;;
unknown's avatar
unknown committed
577 578
    --strace-client )
      STRACE_CLIENT=1
unknown's avatar
unknown committed
579
      ;;
580
    --debug)
581
      EXTRA_MASTER_MYSQLD_TRACE=" \
unknown's avatar
unknown committed
582
       --debug=d:t:i:A,$MYSQL_TEST_DIR/var/log/master.trace"
583
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT \
unknown's avatar
unknown committed
584
       --debug=d:t:i:A,$MYSQL_TEST_DIR/var/log/slave.trace"
585 586
      EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT \
       --debug=d:t:A,$MYSQL_TEST_DIR/var/log/mysqltest.trace"
587 588
      EXTRA_MYSQLCHECK_OPT="$EXTRA_MYSQLCHECK_OPT \
       --debug=d:t:A,$MYSQL_TEST_DIR/var/log/mysqlcheck.trace"
589 590
      EXTRA_MYSQLDUMP_OPT="$EXTRA_MYSQLDUMP_OPT \
       --debug=d:t:A,$MYSQL_TEST_DIR/var/log/mysqldump.trace"
591 592
      EXTRA_MYSQLSLAP_OPT="$EXTRA_MYSQLSLAP_OPT \
       --debug=d:t:A,$MYSQL_TEST_DIR/var/log/mysqlslap.trace"
593 594
      EXTRA_MYSQLSHOW_OPT="$EXTRA_MYSQLSHOW_OPT \
       --debug=d:t:A,$MYSQL_TEST_DIR/var/log/mysqlshow.trace"
595 596
      EXTRA_MYSQLBINLOG_OPT="$EXTRA_MYSQLBINLOG_OPT \
       --debug=d:t:A,$MYSQL_TEST_DIR/var/log/mysqlbinlog.trace"
unknown's avatar
unknown committed
597
      EXTRA_MYSQL_CLIENT_TEST_OPT="--debug=d:t:A,$MYSQL_TEST_DIR/var/log/mysql_client_test.trace"
598
      ;;
599 600 601
    --fast)
      FAST_START=1
      ;;
602
    --use-old-data)
603 604
      USE_OLD_DATA=1
      ;;
605 606 607 608 609 610
    --comment=*)
      TMP=`$ECHO "$1" | $SED -e "s;--comment=;;"`
      echo
      echo '############################################'
      echo "# $TMP"
      echo '############################################'
611
      ;;
612 613 614 615 616 617
    -- )  shift; break ;;
    --* ) $ECHO "Unrecognized option: $1"; exit 1 ;;
    * ) break ;;
  esac
  shift
done
unknown's avatar
fixed  
unknown committed
618

unknown's avatar
unknown committed
619 620 621 622 623 624 625
if [ -z "$TEST_MODE" ] ; then
  TEST_MODE="default"
else
  # Remove the leading space if any
  TEST_MODE=`echo $TEST_MODE | sed 's/^ *//'`
fi

unknown's avatar
unknown committed
626 627 628
#++
# mysqld Environment Parameters
#--
629

unknown's avatar
unknown committed
630
MYRUN_DIR=$MYSQL_TEST_DIR/var/run
631

632
MASTER_MYDDIR="$MYSQL_TEST_DIR/var/master-data"
unknown's avatar
unknown committed
633
MASTER_MYSOCK="$MYSQL_TMP_DIR/master.sock"
unknown's avatar
unknown committed
634
MASTER_MYSOCK1=$MYSQL_MYSOCK"1"
unknown's avatar
unknown committed
635 636 637
MASTER_MYPID="$MYRUN_DIR/master.pid"
MASTER_MYLOG="$MYSQL_TEST_DIR/var/log/master.log"
MASTER_MYERR="$MYSQL_TEST_DIR/var/log/master.err"
638 639

SLAVE_MYDDIR="$MYSQL_TEST_DIR/var/slave-data"
unknown's avatar
unknown committed
640
SLAVE_MYSOCK="$MYSQL_TMP_DIR/slave.sock"
unknown's avatar
unknown committed
641 642 643
SLAVE_MYPID="$MYRUN_DIR/slave.pid"
SLAVE_MYLOG="$MYSQL_TEST_DIR/var/log/slave.log"
SLAVE_MYERR="$MYSQL_TEST_DIR/var/log/slave.err"
644

645
CURRENT_TEST="$MYSQL_TEST_DIR/var/log/current_test"
646
SMALL_SERVER="--key_buffer_size=1M --sort_buffer=256K --max_heap_table_size=1M"
647

unknown's avatar
unknown committed
648
export MASTER_MYHOST MASTER_MYPORT SLAVE_MYHOST SLAVE_MYPORT MYSQL_TCP_PORT MASTER_MYSOCK MASTER_MYSOCK1
unknown's avatar
unknown committed
649

650
NDBCLUSTER_OPTS="--port=$NDBCLUSTER_PORT --data-dir=$MYSQL_TEST_DIR/var --ndb_mgm-extra-opts=$NDB_MGM_EXTRA_OPTS --ndb_mgmd-extra-opts=$NDB_MGMD_EXTRA_OPTS --ndbd-extra-opts=$NDBD_EXTRA_OPTS"
unknown's avatar
unknown committed
651 652
NDBCLUSTER_OPTS_SLAVE="--port=$NDBCLUSTER_PORT_SLAVE --data-dir=$MYSQL_TEST_DIR/var"
if [ -n "$USE_NDBCLUSTER_SLAVE" ] ; then
653
  USE_NDBCLUSTER_SLAVE="$USE_NDBCLUSTER_SLAVE --ndb-connectstring=localhost:$NDBCLUSTER_PORT_SLAVE --ndb-extra-logging"
unknown's avatar
unknown committed
654
fi
655
NDB_BACKUP_DIR=$MYSQL_TEST_DIR/var/ndbcluster-$NDBCLUSTER_PORT
656
NDB_TOOLS_OUTPUT=$MYSQL_TEST_DIR/var/log/ndb_tools.log
657

658 659 660 661
if [ x$SOURCE_DIST = x1 ] ; then
 MY_BASEDIR=$MYSQL_TEST_DIR
else
 MY_BASEDIR=$BASEDIR
unknown's avatar
unknown committed
662
fi
unknown's avatar
unknown committed
663

unknown's avatar
unknown committed
664 665 666 667 668 669 670 671
# 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
672
[ -d $MYSQL_TEST_DIR/var/log ] || mkdir $MYSQL_TEST_DIR/var/log
673 674 675

# Use 'test', not '[' as the shell builtin might not have '-L
if test ! -L "$MYSQL_TEST_DIR/var/std_data_ln" ; then
unknown's avatar
unknown committed
676 677 678
  ln -s $MYSQL_TEST_DIR/std_data/ $MYSQL_TEST_DIR/var/std_data_ln
fi

679
if test ${COLUMNS:-0} -lt 80 ; then COLUMNS=80 ; fi
680
E=`$EXPR $COLUMNS - 8`
unknown's avatar
unknown committed
681
DASH72=`$ECHO '-------------------------------------------------------'|$CUT -c 1-$E`
682

683 684 685
# on source dist, we pick up freshly build executables
# on binary, use what is installed
if [ x$SOURCE_DIST = x1 ] ; then
unknown's avatar
unknown committed
686
 if [ "x$USE_EMBEDDED_SERVER" = "x1" ] ; then
687
   if [ -f "$BASEDIR/libmysqld/examples/mysqltest_embedded" ] ; then
unknown's avatar
unknown committed
688
     MYSQL_TEST="$BASEDIR/libmysqld/examples/mysqltest_embedded"
unknown's avatar
unknown committed
689
   else
690
     echo "Fatal error: Cannot find embedded server 'mysqltest_embedded'" 1>&2
unknown's avatar
unknown committed
691 692
     exit 1
   fi
693
   MYSQL_CLIENT_TEST="$BASEDIR/libmysqld/examples/mysql_client_test_embedded"
694
 else
unknown's avatar
unknown committed
695 696 697 698
   MYSQLD="$BASEDIR/sql/mysqld"
   if [ -n "$VALGRIND" ] ; then
     MYSQLD="$VALGRIND $MYSQLD"
   fi
unknown's avatar
unknown committed
699 700 701 702 703 704 705
   if [ -f "$BASEDIR/client/.libs/lt-mysqltest" ] ; then
     MYSQL_TEST="$BASEDIR/client/.libs/lt-mysqltest"
   elif [ -f "$BASEDIR/client/.libs/mysqltest" ] ; then
     MYSQL_TEST="$BASEDIR/client/.libs/mysqltest"
   else
     MYSQL_TEST="$BASEDIR/client/mysqltest"
   fi
706
   MYSQL_CLIENT_TEST="$BASEDIR/tests/mysql_client_test"
707
 fi
708 709 710 711 712
 if [ -f "$BASEDIR/client/.libs/mysqlcheck" ] ; then
   MYSQL_CHECK="$BASEDIR/client/.libs/mysqlcheck"
 else
   MYSQL_CHECK="$BASEDIR/client/mysqlcheck"
 fi
713
 if [ -f "$BASEDIR/client/.libs/mysqldump" ] ; then
unknown's avatar
unknown committed
714
   MYSQL_DUMP="$BASEDIR/client/.libs/mysqldump"
715
 else
unknown's avatar
unknown committed
716
   MYSQL_DUMP="$BASEDIR/client/mysqldump"
717
 fi
718 719 720 721 722
 if [ -f "$BASEDIR/client/.libs/mysqlslap" ] ; then
   MYSQL_SLAP="$BASEDIR/client/.libs/mysqlslap"
 else
   MYSQL_SLAP="$BASEDIR/client/mysqlslap"
 fi
unknown's avatar
unknown committed
723 724 725 726 727
 if [ -f "$BASEDIR/client/.libs/mysqlimport" ] ; then
   MYSQL_IMPORT="$BASEDIR/client/.libs/mysqlimport"
 else
   MYSQL_IMPORT="$BASEDIR/client/mysqlimport"
 fi
728 729 730 731 732
 if [ -f "$BASEDIR/client/.libs/mysqlshow" ] ; then
   MYSQL_SHOW="$BASEDIR/client/.libs/mysqlshow"
 else
   MYSQL_SHOW="$BASEDIR/client/mysqlshow"
 fi
unknown's avatar
unknown committed
733
 if [ -f "$BASEDIR/client/.libs/mysqlbinlog" ] ; then
unknown's avatar
unknown committed
734
   MYSQL_BINLOG="$BASEDIR/client/.libs/mysqlbinlog"
unknown's avatar
unknown committed
735
 else
unknown's avatar
unknown committed
736
   MYSQL_BINLOG="$BASEDIR/client/mysqlbinlog"
unknown's avatar
unknown committed
737
 fi
unknown's avatar
unknown committed
738 739 740
 if [ -n "$STRACE_CLIENT" ]; then
  MYSQL_TEST="strace -o $MYSQL_TEST_DIR/var/log/mysqltest.strace $MYSQL_TEST"
 fi
unknown's avatar
unknown committed
741

unknown's avatar
unknown committed
742 743
 CLIENT_BINDIR="$BASEDIR/client"
 MYSQLADMIN="$CLIENT_BINDIR/mysqladmin"
unknown's avatar
unknown committed
744
 WAIT_PID="$BASEDIR/extra/mysql_waitpid"
745
 MYSQL_MY_PRINT_DEFAULTS="$BASEDIR/extra/my_print_defaults"
unknown's avatar
unknown committed
746
 MYSQL="$CLIENT_BINDIR/mysql"
747
 LANGUAGE="$BASEDIR/sql/share/english/"
748
 CHARSETSDIR="$BASEDIR/sql/share/charsets"
749
 INSTALL_DB="./install_test_db"
750
 MYSQL_FIX_SYSTEM_TABLES="$BASEDIR/scripts/mysql_fix_privilege_tables"
751 752
 NDB_TOOLS_DIR="$BASEDIR/storage/ndb/tools"
 NDB_MGM="$BASEDIR/storage/ndb/src/mgmclient/ndb_mgm"
unknown's avatar
unknown committed
753 754

 if [ -n "$USE_PURIFY" ] ; then
unknown's avatar
unknown committed
755
   PSUP="$MYSQL_TEST_DIR/suppress.purify"
unknown's avatar
unknown committed
756 757 758 759 760 761 762 763 764 765 766 767 768 769 770 771 772 773 774
   PURIFYOPTIONS="-windows=no -log-file=%v.purifylog -append-logfile -add-suppression-files=$PSUP"
   if [ -f "${MYSQL_TEST}-purify" ] ; then
     MYSQL_TEST="${MYSQL_TEST}-purify"
     PLOG="$MYSQL_TEST.purifylog"
     if [ -f $PLOG ]; then
       mv $PLOG $PLOG.$$
     fi
     PURIFY_LOGS="$PLOG"
   fi
   if [ -f "${MYSQLD}-purify" ] ; then
     MYSQLD="${MYSQLD}-purify"
     PLOG="$MYSQLD.purifylog"
     if [ -f $PLOG ]; then
       mv $PLOG $PLOG.$$
     fi
     PURIFY_LOGS="$PURIFY_LOGS $PLOG"
   fi
 fi

775
else
776 777 778 779 780 781 782 783

 # We have a binary installation. Note that this can be both from
 # unpacking a MySQL AB binary distribution (created using
 # "scripts/make_binary_distribution", and from a "make install".
 # Unfortunately the structure differs a bit, for a "make install"
 # currently all binaries are in "bin", for a MySQL AB packaging
 # some are in "tests".

784 785
 if test -x "$BASEDIR/libexec/mysqld"
 then
unknown's avatar
unknown committed
786
   MYSQLD="$VALGRIND $BASEDIR/libexec/mysqld"
787
 else
unknown's avatar
unknown committed
788
   MYSQLD="$VALGRIND $BASEDIR/bin/mysqld"
789
 fi
unknown's avatar
unknown committed
790
 CLIENT_BINDIR="$BASEDIR/bin"
791 792 793 794 795 796
 if test -d "$BASEDIR/tests"
 then
   TESTS_BINDIR="$BASEDIR/tests"
 else
   TESTS_BINDIR="$BASEDIR/bin"
 fi
unknown's avatar
unknown committed
797
 MYSQL_TEST="$CLIENT_BINDIR/mysqltest"
798
 MYSQL_CHECK="$CLIENT_BINDIR/mysqlcheck"
799
 MYSQL_SLAP="$CLIENT_BINDIR/mysqlslap"
800
 MYSQL_SHOW="$CLIENT_BINDIR/mysqlshow"
unknown's avatar
unknown committed
801
 MYSQL_IMPORT="$CLIENT_BINDIR/mysqlimport"
unknown's avatar
unknown committed
802 803 804
 MYSQL_BINLOG="$CLIENT_BINDIR/mysqlbinlog"
 MYSQLADMIN="$CLIENT_BINDIR/mysqladmin"
 WAIT_PID="$CLIENT_BINDIR/mysql_waitpid"
805
 MYSQL_MY_PRINT_DEFAULTS="$CLIENT_BINDIR/my_print_defaults"
unknown's avatar
unknown committed
806
 MYSQL="$CLIENT_BINDIR/mysql"
807
 INSTALL_DB="./install_test_db --bin"
unknown's avatar
unknown committed
808
 MYSQL_FIX_SYSTEM_TABLES="$CLIENT_BINDIR/mysql_fix_privilege_tables"
809
 NDB_TOOLS_DIR="$CLIENT_BINDIR"
810
 NDB_MGM="$CLIENT_BINDIR/ndb_mgm"
unknown's avatar
unknown committed
811
 if test -d "$BASEDIR/share/mysql/english"
812 813
 then
   LANGUAGE="$BASEDIR/share/mysql/english/"
814
   CHARSETSDIR="$BASEDIR/share/mysql/charsets"
815 816
 else
   LANGUAGE="$BASEDIR/share/english/"
817
   CHARSETSDIR="$BASEDIR/share/charsets"
818 819 820
 fi
 if [ "x$USE_EMBEDDED_SERVER" = "x1" ] ; then
   if [ -f "$CLIENT_BINDIR/mysqltest_embedded" ] ; then
unknown's avatar
unknown committed
821
     MYSQL_TEST="$CLIENT_BINDIR/mysqltest_embedded"
822 823 824 825 826 827 828 829 830 831
   else
     echo "Fatal error: Cannot find embedded server 'mysqltest_embedded'" 1>&2
     exit 1
   fi
   if [ -d "$BASEDIR/tests/mysql_client_test_embedded" ] ; then
     MYSQL_CLIENT_TEST="$TESTS_BINDIR/mysql_client_test_embedded"
   else
     MYSQL_CLIENT_TEST="$CLIENT_BINDIR/mysql_client_test_embedded"
   fi
 else
unknown's avatar
unknown committed
832
   MYSQL_TEST="$CLIENT_BINDIR/mysqltest"
833 834
   MYSQL_CLIENT_TEST="$CLIENT_BINDIR/mysql_client_test"
 fi
unknown's avatar
unknown committed
835 836 837 838 839 840 841
 if [ -f "$BASEDIR/client/.libs/mysqldump" ] ; then
   MYSQL_DUMP="$BASEDIR/client/.libs/mysqldump"
 elif  [ -f "$BASEDIR/client/mysqldump" ] ; then
   MYSQL_DUMP="$BASEDIR/client/mysqldump"
 else
   MYSQL_DUMP="$BASEDIR/bin/mysqldump"
 fi
842 843
fi

844 845 846 847 848 849 850 851 852 853
if [ -z "$MASTER_MYSQLD" ]
then
MASTER_MYSQLD=$MYSQLD
fi

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

854 855
# If we should run all tests cases, we will use a local server for that

unknown's avatar
unknown committed
856
if [ -z "$1" -a -z "$DO_STRESS" ]
857
then
858
   USE_RUNNING_SERVER=0
859
fi
860
if [ $USE_RUNNING_SERVER -eq 1 ]
861
then
862
   MASTER_MYSOCK=$LOCAL_SOCKET;
863
   DBUSER=${DBUSER:-test}
864
else
865
   DBUSER=${DBUSER:-root}		# We want to do FLUSH xxx commands
866
fi
867 868 869

if [ -w / ]
then
unknown's avatar
unknown committed
870 871 872
  # 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"
873 874
fi

unknown's avatar
unknown committed
875
MYSQL_CLIENT_TEST="$MYSQL_CLIENT_TEST --no-defaults --testcase --user=root --socket=$MASTER_MYSOCK --port=$MYSQL_TCP_PORT --silent $EXTRA_MYSQL_CLIENT_TEST_OPT"
876 877 878 879 880 881
# Need to pass additional arguments to MYSQL_CLIENT_TEST for embedded server
# -A marks each argument for passing to the function which initializes the
# embedded library
if [ "x$USE_EMBEDDED_SERVER" = "x1" ]; then
  MYSQL_CLIENT_TEST="$MYSQL_CLIENT_TEST -A --language=$LANGUAGE -A --datadir=$SLAVE_MYDDIR -A --character-sets-dir=$CHARSETSDIR"
fi
unknown's avatar
patch  
unknown committed
882 883 884
# Save path and name of mysqldump
MYSQL_DUMP_DIR="$MYSQL_DUMP"
export MYSQL_DUMP_DIR
885
MYSQL_CHECK="$MYSQL_CHECK --no-defaults -uroot --socket=$MASTER_MYSOCK --password=$DBPASSWD $EXTRA_MYSQLCHECK_OPT"
886
MYSQL_DUMP="$MYSQL_DUMP --no-defaults -uroot --socket=$MASTER_MYSOCK --password=$DBPASSWD $EXTRA_MYSQLDUMP_OPT"
887
MYSQL_SLAP="$MYSQL_SLAP -uroot --socket=$MASTER_MYSOCK --password=$DBPASSWD $EXTRA_MYSQLSLAP_OPT"
888
MYSQL_DUMP_SLAVE="$MYSQL_DUMP_DIR --no-defaults -uroot --socket=$SLAVE_MYSOCK --password=$DBPASSWD $EXTRA_MYSQLDUMP_OPT"
889
MYSQL_SHOW="$MYSQL_SHOW -uroot --socket=$MASTER_MYSOCK --password=$DBPASSWD $EXTRA_MYSQLSHOW_OPT"
890
MYSQL_BINLOG="$MYSQL_BINLOG --no-defaults --local-load=$MYSQL_TMP_DIR  --character-sets-dir=$CHARSETSDIR $EXTRA_MYSQLBINLOG_OPT"
unknown's avatar
unknown committed
891
MYSQL_IMPORT="$MYSQL_IMPORT -uroot --socket=$MASTER_MYSOCK --password=$DBPASSWD $EXTRA_MYSQLDUMP_OPT"
892
MYSQL_FIX_SYSTEM_TABLES="$MYSQL_FIX_SYSTEM_TABLES --no-defaults --host=localhost --port=$MASTER_MYPORT --socket=$MASTER_MYSOCK --user=root --password=$DBPASSWD --basedir=$BASEDIR --bindir=$CLIENT_BINDIR --verbose"
unknown's avatar
unknown committed
893
MYSQL="$MYSQL --no-defaults --host=localhost --port=$MASTER_MYPORT --socket=$MASTER_MYSOCK --user=root --password=$DBPASSWD"
894
export MYSQL MYSQL_CHECK MYSQL_DUMP MYSQL_DUMP_SLAVE MYSQL_SHOW MYSQL_BINLOG MYSQL_FIX_SYSTEM_TABLES MYSQL_IMPORT
895
export CLIENT_BINDIR MYSQL_CLIENT_TEST CHARSETSDIR MYSQL_MY_PRINT_DEFAULTS
896
export MYSQL_SLAP
897
export NDB_TOOLS_DIR
898
export NDB_MGM
899
export NDB_BACKUP_DIR
900
export NDB_TOOLS_OUTPUT
unknown's avatar
unknown committed
901
export PURIFYOPTIONS
902 903
NDB_STATUS_OK=1
export NDB_STATUS_OK
unknown's avatar
unknown committed
904 905 906
NDB_SLAVE_STATUS_OK=1
export NDB_SLAVE_STATUS_OK
export NDB_EXTRA_TEST NDBCLUSTER_PORT NDBCLUSTER_PORT_SLAVE
907

908
MYSQL_TEST_ARGS="--no-defaults --socket=$MASTER_MYSOCK --database=$DB \
909
 --user=$DBUSER --password=$DBPASSWD --silent -v --skip-safemalloc \
unknown's avatar
unknown committed
910
 --tmpdir=$MYSQL_TMP_DIR --port=$MASTER_MYPORT $MYSQL_TEST_SSL_OPTS"
unknown's avatar
unknown committed
911 912 913
if [ x$USE_TIMER = x1 ] ; then
  MYSQL_TEST_ARGS="$MYSQL_TEST_ARGS --timer-file=$MY_LOG_DIR/timer"
fi
914 915
MYSQL_TEST_BIN=$MYSQL_TEST
MYSQL_TEST="$MYSQL_TEST $MYSQL_TEST_ARGS"
unknown's avatar
unknown committed
916 917

# Export MYSQL_TEST variable for use from .test files
918
export MYSQL_TEST
unknown's avatar
unknown committed
919

920
GDB_CLIENT_INIT=$MYSQL_TMP_DIR/gdbinit.client
921 922 923
GDB_MASTER_INIT=$MYSQL_TMP_DIR/gdbinit.master
GDB_SLAVE_INIT=$MYSQL_TMP_DIR/gdbinit.slave
GCOV_MSG=$MYSQL_TMP_DIR/mysqld-gcov.out
unknown's avatar
unknown committed
924 925 926 927
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
928
TIMEFILE="$MYSQL_TEST_DIR/var/log/mysqltest-time"
unknown's avatar
unknown committed
929
MYSQLTEST_LOG="$MYSQL_TEST_DIR/var/log/mysqltest.log"
930 931 932
if [ -n "$DO_CLIENT_GDB" -o -n "$DO_GDB" ] ; then
  XTERM=`which xterm`
fi
933

934
export MYSQL MYSQL_CHECK MYSQL_DUMP MYSQL_SHOW MYSQL_BINLOG MYSQL_FIX_SYSTEM_TABLES CLIENT_BINDIR MASTER_MYSOCK
unknown's avatar
unknown committed
935

unknown's avatar
unknown committed
936 937 938 939
#++
# Function Definitions
#--

unknown's avatar
unknown committed
940 941
prompt_user ()
{
942
 $ECHO $1
943
 read unused
unknown's avatar
unknown committed
944 945
}

unknown's avatar
unknown committed
946
# We can't use diff -u or diff -a as these are not portable
947

unknown's avatar
unknown committed
948 949 950 951
show_failed_diff ()
{
  reject_file=r/$1.reject
  result_file=r/$1.result
952
  eval_file=r/$1.eval
unknown's avatar
unknown committed
953

954 955 956 957
  if [ -f $eval_file ]
  then
    result_file=$eval_file
  fi
unknown's avatar
unknown committed
958

unknown's avatar
unknown committed
959 960 961 962
  if [ -x "$DIFF" ] && [ -f $reject_file ]
  then
    echo "Below are the diffs between actual and expected results:"
    echo "-------------------------------------------------------"
unknown's avatar
unknown committed
963
    $DIFF -c $result_file $reject_file
unknown's avatar
unknown committed
964
    echo "-------------------------------------------------------"
965
    echo "Please follow the instructions outlined at"
unknown's avatar
unknown committed
966
    echo "http://dev.mysql.com/doc/mysql/en/reporting-mysqltest-bugs.html"
967
    echo "to find the reason to this problem and how to report this."
968
    echo ""
unknown's avatar
unknown committed
969
  fi
unknown's avatar
unknown committed
970
}
unknown's avatar
unknown committed
971

972 973 974 975 976 977
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
unknown's avatar
unknown committed
978
  $XTERM -title "Client" -e gdb -x $GDB_CLIENT_INIT $MYSQL_TEST_BIN
979 980
}

unknown's avatar
unknown committed
981
error () {
unknown's avatar
unknown committed
982
    $ECHO  "Error:  $1"
unknown's avatar
unknown committed
983 984 985
    exit 1
}

986
error_is () {
987 988
    $ECHO "Errors are (from $TIMEFILE) :"
    $CAT < $TIMEFILE
989
    $ECHO "(the last lines may be the most important ones)"
990 991
}

unknown's avatar
unknown committed
992
prefix_to_8() {
993
 $ECHO "        $1" | $SED -e 's:.*\(........\)$:\1:'
unknown's avatar
unknown committed
994 995
}

unknown's avatar
unknown committed
996
pass_inc () {
unknown's avatar
unknown committed
997
    TOT_PASS=`$EXPR $TOT_PASS + 1`
unknown's avatar
unknown committed
998 999 1000
}

fail_inc () {
unknown's avatar
unknown committed
1001
    TOT_FAIL=`$EXPR $TOT_FAIL + 1`
unknown's avatar
unknown committed
1002 1003
}

1004 1005 1006 1007
skip_inc () {
    TOT_SKIP=`$EXPR $TOT_SKIP + 1`
}

unknown's avatar
unknown committed
1008
total_inc () {
unknown's avatar
unknown committed
1009
    TOT_TEST=`$EXPR $TOT_TEST + 1`
unknown's avatar
unknown committed
1010 1011
}

1012 1013 1014 1015 1016 1017

skip_test() {
   USERT="    ...."
   SYST="    ...."
   REALT="    ...."
   pname=`$ECHO "$1                        "|$CUT -c 1-24`
1018
   RES="$pname"
1019 1020 1021 1022
   skip_inc
   $ECHO "$RES$RES_SPACE [ skipped ]"
}

1023 1024 1025 1026 1027 1028 1029 1030 1031 1032 1033

disable_test() {
   USERT="    ...."
   SYST="    ...."
   REALT="    ...."
   pname=`$ECHO "$1                        "|$CUT -c 1-24`
   RES="$pname"
   skip_inc
   $ECHO "$RES$RES_SPACE [ disabled ]  $2"
}

unknown's avatar
Merge  
unknown committed
1034

unknown's avatar
unknown committed
1035 1036 1037
report_current_test () {
   tname=$1
   echo "CURRENT_TEST: $tname" >> $MASTER_MYERR
1038 1039 1040 1041
   eval "master1_running=\$MASTER1_RUNNING"
   if [ x$master1_running = x1 ] ; then
     echo "CURRENT_TEST: $tname" >> $MASTER_MYERR"1"
   fi
unknown's avatar
unknown committed
1042 1043 1044 1045 1046 1047 1048 1049
   if [ -n "$PURIFY_LOGS" ] ; then
     for log in $PURIFY_LOGS
     do
       echo "CURRENT_TEST: $tname" >> $log
     done
   fi
}

unknown's avatar
Merge  
unknown committed
1050

unknown's avatar
unknown committed
1051
report_stats () {
1052
    if [ $TOT_FAIL = 0 ]; then
unknown's avatar
unknown committed
1053
	$ECHO "All $TOT_TEST tests were successful."
unknown's avatar
unknown committed
1054
    else
unknown's avatar
unknown committed
1055 1056 1057 1058 1059 1060
	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`
1061
	$ECHO  "Failed ${TOT_FAIL}/${TOT_TEST} tests, ${whole}.${deci}% were successful."
1062
	$ECHO ""
1063
        $ECHO "The log files in $MY_LOG_DIR may give you some hint"
unknown's avatar
unknown committed
1064
	$ECHO "of what went wrong."
1065
	$ECHO "If you want to report this error, please read first the documentation at"
unknown's avatar
unknown committed
1066
        $ECHO "http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html"
unknown's avatar
unknown committed
1067
    fi
unknown's avatar
unknown committed
1068

1069
    if [ $USE_RUNNING_SERVER -eq 0 ]
unknown's avatar
unknown committed
1070 1071
    then

unknown's avatar
unknown committed
1072 1073 1074 1075
    # 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
1076
    $SED -e 's!Warning:  Table:.* on delete!!g' -e 's!Warning: Setting lower_case_table_names=2!!g' -e 's!Warning: One can only use the --user.*root!!g' -e 's|InnoDB: Warning: we did not need to do crash recovery||g' \
1077 1078 1079
        $MY_LOG_DIR/*.err \
        | $SED -e 's!Warning:  Table:.* on rename!!g' \
        > $MY_LOG_DIR/warnings.tmp
unknown's avatar
unknown committed
1080 1081

    # Find errors
1082
    for i in "^Warning:" "^Error:" "^==.* at 0x" "InnoDB: Warning" "missing DBUG_RETURN" "mysqld: Warning" "Attempting backtrace" "Assertion .* failed"
unknown's avatar
unknown committed
1083
    do
unknown's avatar
unknown committed
1084
      if $GREP "$i" $MY_LOG_DIR/warnings.tmp >> $MY_LOG_DIR/warnings
unknown's avatar
unknown committed
1085
      then
unknown's avatar
unknown committed
1086
        GOT_WARNINGS=1
unknown's avatar
unknown committed
1087 1088 1089
      fi
    done
    $RM -f $MY_LOG_DIR/warnings.tmp
unknown's avatar
unknown committed
1090
    if [ $GOT_WARNINGS = "1" ]
unknown's avatar
unknown committed
1091 1092 1093 1094
    then
      echo "WARNING: Got errors/warnings while running tests. Please examine"
      echo "$MY_LOG_DIR/warnings for details."
    fi
unknown's avatar
unknown committed
1095 1096 1097 1098 1099 1100 1101 1102 1103 1104 1105 1106

    fi # USE_RUNNING_SERVER

    # Check valgrind errors from mysqltest
    if [ ! -z "$VALGRIND_MYSQLTEST" ]
    then
      if $GREP "ERROR SUMMARY" $MYSQLTEST_LOG | $GREP -v "0 errors" > /dev/null
      then
	  $ECHO "Valgrind detected errors!"
	  $GREP "ERROR SUMMARY" $MYSQLTEST_LOG | $GREP -v "0 errors"
	  $ECHO "See $MYSQLTEST_LOG"
      fi
unknown's avatar
unknown committed
1107
    fi
unknown's avatar
unknown committed
1108
}
1109

unknown's avatar
unknown committed
1110
mysql_install_db () {
1111
    $ECHO "Removing Stale Files"
1112 1113 1114 1115 1116
    if [ -z "$USE_OLD_DATA" ]; then
      $RM -rf $MASTER_MYDDIR $MASTER_MYDDIR"1"
      $ECHO "Installing Master Databases"
      $INSTALL_DB
      if [ $? != 0 ]; then
1117
	error "Could not install master test DBs"
1118 1119
        exit 1
      fi
1120
    fi
unknown's avatar
unknown committed
1121 1122 1123 1124 1125 1126 1127 1128 1129
    if [ ! -z "$USE_NDBCLUSTER" ]
    then
      $ECHO "Installing Master Databases 1"
      $INSTALL_DB -1
      if [ $? != 0 ]; then
	error "Could not install master test DBs 1"
	exit 1
      fi
    fi
1130
    $ECHO "Installing Slave Databases"
1131
    $RM -rf $SLAVE_MYDDIR $MY_LOG_DIR/* 
1132
    $INSTALL_DB -slave
1133
    if [ $? != 0 ]; then
1134
	error "Could not install slave test DBs"
1135
	exit 1
unknown's avatar
unknown committed
1136
    fi
unknown's avatar
unknown committed
1137

1138 1139
    for slave_num in 1 2 ;
    do
1140
      $RM -rf var/slave$slave_num-data
1141 1142 1143
      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
1144
    done
unknown's avatar
unknown committed
1145 1146 1147
    return 0
}

unknown's avatar
unknown committed
1148 1149
gprof_prepare ()
{
unknown's avatar
unknown committed
1150 1151
 $RM -rf $GPROF_DIR
 mkdir -p $GPROF_DIR
unknown's avatar
unknown committed
1152 1153 1154 1155 1156
}

gprof_collect ()
{
 if [ -f $MASTER_MYDDIR/gmon.out ]; then
1157
   gprof $MASTER_MYSQLD $MASTER_MYDDIR/gmon.out > $GPROF_MASTER
unknown's avatar
unknown committed
1158 1159 1160
   echo "Master execution profile has been saved in $GPROF_MASTER"
 fi
 if [ -f $SLAVE_MYDDIR/gmon.out ]; then
1161
   gprof $SLAVE_MYSQLD $SLAVE_MYDDIR/gmon.out > $GPROF_SLAVE
unknown's avatar
unknown committed
1162 1163 1164 1165
   echo "Slave execution profile has been saved in $GPROF_SLAVE"
 fi
}

1166
gcov_prepare () {
unknown's avatar
unknown committed
1167 1168
    $FIND $BASEDIR -name \*.gcov \
    -or -name \*.da | $XARGS $RM
unknown's avatar
unknown committed
1169 1170 1171
}

gcov_collect () {
unknown's avatar
unknown committed
1172
    $ECHO "Collecting source coverage info..."
unknown's avatar
unknown committed
1173 1174
    [ -f $GCOV_MSG ] && $RM $GCOV_MSG
    [ -f $GCOV_ERR ] && $RM $GCOV_ERR
unknown's avatar
unknown committed
1175 1176 1177
    for d in $MYSQLD_SRC_DIRS; do
	cd $BASEDIR/$d
	for f in *.h *.cc *.c; do
unknown's avatar
unknown committed
1178
	    $GCOV $f 2>>$GCOV_ERR  >>$GCOV_MSG
unknown's avatar
unknown committed
1179
	done
1180
	cd $MYSQL_TEST_DIR
unknown's avatar
unknown committed
1181 1182
    done

unknown's avatar
unknown committed
1183
    $ECHO "gcov info in $GCOV_MSG, errors in $GCOV_ERR"
unknown's avatar
unknown committed
1184 1185
}

unknown's avatar
unknown committed
1186 1187 1188 1189 1190
abort_if_failed()
{
 if [ ! $? = 0 ] ; then
  echo $1
  exit 1
unknown's avatar
unknown committed
1191
 fi
unknown's avatar
unknown committed
1192 1193
}

1194
launch_in_background()
unknown's avatar
unknown committed
1195
{
1196
  shift
1197 1198
  echo $@ | /bin/sh  >> $CUR_MYERR 2>&1  &
  sleep 2 #hack
1199
  return
unknown's avatar
unknown committed
1200 1201
}

1202
shutdown_mysqld()
unknown's avatar
unknown committed
1203
{
1204 1205
  pid=$1
  ident=$2
1206 1207 1208 1209 1210 1211 1212 1213
  # Shutdown time must be high as slave may be in reconnect
  $MYSQLADMIN --no-defaults -uroot --socket=$MYSQL_TMP_DIR/$ident.sock$3 --connect_timeout=5 --shutdown_timeout=70 shutdown >> $MYSQL_MANAGER_LOG 2>&1
  res=$?
  # Some systems require an extra connect
  $MYSQLADMIN --no-defaults -uroot --socket=$MYSQL_TMP_DIR/$ident.sock$3 --connect_timeout=1 ping >> $MYSQL_MANAGER_LOG 2>&1
  if test $res = 0
  then
    wait_for_pid $pid
1214
  fi
1215
  return $res
unknown's avatar
unknown committed
1216 1217
}

1218 1219
start_ndbcluster()
{
unknown's avatar
unknown committed
1220 1221 1222 1223 1224 1225 1226
  if [ ! -n "$USE_NDBCLUSTER" ] ;
  then
    USING_NDBCLUSTER=0
    USE_NDBCLUSTER_OPT=
  fi
  
  if [ x$USING_NDBCLUSTER = x1 -a -z "$USE_NDBCLUSTER_OPT" ]
1227
  then
unknown's avatar
merge  
unknown committed
1228
  rm -f $NDB_TOOLS_OUTPUT
1229 1230
  if [ -z "$USE_RUNNING_NDBCLUSTER" ]
  then
unknown's avatar
unknown committed
1231
    if [ "$DO_BENCH" != 1 -a -z "$NDBCLUSTER_EXTRA_OPTS" ]
1232
    then
1233
      NDBCLUSTER_EXTRA_OPTS="--small"
1234
    fi
1235
    OPTS="$NDBCLUSTER_OPTS $NDBCLUSTER_EXTRA_OPTS --character-sets-dir=$CHARSETSDIR --verbose=$NDB_VERBOSE --initial --relative-config-data-dir --core"
1236 1237 1238
    if [ "x$NDB_VERBOSE" != "x0" ] ; then
      echo "Starting master ndbcluster " $OPTS
    fi
unknown's avatar
unknown committed
1239
    ./ndb/ndbcluster $OPTS || NDB_STATUS_OK=0
1240
    if [ x$NDB_STATUS_OK != x1 ] ; then
unknown's avatar
unknown committed
1241 1242 1243
      if [ x$FORCE != x1 ] ; then
        exit 1
      fi
unknown's avatar
unknown committed
1244 1245
      USING_NDBCLUSTER=0
      USE_NDBCLUSTER_OPT=
1246
      return
unknown's avatar
unknown committed
1247
    fi
1248

1249
    NDB_CONNECTSTRING="host=localhost:$NDBCLUSTER_PORT"
1250
  else
1251 1252
    NDB_CONNECTSTRING="$USE_RUNNING_NDBCLUSTER"
    echo "Using ndbcluster at $NDB_CONNECTSTRING"
1253
  fi
1254
  USE_NDBCLUSTER_OPT="$USE_NDBCLUSTER --ndb-connectstring=\"$NDB_CONNECTSTRING\" --ndb-extra-logging"
1255
  export NDB_CONNECTSTRING
1256 1257 1258
  fi
}

unknown's avatar
unknown committed
1259 1260
rm_ndbcluster_tables()
{
1261 1262
  $RM -f $1/cluster/apply_status*
  $RM -f $1/cluster/schema*
unknown's avatar
unknown committed
1263 1264
}

1265 1266
stop_ndbcluster()
{
unknown's avatar
unknown committed
1267
 if [ -n "$USE_NDBCLUSTER_OPT" ]
1268
 then
unknown's avatar
unknown committed
1269
 USE_NDBCLUSTER_OPT=
1270 1271 1272
 if [ -z "$USE_RUNNING_NDBCLUSTER" ]
 then
   # Kill any running ndbcluster stuff
unknown's avatar
unknown committed
1273
   $ECHO "Stopping master cluster"
1274
   ./ndb/ndbcluster $NDBCLUSTER_OPTS --stop
unknown's avatar
unknown committed
1275 1276 1277
   # remove ndb table the hard way as not to upset later tests
   rm_ndbcluster_tables $MASTER_MYDDIR
   rm_ndbcluster_tables $MASTER_MYDDIR"1"
1278 1279 1280 1281
 fi
 fi
}

unknown's avatar
unknown committed
1282 1283
# The embedded server needs the cleanup so we do some of the start work
# but stop before actually running mysqld or anything.
unknown's avatar
unknown committed
1284

unknown's avatar
unknown committed
1285 1286
start_master()
{
unknown's avatar
unknown committed
1287 1288
  eval "this_master_running=\$MASTER$1_RUNNING"
  if [ x$this_master_running = x1 ] || [ x$LOCAL_MASTER = x1 ] ; then
unknown's avatar
unknown committed
1289 1290
    return
  fi
unknown's avatar
unknown committed
1291 1292 1293
  # Remove stale binary logs except for 2 tests which need them
  if [ "$tname" != "rpl_crash_binlog_ib_1b" ] && [ "$tname" != "rpl_crash_binlog_ib_2b" ] && [ "$tname" != "rpl_crash_binlog_ib_3b" ] 
  then
unknown's avatar
unknown committed
1294
    $RM -f $MYSQL_TEST_DIR/var/log/master-bin$1.*
unknown's avatar
unknown committed
1295 1296
  fi

1297
  # Remove old master.info and relay-log.info files
unknown's avatar
unknown committed
1298
  $RM -f $MYSQL_TEST_DIR/var/master-data$1/master.info $MYSQL_TEST_DIR/var/master-data$1/relay-log.info
unknown's avatar
unknown committed
1299 1300 1301 1302 1303 1304 1305 1306

  #run master initialization shell script if one exists

  if [ -f "$master_init_script" ] ;
  then
      /bin/sh $master_init_script
  fi
  cd $BASEDIR # for gcov
unknown's avatar
unknown committed
1307 1308 1309
  if [ -n "$1" ] ; then
   id=`$EXPR $1 + 101`;
   this_master_myport=`$EXPR $MASTER_MYPORT + $1`
1310
   NOT_FIRST_MASTER_EXTRA_OPTS="--skip-innodb"
1311 1312
   eval "MASTER_MYPORT$1=$this_master_myport"
   export MASTER_MYPORT$1
unknown's avatar
unknown committed
1313 1314 1315
  else
   id=1;
   this_master_myport=$MASTER_MYPORT
1316
   NOT_FIRST_MASTER_EXTRA_OPTS=""
unknown's avatar
unknown committed
1317
  fi
1318 1319
  if [ -n "$EXTRA_MASTER_MYSQLD_TRACE" ] 
  then
1320
      CURR_MASTER_MYSQLD_TRACE="$EXTRA_MASTER_MYSQLD_TRACE$1"
1321
  fi
1322 1323
  if [ x$MASTER_MYSQLDBINLOG = x1 ]
  then
1324
    MASTER_MYSQLD_BINLOG_OPT="--log-bin=$MYSQL_TEST_DIR/var/log/master-bin$1"
1325
  fi
1326
  if [ -z "$DO_BENCH" -a -z "$DO_STRESS"  ]
unknown's avatar
unknown committed
1327
  then
1328
    master_args="--no-defaults \
unknown's avatar
unknown committed
1329
  	    --server-id=$id  \
1330
          --basedir=$MY_BASEDIR \
unknown's avatar
unknown committed
1331
          --port=$this_master_myport \
1332
          --port-open-timeout=380 \
unknown's avatar
unknown committed
1333
          --local-infile \
unknown's avatar
unknown committed
1334 1335
          --exit-info=256 \
          --core \
unknown's avatar
unknown committed
1336
          $USE_NDBCLUSTER_OPT \
unknown's avatar
unknown committed
1337 1338 1339 1340
          --datadir=$MASTER_MYDDIR$1 \
          --pid-file=$MASTER_MYPID$1 \
          --socket=$MASTER_MYSOCK$1 \
          --log=$MASTER_MYLOG$1 \
unknown's avatar
unknown committed
1341 1342 1343 1344
          --character-sets-dir=$CHARSETSDIR \
          --default-character-set=$CHARACTER_SET \
          --tmpdir=$MYSQL_TMP_DIR \
          --language=$LANGUAGE \
1345
          --innodb_data_file_path=ibdata1:128M:autoextend \
1346
	  --open-files-limit=1024 \
1347
          --log-bin-trust-function-creators \
1348
	   $MASTER_40_ARGS \
unknown's avatar
unknown committed
1349
           $SMALL_SERVER \
1350
           $MASTER_MYSQLD_BINLOG_OPT \
1351
           $EXTRA_MASTER_MYSQLD_OPT $EXTRA_MASTER_OPT \
1352
           $NOT_FIRST_MASTER_EXTRA_OPTS $CURR_MASTER_MYSQLD_TRACE"
unknown's avatar
unknown committed
1353
  else
1354
    master_args="--no-defaults \
unknown's avatar
unknown committed
1355
          --server-id=$id --rpl-recovery-rank=1 \
unknown's avatar
unknown committed
1356
          --basedir=$MY_BASEDIR --init-rpl-role=master \
unknown's avatar
unknown committed
1357
          --port=$this_master_myport \
1358
          --port-open-timeout=380 \
unknown's avatar
unknown committed
1359
          --local-infile \
unknown's avatar
unknown committed
1360 1361 1362
          --datadir=$MASTER_MYDDIR$1 \
          --pid-file=$MASTER_MYPID$1 \
          --socket=$MASTER_MYSOCK$1 \
unknown's avatar
unknown committed
1363 1364 1365
          --character-sets-dir=$CHARSETSDIR \
          --default-character-set=$CHARACTER_SET \
          --core \
unknown's avatar
unknown committed
1366
          $USE_NDBCLUSTER_OPT \
unknown's avatar
unknown committed
1367 1368
          --tmpdir=$MYSQL_TMP_DIR \
          --language=$LANGUAGE \
1369
          --innodb_data_file_path=ibdata1:128M:autoextend \
1370
          --log-bin-trust-function-creators \
1371
	   $MASTER_40_ARGS \
unknown's avatar
unknown committed
1372
           $SMALL_SERVER \
1373
           $MASTER_MYSQLD_BINLOG_OPT \
1374
           $EXTRA_MASTER_MYSQLD_OPT $EXTRA_MASTER_OPT \
1375
           $NOT_FIRST_MASTER_EXTRA_OPTS"
unknown's avatar
unknown committed
1376 1377
  fi

1378 1379
  CUR_MYERR=$MASTER_MYERR$1
  CUR_MYSOCK=$MASTER_MYSOCK$1
unknown's avatar
unknown committed
1380

unknown's avatar
unknown committed
1381 1382 1383 1384 1385 1386 1387 1388 1389 1390 1391 1392
  # For embedded server we collect the server flags and return
  if [ "x$USE_EMBEDDED_SERVER" = "x1" ] ; then
    # Add a -A to each argument to pass it to embedded server
    EMBEDDED_SERVER_OPTS=""
    for opt in $master_args
    do
      EMBEDDED_SERVER_OPTS="$EMBEDDED_SERVER_OPTS -A $opt"
    done
    EXTRA_MYSQL_TEST_OPT="$EMBEDDED_SERVER_OPTS"
    return
  fi

unknown's avatar
unknown committed
1393 1394
  if [ x$DO_DDD = x1 ]
  then
unknown's avatar
unknown committed
1395
    $ECHO "set args $master_args" > $GDB_MASTER_INIT$1
1396
    launch_in_background master ddd -display $DISPLAY --debugger \
unknown's avatar
unknown committed
1397
    "gdb -x $GDB_MASTER_INIT$1" $MASTER_MYSQLD
unknown's avatar
unknown committed
1398 1399
  elif [ x$DO_GDB = x1 ]
  then
unknown's avatar
unknown committed
1400 1401
    if [ x$MANUAL_GDB = x1 ]
    then
unknown's avatar
unknown committed
1402
      $ECHO "set args $master_args" > $GDB_MASTER_INIT$1
unknown's avatar
unknown committed
1403
      $ECHO "To start gdb for the master , type in another window:"
unknown's avatar
unknown committed
1404
      $ECHO "cd $CWD ; gdb -x $GDB_MASTER_INIT$1 $MASTER_MYSQLD"
unknown's avatar
unknown committed
1405 1406 1407 1408
      wait_for_master=1500
    else
      ( $ECHO set args $master_args;
      if [ $USE_MANAGER = 0 ] ; then
unknown's avatar
unknown committed
1409
    cat <<EOF
unknown's avatar
unknown committed
1410 1411
b mysql_parse
commands 1
1412
disa 1
unknown's avatar
unknown committed
1413
end
unknown's avatar
unknown committed
1414 1415
r
EOF
unknown's avatar
unknown committed
1416
      fi )  > $GDB_MASTER_INIT$1
1417
      launch_in_background master $XTERM -display $DISPLAY \
unknown's avatar
unknown committed
1418
      -title "Master" -e gdb -x $GDB_MASTER_INIT$1 $MASTER_MYSQLD
unknown's avatar
unknown committed
1419
    fi
unknown's avatar
unknown committed
1420
  else
1421
    launch_in_background master $MASTER_MYSQLD $master_args
unknown's avatar
unknown committed
1422
  fi
unknown's avatar
unknown committed
1423
  sleep_until_file_created $MASTER_MYPID$1 $wait_for_master
unknown's avatar
unknown committed
1424
  wait_for_master=$SLEEP_TIME_FOR_SECOND_MASTER
unknown's avatar
unknown committed
1425
  eval "MASTER$1_RUNNING=1"
unknown's avatar
unknown committed
1426 1427 1428 1429
}

start_slave()
{
unknown's avatar
unknown committed
1430 1431 1432
  [ x$SKIP_SLAVE = x1 ] && return
  eval "this_slave_running=\$SLAVE$1_RUNNING"
  [ x$this_slave_running = 1 ] && return
unknown's avatar
unknown committed
1433

unknown's avatar
unknown committed
1434 1435
  # When testing fail-safe replication, we will have more than one slave
  # in this case, we start secondary slaves with an argument
unknown's avatar
unknown committed
1436 1437 1438 1439 1440 1441 1442 1443
  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"
1444
   slave_datadir="$SLAVE_MYDDIR/../$slave_ident-data/"
unknown's avatar
unknown committed
1445 1446 1447 1448 1449 1450 1451 1452 1453 1454 1455 1456
   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
unknown's avatar
unknown committed
1457 1458 1459 1460 1461 1462 1463 1464 1465 1466 1467

  #
  if [ x$USING_NDBCLUSTER = x1 -a -n "$USE_NDBCLUSTER_SLAVE" ] ; then
    if [ $slave_server_id -eq 2 ] ; then
      savedir=`pwd`
      cd $MYSQL_TEST_DIR
      if [ "$DO_BENCH" != 1 -a -z "$NDBCLUSTER_EXTRA_OPTS" ]
       then
         NDBCLUSTER_EXTRA_OPTS="--small"
      fi

1468
      OPTS="$NDBCLUSTER_OPTS_SLAVE --initial $NDBCLUSTER_EXTRA_OPTS --ndbd-nodes=1 --verbose=$NDB_VERBOSE --relative-config-data-dir --core"
1469 1470 1471
      if [ "x$NDB_VERBOSE" != "x0" ] ; then
        echo "Starting slave ndbcluster " $OPTS
      fi
unknown's avatar
unknown committed
1472 1473 1474 1475 1476 1477 1478 1479 1480 1481 1482 1483 1484 1485 1486 1487 1488
      ./ndb/ndbcluster $OPTS \
                      || NDB_SLAVE_STATUS_OK=0
      #                > /dev/null 2>&1 || NDB_SLAVE_STATUS_OK=0
      cd $savedir
      if [ x$NDB_SLAVE_STATUS_OK != x1 ] ; then
        if [ x$FORCE != x1 ] ; then
          exit 1
        fi
        USE_NDBCLUSTER_SLAVE_OPT=
        USE_NDBCLUSTER_SLAVE=
      fi
      USE_NDBCLUSTER_SLAVE_OPT=$USE_NDBCLUSTER_SLAVE
    fi
  else
    USE_NDBCLUSTER_SLAVE_OPT=
  fi

unknown's avatar
unknown committed
1489
  # Remove stale binary logs and old master.info files
unknown's avatar
unknown committed
1490 1491 1492 1493 1494 1495
  # except for too tests which need them
  if [ "$tname" != "rpl_crash_binlog_ib_1b" ] && [ "$tname" != "rpl_crash_binlog_ib_2b" ] && [ "$tname" != "rpl_crash_binlog_ib_3b" ]
  then
    $RM -f $MYSQL_TEST_DIR/var/log/$slave_ident-*bin.*
    $RM -f $slave_datadir/master.info $slave_datadir/relay-log.info
  fi
unknown's avatar
unknown committed
1496 1497 1498 1499 1500 1501 1502 1503 1504 1505 1506

  #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 \
1507
          --master-password="" \
unknown's avatar
unknown committed
1508 1509 1510 1511 1512 1513
          --master-port=$MASTER_MYPORT \
          --server-id=$slave_server_id --rpl-recovery-rank=$slave_rpl_rank"
 else
   master_info=$SLAVE_MASTER_INFO
 fi

unknown's avatar
unknown committed
1514 1515
  if [ x$SLAVE_MYSQLDBINLOG = x1 ]
  then
1516
    SLAVE_MYSQLD_BINLOG_OPT="--log-bin=$MYSQL_TEST_DIR/var/log/$slave_ident-bin --log-slave-updates"
unknown's avatar
unknown committed
1517 1518
  fi

unknown's avatar
unknown committed
1519 1520 1521
  $RM -f $slave_datadir/log.*
  slave_args="--no-defaults $master_info \
  	    --exit-info=256 \
unknown's avatar
unknown committed
1522
          $SLAVE_MYSQLDBINLOG_OPT \
1523
          --relay-log=$MYSQL_TEST_DIR/var/log/$slave_ident-relay-bin \
unknown's avatar
unknown committed
1524 1525 1526 1527 1528
          --log=$slave_log \
          --basedir=$MY_BASEDIR \
          --datadir=$slave_datadir \
          --pid-file=$slave_pid \
          --port=$slave_port \
1529
          --port-open-timeout=380 \
unknown's avatar
unknown committed
1530 1531 1532 1533 1534 1535
          --socket=$slave_sock \
          --character-sets-dir=$CHARSETSDIR \
          --default-character-set=$CHARACTER_SET \
          --core --init-rpl-role=slave \
          --tmpdir=$MYSQL_TMP_DIR \
          --language=$LANGUAGE \
unknown's avatar
unknown committed
1536
          --skip-innodb --skip-ndbcluster --skip-slave-start \
unknown's avatar
unknown committed
1537 1538 1539
          --slave-load-tmpdir=$SLAVE_LOAD_TMPDIR \
          --report-host=127.0.0.1 --report-user=root \
          --report-port=$slave_port \
1540
          --master-retry-count=10 \
unknown's avatar
unknown committed
1541
          -O slave_net_timeout=10 \
1542
          --log-bin-trust-function-creators \
unknown's avatar
unknown committed
1543
           $SMALL_SERVER \
1544
           $SLAVE_MYSQLD_BINLOG_OPT \
unknown's avatar
unknown committed
1545 1546
           $EXTRA_SLAVE_MYSQLD_OPT $EXTRA_SLAVE_OPT \
           $USE_NDBCLUSTER_SLAVE_OPT"
unknown's avatar
unknown committed
1547 1548 1549 1550 1551
  CUR_MYERR=$slave_err
  CUR_MYSOCK=$slave_sock

  if [ x$DO_DDD = x1 ]
  then
1552
    $ECHO "set args $slave_args" > $GDB_SLAVE_INIT
1553
    launch_in_background $slave_ident ddd -display $DISPLAY --debugger \
unknown's avatar
unknown committed
1554 1555 1556
     "gdb -x $GDB_SLAVE_INIT" $SLAVE_MYSQLD
  elif [ x$DO_GDB = x1 ]
  then
unknown's avatar
unknown committed
1557 1558
    if [ x$MANUAL_GDB = x1 ]
    then
unknown's avatar
unknown committed
1559
      $ECHO "set args $slave_args" > $GDB_SLAVE_INIT
unknown's avatar
unknown committed
1560
      echo "To start gdb for the slave, type in another window:"
1561
      echo "cd $CWD ; gdb -x $GDB_SLAVE_INIT $SLAVE_MYSQLD"
unknown's avatar
unknown committed
1562 1563
      wait_for_slave=1500
    else
unknown's avatar
unknown committed
1564 1565 1566 1567 1568 1569 1570 1571 1572 1573
      ( $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
1574
      launch_in_background $slave_ident $XTERM -display $DISPLAY -title "Slave" -e \
unknown's avatar
unknown committed
1575 1576
      gdb -x $GDB_SLAVE_INIT $SLAVE_MYSQLD
    fi
unknown's avatar
unknown committed
1577
  else
1578
    launch_in_background $slave_ident $SLAVE_MYSQLD $slave_args
unknown's avatar
unknown committed
1579 1580
  fi
  eval "SLAVE$1_RUNNING=1"
1581
  sleep_until_file_created $slave_pid $wait_for_slave
unknown's avatar
unknown committed
1582
  wait_for_slave=$SLEEP_TIME_FOR_SECOND_SLAVE
unknown's avatar
unknown committed
1583 1584
}

unknown's avatar
unknown committed
1585 1586
mysql_start ()
{
unknown's avatar
unknown committed
1587
# We should not start the daemon here as we don't know the arguments
unknown's avatar
unknown committed
1588
# for the test.  Better to let the test start the daemon
unknown's avatar
unknown committed
1589 1590 1591 1592

#  $ECHO "Starting MySQL daemon"
#  start_master
#  start_slave
unknown's avatar
unknown committed
1593 1594
  cd $MYSQL_TEST_DIR
  return 1
unknown's avatar
unknown committed
1595 1596
}

unknown's avatar
unknown committed
1597 1598
stop_slave ()
{
1599 1600 1601
  eval "this_slave_running=\$SLAVE$1_RUNNING"
  slave_ident="slave$1"
  if [ -n "$1" ] ;
unknown's avatar
unknown committed
1602
  then
1603 1604 1605
   slave_pid="$MYRUN_DIR/mysqld-$slave_ident.pid"
  else
   slave_pid=$SLAVE_MYPID
unknown's avatar
unknown committed
1606
  fi
1607 1608
  if [ x$this_slave_running = x1 ]
  then
1609
    pid=`$CAT $slave_pid`
1610
    shutdown_mysqld $pid $slave_ident
1611
    if [ $? != 0 ] && [ -f $slave_pid ]
1612
    then # try harder!
1613
      $ECHO "slave not cooperating with mysqladmin, will try manual kill"
1614 1615
      kill $pid
      sleep_until_file_deleted $pid $slave_pid
1616 1617 1618 1619 1620 1621 1622 1623 1624
      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
unknown's avatar
unknown committed
1625
    fi
1626
    eval "SLAVE$1_RUNNING=0"
unknown's avatar
unknown committed
1627 1628 1629 1630 1631 1632 1633 1634
    if [ -n "$USE_NDBCLUSTER_SLAVE_OPT" ] ; then
      savedir=`pwd`
      cd $MYSQL_TEST_DIR
        $ECHO "Stopping slave cluster"
      ./ndb/ndbcluster $NDBCLUSTER_OPTS_SLAVE --stop
      rm_ndbcluster_tables $SLAVE_MYDDIR
      cd $savedir
    fi
unknown's avatar
unknown committed
1635
  fi
unknown's avatar
unknown committed
1636
}
unknown's avatar
unknown committed
1637

1638 1639 1640 1641 1642 1643 1644 1645 1646 1647
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
}

unknown's avatar
unknown committed
1648 1649
stop_master ()
{
unknown's avatar
unknown committed
1650 1651
  eval "this_master_running=\$MASTER$1_RUNNING"
  if [ x$this_master_running = x1 ]
unknown's avatar
unknown committed
1652
  then
unknown's avatar
unknown committed
1653 1654 1655
    # For embedded server we don't stop anyting but mark that
    # MASTER_RUNNING=0 to get cleanup when calling start_master().
    if [ x$USE_EMBEDDED_SERVER != x1 ] ; then
unknown's avatar
Merge  
unknown committed
1656
      pid=`$CAT $MASTER_MYPID$1`
1657
      shutdown_mysqld $pid master $1
unknown's avatar
Merge  
unknown committed
1658
      if [ $? != 0 ] && [ -f $MASTER_MYPID$1 ]
unknown's avatar
unknown committed
1659 1660 1661
      then # try harder!
	$ECHO "master not cooperating with mysqladmin, will try manual kill"
	kill $pid
unknown's avatar
Merge  
unknown committed
1662 1663
	sleep_until_file_deleted $pid $MASTER_MYPID$1
	if [ -f $MASTER_MYPID$1 ] ; then
unknown's avatar
unknown committed
1664
	  $ECHO "master refused to die. Sending SIGKILL"
unknown's avatar
Merge  
unknown committed
1665 1666
	  kill -9 `$CAT $MASTER_MYPID$1`
	  $RM -f $MASTER_MYPID$1
unknown's avatar
unknown committed
1667 1668 1669
	else
	  $ECHO "master responded to SIGTERM "
	fi
1670
      else
unknown's avatar
unknown committed
1671
	sleep $SLEEP_TIME_AFTER_RESTART
1672
      fi
unknown's avatar
unknown committed
1673
    fi
unknown's avatar
unknown committed
1674
    eval "MASTER$1_RUNNING=0"
unknown's avatar
unknown committed
1675 1676
  fi
}
unknown's avatar
unknown committed
1677

unknown's avatar
unknown committed
1678 1679
mysql_stop ()
{
1680 1681 1682 1683 1684 1685
  if [ "$MASTER_RUNNING" = 1 ]
  then
    $ECHO  "Ending Tests"
    $ECHO  "Shutting-down MySQL daemon"
    $ECHO  ""
    stop_master
unknown's avatar
unknown committed
1686
    stop_master 1
1687 1688 1689 1690 1691
    $ECHO "Master shutdown finished"
    stop_slave
    stop_slave 1
    stop_slave 2
    $ECHO "Slave shutdown finished"
unknown's avatar
unknown committed
1692
    stop_ndbcluster
1693 1694
  fi
  return 1
unknown's avatar
unknown committed
1695 1696
}

unknown's avatar
unknown committed
1697 1698 1699 1700 1701
mysql_restart ()
{
  mysql_stop
  mysql_start
  return 1
unknown's avatar
unknown committed
1702 1703 1704
}

mysql_loadstd () {
unknown's avatar
unknown committed
1705 1706

    # cp $STD_DATA/*.frm $STD_DATA/*.MRG $MASTER_MYDDIR/test
unknown's avatar
unknown committed
1707 1708 1709
    return 1
}

unknown's avatar
unknown committed
1710 1711 1712
run_testcase ()
{
 tf=$1
unknown's avatar
unknown committed
1713
 tname=`$BASENAME $tf .test`
unknown's avatar
unknown committed
1714 1715
 master_opt_file=$TESTDIR/$tname-master.opt
 slave_opt_file=$TESTDIR/$tname-slave.opt
1716 1717
 master_init_script=$TESTDIR/$tname-master.sh
 slave_init_script=$TESTDIR/$tname-slave.sh
1718
 slave_master_info_file=$TESTDIR/$tname.slave-mi
unknown's avatar
unknown committed
1719 1720
 tsrcdir=$TESTDIR/$tname-src
 result_file="r/$tname.result"
1721
 echo $tname > $CURRENT_TEST
1722
 SKIP_SLAVE=`$EXPR \( $tname : rpl \) = 0 \& \( $tname : federated \) = 0`
unknown's avatar
unknown committed
1723
 NDBCLUSTER_TEST=`$EXPR \( $tname : '.*ndb.*' \) != 0`
1724 1725 1726
 if [ "x$USE_NDBCLUSTER_ALL" = "x1" ] ; then
   NDBCLUSTER_TEST=1
 fi
1727 1728 1729 1730
 if [ "x$USE_NDBCLUSTER_ONLY" = "x1" -a "x$NDBCLUSTER_TEST" != "x1" ] ; then
   skip_test $tname
   return
 fi
1731
 if [ "$USE_MANAGER" = 1 ] ; then
unknown's avatar
unknown committed
1732
  many_slaves=`$EXPR \( \( $tname : rpl_failsafe \) != 0 \) \| \( \( $tname : rpl_chain_temp_table \) != 0 \)`
1733 1734 1735 1736
 fi
 if $EXPR "$tname" '<' "$START_FROM" > /dev/null ; then
   #skip_test $tname
   return
unknown's avatar
unknown committed
1737 1738
 fi

1739 1740 1741 1742
 if [ "$SKIP_TEST" ] ; then
   if $EXPR \( "$tname" : "$SKIP_TEST" \) > /dev/null ; then
     skip_test $tname
     return
unknown's avatar
unknown committed
1743
   fi
1744
 fi
1745

1746 1747
 if [ "$DO_TEST" ] ; then
   if $EXPR \( "$tname" : "$DO_TEST" \) > /dev/null ; then
unknown's avatar
unknown committed
1748
     : #empty command to keep some shells happy
1749 1750 1751
   else
     #skip_test $tname
     return
1752
   fi
1753
 fi
1754

1755 1756
 if [ x${NO_SLAVE}x$SKIP_SLAVE = x1x0 ] ; then
   skip_test $tname
1757 1758 1759
   return
 fi

unknown's avatar
unknown committed
1760 1761 1762 1763 1764 1765
# if [ -f "$TESTDIR/$tname.disabled" ]
# then
#   comment=`$CAT $TESTDIR/$tname.disabled`;
#   disable_test $tname "$comment"
#   return
# fi
unknown's avatar
unknown committed
1766 1767 1768 1769 1770 1771 1772 1773
 if [ -f "$TESTDIR/disabled.def" ] ; then
   comment=`$GREP "^$tname *: *" $TESTDIR/disabled.def`;
   if [ -n "$comment" ]
   then
     comment=`echo $comment | sed 's/^[^:]*: *//'`
     disable_test $tname "$comment"
     return
   fi
unknown's avatar
unknown committed
1774 1775
 fi

unknown's avatar
unknown committed
1776 1777 1778 1779 1780 1781 1782 1783 1784 1785 1786 1787
 if [ "x$USE_EMBEDDED_SERVER" != "x1" ] ; then
   # 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
 fi

 # FIXME temporary solution, we will get a new C version of this
 # script soon anyway so it is not worth it spending the time
 if [ "x$USE_EMBEDDED_SERVER" = "x1" -a -z "$DO_TEST" ] ; then
   for t in \
1788 1789
       "init_connect" \
       "init_file"
unknown's avatar
unknown committed
1790 1791 1792 1793 1794 1795 1796
   do
     if [ "$tname" = "$t" ] ; then
       skip_test $tname
       return
     fi
   done
 fi
1797

1798
 if [ $USE_RUNNING_SERVER -eq 0 ] ;
unknown's avatar
unknown committed
1799
 then
1800 1801
   if [ -f $master_opt_file ] ;
   then
unknown's avatar
unknown committed
1802
     EXTRA_MASTER_OPT=`$CAT $master_opt_file | $SED -e "s;\\$MYSQL_TEST_DIR;$MYSQL_TEST_DIR;"`
1803 1804 1805 1806 1807 1808 1809
     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=" "
	 ;;
1810 1811
       --result-file=*)
         result_file=`$ECHO "$EXTRA_MASTER_OPT" | $SED -e "s;--result-file=;;"`
unknown's avatar
unknown committed
1812
         result_file="r/$result_file.result"
1813 1814
         # Note that this must be set to space, not "" for test-reset to
# work
1815 1816
	 EXTRA_MASTER_OPT=" "
         ;;
1817
     esac
1818
     stop_master
unknown's avatar
unknown committed
1819
     stop_master 1
unknown's avatar
unknown committed
1820 1821 1822 1823 1824 1825 1826

     # only stop the cluster if this test will not use cluster
     if [ x$NDBCLUSTER_TEST != x1 ] ;
     then
       stop_ndbcluster
     fi

unknown's avatar
unknown committed
1827
     report_current_test $tname
unknown's avatar
unknown committed
1828 1829 1830
     USING_NDBCLUSTER=$NDBCLUSTER_TEST
     # start_ndbcluster knows if cluster is already started
     start_ndbcluster
1831
     start_master
unknown's avatar
unknown committed
1832
     if [ x$USING_NDBCLUSTER = x1 -a -z "$DO_BENCH" -a -z "$DO_STRESS" ] ; then
1833
       echo "CURRENT_TEST: $tname" >> $MASTER_MYERR"1"
unknown's avatar
unknown committed
1834 1835
       start_master 1
     fi
1836
     TZ=$MY_TZ; export TZ
1837
   else
unknown's avatar
unknown committed
1838 1839 1840 1841
     # If we had extra master opts to the previous run
     # or there is no master running (FIXME strange.....)
     # or there is a master init script
     if [ ! -z "$EXTRA_MASTER_OPT" ] || [ x$MASTER_RUNNING != x1 ] || \
unknown's avatar
unknown committed
1842 1843
	[ -f $master_init_script ] || \
        [ -n "$USE_NDBCLUSTER" -a x$NDBCLUSTER_TEST != x$USING_NDBCLUSTER ]
1844 1845 1846
     then
       EXTRA_MASTER_OPT=""
       stop_master
unknown's avatar
unknown committed
1847
       stop_master 1
unknown's avatar
unknown committed
1848 1849 1850 1851 1852 1853 1854

       # only stop the cluster if this test will not use cluster
       if [ x$NDBCLUSTER_TEST != x1 ] ;
       then
         stop_ndbcluster
       fi

unknown's avatar
unknown committed
1855
       report_current_test $tname
unknown's avatar
unknown committed
1856 1857 1858
       USING_NDBCLUSTER=$NDBCLUSTER_TEST
       # start_ndbcluster knows if cluster is already started
       start_ndbcluster
1859
       start_master
unknown's avatar
unknown committed
1860
       if [ x$USING_NDBCLUSTER = x1  -a -z "$DO_BENCH" -a -z "$DO_STRESS" ] ; then
1861
         echo "CURRENT_TEST: $tname" >> $MASTER_MYERR"1"
unknown's avatar
unknown committed
1862 1863
         start_master 1
       fi
unknown's avatar
unknown committed
1864
     else
unknown's avatar
unknown committed
1865
       report_current_test $tname
unknown's avatar
unknown committed
1866
     fi
1867
   fi
unknown's avatar
unknown committed
1868

unknown's avatar
unknown committed
1869 1870 1871 1872
   # We never start a slave if embedded server is used
   if [ "x$USE_EMBEDDED_SERVER" != "x1" ] ; then
     do_slave_restart=0
     if [ -f $slave_opt_file ] ;
1873
     then
unknown's avatar
unknown committed
1874
       EXTRA_SLAVE_OPT=`$CAT $slave_opt_file | $SED -e "s;\\$MYSQL_TEST_DIR;$MYSQL_TEST_DIR;"`
unknown's avatar
unknown committed
1875
       do_slave_restart=1
unknown's avatar
unknown committed
1876 1877 1878 1879 1880 1881
     else
      if [ ! -z "$EXTRA_SLAVE_OPT" ] || [ x$SLAVE_RUNNING != x1 ] ;
      then
	EXTRA_SLAVE_OPT=""
	do_slave_restart=1
      fi
unknown's avatar
unknown committed
1882
     fi
1883

unknown's avatar
unknown committed
1884 1885 1886 1887 1888 1889 1890 1891 1892 1893 1894
     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=""
	 do_slave_restart=1
       fi
     fi

unknown's avatar
unknown committed
1895 1896 1897 1898 1899 1900 1901 1902 1903 1904 1905 1906
     USING_NDBCLUSTER=$NDBCLUSTER_TEST
     if [ -n "$USE_NDBCLUSTER_SLAVE_OPT" ] ; then
       if [ x$USING_NDBCLUSTER != x1 ] ; then
         do_slave_restart=1
       fi
     else
       if [ x$USING_NDBCLUSTER = x1 ] ; then
         do_slave_restart=1
       fi
     fi


unknown's avatar
unknown committed
1907 1908 1909 1910 1911 1912 1913 1914 1915 1916 1917
     if [ x$do_slave_restart = x1 ] ; then
       stop_slave
       echo "CURRENT_TEST: $tname" >> $SLAVE_MYERR
       start_slave
     else
       echo "CURRENT_TEST: $tname" >> $SLAVE_MYERR
     fi
     if [ x$many_slaves = x1 ]; then
      start_slave 1
      start_slave 2
     fi
1918
   fi
unknown's avatar
fixed  
unknown committed
1919
 fi
1920 1921 1922 1923 1924 1925

 if [ "x$START_AND_EXIT" = "x1" ] ; then
  echo "Servers started, exiting"
  exit
 fi

1926
 cd $MYSQL_TEST_DIR
unknown's avatar
unknown committed
1927

unknown's avatar
unknown committed
1928
 if [ -f $tf ] ; then
unknown's avatar
unknown committed
1929
    $RM -f r/$tname.*reject
unknown's avatar
unknown committed
1930
    mysql_test_args="-R $result_file $EXTRA_MYSQL_TEST_OPT"
1931
    if [ -z "$DO_CLIENT_GDB" ] ; then
unknown's avatar
unknown committed
1932
      `$VALGRIND_MYSQLTEST $MYSQL_TEST  $mysql_test_args < $tf 2> $TIMEFILE`;
1933
    else
1934
      do_gdb_test "$mysql_test_args" "$tf"
1935
    fi
unknown's avatar
unknown committed
1936

unknown's avatar
unknown committed
1937 1938
    res=$?

unknown's avatar
unknown committed
1939 1940 1941 1942
    # Save the testcase log to mysqltest log file
    echo "CURRENT_TEST: $tname" >> $MYSQLTEST_LOG
    cat $TIMEFILE >> $MYSQLTEST_LOG

1943
    pname=`$ECHO "$tname                        "|$CUT -c 1-24`
1944
    RES="$pname"
unknown's avatar
unknown committed
1945

1946 1947 1948 1949
    if [ x$many_slaves = x1 ] ; then
     stop_slave 1
     stop_slave 2
    fi
unknown's avatar
unknown committed
1950

unknown's avatar
unknown committed
1951
    if [ $res = 0 ]; then
1952 1953
      total_inc
      pass_inc
unknown's avatar
unknown committed
1954
      TIMER=""
unknown's avatar
unknown committed
1955
      if [ x$USE_TIMER = x1 -a -f "$MY_LOG_DIR/timer" ]; then
unknown's avatar
unknown committed
1956 1957 1958 1959
	TIMER=`cat $MY_LOG_DIR/timer`
	TIMER=`$PRINTF "%13s" $TIMER`
      fi
      $ECHO "$RES$RES_SPACE [ pass ]   $TIMER"
1960
    else
1961
      # why the following ``if'' ? That is why res==1 is special ?
unknown's avatar
unknown committed
1962
      if [ $res = 62 ]; then
1963 1964 1965
        skip_inc
	$ECHO "$RES$RES_SPACE [ skipped ]"
      else
unknown's avatar
unknown committed
1966
        if [ $res -ne 1 ]; then
1967 1968
          $ECHO "mysqltest returned unexpected code $res, it has probably crashed" >> $TIMEFILE
        fi
1969
	total_inc
unknown's avatar
unknown committed
1970
        fail_inc
1971
	$ECHO "$RES$RES_SPACE [ fail ]"
1972 1973
        $ECHO
	error_is
unknown's avatar
unknown committed
1974
	show_failed_diff $tname
unknown's avatar
unknown committed
1975
	$ECHO
1976
	if [ x$FORCE != x1 ] ; then
unknown's avatar
unknown committed
1977
	 $ECHO "Aborting: $tname failed in $TEST_MODE mode. To continue, re-run with '--force'."
1978
	 $ECHO
1979
         if [ -z "$DO_GDB" ] && [ $USE_RUNNING_SERVER -eq 0 ] && \
unknown's avatar
unknown committed
1980
	    [ -z "$DO_DDD" ] && [ -z "$USE_EMBEDDED_SERVER" ]
unknown's avatar
unknown committed
1981 1982 1983
	 then
	   mysql_stop
   	 fi
1984 1985
	 exit 1
	fi
unknown's avatar
unknown committed
1986
	FAILED_CASES="$FAILED_CASES $tname"
1987
        if [ -z "$DO_GDB" ] && [ $USE_RUNNING_SERVER -eq 0 ] && \
unknown's avatar
unknown committed
1988
	   [ -z "$DO_DDD" ] && [ -z "$USE_EMBEDDED_SERVER" ]
unknown's avatar
unknown committed
1989 1990 1991
	then
	  mysql_restart
	fi
1992
      fi
unknown's avatar
unknown committed
1993
    fi
1994
  fi
unknown's avatar
unknown committed
1995 1996
}

1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029
run_stress_test()
{

  STRESS_BASEDIR="$MYSQL_TEST_DIR/var/stress"

  #Clean-up old stress test basedir
  if [ -d $STRESS_BASEDIR ] ; then 
    $RM -rf $STRESS_BASEDIR
  fi
  #Create stress test basedir 
  mkdir $STRESS_BASEDIR

  if [ "$STRESS_SUITE" != "main" -a "$STRESS_SUITE" != "default" ] ; then
    STRESS_SUITE_DIR="$MYSQL_TEST_DIR/suite/$STRESS_SUITE"
  else
    STRESS_SUITE_DIR="$MYSQL_TEST_DIR"
  fi

  if [ -d "$STRESS_SUITE_DIR" ] ; then 
    STRESS_SUITE_T_DIR="$STRESS_SUITE_DIR/t"
    STRESS_SUITE_R_DIR="$STRESS_SUITE_DIR/r"
    #FIXME: check that dirs above are exist
  else
    echo "Directory $STRESS_SUITE_DIR with test suite doesn't exists. Abort stress testing"
    exit 1
  fi
  
  if [ -n "$STRESS_TEST" ] ; then 
    STRESS_TEST_FILE="$STRESS_BASEDIR/stress_tests.txt"
    echo $STRESS_TEST > $STRESS_TEST_FILE
  elif [ -n "$STRESS_TEST_FILE" ] ; then    
    STRESS_TEST_FILE="$STRESS_SUITE_DIR/$STRESS_TEST_FILE"
    if [ ! -f  "$STRESS_TEST_FILE" ] ; then 
unknown's avatar
unknown committed
2030 2031
      echo "Specified file $STRESS_TEST_FILE with list of tests does not exist"
      echo "Please ensure that file exists and has proper permissions"
2032 2033 2034 2035 2036
      exit 1
    fi
  else 
    STRESS_TEST_FILE="$STRESS_SUITE_DIR/stress_tests.txt"
    if [ ! -f  "$STRESS_TEST_FILE" ] ; then 
unknown's avatar
unknown committed
2037 2038 2039
      echo "Default file $STRESS_TEST_FILE with list of tests does not exist."
      echo "Please use --stress-test-file option to specify custom one or you can" 
      echo "just specify name of test for testing as last argument in command line"
2040 2041 2042 2043 2044 2045 2046
      exit 1
    fi
  fi

  if [ -n "$STRESS_INIT_FILE" ] ; then 
    STRESS_INIT_FILE="$STRESS_SUITE_DIR/$STRESS_INIT_FILE"
    if [ ! -f  "$STRESS_INIT_FILE" ] ; then 
unknown's avatar
unknown committed
2047 2048
      echo "Specified file $STRESS_INIT_FILE with list of tests doesn't exist."
      echo "Please ensure that file exists and has proper permissions"
2049 2050 2051 2052 2053 2054 2055 2056 2057 2058 2059
      exit 1
    fi
  else
    STRESS_INIT_FILE="$STRESS_SUITE_DIR/stress_init.txt"
    #Check for default init file
    if [ ! -f "$STRESS_INIT_FILE" ] ; then 
      STRESS_INIT_FILE=""
    fi
  fi

  if [ "$STRESS_MODE" != "random" -a "$STRESS_MODE" != "seq" ] ; then
unknown's avatar
unknown committed
2060 2061
    echo "You specified wrong mode '$STRESS_MODE' for stress test."
    echo "Correct values are 'random' or 'seq'"
2062 2063 2064 2065 2066 2067 2068 2069 2070 2071 2072 2073
    exit 1
  fi
 
  STRESS_TEST_ARGS="--server-socket=$MASTER_MYSOCK \
                    --server-user=$DBUSER \
                    --server-database=$DB \
                    --stress-suite-basedir=$MYSQL_TEST_DIR \
                    --suite=$STRESS_SUITE \
                    --stress-tests-file=$STRESS_TEST_FILE \
                    --stress-basedir=$STRESS_BASEDIR \
                    --server-logs-dir=$STRESS_BASEDIR \
                    --stress-mode=$STRESS_MODE \
2074
                    --mysqltest=$CLIENT_BINDIR/mysqltest \
2075 2076 2077 2078 2079 2080 2081 2082 2083 2084
                    --threads=$STRESS_THREADS \
                    --verbose \
                    --cleanup \
                    --log-error-details \
                    --abort-on-error" 
  
  if [ -n "$STRESS_INIT_FILE" ] ; then 
    STRESS_TEST_ARGS="$STRESS_TEST_ARGS --stress-init-file=$STRESS_INIT_FILE"
  fi

2085 2086 2087 2088 2089 2090 2091 2092
  if [ -z "$STRESS_LOOP_COUNT" -a -z  "$STRESS_TEST_COUNT" -a 
       -z "$STRESS_TEST_DURATION" ] ; then 

    #Limit stress testing with 20 loops in case when any limit parameter
    #was specified
    STRESS_TEST_COUNT=20
  fi

2093 2094 2095 2096 2097 2098 2099 2100 2101 2102 2103 2104 2105 2106 2107 2108 2109 2110 2111 2112 2113 2114 2115 2116 2117 2118 2119 2120 2121 2122 2123
  if [ -n "$STRESS_LOOP_COUNT" ] ; then 
    STRESS_TEST_ARGS="$STRESS_TEST_ARGS --loop-count=$STRESS_LOOP_COUNT"
  fi

  if [ -n "$STRESS_TEST_COUNT" ] ; then 
    STRESS_TEST_ARGS="$STRESS_TEST_ARGS --test-count=$STRESS_TEST_COUNT"
  fi

  if [ -n "$STRESS_TEST_DURATION" ] ; then 
    STRESS_TEST_ARGS="$STRESS_TEST_ARGS --test-duration=$STRESS_TEST_DURATION"
  fi  

  echo "Stress test related variables:"
  echo "TESTS                - $1"
  echo "STRESS               - $DO_STRESS"
  echo "STRESS_SUITE         - $STRESS_SUITE"
  echo "STRESS_TEST_FILE     - $STRESS_TEST_FILE"
  echo "STRESS_INIT_FILE     - $STRESS_INIT_FILE"
  echo "STRESS_THREADS       - $STRESS_THREADS"
  echo "STRESS_MODE          - $STRESS_MODE"
  echo "STRESS_TEST_COUNT    - $STRESS_TEST_COUNT"
  echo "STRESS_LOOP_COUNT    - $STRESS_LOOP_COUNT"  
  echo "STRESS_TEST_DURATION - $STRESS_TEST_DURATION"

  #echo "$STRESS_TEST_ARGS";
  #Run stress test 
  $MYSQL_TEST_DIR/mysql-stress-test.pl $STRESS_TEST_ARGS


}

unknown's avatar
unknown committed
2124 2125 2126 2127
######################################################################
# Main script starts here
######################################################################

unknown's avatar
unknown committed
2128 2129
[ "$DO_GCOV" -a ! -x "$GCOV" ] && error "No gcov found"

unknown's avatar
unknown committed
2130 2131
[ "$DO_GCOV" ] && gcov_prepare
[ "$DO_GPROF" ] && gprof_prepare
unknown's avatar
unknown committed
2132

2133
if [ $USE_RUNNING_SERVER -eq 0 ]
2134
then
2135 2136 2137 2138
  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
2139
    $MYSQLADMIN --no-defaults --socket=$MASTER_MYSOCK1 -u root -O connect_timeout=5 -O shutdown_timeout=20 shutdown > /dev/null 2>&1
2140
    $MYSQLADMIN --no-defaults --socket=$SLAVE_MYSOCK -u root -O connect_timeout=5 -O shutdown_timeout=20 shutdown > /dev/null 2>&1
unknown's avatar
unknown committed
2141 2142 2143 2144
    $MYSQLADMIN --no-defaults --host=$hostname --port=$MASTER_MYPORT --protocol=tcp -u root -O connect_timeout=5 -O shutdown_timeout=20 shutdown > /dev/null 2>&1
    $MYSQLADMIN --no-defaults --host=$hostname --protocol=tcp --port=`expr $MASTER_MYPORT+1` -u root -O connect_timeout=5 -O shutdown_timeout=20 shutdown > /dev/null 2>&1
    $MYSQLADMIN --no-defaults --host=$hostname --protocol=tcp --port=$SLAVE_MYPORT -u root -O connect_timeout=5 -O shutdown_timeout=20 shutdown > /dev/null 2>&1
    $MYSQLADMIN --no-defaults --host=$hostname --protocol=tcp --port=`expr $SLAVE_MYPORT + 1` -u root -O connect_timeout=5 -O shutdown_timeout=20 shutdown > /dev/null 2>&1
2145
    sleep_until_file_deleted 0 $MASTER_MYPID
2146
    sleep_until_file_deleted 0 $MASTER_MYPID"1"
2147 2148
    sleep_until_file_deleted 0 $SLAVE_MYPID
  else
2149
    rm $MASTER_MYPID $MASTER_MYPID"1" $SLAVE_MYPID
2150
  fi
unknown's avatar
unknown committed
2151

unknown's avatar
unknown committed
2152 2153
  # just to force stopping anything from previous runs
  USE_NDBCLUSTER_OPT=$USE_NDBCLUSTER
unknown's avatar
unknown committed
2154
  stop_ndbcluster
unknown's avatar
unknown committed
2155

unknown's avatar
unknown committed
2156
  # Remove files that can cause problems
2157
  $RM -rf $MYSQL_TEST_DIR/var/ndbcluster
unknown's avatar
unknown committed
2158 2159
  $RM -f $MYSQL_TEST_DIR/var/run/* $MYSQL_TEST_DIR/var/tmp/*

2160 2161
  # Remove old berkeley db log files that can confuse the server
  $RM -f $MASTER_MYDDIR/log.*
unknown's avatar
unknown committed
2162
  $RM -f $MASTER_MYDDIR"1"/log.*
2163

unknown's avatar
unknown committed
2164 2165
  wait_for_master=$SLEEP_TIME_FOR_FIRST_MASTER
  wait_for_slave=$SLEEP_TIME_FOR_FIRST_SLAVE
2166 2167
  $ECHO "Installing Test Databases"
  mysql_install_db
unknown's avatar
unknown committed
2168

unknown's avatar
unknown committed
2169 2170
  if [ -n "$1" -a `expr "X$*" : '.*ndb'` -eq 0 ]
  then
unknown's avatar
unknown committed
2171 2172
    USING_NDBCLUSTER=0
    USE_NDBCLUSTER_OPT=
unknown's avatar
unknown committed
2173 2174
  fi

2175 2176
# Do not automagically start daemons if we are in gdb or running only one
# test case
2177 2178 2179 2180 2181 2182
  if [ -z "$DO_GDB" ] && [ -z "$DO_DDD" ]
  then
    mysql_start
  fi
  $ECHO  "Loading Standard Test Databases"
  mysql_loadstd
unknown's avatar
unknown committed
2183 2184
fi

2185
$ECHO  "Starting Tests"
unknown's avatar
unknown committed
2186

2187 2188 2189
# Some test cases need USE_RUNNING_SERVER
export USE_RUNNING_SERVER

2190 2191 2192
#
# This can probably be deleted
#
unknown's avatar
unknown committed
2193 2194
if [ "$DO_BENCH" = 1 ]
then
2195 2196
  start_master

2197 2198 2199 2200 2201
  if [ "$DO_SMALL_BENCH" = 1 ]
  then
    EXTRA_BENCH_ARGS="--small-test --small-tables"
  fi

unknown's avatar
unknown committed
2202
  if [ x$USING_NDBCLUSTER = x1 ]
2203
  then
2204
    EXTRA_BENCH_ARGS="--create-options=TYPE=ndb $EXTRA_BENCH_ARGS"
2205 2206
  fi 

unknown's avatar
unknown committed
2207 2208 2209 2210
  BENCHDIR=$BASEDIR/sql-bench/
  savedir=`pwd`
  cd $BENCHDIR
  if [ -z "$1" ]
unknown's avatar
unknown committed
2211
  then
2212
    ./run-all-tests --socket=$MASTER_MYSOCK --user=root $EXTRA_BENCH_ARGS --log
unknown's avatar
unknown committed
2213
  else
unknown's avatar
unknown committed
2214 2215
    if [ -x "./$1" ]
    then
2216
       ./$1 --socket=$MASTER_MYSOCK --user=root $EXTRA_BENCH_ARGS
unknown's avatar
unknown committed
2217 2218 2219
    else
      echo "benchmark $1 not found"
    fi
unknown's avatar
unknown committed
2220
  fi
unknown's avatar
unknown committed
2221 2222 2223
  cd $savedir
  mysql_stop
  exit
unknown's avatar
unknown committed
2224 2225
fi

2226 2227 2228 2229 2230 2231 2232 2233 2234 2235 2236 2237 2238 2239 2240 2241 2242 2243 2244 2245 2246 2247 2248 2249 2250
#
# Stress testing
#
if [ "$DO_STRESS" = 1 ] 
then

  if [ -n "$1" ] ; then
    STRESS_TEST="$1";
  fi                      
 
  if [ $USE_RUNNING_SERVER -eq 0 ] ; then 
    start_master
  fi
 
  run_stress_test

  if [ $USE_RUNNING_SERVER -eq 0 ] ; then
    mysql_stop
  fi
  
  exit

fi


unknown's avatar
unknown committed
2251
$ECHO
unknown's avatar
unknown committed
2252
if [ x$USE_TIMER = x1 ] ; then
unknown's avatar
unknown committed
2253
$ECHO "TEST                            RESULT        TIME (ms)"
unknown's avatar
unknown committed
2254 2255 2256
else
$ECHO "TEST                            RESULT"
fi
unknown's avatar
unknown committed
2257 2258
$ECHO $DASH72

unknown's avatar
unknown committed
2259
if [ -z "$1" ] ;
unknown's avatar
unknown committed
2260
then
2261 2262 2263
  if [ x$RECORD = x1 ]; then
    $ECHO "Will not run in record mode without a specific test case."
  else
2264 2265 2266 2267
    for tf in $TESTDIR/*.$TESTSUFFIX
    do
      run_testcase $tf
    done
2268 2269
    $RM -f $TIMEFILE	# Remove for full test
  fi
unknown's avatar
unknown committed
2270
else
unknown's avatar
unknown committed
2271 2272 2273 2274 2275 2276 2277 2278 2279 2280
  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
unknown's avatar
unknown committed
2281
fi
unknown's avatar
unknown committed
2282

unknown's avatar
unknown committed
2283 2284
$ECHO $DASH72
$ECHO
2285

2286
if [ -z "$DO_GDB" ] && [ $USE_RUNNING_SERVER -eq 0 ] && [ -z "$DO_DDD" ]
unknown's avatar
unknown committed
2287 2288 2289
then
    mysql_stop
fi
unknown's avatar
unknown committed
2290
report_stats
unknown's avatar
unknown committed
2291
$ECHO
unknown's avatar
unknown committed
2292

unknown's avatar
unknown committed
2293
[ "$DO_GCOV" ] && gcov_collect # collect coverage information
unknown's avatar
unknown committed
2294
[ "$DO_GPROF" ] && gprof_collect # collect coverage information
unknown's avatar
unknown committed
2295

unknown's avatar
unknown committed
2296
if [ $TOT_FAIL -ne 0 ]; then
unknown's avatar
unknown committed
2297
  $ECHO "mysql-test-run in $TEST_MODE mode: *** Failing the test(s):$FAILED_CASES"
unknown's avatar
unknown committed
2298 2299 2300
  $ECHO
  exit 1
fi
unknown's avatar
unknown committed
2301 2302 2303 2304
if [ $GOT_WARNINGS -ne 0 ]; then
  exit 1
fi
exit 0