mysql-test-run.sh 60.4 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

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

22
# For query_cache test
unknown's avatar
unknown committed
23
case `uname` in
24 25 26
    SCO_SV | UnixWare | OpenUNIX )
        # do nothing (Causes strange behavior)
        ;;
unknown's avatar
unknown committed
27 28 29
    QNX)
        # do nothing (avoid error message)
        ;;
30 31 32 33
    * )
        ulimit -n 1024
        ;;
esac
34

35 36 37 38
#++
# Program Definitions
#--

unknown's avatar
unknown committed
39 40
LC_COLLATE=C
export LC_COLLATE
41
PATH=/bin:/usr/bin:/usr/local/bin:/usr/bsd:/usr/X11R6/bin:/usr/openwin/bin:/usr/bin/X11:$PATH
42
MASTER_40_ARGS="--rpl-recovery-rank=1 --init-rpl-role=master"
43

44 45 46 47
# Standard functions

which ()
{
48
  IFS="${IFS=   }"; save_ifs="$IFS"; IFS=':'
49 50
  for file
  do
51
    for dir in $PATH
52
    do
unknown's avatar
unknown committed
53
      if test -f $dir/$file
54 55 56 57 58
      then
        echo "$dir/$file"
        continue 2
      fi
    done
59
    echo "Fatal error: Cannot find program $file in $PATH" 1>&2
60 61
    exit 1
  done
62
  IFS="$save_ifs"
63
  exit 0
64 65 66
}


unknown's avatar
unknown committed
67 68
sleep_until_file_deleted ()
{
69 70
  pid=$1;
  file=$2
unknown's avatar
unknown committed
71
  loop=$SLEEP_TIME_FOR_DELETE
unknown's avatar
unknown committed
72 73
  while (test $loop -gt 0)
  do
unknown's avatar
unknown committed
74
    if [ ! -r $file ]
unknown's avatar
unknown committed
75
    then
76 77 78 79
      if test $pid != "0"
      then
        wait_for_pid $pid
      fi
unknown's avatar
unknown committed
80 81
      return
    fi
unknown's avatar
unknown committed
82
    sleep 1
unknown's avatar
unknown committed
83 84 85 86
    loop=`expr $loop - 1`
  done
}

87
sleep_until_file_created ()
unknown's avatar
unknown committed
88 89
{
  file=$1
unknown's avatar
unknown committed
90 91
  loop=$2
  org_time=$2
unknown's avatar
unknown committed
92 93
  while (test $loop -gt 0)
  do
unknown's avatar
unknown committed
94
    if [ -r $file ]
unknown's avatar
unknown committed
95
    then
96
      return 0
unknown's avatar
unknown committed
97
    fi
unknown's avatar
unknown committed
98
    sleep 1
unknown's avatar
unknown committed
99 100
    loop=`expr $loop - 1`
  done
unknown's avatar
unknown committed
101
  echo "ERROR: $file was not created in $org_time seconds;  Aborting"
unknown's avatar
unknown committed
102 103 104
  exit 1;
}

105 106 107 108 109
# For the future

wait_for_pid()
{
  pid=$1
unknown's avatar
unknown committed
110
  #$WAIT_PID pid $SLEEP_TIME_FOR_DELETE
111 112
}

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

unknown's avatar
unknown committed
115 116
SED=sed

117 118
BASENAME=`which basename`
if test $? != 0; then exit 1; fi
unknown's avatar
unknown committed
119
DIFF=`which diff | $SED q`
120
if test $? != 0; then exit 1; fi
121 122
CAT=cat
CUT=cut
unknown's avatar
unknown committed
123
HEAD=head
124 125 126 127
TAIL=tail
ECHO=echo # use internal echo if possible
EXPR=expr # use internal if possible
FIND=find
unknown's avatar
unknown committed
128
GREP=grep
129
if test $? != 0; then exit 1; fi
130 131
PRINTF=printf
RM=rm
132
if test $? != 0; then exit 1; fi
133
TR=tr
134 135
XARGS=`which xargs`
if test $? != 0; then exit 1; fi
136
SORT=sort
137 138 139 140 141

# Are we using a source or a binary distribution?

testdir=@testdir@
if [ -d bin/mysqld ] && [ -d mysql-test ] ; then
142 143
 cd mysql-test
else
144 145
 if [ -d $testdir/mysql-test ] ; then
   cd $testdir
146
 fi
147 148 149 150 151 152 153
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
154
  exit 1
155
fi
156

unknown's avatar
unknown committed
157 158 159
#++
# Misc. Definitions
#--
160

161 162 163 164 165
if [ -d ../sql ] ; then
   SOURCE_DIST=1
else
   BINARY_DIST=1
fi
166

unknown's avatar
unknown committed
167
#BASEDIR is always one above mysql-test directory
unknown's avatar
unknown committed
168 169 170 171
CWD=`pwd`
cd ..
BASEDIR=`pwd`
cd $CWD
172
MYSQL_TEST_DIR=$BASEDIR/mysql-test
unknown's avatar
unknown committed
173
MYSQL_TEST_WINDIR=$MYSQL_TEST_DIR
174 175
MYSQLTEST_VARDIR=$MYSQL_TEST_DIR/var
export MYSQL_TEST_DIR MYSQL_TEST_WINDIR MYSQLTEST_VARDIR
176
STD_DATA=$MYSQL_TEST_DIR/std_data
unknown's avatar
unknown committed
177
hostname=`hostname`		# Installed in the mysql privilege table
unknown's avatar
unknown committed
178

unknown's avatar
unknown committed
179
MANAGER_QUIET_OPT="-q"
180
TESTDIR="$MYSQL_TEST_DIR/t"
unknown's avatar
unknown committed
181
TESTSUFFIX=test
182
TOT_SKIP=0
unknown's avatar
unknown committed
183 184 185
TOT_PASS=0
TOT_FAIL=0
TOT_TEST=0
186 187 188
USERT=0
SYST=0
REALT=0
189
FAST_START=""
unknown's avatar
unknown committed
190
MYSQL_TMP_DIR=$MYSQL_TEST_DIR/var/tmp
unknown's avatar
unknown committed
191
SLAVE_LOAD_TMPDIR=../../var/tmp #needs to be same length to test logging
unknown's avatar
unknown committed
192
RES_SPACE="      "
193
MYSQLD_SRC_DIRS="strings mysys include extra regex myisam \
unknown's avatar
unknown committed
194
 myisammrg heap sql"
195
MY_LOG_DIR="$MYSQL_TEST_DIR/var/log" 
196 197 198
#
# Set LD_LIBRARY_PATH if we are using shared libraries
#
199 200
LD_LIBRARY_PATH="$BASEDIR/lib:$BASEDIR/libmysql/.libs:$BASEDIR/zlib/.libs:$LD_LIBRARY_PATH"
DYLD_LIBRARY_PATH="$BASEDIR/lib:$BASEDIR/libmysql/.libs:$BASEDIR/zlib/.libs:$DYLD_LIBRARY_PATH"
unknown's avatar
unknown committed
201
export LD_LIBRARY_PATH DYLD_LIBRARY_PATH
202

unknown's avatar
unknown committed
203 204 205 206 207 208 209
#
# 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
210
MASTER_RUNNING=0
unknown's avatar
unknown committed
211
MASTER1_RUNNING=0
212
MASTER_MYPORT=9306
unknown's avatar
fixed  
unknown committed
213
SLAVE_RUNNING=0
unknown's avatar
unknown committed
214
SLAVE_MYPORT=9308 # leave room for 2 masters for cluster tests
unknown's avatar
unknown committed
215
MYSQL_MANAGER_PORT=9305 # needs to be out of the way of slaves
216
NDBCLUSTER_PORT=9350
unknown's avatar
unknown committed
217 218 219
MYSQL_MANAGER_PW_FILE=$MYSQL_TEST_DIR/var/tmp/manager.pwd
MYSQL_MANAGER_LOG=$MYSQL_TEST_DIR/var/log/manager.log
MYSQL_MANAGER_USER=root
unknown's avatar
unknown committed
220 221 222 223 224 225 226

#
# 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.
#
if [ -n "$MTR_BUILD_THREAD" ] ; then
227
  MASTER_MYPORT=`expr $MTR_BUILD_THREAD '*' 5 + 10000`
unknown's avatar
unknown committed
228
  MYSQL_MANAGER_PORT=`expr $MASTER_MYPORT + 2`
229 230
  SLAVE_MYPORT=`expr $MASTER_MYPORT + 3`
  NDBCLUSTER_PORT=`expr $MASTER_MYPORT + 4`
unknown's avatar
unknown committed
231 232 233 234 235

  echo "Using MTR_BUILD_THREAD   = $MTR_BUILD_THREAD"
  echo "Using MASTER_MYPORT      = $MASTER_MYPORT"
  echo "Using MYSQL_MANAGER_PORT = $MYSQL_MANAGER_PORT"
  echo "Using SLAVE_MYPORT       = $SLAVE_MYPORT"
236
  echo "Using NDBCLUSTER_PORT    = $NDBCLUSTER_PORT"
unknown's avatar
unknown committed
237 238
fi

239
NO_SLAVE=0
unknown's avatar
unknown committed
240
USER_TEST=
unknown's avatar
unknown committed
241
FAILED_CASES=
242

243
EXTRA_MASTER_OPT=""
244
EXTRA_MYSQL_TEST_OPT=""
245
EXTRA_MYSQLCHECK_OPT=""
246
EXTRA_MYSQLDUMP_OPT=""
247
EXTRA_MYSQLSHOW_OPT=""
248
EXTRA_MYSQLBINLOG_OPT=""
249
USE_RUNNING_SERVER=0
250
USE_NDBCLUSTER=@USE_NDBCLUSTER@
unknown's avatar
unknown committed
251
USE_RUNNING_NDBCLUSTER=""
unknown's avatar
unknown committed
252 253
USE_PURIFY=""
PURIFY_LOGS=""
254 255
DO_GCOV=""
DO_GDB=""
unknown's avatar
unknown committed
256
MANUAL_GDB=""
257
DO_DDD=""
258
DO_CLIENT_GDB=""
259
DO_VALGRIND_MYSQL_TEST=""
unknown's avatar
unknown committed
260
SLEEP_TIME_AFTER_RESTART=1
unknown's avatar
unknown committed
261
SLEEP_TIME_FOR_DELETE=10
unknown's avatar
unknown committed
262
SLEEP_TIME_FOR_FIRST_MASTER=400		# Enough time to create innodb tables
unknown's avatar
unknown committed
263
SLEEP_TIME_FOR_SECOND_MASTER=400
unknown's avatar
unknown committed
264
SLEEP_TIME_FOR_FIRST_SLAVE=400
265
SLEEP_TIME_FOR_SECOND_SLAVE=300
unknown's avatar
unknown committed
266
CHARACTER_SET=latin1
267
DBUSER=""
268 269
START_WAIT_TIMEOUT=10
STOP_WAIT_TIMEOUT=10
unknown's avatar
unknown committed
270
MYSQL_TEST_SSL_OPTS=""
unknown's avatar
unknown committed
271
USE_TIMER=""
unknown's avatar
unknown committed
272
USE_EMBEDDED_SERVER=""
unknown's avatar
unknown committed
273
TEST_MODE=""
274

275
NDB_MGM_EXTRA_OPTS=
276 277 278
NDB_MGMD_EXTRA_OPTS=
NDBD_EXTRA_OPTS=

unknown's avatar
unknown committed
279
DO_STRESS=""
280 281 282 283 284 285 286 287 288 289
STRESS_SUITE="main"
STRESS_MODE="random"
STRESS_THREADS=5
STRESS_TEST_COUNT=20
STRESS_LOOP_COUNT=""
STRESS_TEST_DURATION=""
STRESS_INIT_FILE=""
STRESS_TEST_FILE=""
STRESS_TEST=""

290 291
while test $# -gt 0; do
  case "$1" in
unknown's avatar
unknown committed
292 293 294
    --embedded-server)
      USE_EMBEDDED_SERVER=1
      USE_MANAGER=0 NO_SLAVE=1
unknown's avatar
unknown committed
295
      USE_RUNNING_SERVER=0
unknown's avatar
unknown committed
296 297 298 299
      TEST_MODE="$TEST_MODE embedded" ;;
    --purify)
      USE_PURIFY=1
      USE_MANAGER=0
unknown's avatar
unknown committed
300
      USE_RUNNING_SERVER=0
unknown's avatar
unknown committed
301
      TEST_MODE="$TEST_MODE purify" ;;
302 303
    --user=*) DBUSER=`$ECHO "$1" | $SED -e "s;--user=;;"` ;;
    --force)  FORCE=1 ;;
unknown's avatar
unknown committed
304
    --timer)  USE_TIMER=1 ;;
unknown's avatar
unknown committed
305
    --verbose-manager)  MANAGER_QUIET_OPT="" ;;
306 307 308 309 310
    --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=;;"` ;;
311 312
    --local)   USE_RUNNING_SERVER=0 ;;
    --extern)  USE_RUNNING_SERVER=1 ;;
unknown's avatar
unknown committed
313
    --with-ndbcluster)
314
      USE_NDBCLUSTER="--ndbcluster" ;;
unknown's avatar
unknown committed
315
    --ndb-connectstring=*)
316
      USE_NDBCLUSTER="--ndbcluster" ;
unknown's avatar
unknown committed
317
      USE_RUNNING_NDBCLUSTER=`$ECHO "$1" | $SED -e "s;--ndb-connectstring=;;"` ;;
318 319
    --ndb_mgm-extra-opts=*)
      NDB_MGM_EXTRA_OPTS=`$ECHO "$1" | $SED -e "s;--ndb_mgm-extra-opts=;;"` ;;
320 321 322 323
    --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=;;"` ;;
324
    --tmpdir=*) MYSQL_TMP_DIR=`$ECHO "$1" | $SED -e "s;--tmpdir=;;"` ;;
325 326 327 328 329
    --local-master)
      MASTER_MYPORT=3306;
      EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT --host=127.0.0.1 \
      --port=$MYSQL_MYPORT"
      LOCAL_MASTER=1 ;;
330 331
    --master_port=*) MASTER_MYPORT=`$ECHO "$1" | $SED -e "s;--master_port=;;"` ;;
    --slave_port=*) SLAVE_MYPORT=`$ECHO "$1" | $SED -e "s;--slave_port=;;"` ;;
unknown's avatar
unknown committed
332
    --manager-port=*) MYSQL_MANAGER_PORT=`$ECHO "$1" | $SED -e "s;--manager_port=;;"` ;;
333
    --ndbcluster_port=*) NDBCLUSTER_PORT=`$ECHO "$1" | $SED -e "s;--ndbcluster_port=;;"` ;;
unknown's avatar
unknown committed
334 335
    --with-openssl)
     EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT \
336 337 338
     --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
339
     EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT \
340 341 342
     --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
343
     MYSQL_TEST_SSL_OPTS="--ssl-ca=$MYSQL_TEST_DIR/std_data/cacert.pem \
344 345
     --ssl-cert=$MYSQL_TEST_DIR/std_data/client-cert.pem \
     --ssl-key=$MYSQL_TEST_DIR/std_data/client-key.pem" ;;
unknown's avatar
unknown committed
346
    --no-manager | --skip-manager) USE_MANAGER=0 ;;
347 348
    --manager)
     USE_MANAGER=1
349
     USE_RUNNING_SERVER=0
350
     ;;
351 352
    --start-and-exit)
     START_AND_EXIT=1
unknown's avatar
unknown committed
353
     ;;
354
    --socket=*) LOCAL_SOCKET=`$ECHO "$1" | $SED -e "s;--socket=;;"` ;;
355
    --skip-rpl) NO_SLAVE=1 ;;
unknown's avatar
unknown committed
356
    --skip-test=*) SKIP_TEST=`$ECHO "$1" | $SED -e "s;--skip-test=;;"`;;
357
    --do-test=*) DO_TEST=`$ECHO "$1" | $SED -e "s;--do-test=;;"`;;
358
    --start-from=* ) START_FROM=`$ECHO "$1" | $SED -e "s;--start-from=;;"` ;;
359 360 361 362
    --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
363 364 365
    --wait-timeout=*)
     START_WAIT_TIMEOUT=`$ECHO "$1" | $SED -e "s;--wait-timeout=;;"`
     STOP_WAIT_TIMEOUT=$START_WAIT_TIMEOUT;;
366 367 368
    --record)
      RECORD=1;
      EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT $1" ;;
369 370 371 372 373
    --small-bench)
      DO_SMALL_BENCH=1
      DO_BENCH=1
      NO_SLAVE=1
      ;;
unknown's avatar
unknown committed
374 375 376
    --bench)
      DO_BENCH=1
      NO_SLAVE=1
unknown's avatar
unknown committed
377
      ;;
378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406
    --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=;;"`
      ;;
407 408
    --big*)			# Actually --big-test
      EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT $1" ;;
unknown's avatar
unknown committed
409 410
    --compress)
      EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT $1" ;;
411 412
    --sleep=*)
      EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT $1"
unknown's avatar
unknown committed
413
      SLEEP_TIME_AFTER_RESTART=`$ECHO "$1" | $SED -e "s;--sleep=;;"`
414
      ;;
415
    --ps-protocol)
unknown's avatar
unknown committed
416
      TEST_MODE="$TEST_MODE ps-protocol" EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT $1" ;;
unknown's avatar
unknown committed
417 418 419
    --user-test=*)
      USER_TEST=`$ECHO "$1" | $SED -e "s;--user-test=;;"`
      ;;
420
    --mysqld=*)
unknown's avatar
unknown committed
421
       TMP=`$ECHO "$1" | $SED -e "s;--mysqld=;;"`
unknown's avatar
unknown committed
422
       EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT $TMP"
423
       EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT $TMP"
424
       ;;
425 426 427 428 429 430
    --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
431
      GCOV=`which gcov`
432
      ;;
unknown's avatar
unknown committed
433 434
    --gprof )
      DO_GPROF=1
unknown's avatar
unknown committed
435
      ;;
436
    --gdb )
unknown's avatar
unknown committed
437 438
      START_WAIT_TIMEOUT=300
      STOP_WAIT_TIMEOUT=300
439
      if [ x$BINARY_DIST = x1 ] ; then
440
	$ECHO "Note: you will get more meaningful output on a source distribution compiled with debugging option when running tests with --gdb option"
441 442
      fi
      DO_GDB=1
443 444
      EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --gdb"
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --gdb"
unknown's avatar
unknown committed
445 446
      # This needs to be checked properly
      # USE_MANAGER=1
447
      USE_RUNNING_SERVER=0
448
      ;;
449 450 451 452 453
    --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
454 455
      EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --gdb"
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --gdb"
456
      ;;
unknown's avatar
unknown committed
457 458 459
    --manual-gdb )
      DO_GDB=1
      MANUAL_GDB=1
460
      USE_RUNNING_SERVER=0
461 462
      EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --gdb"
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --gdb"
unknown's avatar
unknown committed
463
      ;;
464 465
    --ddd )
      if [ x$BINARY_DIST = x1 ] ; then
466
	$ECHO "Note: you will get more meaningful output on a source distribution compiled with debugging option when running tests with --ddd option"
467 468
      fi
      DO_DDD=1
469
      USE_RUNNING_SERVER=0
470 471
      EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --gdb"
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --gdb"
472
      ;;
473
    --valgrind | --valgrind-all)
unknown's avatar
unknown committed
474 475 476
      VALGRIND=`which valgrind` # this will print an error if not found
      # Give good warning to the user and stop
      if [ -z "$VALGRIND" ] ; then
477
        $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 ."
unknown's avatar
unknown committed
478 479
        exit 1
      fi
480 481
      # >=2.1.2 requires the --tool option, some versions write to stdout, some to stderr
      valgrind --help 2>&1 | grep "\-\-tool" > /dev/null && VALGRIND="$VALGRIND --tool=memcheck"
482
      VALGRIND="$VALGRIND --alignment=8 --leak-check=yes --num-callers=16 --suppressions=$CWD/valgrind.supp"
483 484
      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
485
      SLEEP_TIME_AFTER_RESTART=10
486
      SLEEP_TIME_FOR_DELETE=60
487
      USE_RUNNING_SERVER=0
488 489 490 491
      if test "$1" = "--valgrind-all"
      then
        VALGRIND="$VALGRIND -v --show-reachable=yes"
      fi
unknown's avatar
unknown committed
492 493 494 495 496
      ;;
    --valgrind-options=*)
      TMP=`$ECHO "$1" | $SED -e "s;--valgrind-options=;;"`
      VALGRIND="$VALGRIND $TMP"
      ;;
497 498 499
    --valgrind-mysqltest)
      DO_VALGRIND_MYSQL_TEST=1
      ;;
500
    --skip-ndbcluster | --skip-ndb)
unknown's avatar
unknown committed
501
      USE_NDBCLUSTER=""
unknown's avatar
unknown committed
502 503
      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
504
      ;;
505 506 507 508
    --skip-*)
      EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT $1"
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT $1"
      ;;
unknown's avatar
unknown committed
509 510
    --strace-client )
      STRACE_CLIENT=1
unknown's avatar
unknown committed
511
      ;;
512
    --debug)
513
      EXTRA_MASTER_MYSQLD_TRACE=" \
unknown's avatar
unknown committed
514
       --debug=d:t:i:A,$MYSQL_TEST_DIR/var/log/master.trace"
515
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT \
unknown's avatar
unknown committed
516
       --debug=d:t:i:A,$MYSQL_TEST_DIR/var/log/slave.trace"
517 518
      EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT \
       --debug=d:t:A,$MYSQL_TEST_DIR/var/log/mysqltest.trace"
519 520
      EXTRA_MYSQLCHECK_OPT="$EXTRA_MYSQLCHECK_OPT \
       --debug=d:t:A,$MYSQL_TEST_DIR/var/log/mysqlcheck.trace"
521 522
      EXTRA_MYSQLDUMP_OPT="$EXTRA_MYSQLDUMP_OPT \
       --debug=d:t:A,$MYSQL_TEST_DIR/var/log/mysqldump.trace"
523 524
      EXTRA_MYSQLSHOW_OPT="$EXTRA_MYSQLSHOW_OPT \
       --debug=d:t:A,$MYSQL_TEST_DIR/var/log/mysqlshow.trace"
525 526
      EXTRA_MYSQLBINLOG_OPT="$EXTRA_MYSQLBINLOG_OPT \
       --debug=d:t:A,$MYSQL_TEST_DIR/var/log/mysqlbinlog.trace"
unknown's avatar
unknown committed
527
      EXTRA_MYSQL_CLIENT_TEST_OPT="--debug=d:t:A,$MYSQL_TEST_DIR/var/log/mysql_client_test.trace"
528
      ;;
529 530 531
    --fast)
      FAST_START=1
      ;;
532 533 534
    --use-old-data)
      USE_OLD_DATA=1;
      ;;
535 536 537 538 539 540
    -- )  shift; break ;;
    --* ) $ECHO "Unrecognized option: $1"; exit 1 ;;
    * ) break ;;
  esac
  shift
done
unknown's avatar
fixed  
unknown committed
541

unknown's avatar
unknown committed
542 543 544 545 546 547 548
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
549 550 551
#++
# mysqld Environment Parameters
#--
552

unknown's avatar
unknown committed
553
MYRUN_DIR=$MYSQL_TEST_DIR/var/run
554 555
MANAGER_PID_FILE="$MYRUN_DIR/manager.pid"

556
MASTER_MYDDIR="$MYSQL_TEST_DIR/var/master-data"
unknown's avatar
unknown committed
557
MASTER_MYSOCK="$MYSQL_TMP_DIR/master.sock"
unknown's avatar
unknown committed
558
MASTER_MYSOCK1=$MYSQL_MYSOCK"1"
unknown's avatar
unknown committed
559 560 561
MASTER_MYPID="$MYRUN_DIR/master.pid"
MASTER_MYLOG="$MYSQL_TEST_DIR/var/log/master.log"
MASTER_MYERR="$MYSQL_TEST_DIR/var/log/master.err"
562 563

SLAVE_MYDDIR="$MYSQL_TEST_DIR/var/slave-data"
unknown's avatar
unknown committed
564
SLAVE_MYSOCK="$MYSQL_TMP_DIR/slave.sock"
unknown's avatar
unknown committed
565 566 567
SLAVE_MYPID="$MYRUN_DIR/slave.pid"
SLAVE_MYLOG="$MYSQL_TEST_DIR/var/log/slave.log"
SLAVE_MYERR="$MYSQL_TEST_DIR/var/log/slave.err"
568

569
CURRENT_TEST="$MYSQL_TEST_DIR/var/log/current_test"
570
SMALL_SERVER="--key_buffer_size=1M --sort_buffer=256K --max_heap_table_size=1M"
571

572
export MASTER_MYPORT SLAVE_MYPORT MYSQL_TCP_PORT MASTER_MYSOCK MASTER_MYSOCK1
unknown's avatar
unknown committed
573

574
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"
575
NDB_BACKUP_DIR=$MYSQL_TEST_DIR/var/ndbcluster-$NDBCLUSTER_PORT
576
NDB_TOOLS_OUTPUT=$MYSQL_TEST_DIR/var/log/ndb_tools.log
577

578 579 580 581
if [ x$SOURCE_DIST = x1 ] ; then
 MY_BASEDIR=$MYSQL_TEST_DIR
else
 MY_BASEDIR=$BASEDIR
unknown's avatar
unknown committed
582
fi
unknown's avatar
unknown committed
583

unknown's avatar
unknown committed
584 585 586 587 588 589 590 591
# 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
592
[ -d $MYSQL_TEST_DIR/var/log ] || mkdir $MYSQL_TEST_DIR/var/log
unknown's avatar
unknown committed
593 594
ln -s $MYSQL_TEST_DIR/std_data $MYSQL_TEST_DIR/var/std_data_ln
 
595
if test ${COLUMNS:-0} -lt 80 ; then COLUMNS=80 ; fi
596
E=`$EXPR $COLUMNS - 8`
unknown's avatar
unknown committed
597
DASH72=`$ECHO '-------------------------------------------------------'|$CUT -c 1-$E`
598

599 600 601
# 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
602
 if [ "x$USE_EMBEDDED_SERVER" = "x1" ] ; then
603 604
   if [ -f "$BASEDIR/libmysqld/examples/mysqltest_embedded" ] ; then
     MYSQL_TEST="$VALGRIND $BASEDIR/libmysqld/examples/mysqltest_embedded"
unknown's avatar
unknown committed
605
   else
606
     echo "Fatal error: Cannot find embedded server 'mysqltest_embedded'" 1>&2
unknown's avatar
unknown committed
607 608
     exit 1
   fi
609
   MYSQL_CLIENT_TEST="$BASEDIR/libmysqld/examples/mysql_client_test_embedded"
610
 else
unknown's avatar
unknown committed
611 612 613 614
   MYSQLD="$BASEDIR/sql/mysqld"
   if [ -n "$VALGRIND" ] ; then
     MYSQLD="$VALGRIND $MYSQLD"
   fi
unknown's avatar
unknown committed
615 616 617 618 619 620 621
   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
622
   MYSQL_CLIENT_TEST="$BASEDIR/tests/mysql_client_test"
623
 fi
624 625 626 627 628
 if [ -f "$BASEDIR/client/.libs/mysqlcheck" ] ; then
   MYSQL_CHECK="$BASEDIR/client/.libs/mysqlcheck"
 else
   MYSQL_CHECK="$BASEDIR/client/mysqlcheck"
 fi
629
 if [ -f "$BASEDIR/client/.libs/mysqldump" ] ; then
unknown's avatar
unknown committed
630
   MYSQL_DUMP="$BASEDIR/client/.libs/mysqldump"
631
 else
unknown's avatar
unknown committed
632
   MYSQL_DUMP="$BASEDIR/client/mysqldump"
633
 fi
unknown's avatar
unknown committed
634 635 636 637 638
 if [ -f "$BASEDIR/client/.libs/mysqlimport" ] ; then
   MYSQL_IMPORT="$BASEDIR/client/.libs/mysqlimport"
 else
   MYSQL_IMPORT="$BASEDIR/client/mysqlimport"
 fi
639 640 641 642 643
 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
644
 if [ -f "$BASEDIR/client/.libs/mysqlbinlog" ] ; then
unknown's avatar
unknown committed
645
   MYSQL_BINLOG="$BASEDIR/client/.libs/mysqlbinlog"
unknown's avatar
unknown committed
646
 else
unknown's avatar
unknown committed
647
   MYSQL_BINLOG="$BASEDIR/client/mysqlbinlog"
unknown's avatar
unknown committed
648
 fi
unknown's avatar
unknown committed
649 650 651
 if [ -n "$STRACE_CLIENT" ]; then
  MYSQL_TEST="strace -o $MYSQL_TEST_DIR/var/log/mysqltest.strace $MYSQL_TEST"
 fi
unknown's avatar
unknown committed
652

unknown's avatar
unknown committed
653 654
 CLIENT_BINDIR="$BASEDIR/client"
 MYSQLADMIN="$CLIENT_BINDIR/mysqladmin"
unknown's avatar
unknown committed
655
 WAIT_PID="$BASEDIR/extra/mysql_waitpid"
656
 MYSQL_MY_PRINT_DEFAULTS="$BASEDIR/extra/my_print_defaults"
657 658 659
 MYSQL_MANAGER_CLIENT="$CLIENT_BINDIR/mysqltestmanagerc"
 MYSQL_MANAGER="$BASEDIR/tools/mysqltestmanager"
 MYSQL_MANAGER_PWGEN="$CLIENT_BINDIR/mysqltestmanager-pwgen"
unknown's avatar
unknown committed
660
 MYSQL="$CLIENT_BINDIR/mysql"
661
 LANGUAGE="$BASEDIR/sql/share/english/"
662
 CHARSETSDIR="$BASEDIR/sql/share/charsets"
663
 INSTALL_DB="./install_test_db"
664
 MYSQL_FIX_SYSTEM_TABLES="$BASEDIR/scripts/mysql_fix_privilege_tables"
665
 NDB_TOOLS_DIR="$BASEDIR/ndb/tools"
666
 NDB_MGM="$BASEDIR/ndb/src/mgmclient/ndb_mgm"
unknown's avatar
unknown committed
667 668

 if [ -n "$USE_PURIFY" ] ; then
unknown's avatar
unknown committed
669
   PSUP="$MYSQL_TEST_DIR/suppress.purify"
unknown's avatar
unknown committed
670 671 672 673 674 675 676 677 678 679 680 681 682 683 684 685 686 687 688
   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

689
else
690 691 692 693 694 695 696 697

 # 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".

698 699
 if test -x "$BASEDIR/libexec/mysqld"
 then
unknown's avatar
unknown committed
700
   MYSQLD="$VALGRIND $BASEDIR/libexec/mysqld"
701
 else
unknown's avatar
unknown committed
702
   MYSQLD="$VALGRIND $BASEDIR/bin/mysqld"
703
 fi
unknown's avatar
unknown committed
704
 CLIENT_BINDIR="$BASEDIR/bin"
705 706 707 708 709 710
 if test -d "$BASEDIR/tests"
 then
   TESTS_BINDIR="$BASEDIR/tests"
 else
   TESTS_BINDIR="$BASEDIR/bin"
 fi
unknown's avatar
unknown committed
711
 MYSQL_TEST="$CLIENT_BINDIR/mysqltest"
712
 MYSQL_CHECK="$CLIENT_BINDIR/mysqlcheck"
unknown's avatar
unknown committed
713
 MYSQL_DUMP="$CLIENT_BINDIR/mysqldump"
714
 MYSQL_SHOW="$CLIENT_BINDIR/mysqlshow"
unknown's avatar
unknown committed
715
 MYSQL_IMPORT="$CLIENT_BINDIR/mysqlimport"
unknown's avatar
unknown committed
716 717 718
 MYSQL_BINLOG="$CLIENT_BINDIR/mysqlbinlog"
 MYSQLADMIN="$CLIENT_BINDIR/mysqladmin"
 WAIT_PID="$CLIENT_BINDIR/mysql_waitpid"
719
 MYSQL_MY_PRINT_DEFAULTS="$CLIENT_BINDIR/my_print_defaults"
720 721 722
 MYSQL_MANAGER="$CLIENT_BINDIR/mysqltestmanager"
 MYSQL_MANAGER_CLIENT="$CLIENT_BINDIR/mysqltestmanagerc"
 MYSQL_MANAGER_PWGEN="$CLIENT_BINDIR/mysqltestmanager-pwgen"
unknown's avatar
unknown committed
723
 MYSQL="$CLIENT_BINDIR/mysql"
724
 INSTALL_DB="./install_test_db --bin"
unknown's avatar
unknown committed
725
 MYSQL_FIX_SYSTEM_TABLES="$CLIENT_BINDIR/mysql_fix_privilege_tables"
726
 NDB_TOOLS_DIR="$CLIENT_BINDIR"
727
 NDB_MGM="$CLIENT_BINDIR/ndb_mgm"
unknown's avatar
unknown committed
728
 if test -d "$BASEDIR/share/mysql/english"
729 730
 then
   LANGUAGE="$BASEDIR/share/mysql/english/"
731
   CHARSETSDIR="$BASEDIR/share/mysql/charsets"
732 733
 else
   LANGUAGE="$BASEDIR/share/english/"
734
   CHARSETSDIR="$BASEDIR/share/charsets"
735 736 737 738 739 740 741 742 743 744 745 746 747 748
 fi
 if [ "x$USE_EMBEDDED_SERVER" = "x1" ] ; then
   if [ -f "$CLIENT_BINDIR/mysqltest_embedded" ] ; then
     MYSQL_TEST="$VALGRIND $CLIENT_BINDIR/mysqltest_embedded"
   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
749
   MYSQL_TEST="$VALGRIND_MYSQLTEST $CLIENT_BINDIR/mysqltest"
750 751
   MYSQL_CLIENT_TEST="$CLIENT_BINDIR/mysql_client_test"
 fi
752 753
fi

754 755 756 757 758 759 760 761 762 763
if [ -z "$MASTER_MYSQLD" ]
then
MASTER_MYSQLD=$MYSQLD
fi

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

764 765 766 767
if [ x$DO_VALGRIND_MYSQL_TEST = x1 ] ; then
  MYSQL_TEST="$VALGRIND $MYSQL_TEST"
fi

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

unknown's avatar
unknown committed
770
if [ -z "$1" -a -z "$DO_STRESS" ]
771
then
772
   USE_RUNNING_SERVER=0
773
fi
774
if [ $USE_RUNNING_SERVER -eq 1 ]
775
then
776
   MASTER_MYSOCK=$LOCAL_SOCKET;
777
   DBUSER=${DBUSER:-test}
778
else
779
   DBUSER=${DBUSER:-root}		# We want to do FLUSH xxx commands
780
fi
781 782 783

if [ -w / ]
then
unknown's avatar
unknown committed
784 785 786
  # 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"
787 788
fi

unknown's avatar
unknown committed
789
MYSQL_CLIENT_TEST="$MYSQL_CLIENT_TEST --no-defaults --testcase --user=root --socket=$MASTER_MYSOCK --port=$MYSQL_TCP_PORT --silent $EXTRA_MYSQL_CLIENT_TEST_OPT"
790 791 792 793 794 795
# 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
796 797 798
# Save path and name of mysqldump
MYSQL_DUMP_DIR="$MYSQL_DUMP"
export MYSQL_DUMP_DIR
799
MYSQL_CHECK="$MYSQL_CHECK --no-defaults -uroot --socket=$MASTER_MYSOCK --password=$DBPASSWD $EXTRA_MYSQLCHECK_OPT"
800
MYSQL_DUMP="$MYSQL_DUMP --no-defaults -uroot --socket=$MASTER_MYSOCK --password=$DBPASSWD $EXTRA_MYSQLDUMP_OPT"
801
MYSQL_SHOW="$MYSQL_SHOW -uroot --socket=$MASTER_MYSOCK --password=$DBPASSWD $EXTRA_MYSQLSHOW_OPT"
802
MYSQL_BINLOG="$MYSQL_BINLOG --no-defaults --local-load=$MYSQL_TMP_DIR  --character-sets-dir=$CHARSETSDIR $EXTRA_MYSQLBINLOG_OPT"
unknown's avatar
unknown committed
803
MYSQL_IMPORT="$MYSQL_IMPORT -uroot --socket=$MASTER_MYSOCK --password=$DBPASSWD $EXTRA_MYSQLDUMP_OPT"
804
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
805
MYSQL="$MYSQL --no-defaults --host=localhost --port=$MASTER_MYPORT --socket=$MASTER_MYSOCK --user=root --password=$DBPASSWD"
806
export MYSQL MYSQL_CHECK MYSQL_DUMP MYSQL_SHOW MYSQL_BINLOG MYSQL_FIX_SYSTEM_TABLES MYSQL_IMPORT
807
export CLIENT_BINDIR MYSQL_CLIENT_TEST CHARSETSDIR MYSQL_MY_PRINT_DEFAULTS
808
export NDB_TOOLS_DIR
809
export NDB_MGM
810
export NDB_BACKUP_DIR
811
export NDB_TOOLS_OUTPUT
unknown's avatar
unknown committed
812
export PURIFYOPTIONS
813 814
NDB_STATUS_OK=1
export NDB_STATUS_OK
815

816
MYSQL_TEST_ARGS="--no-defaults --socket=$MASTER_MYSOCK --database=$DB \
817
 --user=$DBUSER --password=$DBPASSWD --silent -v --skip-safemalloc \
unknown's avatar
unknown committed
818
 --tmpdir=$MYSQL_TMP_DIR --port=$MASTER_MYPORT $MYSQL_TEST_SSL_OPTS"
unknown's avatar
unknown committed
819 820 821
if [ x$USE_TIMER = x1 ] ; then
  MYSQL_TEST_ARGS="$MYSQL_TEST_ARGS --timer-file=$MY_LOG_DIR/timer"
fi
822 823
MYSQL_TEST_BIN=$MYSQL_TEST
MYSQL_TEST="$MYSQL_TEST $MYSQL_TEST_ARGS"
824
export MYSQL_TEST
825
GDB_CLIENT_INIT=$MYSQL_TMP_DIR/gdbinit.client
826 827 828
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
829 830 831 832
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
833
TIMEFILE="$MYSQL_TEST_DIR/var/log/mysqltest-time"
834 835 836
if [ -n "$DO_CLIENT_GDB" -o -n "$DO_GDB" ] ; then
  XTERM=`which xterm`
fi
837

838
export MYSQL MYSQL_CHECK MYSQL_DUMP MYSQL_SHOW MYSQL_BINLOG MYSQL_FIX_SYSTEM_TABLES CLIENT_BINDIR MASTER_MYSOCK
unknown's avatar
unknown committed
839

unknown's avatar
unknown committed
840 841 842 843
#++
# Function Definitions
#--

unknown's avatar
unknown committed
844 845
prompt_user ()
{
846
 $ECHO $1
847
 read unused
unknown's avatar
unknown committed
848 849
}

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

unknown's avatar
unknown committed
852 853 854 855
show_failed_diff ()
{
  reject_file=r/$1.reject
  result_file=r/$1.result
856
  eval_file=r/$1.eval
unknown's avatar
unknown committed
857

858 859 860 861
  if [ -f $eval_file ]
  then
    result_file=$eval_file
  fi
unknown's avatar
unknown committed
862

unknown's avatar
unknown committed
863 864 865 866
  if [ -x "$DIFF" ] && [ -f $reject_file ]
  then
    echo "Below are the diffs between actual and expected results:"
    echo "-------------------------------------------------------"
unknown's avatar
unknown committed
867
    $DIFF -c $result_file $reject_file
unknown's avatar
unknown committed
868
    echo "-------------------------------------------------------"
869
    echo "Please follow the instructions outlined at"
870
    echo "http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html"
871
    echo "to find the reason to this problem and how to report this."
872
    echo ""
unknown's avatar
unknown committed
873
  fi
unknown's avatar
unknown committed
874
}
unknown's avatar
unknown committed
875

876 877 878 879 880 881
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
882
  $XTERM -title "Client" -e gdb -x $GDB_CLIENT_INIT $MYSQL_TEST_BIN
883 884
}

unknown's avatar
unknown committed
885
error () {
unknown's avatar
unknown committed
886
    $ECHO  "Error:  $1"
unknown's avatar
unknown committed
887 888 889
    exit 1
}

890
error_is () {
891 892
    $ECHO "Errors are (from $TIMEFILE) :"
    $CAT < $TIMEFILE
893
    $ECHO "(the last lines may be the most important ones)"
894 895
}

unknown's avatar
unknown committed
896
prefix_to_8() {
897
 $ECHO "        $1" | $SED -e 's:.*\(........\)$:\1:'
unknown's avatar
unknown committed
898 899
}

unknown's avatar
unknown committed
900
pass_inc () {
unknown's avatar
unknown committed
901
    TOT_PASS=`$EXPR $TOT_PASS + 1`
unknown's avatar
unknown committed
902 903 904
}

fail_inc () {
unknown's avatar
unknown committed
905
    TOT_FAIL=`$EXPR $TOT_FAIL + 1`
unknown's avatar
unknown committed
906 907
}

908 909 910 911
skip_inc () {
    TOT_SKIP=`$EXPR $TOT_SKIP + 1`
}

unknown's avatar
unknown committed
912
total_inc () {
unknown's avatar
unknown committed
913
    TOT_TEST=`$EXPR $TOT_TEST + 1`
unknown's avatar
unknown committed
914 915
}

916 917 918 919 920 921

skip_test() {
   USERT="    ...."
   SYST="    ...."
   REALT="    ...."
   pname=`$ECHO "$1                        "|$CUT -c 1-24`
922
   RES="$pname"
923 924 925 926
   skip_inc
   $ECHO "$RES$RES_SPACE [ skipped ]"
}

927 928 929 930 931 932 933 934 935 936 937

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
938

unknown's avatar
unknown committed
939 940 941 942 943 944 945 946 947 948 949
report_current_test () {
   tname=$1
   echo "CURRENT_TEST: $tname" >> $MASTER_MYERR
   if [ -n "$PURIFY_LOGS" ] ; then
     for log in $PURIFY_LOGS
     do
       echo "CURRENT_TEST: $tname" >> $log
     done
   fi
}

unknown's avatar
Merge  
unknown committed
950

unknown's avatar
unknown committed
951
report_stats () {
952
    if [ $TOT_FAIL = 0 ]; then
unknown's avatar
unknown committed
953
	$ECHO "All $TOT_TEST tests were successful."
unknown's avatar
unknown committed
954
    else
unknown's avatar
unknown committed
955 956 957 958 959 960
	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`
961
	$ECHO  "Failed ${TOT_FAIL}/${TOT_TEST} tests, ${whole}.${deci}% were successful."
962
	$ECHO ""
963
        $ECHO "The log files in $MY_LOG_DIR may give you some hint"
unknown's avatar
unknown committed
964
	$ECHO "of what went wrong."
965
	$ECHO "If you want to report this error, please read first the documentation at"
966
        $ECHO "http://www.mysql.com/doc/en/MySQL_test_suite.html"
unknown's avatar
unknown committed
967
    fi
unknown's avatar
unknown committed
968

969
    if [ $USE_RUNNING_SERVER -eq 0 ]
unknown's avatar
unknown committed
970 971
    then

unknown's avatar
unknown committed
972 973 974 975
    # 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
976
    $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' \
977 978 979
        $MY_LOG_DIR/*.err \
        | $SED -e 's!Warning:  Table:.* on rename!!g' \
        > $MY_LOG_DIR/warnings.tmp
unknown's avatar
unknown committed
980 981 982

    found_error=0
    # Find errors
unknown's avatar
unknown committed
983
    for i in "^Warning:" "^Error:" "^==.* at 0x" "InnoDB: Warning"
unknown's avatar
unknown committed
984
    do
unknown's avatar
unknown committed
985
      if $GREP "$i" $MY_LOG_DIR/warnings.tmp >> $MY_LOG_DIR/warnings
unknown's avatar
unknown committed
986 987 988 989 990 991 992 993 994 995
      then
        found_error=1
      fi
    done
    $RM -f $MY_LOG_DIR/warnings.tmp
    if [ $found_error = "1" ]
    then
      echo "WARNING: Got errors/warnings while running tests. Please examine"
      echo "$MY_LOG_DIR/warnings for details."
    fi
unknown's avatar
unknown committed
996
    fi
unknown's avatar
unknown committed
997
}
998

unknown's avatar
unknown committed
999
mysql_install_db () {
1000
    $ECHO "Removing Stale Files"
1001 1002 1003 1004 1005
    if [ -z "$USE_OLD_DATA" ]; then
      $RM -rf $MASTER_MYDDIR $MASTER_MYDDIR"1"
      $ECHO "Installing Master Databases"
      $INSTALL_DB
      if [ $? != 0 ]; then
1006
	error "Could not install master test DBs"
1007 1008
        exit 1
      fi
1009
    fi
unknown's avatar
unknown committed
1010 1011 1012 1013 1014 1015 1016 1017 1018
    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
1019
    $ECHO "Installing Slave Databases"
1020
    $RM -rf $SLAVE_MYDDIR $MY_LOG_DIR/* 
1021
    $INSTALL_DB -slave
1022
    if [ $? != 0 ]; then
1023
	error "Could not install slave test DBs"
1024
	exit 1
unknown's avatar
unknown committed
1025
    fi
unknown's avatar
unknown committed
1026

1027 1028
    for slave_num in 1 2 ;
    do
1029
      $RM -rf var/slave$slave_num-data
1030 1031 1032
      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
1033
    done
unknown's avatar
unknown committed
1034 1035 1036
    return 0
}

unknown's avatar
unknown committed
1037 1038
gprof_prepare ()
{
unknown's avatar
unknown committed
1039 1040
 $RM -rf $GPROF_DIR
 mkdir -p $GPROF_DIR
unknown's avatar
unknown committed
1041 1042 1043 1044 1045
}

gprof_collect ()
{
 if [ -f $MASTER_MYDDIR/gmon.out ]; then
1046
   gprof $MASTER_MYSQLD $MASTER_MYDDIR/gmon.out > $GPROF_MASTER
unknown's avatar
unknown committed
1047 1048 1049
   echo "Master execution profile has been saved in $GPROF_MASTER"
 fi
 if [ -f $SLAVE_MYDDIR/gmon.out ]; then
1050
   gprof $SLAVE_MYSQLD $SLAVE_MYDDIR/gmon.out > $GPROF_SLAVE
unknown's avatar
unknown committed
1051 1052 1053 1054
   echo "Slave execution profile has been saved in $GPROF_SLAVE"
 fi
}

1055
gcov_prepare () {
unknown's avatar
unknown committed
1056 1057
    $FIND $BASEDIR -name \*.gcov \
    -or -name \*.da | $XARGS $RM
unknown's avatar
unknown committed
1058 1059 1060
}

gcov_collect () {
unknown's avatar
unknown committed
1061
    $ECHO "Collecting source coverage info..."
unknown's avatar
unknown committed
1062 1063
    [ -f $GCOV_MSG ] && $RM $GCOV_MSG
    [ -f $GCOV_ERR ] && $RM $GCOV_ERR
unknown's avatar
unknown committed
1064 1065 1066
    for d in $MYSQLD_SRC_DIRS; do
	cd $BASEDIR/$d
	for f in *.h *.cc *.c; do
unknown's avatar
unknown committed
1067
	    $GCOV $f 2>>$GCOV_ERR  >>$GCOV_MSG
unknown's avatar
unknown committed
1068
	done
1069
	cd $MYSQL_TEST_DIR
unknown's avatar
unknown committed
1070 1071
    done

unknown's avatar
unknown committed
1072
    $ECHO "gcov info in $GCOV_MSG, errors in $GCOV_ERR"
unknown's avatar
unknown committed
1073 1074
}

unknown's avatar
unknown committed
1075 1076 1077 1078 1079
abort_if_failed()
{
 if [ ! $? = 0 ] ; then
  echo $1
  exit 1
unknown's avatar
unknown committed
1080
 fi
unknown's avatar
unknown committed
1081 1082 1083 1084
}

start_manager()
{
unknown's avatar
unknown committed
1085
 if [ $USE_MANAGER = 0 ] ; then
1086 1087
   echo "Manager disabled, skipping manager start."
   $RM -f $MYSQL_MANAGER_LOG
1088 1089
  return
 fi
unknown's avatar
unknown committed
1090
 $ECHO "Starting MySQL Manager"
1091 1092 1093 1094 1095 1096 1097 1098 1099
 if [ -f "$MANAGER_PID_FILE" ] ; then
    kill `cat $MANAGER_PID_FILE`
    sleep 1
    if [ -f "$MANAGER_PID_FILE" ] ; then
     kill -9 `cat $MANAGER_PID_FILE`
     sleep 1
    fi
 fi

unknown's avatar
unknown committed
1100
 $RM -f $MANAGER_PID_FILE
unknown's avatar
unknown committed
1101 1102
 MYSQL_MANAGER_PW=`$MYSQL_MANAGER_PWGEN -u $MYSQL_MANAGER_USER \
 -o $MYSQL_MANAGER_PW_FILE`
unknown's avatar
unknown committed
1103
 $MYSQL_MANAGER --log=$MYSQL_MANAGER_LOG --port=$MYSQL_MANAGER_PORT \
1104
  --password-file=$MYSQL_MANAGER_PW_FILE --pid-file=$MANAGER_PID_FILE
unknown's avatar
unknown committed
1105
  abort_if_failed "Could not start MySQL manager"
1106 1107
  mysqltest_manager_args="--manager-host=localhost \
  --manager-user=$MYSQL_MANAGER_USER \
1108 1109 1110 1111 1112
  --manager-password=$MYSQL_MANAGER_PW \
  --manager-port=$MYSQL_MANAGER_PORT \
  --manager-wait-timeout=$START_WAIT_TIMEOUT"
  MYSQL_TEST="$MYSQL_TEST $mysqltest_manager_args"
  MYSQL_TEST_ARGS="$MYSQL_TEST_ARGS $mysqltest_manager_args"
1113 1114 1115 1116
  while [ ! -f $MANAGER_PID_FILE ] ; do
   sleep 1
  done
  echo "Manager started"
unknown's avatar
unknown committed
1117 1118
}

unknown's avatar
unknown committed
1119 1120
stop_manager()
{
unknown's avatar
unknown committed
1121
 if [ $USE_MANAGER = 0 ] ; then
1122 1123
  return
 fi
unknown's avatar
unknown committed
1124 1125 1126 1127
 $MYSQL_MANAGER_CLIENT $MANAGER_QUIET_OPT -u$MYSQL_MANAGER_USER \
  -p$MYSQL_MANAGER_PW -P $MYSQL_MANAGER_PORT <<EOF
shutdown
EOF
1128 1129
 echo "Manager terminated"

unknown's avatar
unknown committed
1130 1131 1132
}

manager_launch()
unknown's avatar
unknown committed
1133
{
unknown's avatar
unknown committed
1134 1135
  ident=$1
  shift
unknown's avatar
unknown committed
1136
  if [ $USE_MANAGER = 0 ] ; then
unknown's avatar
unknown committed
1137
    echo $@ | /bin/sh  >> $CUR_MYERR 2>&1  &
unknown's avatar
unknown committed
1138 1139
    sleep 2 #hack
    return
1140
  fi
unknown's avatar
unknown committed
1141
  $MYSQL_MANAGER_CLIENT $MANAGER_QUIET_OPT --user=$MYSQL_MANAGER_USER \
unknown's avatar
unknown committed
1142
   --password=$MYSQL_MANAGER_PW  --port=$MYSQL_MANAGER_PORT <<EOF
1143
def_exec $ident "$@"
unknown's avatar
unknown committed
1144 1145 1146 1147
set_exec_stdout $ident $CUR_MYERR
set_exec_stderr $ident $CUR_MYERR
set_exec_con $ident root localhost $CUR_MYSOCK
start_exec $ident $START_WAIT_TIMEOUT
unknown's avatar
unknown committed
1148
EOF
unknown's avatar
unknown committed
1149
  abort_if_failed "Could not execute manager command"
unknown's avatar
unknown committed
1150
}
unknown's avatar
unknown committed
1151

unknown's avatar
unknown committed
1152 1153
manager_term()
{
1154 1155
  pid=$1
  ident=$2
unknown's avatar
unknown committed
1156
  if [ $USE_MANAGER = 0 ] ; then
unknown's avatar
unknown committed
1157
    # Shutdown time must be high as slave may be in reconnect
unknown's avatar
unknown committed
1158
    $MYSQLADMIN --no-defaults -uroot --socket=$MYSQL_TMP_DIR/$ident.sock$3 --connect_timeout=5 --shutdown_timeout=70 shutdown >> $MYSQL_MANAGER_LOG 2>&1
1159 1160
    res=$?
    # Some systems require an extra connect
unknown's avatar
unknown committed
1161
    $MYSQLADMIN --no-defaults -uroot --socket=$MYSQL_TMP_DIR/$ident.sock$3 --connect_timeout=1 ping >> $MYSQL_MANAGER_LOG 2>&1
1162 1163 1164 1165 1166
    if test $res = 0
    then
      wait_for_pid $pid
    fi
    return $res
1167
  fi
unknown's avatar
unknown committed
1168 1169
  $MYSQL_MANAGER_CLIENT $MANAGER_QUIET_OPT --user=$MYSQL_MANAGER_USER \
   --password=$MYSQL_MANAGER_PW  --port=$MYSQL_MANAGER_PORT <<EOF
1170
stop_exec $ident $STOP_WAIT_TIMEOUT
unknown's avatar
unknown committed
1171 1172 1173 1174
EOF
 abort_if_failed "Could not execute manager command"
}

1175 1176 1177 1178
start_ndbcluster()
{
  if [ ! -z "$USE_NDBCLUSTER" ]
  then
unknown's avatar
merge  
unknown committed
1179
  rm -f $NDB_TOOLS_OUTPUT
1180 1181 1182 1183 1184
  if [ -z "$USE_RUNNING_NDBCLUSTER" ]
  then
    echo "Starting ndbcluster"
    if [ "$DO_BENCH" = 1 ]
    then
1185
      NDBCLUSTER_EXTRA_OPTS=""
1186
    else
1187
      NDBCLUSTER_EXTRA_OPTS="--small"
1188
    fi
1189 1190
    ./ndb/ndbcluster $NDBCLUSTER_OPTS $NDBCLUSTER_EXTRA_OPTS --initial || NDB_STATUS_OK=0
    if [ x$NDB_STATUS_OK != x1 ] ; then
unknown's avatar
unknown committed
1191 1192 1193
      if [ x$FORCE != x1 ] ; then
        exit 1
      fi
1194 1195
      USE_NDBCLUSTER=
      return
unknown's avatar
unknown committed
1196
    fi
1197

1198
    NDB_CONNECTSTRING="host=localhost:$NDBCLUSTER_PORT"
1199
  else
1200 1201
    NDB_CONNECTSTRING="$USE_RUNNING_NDBCLUSTER"
    echo "Using ndbcluster at $NDB_CONNECTSTRING"
1202
  fi
1203 1204
  USE_NDBCLUSTER="$USE_NDBCLUSTER --ndb-connectstring=\"$NDB_CONNECTSTRING\""
  export NDB_CONNECTSTRING
1205 1206 1207 1208 1209 1210 1211 1212 1213 1214
  fi
}

stop_ndbcluster()
{
 if [ ! -z "$USE_NDBCLUSTER" ]
 then
 if [ -z "$USE_RUNNING_NDBCLUSTER" ]
 then
   # Kill any running ndbcluster stuff
1215
   ./ndb/ndbcluster $NDBCLUSTER_OPTS --stop
1216 1217 1218 1219
 fi
 fi
}

unknown's avatar
unknown committed
1220 1221
# 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
1222

unknown's avatar
unknown committed
1223 1224
start_master()
{
unknown's avatar
unknown committed
1225 1226
  eval "this_master_running=\$MASTER$1_RUNNING"
  if [ x$this_master_running = x1 ] || [ x$LOCAL_MASTER = x1 ] ; then
unknown's avatar
unknown committed
1227 1228
    return
  fi
unknown's avatar
unknown committed
1229 1230 1231
  # 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
1232
    $RM -f $MYSQL_TEST_DIR/var/log/master-bin$1.*
unknown's avatar
unknown committed
1233 1234
  fi

1235
  # Remove old master.info and relay-log.info files
unknown's avatar
unknown committed
1236
  $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
1237 1238 1239 1240 1241 1242 1243 1244

  #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
1245 1246 1247
  if [ -n "$1" ] ; then
   id=`$EXPR $1 + 101`;
   this_master_myport=`$EXPR $MASTER_MYPORT + $1`
1248
   NOT_FIRST_MASTER_EXTRA_OPTS="--skip-innodb"
1249 1250
   eval "MASTER_MYPORT$1=$this_master_myport"
   export MASTER_MYPORT$1
unknown's avatar
unknown committed
1251 1252 1253
  else
   id=1;
   this_master_myport=$MASTER_MYPORT
1254
   NOT_FIRST_MASTER_EXTRA_OPTS=""
unknown's avatar
unknown committed
1255
  fi
1256 1257
  if [ -n "$EXTRA_MASTER_MYSQLD_TRACE" ] 
  then
1258
      CURR_MASTER_MYSQLD_TRACE="$EXTRA_MASTER_MYSQLD_TRACE$1"
1259
  fi
1260
  if [ -z "$DO_BENCH" -a -z "$DO_STRESS"  ]
unknown's avatar
unknown committed
1261
  then
unknown's avatar
unknown committed
1262 1263
    master_args="--no-defaults --log-bin=$MYSQL_TEST_DIR/var/log/master-bin$1 \
  	    --server-id=$id  \
1264
          --basedir=$MY_BASEDIR \
unknown's avatar
unknown committed
1265
          --port=$this_master_myport \
unknown's avatar
unknown committed
1266
          --local-infile \
unknown's avatar
unknown committed
1267 1268
          --exit-info=256 \
          --core \
unknown's avatar
unknown committed
1269
          $USE_NDBCLUSTER \
unknown's avatar
unknown committed
1270 1271 1272 1273
          --datadir=$MASTER_MYDDIR$1 \
          --pid-file=$MASTER_MYPID$1 \
          --socket=$MASTER_MYSOCK$1 \
          --log=$MASTER_MYLOG$1 \
unknown's avatar
unknown committed
1274 1275 1276 1277
          --character-sets-dir=$CHARSETSDIR \
          --default-character-set=$CHARACTER_SET \
          --tmpdir=$MYSQL_TMP_DIR \
          --language=$LANGUAGE \
1278
          --innodb_data_file_path=ibdata1:128M:autoextend \
1279
	  --open-files-limit=1024 \
1280
          --log-bin-trust-function-creators \
1281
	   $MASTER_40_ARGS \
unknown's avatar
unknown committed
1282
           $SMALL_SERVER \
1283
           $EXTRA_MASTER_OPT $EXTRA_MASTER_MYSQLD_OPT \
1284
           $NOT_FIRST_MASTER_EXTRA_OPTS $CURR_MASTER_MYSQLD_TRACE"
unknown's avatar
unknown committed
1285
  else
unknown's avatar
unknown committed
1286 1287
    master_args="--no-defaults --log-bin=$MYSQL_TEST_DIR/var/log/master-bin$1 \
          --server-id=$id --rpl-recovery-rank=1 \
unknown's avatar
unknown committed
1288
          --basedir=$MY_BASEDIR --init-rpl-role=master \
unknown's avatar
unknown committed
1289
          --port=$this_master_myport \
unknown's avatar
unknown committed
1290
          --local-infile \
unknown's avatar
unknown committed
1291 1292 1293
          --datadir=$MASTER_MYDDIR$1 \
          --pid-file=$MASTER_MYPID$1 \
          --socket=$MASTER_MYSOCK$1 \
unknown's avatar
unknown committed
1294 1295 1296
          --character-sets-dir=$CHARSETSDIR \
          --default-character-set=$CHARACTER_SET \
          --core \
unknown's avatar
unknown committed
1297
          $USE_NDBCLUSTER \
unknown's avatar
unknown committed
1298 1299
          --tmpdir=$MYSQL_TMP_DIR \
          --language=$LANGUAGE \
1300
          --innodb_data_file_path=ibdata1:128M:autoextend \
1301
          --log-bin-trust-function-creators \
1302
	   $MASTER_40_ARGS \
unknown's avatar
unknown committed
1303
           $SMALL_SERVER \
1304 1305
           $EXTRA_MASTER_OPT $EXTRA_MASTER_MYSQLD_OPT \
           $NOT_FIRST_MASTER_EXTRA_OPTS"
unknown's avatar
unknown committed
1306 1307
  fi

1308 1309
  CUR_MYERR=$MASTER_MYERR$1
  CUR_MYSOCK=$MASTER_MYSOCK$1
unknown's avatar
unknown committed
1310

unknown's avatar
unknown committed
1311 1312 1313 1314 1315 1316 1317 1318 1319 1320 1321 1322
  # 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
1323 1324 1325 1326
  if [ x$DO_DDD = x1 ]
  then
    $ECHO "set args $master_args" > $GDB_MASTER_INIT
    manager_launch master ddd -display $DISPLAY --debugger \
1327
    "gdb -x $GDB_MASTER_INIT" $MASTER_MYSQLD
unknown's avatar
unknown committed
1328 1329
  elif [ x$DO_GDB = x1 ]
  then
unknown's avatar
unknown committed
1330 1331 1332 1333
    if [ x$MANUAL_GDB = x1 ]
    then
      $ECHO "set args $master_args" > $GDB_MASTER_INIT
      $ECHO "To start gdb for the master , type in another window:"
1334
      $ECHO "cd $CWD ; gdb -x $GDB_MASTER_INIT $MASTER_MYSQLD"
unknown's avatar
unknown committed
1335 1336 1337 1338
      wait_for_master=1500
    else
      ( $ECHO set args $master_args;
      if [ $USE_MANAGER = 0 ] ; then
unknown's avatar
unknown committed
1339
    cat <<EOF
unknown's avatar
unknown committed
1340 1341
b mysql_parse
commands 1
1342
disa 1
unknown's avatar
unknown committed
1343
end
unknown's avatar
unknown committed
1344 1345
r
EOF
unknown's avatar
unknown committed
1346 1347
      fi )  > $GDB_MASTER_INIT
      manager_launch master $XTERM -display $DISPLAY \
1348
      -title "Master" -e gdb -x $GDB_MASTER_INIT $MASTER_MYSQLD
unknown's avatar
unknown committed
1349
    fi
unknown's avatar
unknown committed
1350
  else
1351
    manager_launch master $MASTER_MYSQLD $master_args
unknown's avatar
unknown committed
1352
  fi
unknown's avatar
unknown committed
1353
  sleep_until_file_created $MASTER_MYPID$1 $wait_for_master
unknown's avatar
unknown committed
1354
  wait_for_master=$SLEEP_TIME_FOR_SECOND_MASTER
unknown's avatar
unknown committed
1355
  eval "MASTER$1_RUNNING=1"
unknown's avatar
unknown committed
1356 1357 1358 1359
}

start_slave()
{
unknown's avatar
unknown committed
1360 1361 1362
  [ x$SKIP_SLAVE = x1 ] && return
  eval "this_slave_running=\$SLAVE$1_RUNNING"
  [ x$this_slave_running = 1 ] && return
unknown's avatar
unknown committed
1363 1364
  # 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
1365 1366 1367 1368 1369 1370 1371 1372
  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"
1373
   slave_datadir="$SLAVE_MYDDIR/../$slave_ident-data/"
unknown's avatar
unknown committed
1374 1375 1376 1377 1378 1379 1380 1381 1382 1383 1384 1385
   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
1386
  # Remove stale binary logs and old master.info files
unknown's avatar
unknown committed
1387 1388 1389 1390 1391 1392
  # 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
1393 1394 1395 1396 1397 1398 1399 1400 1401 1402 1403

  #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 \
1404
          --master-password="" \
unknown's avatar
unknown committed
1405 1406 1407 1408 1409 1410 1411 1412 1413 1414
          --master-port=$MASTER_MYPORT \
          --server-id=$slave_server_id --rpl-recovery-rank=$slave_rpl_rank"
 else
   master_info=$SLAVE_MASTER_INFO
 fi

  $RM -f $slave_datadir/log.*
  slave_args="--no-defaults $master_info \
  	    --exit-info=256 \
          --log-bin=$MYSQL_TEST_DIR/var/log/$slave_ident-bin \
1415
          --relay-log=$MYSQL_TEST_DIR/var/log/$slave_ident-relay-bin \
unknown's avatar
unknown committed
1416 1417 1418 1419 1420 1421 1422 1423 1424 1425 1426 1427
          --log-slave-updates \
          --log=$slave_log \
          --basedir=$MY_BASEDIR \
          --datadir=$slave_datadir \
          --pid-file=$slave_pid \
          --port=$slave_port \
          --socket=$slave_sock \
          --character-sets-dir=$CHARSETSDIR \
          --default-character-set=$CHARACTER_SET \
          --core --init-rpl-role=slave \
          --tmpdir=$MYSQL_TMP_DIR \
          --language=$LANGUAGE \
unknown's avatar
unknown committed
1428
          --skip-innodb --skip-ndbcluster --skip-slave-start \
unknown's avatar
unknown committed
1429 1430 1431
          --slave-load-tmpdir=$SLAVE_LOAD_TMPDIR \
          --report-host=127.0.0.1 --report-user=root \
          --report-port=$slave_port \
1432
          --master-retry-count=10 \
unknown's avatar
unknown committed
1433
          -O slave_net_timeout=10 \
1434
          --log-bin-trust-function-creators \
unknown's avatar
unknown committed
1435 1436 1437 1438 1439 1440 1441
           $SMALL_SERVER \
           $EXTRA_SLAVE_OPT $EXTRA_SLAVE_MYSQLD_OPT"
  CUR_MYERR=$slave_err
  CUR_MYSOCK=$slave_sock

  if [ x$DO_DDD = x1 ]
  then
1442
    $ECHO "set args $slave_args" > $GDB_SLAVE_INIT
unknown's avatar
unknown committed
1443 1444 1445 1446
    manager_launch $slave_ident ddd -display $DISPLAY --debugger \
     "gdb -x $GDB_SLAVE_INIT" $SLAVE_MYSQLD
  elif [ x$DO_GDB = x1 ]
  then
unknown's avatar
unknown committed
1447 1448
    if [ x$MANUAL_GDB = x1 ]
    then
unknown's avatar
unknown committed
1449
      $ECHO "set args $slave_args" > $GDB_SLAVE_INIT
unknown's avatar
unknown committed
1450
      echo "To start gdb for the slave, type in another window:"
1451
      echo "cd $CWD ; gdb -x $GDB_SLAVE_INIT $SLAVE_MYSQLD"
unknown's avatar
unknown committed
1452 1453
      wait_for_slave=1500
    else
unknown's avatar
unknown committed
1454 1455 1456 1457 1458 1459 1460 1461 1462 1463
      ( $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
unknown's avatar
unknown committed
1464 1465 1466
      manager_launch $slave_ident $XTERM -display $DISPLAY -title "Slave" -e \
      gdb -x $GDB_SLAVE_INIT $SLAVE_MYSQLD
    fi
unknown's avatar
unknown committed
1467 1468 1469 1470
  else
    manager_launch $slave_ident $SLAVE_MYSQLD $slave_args
  fi
  eval "SLAVE$1_RUNNING=1"
1471
  sleep_until_file_created $slave_pid $wait_for_slave
unknown's avatar
unknown committed
1472
  wait_for_slave=$SLEEP_TIME_FOR_SECOND_SLAVE
unknown's avatar
unknown committed
1473 1474
}

unknown's avatar
unknown committed
1475 1476
mysql_start ()
{
unknown's avatar
unknown committed
1477
# We should not start the daemon here as we don't know the arguments
unknown's avatar
unknown committed
1478
# for the test.  Better to let the test start the daemon
unknown's avatar
unknown committed
1479 1480 1481 1482

#  $ECHO "Starting MySQL daemon"
#  start_master
#  start_slave
unknown's avatar
unknown committed
1483
  cd $MYSQL_TEST_DIR
1484
  start_ndbcluster
unknown's avatar
unknown committed
1485
  return 1
unknown's avatar
unknown committed
1486 1487
}

unknown's avatar
unknown committed
1488 1489
stop_slave ()
{
1490 1491 1492
  eval "this_slave_running=\$SLAVE$1_RUNNING"
  slave_ident="slave$1"
  if [ -n "$1" ] ;
unknown's avatar
unknown committed
1493
  then
1494 1495 1496
   slave_pid="$MYRUN_DIR/mysqld-$slave_ident.pid"
  else
   slave_pid=$SLAVE_MYPID
unknown's avatar
unknown committed
1497
  fi
1498 1499
  if [ x$this_slave_running = x1 ]
  then
1500 1501
    pid=`$CAT $slave_pid`
    manager_term $pid $slave_ident
1502
    if [ $? != 0 ] && [ -f $slave_pid ]
1503
    then # try harder!
1504
      $ECHO "slave not cooperating with mysqladmin, will try manual kill"
1505 1506
      kill $pid
      sleep_until_file_deleted $pid $slave_pid
1507 1508 1509 1510 1511 1512 1513 1514 1515
      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
1516
    fi
1517
    eval "SLAVE$1_RUNNING=0"
unknown's avatar
unknown committed
1518
  fi
unknown's avatar
unknown committed
1519
}
unknown's avatar
unknown committed
1520

1521 1522 1523 1524 1525 1526 1527 1528 1529 1530
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
1531 1532
stop_master ()
{
unknown's avatar
unknown committed
1533 1534
  eval "this_master_running=\$MASTER$1_RUNNING"
  if [ x$this_master_running = x1 ]
unknown's avatar
unknown committed
1535
  then
unknown's avatar
unknown committed
1536 1537 1538
    # 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
1539
      pid=`$CAT $MASTER_MYPID$1`
unknown's avatar
unknown committed
1540
      manager_term $pid master $1
unknown's avatar
Merge  
unknown committed
1541
      if [ $? != 0 ] && [ -f $MASTER_MYPID$1 ]
unknown's avatar
unknown committed
1542 1543 1544
      then # try harder!
	$ECHO "master not cooperating with mysqladmin, will try manual kill"
	kill $pid
unknown's avatar
Merge  
unknown committed
1545 1546
	sleep_until_file_deleted $pid $MASTER_MYPID$1
	if [ -f $MASTER_MYPID$1 ] ; then
unknown's avatar
unknown committed
1547
	  $ECHO "master refused to die. Sending SIGKILL"
unknown's avatar
Merge  
unknown committed
1548 1549
	  kill -9 `$CAT $MASTER_MYPID$1`
	  $RM -f $MASTER_MYPID$1
unknown's avatar
unknown committed
1550 1551 1552
	else
	  $ECHO "master responded to SIGTERM "
	fi
1553
      else
unknown's avatar
unknown committed
1554
	sleep $SLEEP_TIME_AFTER_RESTART
1555
      fi
unknown's avatar
unknown committed
1556
    fi
unknown's avatar
unknown committed
1557
    eval "MASTER$1_RUNNING=0"
unknown's avatar
unknown committed
1558 1559
  fi
}
unknown's avatar
unknown committed
1560

unknown's avatar
unknown committed
1561 1562
mysql_stop ()
{
1563 1564 1565 1566 1567 1568
  if [ "$MASTER_RUNNING" = 1 ]
  then
    $ECHO  "Ending Tests"
    $ECHO  "Shutting-down MySQL daemon"
    $ECHO  ""
    stop_master
unknown's avatar
unknown committed
1569
    stop_master 1
1570 1571 1572 1573 1574
    $ECHO "Master shutdown finished"
    stop_slave
    stop_slave 1
    stop_slave 2
    $ECHO "Slave shutdown finished"
unknown's avatar
unknown committed
1575
    stop_ndbcluster
1576 1577
  fi
  return 1
unknown's avatar
unknown committed
1578 1579
}

unknown's avatar
unknown committed
1580 1581 1582 1583 1584
mysql_restart ()
{
  mysql_stop
  mysql_start
  return 1
unknown's avatar
unknown committed
1585 1586 1587
}

mysql_loadstd () {
unknown's avatar
unknown committed
1588 1589

    # cp $STD_DATA/*.frm $STD_DATA/*.MRG $MASTER_MYDDIR/test
unknown's avatar
unknown committed
1590 1591 1592
    return 1
}

unknown's avatar
unknown committed
1593 1594 1595
run_testcase ()
{
 tf=$1
unknown's avatar
unknown committed
1596
 tname=`$BASENAME $tf .test`
unknown's avatar
unknown committed
1597 1598
 master_opt_file=$TESTDIR/$tname-master.opt
 slave_opt_file=$TESTDIR/$tname-slave.opt
1599 1600
 master_init_script=$TESTDIR/$tname-master.sh
 slave_init_script=$TESTDIR/$tname-slave.sh
1601
 slave_master_info_file=$TESTDIR/$tname.slave-mi
unknown's avatar
unknown committed
1602 1603
 tsrcdir=$TESTDIR/$tname-src
 result_file="r/$tname.result"
1604
 echo $tname > $CURRENT_TEST
1605
 SKIP_SLAVE=`$EXPR \( $tname : rpl \) = 0 \& \( $tname : federated \) = 0`
1606
 if [ "$USE_MANAGER" = 1 ] ; then
unknown's avatar
unknown committed
1607
  many_slaves=`$EXPR \( \( $tname : rpl_failsafe \) != 0 \) \| \( \( $tname : rpl_chain_temp_table \) != 0 \)`
1608 1609 1610 1611
 fi
 if $EXPR "$tname" '<' "$START_FROM" > /dev/null ; then
   #skip_test $tname
   return
unknown's avatar
unknown committed
1612 1613
 fi

1614 1615 1616 1617
 if [ "$SKIP_TEST" ] ; then
   if $EXPR \( "$tname" : "$SKIP_TEST" \) > /dev/null ; then
     skip_test $tname
     return
unknown's avatar
unknown committed
1618
   fi
1619
 fi
1620

1621 1622
 if [ "$DO_TEST" ] ; then
   if $EXPR \( "$tname" : "$DO_TEST" \) > /dev/null ; then
unknown's avatar
unknown committed
1623
     : #empty command to keep some shells happy
1624 1625 1626
   else
     #skip_test $tname
     return
1627
   fi
1628
 fi
1629

1630 1631
 if [ x${NO_SLAVE}x$SKIP_SLAVE = x1x0 ] ; then
   skip_test $tname
1632 1633 1634
   return
 fi

unknown's avatar
unknown committed
1635 1636 1637 1638 1639 1640
# if [ -f "$TESTDIR/$tname.disabled" ]
# then
#   comment=`$CAT $TESTDIR/$tname.disabled`;
#   disable_test $tname "$comment"
#   return
# fi
unknown's avatar
unknown committed
1641 1642 1643 1644 1645 1646 1647 1648
 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
1649 1650
 fi

unknown's avatar
unknown committed
1651 1652 1653 1654 1655 1656 1657 1658 1659 1660 1661 1662
 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 \
1663 1664
       "init_connect" \
       "init_file"
unknown's avatar
unknown committed
1665 1666 1667 1668 1669 1670 1671
   do
     if [ "$tname" = "$t" ] ; then
       skip_test $tname
       return
     fi
   done
 fi
1672

1673
 if [ $USE_RUNNING_SERVER -eq 0 ] ;
unknown's avatar
unknown committed
1674
 then
1675 1676
   if [ -f $master_opt_file ] ;
   then
unknown's avatar
unknown committed
1677
     EXTRA_MASTER_OPT=`$CAT $master_opt_file | $SED -e "s;\\$MYSQL_TEST_DIR;$MYSQL_TEST_DIR;"`
1678 1679 1680 1681 1682 1683 1684
     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=" "
	 ;;
1685 1686
       --result-file=*)
         result_file=`$ECHO "$EXTRA_MASTER_OPT" | $SED -e "s;--result-file=;;"`
unknown's avatar
unknown committed
1687
         result_file="r/$result_file.result"
1688 1689
         # Note that this must be set to space, not "" for test-reset to
# work
1690 1691
	 EXTRA_MASTER_OPT=" "
         ;;
1692
     esac
1693
     stop_master
unknown's avatar
unknown committed
1694
     stop_master 1
unknown's avatar
unknown committed
1695
     report_current_test $tname
1696
     start_master
1697
     if [ -n "$USE_NDBCLUSTER" -a -z "$DO_BENCH" -a -z "$DO_STRESS" ] ; then
unknown's avatar
unknown committed
1698 1699
       start_master 1
     fi
1700
     TZ=$MY_TZ; export TZ
1701
   else
unknown's avatar
unknown committed
1702 1703 1704 1705 1706
     # 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 ] || \
	[ -f $master_init_script ]
1707 1708 1709
     then
       EXTRA_MASTER_OPT=""
       stop_master
unknown's avatar
unknown committed
1710
       stop_master 1
unknown's avatar
unknown committed
1711
       report_current_test $tname
1712
       start_master
1713
       if [ -n "$USE_NDBCLUSTER"  -a -z "$DO_BENCH" -a -z "$DO_STRESS" ] ; then
unknown's avatar
unknown committed
1714 1715
         start_master 1
       fi
unknown's avatar
unknown committed
1716
     else
unknown's avatar
unknown committed
1717
       report_current_test $tname
unknown's avatar
unknown committed
1718
     fi
1719
   fi
unknown's avatar
unknown committed
1720

unknown's avatar
unknown committed
1721 1722 1723 1724
   # 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 ] ;
1725
     then
unknown's avatar
unknown committed
1726
       EXTRA_SLAVE_OPT=`$CAT $slave_opt_file | $SED -e "s;\\$MYSQL_TEST_DIR;$MYSQL_TEST_DIR;"`
unknown's avatar
unknown committed
1727
       do_slave_restart=1
unknown's avatar
unknown committed
1728 1729 1730 1731 1732 1733
     else
      if [ ! -z "$EXTRA_SLAVE_OPT" ] || [ x$SLAVE_RUNNING != x1 ] ;
      then
	EXTRA_SLAVE_OPT=""
	do_slave_restart=1
      fi
unknown's avatar
unknown committed
1734
     fi
1735

unknown's avatar
unknown committed
1736 1737 1738 1739 1740 1741 1742 1743 1744 1745 1746 1747 1748 1749 1750 1751 1752 1753 1754 1755 1756 1757
     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

     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
1758
   fi
unknown's avatar
fixed  
unknown committed
1759
 fi
1760 1761 1762 1763 1764 1765

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

1766
 cd $MYSQL_TEST_DIR
unknown's avatar
unknown committed
1767

unknown's avatar
unknown committed
1768
 if [ -f $tf ] ; then
unknown's avatar
unknown committed
1769
    $RM -f r/$tname.*reject
unknown's avatar
unknown committed
1770
    mysql_test_args="-R $result_file $EXTRA_MYSQL_TEST_OPT"
1771
    if [ -z "$DO_CLIENT_GDB" ] ; then
1772
      `$MYSQL_TEST  $mysql_test_args < $tf 2> $TIMEFILE`;
1773
    else
1774
      do_gdb_test "$mysql_test_args" "$tf"
1775
    fi
unknown's avatar
unknown committed
1776

unknown's avatar
unknown committed
1777 1778
    res=$?

1779
    pname=`$ECHO "$tname                        "|$CUT -c 1-24`
1780
    RES="$pname"
unknown's avatar
unknown committed
1781

1782 1783 1784 1785
    if [ x$many_slaves = x1 ] ; then
     stop_slave 1
     stop_slave 2
    fi
unknown's avatar
unknown committed
1786

unknown's avatar
unknown committed
1787
    if [ $res = 0 ]; then
1788 1789
      total_inc
      pass_inc
unknown's avatar
unknown committed
1790
      TIMER=""
unknown's avatar
unknown committed
1791
      if [ x$USE_TIMER = x1 -a -f "$MY_LOG_DIR/timer" ]; then
unknown's avatar
unknown committed
1792 1793 1794 1795
	TIMER=`cat $MY_LOG_DIR/timer`
	TIMER=`$PRINTF "%13s" $TIMER`
      fi
      $ECHO "$RES$RES_SPACE [ pass ]   $TIMER"
1796
    else
1797
      # why the following ``if'' ? That is why res==1 is special ?
unknown's avatar
unknown committed
1798
      if [ $res = 62 ]; then
1799 1800 1801
        skip_inc
	$ECHO "$RES$RES_SPACE [ skipped ]"
      else
unknown's avatar
unknown committed
1802
        if [ $res -ne 1 ]; then
1803 1804
          $ECHO "mysqltest returned unexpected code $res, it has probably crashed" >> $TIMEFILE
        fi
1805
	total_inc
unknown's avatar
unknown committed
1806
        fail_inc
1807
	$ECHO "$RES$RES_SPACE [ fail ]"
1808 1809
        $ECHO
	error_is
unknown's avatar
unknown committed
1810
	show_failed_diff $tname
unknown's avatar
unknown committed
1811
	$ECHO
1812
	if [ x$FORCE != x1 ] ; then
unknown's avatar
unknown committed
1813
	 $ECHO "Aborting: $tname failed in $TEST_MODE mode. To continue, re-run with '--force'."
1814
	 $ECHO
1815
         if [ -z "$DO_GDB" ] && [ $USE_RUNNING_SERVER -eq 0 ] && \
unknown's avatar
unknown committed
1816
	    [ -z "$DO_DDD" ] && [ -z "$USE_EMBEDDED_SERVER" ]
unknown's avatar
unknown committed
1817 1818
	 then
	   mysql_stop
unknown's avatar
unknown committed
1819
	   stop_manager
unknown's avatar
unknown committed
1820
   	 fi
1821 1822
	 exit 1
	fi
unknown's avatar
unknown committed
1823
	FAILED_CASES="$FAILED_CASES $tname"
1824
        if [ -z "$DO_GDB" ] && [ $USE_RUNNING_SERVER -eq 0 ] && \
unknown's avatar
unknown committed
1825
	   [ -z "$DO_DDD" ] && [ -z "$USE_EMBEDDED_SERVER" ]
unknown's avatar
unknown committed
1826 1827 1828
	then
	  mysql_restart
	fi
1829
      fi
unknown's avatar
unknown committed
1830
    fi
1831
  fi
unknown's avatar
unknown committed
1832 1833
}

1834 1835 1836 1837 1838 1839 1840 1841 1842 1843 1844 1845 1846 1847 1848 1849 1850 1851 1852 1853 1854 1855 1856 1857 1858 1859 1860 1861 1862 1863 1864 1865 1866
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
1867 1868
      echo "Specified file $STRESS_TEST_FILE with list of tests does not exist"
      echo "Please ensure that file exists and has proper permissions"
1869 1870 1871 1872 1873
      exit 1
    fi
  else 
    STRESS_TEST_FILE="$STRESS_SUITE_DIR/stress_tests.txt"
    if [ ! -f  "$STRESS_TEST_FILE" ] ; then 
unknown's avatar
unknown committed
1874 1875 1876
      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"
1877 1878 1879 1880 1881 1882 1883
      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
1884 1885
      echo "Specified file $STRESS_INIT_FILE with list of tests doesn't exist."
      echo "Please ensure that file exists and has proper permissions"
1886 1887 1888 1889 1890 1891 1892 1893 1894 1895 1896
      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
1897 1898
    echo "You specified wrong mode '$STRESS_MODE' for stress test."
    echo "Correct values are 'random' or 'seq'"
1899 1900 1901 1902 1903 1904 1905 1906 1907 1908 1909 1910 1911 1912 1913 1914 1915 1916 1917 1918 1919 1920 1921 1922 1923 1924 1925 1926 1927 1928 1929 1930 1931 1932 1933 1934 1935 1936 1937 1938 1939 1940 1941 1942 1943 1944 1945 1946 1947 1948 1949 1950 1951 1952
    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 \
                    --mysqltest=$BASEDIR/client/mysqltest \
                    --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

  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
1953 1954 1955 1956
######################################################################
# Main script starts here
######################################################################

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

unknown's avatar
unknown committed
1959 1960
[ "$DO_GCOV" ] && gcov_prepare
[ "$DO_GPROF" ] && gprof_prepare
unknown's avatar
unknown committed
1961

1962
if [ $USE_RUNNING_SERVER -eq 0 ]
1963
then
1964 1965 1966 1967
  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
1968
    $MYSQLADMIN --no-defaults --socket=$MASTER_MYSOCK1 -u root -O connect_timeout=5 -O shutdown_timeout=20 shutdown > /dev/null 2>&1
1969 1970
    $MYSQLADMIN --no-defaults --socket=$SLAVE_MYSOCK -u root -O connect_timeout=5 -O shutdown_timeout=20 shutdown > /dev/null 2>&1
    $MYSQLADMIN --no-defaults --host=$hostname --port=$MASTER_MYPORT -u root -O connect_timeout=5 -O shutdown_timeout=20 shutdown > /dev/null 2>&1
1971
    $MYSQLADMIN --no-defaults --host=$hostname --port=`expr $MASTER_MYPORT+1` -u root -O connect_timeout=5 -O shutdown_timeout=20 shutdown > /dev/null 2>&1
1972 1973 1974
    $MYSQLADMIN --no-defaults --host=$hostname --port=$SLAVE_MYPORT -u root -O connect_timeout=5 -O shutdown_timeout=20 shutdown > /dev/null 2>&1
    $MYSQLADMIN --no-defaults --host=$hostname --port=`expr $SLAVE_MYPORT + 1` -u root -O connect_timeout=5 -O shutdown_timeout=20 shutdown > /dev/null 2>&1
    sleep_until_file_deleted 0 $MASTER_MYPID
1975
    sleep_until_file_deleted 0 $MASTER_MYPID"1"
1976 1977
    sleep_until_file_deleted 0 $SLAVE_MYPID
  else
1978
    rm $MASTER_MYPID $MASTER_MYPID"1" $SLAVE_MYPID
1979
  fi
unknown's avatar
unknown committed
1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992

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

unknown's avatar
unknown committed
1993
  stop_ndbcluster
unknown's avatar
unknown committed
1994

unknown's avatar
unknown committed
1995
  # Remove files that can cause problems
1996
  $RM -rf $MYSQL_TEST_DIR/var/ndbcluster
unknown's avatar
unknown committed
1997 1998
  $RM -f $MYSQL_TEST_DIR/var/run/* $MYSQL_TEST_DIR/var/tmp/*

1999 2000
  # Remove old berkeley db log files that can confuse the server
  $RM -f $MASTER_MYDDIR/log.*
unknown's avatar
unknown committed
2001
  $RM -f $MASTER_MYDDIR"1"/log.*
2002

unknown's avatar
unknown committed
2003 2004
  wait_for_master=$SLEEP_TIME_FOR_FIRST_MASTER
  wait_for_slave=$SLEEP_TIME_FOR_FIRST_SLAVE
2005 2006
  $ECHO "Installing Test Databases"
  mysql_install_db
unknown's avatar
unknown committed
2007

unknown's avatar
unknown committed
2008 2009 2010 2011 2012
  if [ -n "$1" -a `expr "X$*" : '.*ndb'` -eq 0 ]
  then
    USE_NDBCLUSTER=""
  fi

unknown's avatar
unknown committed
2013
  start_manager
unknown's avatar
unknown committed
2014

unknown's avatar
unknown committed
2015
# Do not automagically start daemons if we are in gdb or running only one test
unknown's avatar
unknown committed
2016
# case
2017 2018 2019 2020 2021 2022
  if [ -z "$DO_GDB" ] && [ -z "$DO_DDD" ]
  then
    mysql_start
  fi
  $ECHO  "Loading Standard Test Databases"
  mysql_loadstd
unknown's avatar
unknown committed
2023 2024
fi

2025
$ECHO  "Starting Tests"
unknown's avatar
unknown committed
2026

2027 2028 2029
# Some test cases need USE_RUNNING_SERVER
export USE_RUNNING_SERVER

2030 2031 2032
#
# This can probably be deleted
#
unknown's avatar
unknown committed
2033 2034
if [ "$DO_BENCH" = 1 ]
then
2035 2036
  start_master

2037 2038 2039 2040 2041
  if [ "$DO_SMALL_BENCH" = 1 ]
  then
    EXTRA_BENCH_ARGS="--small-test --small-tables"
  fi

2042 2043
  if [ ! -z "$USE_NDBCLUSTER" ]
  then
2044
    EXTRA_BENCH_ARGS="--create-options=TYPE=ndb $EXTRA_BENCH_ARGS"
2045 2046
  fi 

unknown's avatar
unknown committed
2047 2048 2049 2050
  BENCHDIR=$BASEDIR/sql-bench/
  savedir=`pwd`
  cd $BENCHDIR
  if [ -z "$1" ]
unknown's avatar
unknown committed
2051
  then
2052
    ./run-all-tests --socket=$MASTER_MYSOCK --user=root $EXTRA_BENCH_ARGS --log
unknown's avatar
unknown committed
2053
  else
unknown's avatar
unknown committed
2054 2055
    if [ -x "./$1" ]
    then
2056
       ./$1 --socket=$MASTER_MYSOCK --user=root $EXTRA_BENCH_ARGS
unknown's avatar
unknown committed
2057 2058 2059
    else
      echo "benchmark $1 not found"
    fi
unknown's avatar
unknown committed
2060
  fi
unknown's avatar
unknown committed
2061 2062 2063 2064
  cd $savedir
  mysql_stop
  stop_manager
  exit
unknown's avatar
unknown committed
2065 2066
fi

2067 2068 2069 2070 2071 2072 2073 2074 2075 2076 2077 2078 2079 2080 2081 2082 2083 2084 2085 2086 2087 2088 2089 2090 2091 2092
#
# 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
    stop_manager
  fi
  
  exit

fi


unknown's avatar
unknown committed
2093
$ECHO
unknown's avatar
unknown committed
2094
if [ x$USE_TIMER = x1 ] ; then
unknown's avatar
unknown committed
2095
$ECHO "TEST                            RESULT        TIME (ms)"
unknown's avatar
unknown committed
2096 2097 2098
else
$ECHO "TEST                            RESULT"
fi
unknown's avatar
unknown committed
2099 2100
$ECHO $DASH72

unknown's avatar
unknown committed
2101
if [ -z "$1" ] ;
unknown's avatar
unknown committed
2102
then
2103 2104 2105
  if [ x$RECORD = x1 ]; then
    $ECHO "Will not run in record mode without a specific test case."
  else
2106 2107 2108 2109
    for tf in $TESTDIR/*.$TESTSUFFIX
    do
      run_testcase $tf
    done
2110 2111
    $RM -f $TIMEFILE	# Remove for full test
  fi
unknown's avatar
unknown committed
2112
else
unknown's avatar
unknown committed
2113 2114 2115 2116 2117 2118 2119 2120 2121 2122
  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
2123
fi
unknown's avatar
unknown committed
2124

unknown's avatar
unknown committed
2125 2126
$ECHO $DASH72
$ECHO
2127

2128
if [ -z "$DO_GDB" ] && [ $USE_RUNNING_SERVER -eq 0 ] && [ -z "$DO_DDD" ]
unknown's avatar
unknown committed
2129 2130 2131
then
    mysql_stop
fi
unknown's avatar
unknown committed
2132
stop_manager
unknown's avatar
unknown committed
2133
report_stats
unknown's avatar
unknown committed
2134
$ECHO
unknown's avatar
unknown committed
2135

unknown's avatar
unknown committed
2136
[ "$DO_GCOV" ] && gcov_collect # collect coverage information
unknown's avatar
unknown committed
2137
[ "$DO_GPROF" ] && gprof_collect # collect coverage information
unknown's avatar
unknown committed
2138

unknown's avatar
unknown committed
2139
if [ $TOT_FAIL -ne 0 ]; then
unknown's avatar
unknown committed
2140
  $ECHO "mysql-test-run in $TEST_MODE mode: *** Failing the test(s):$FAILED_CASES"
unknown's avatar
unknown committed
2141 2142 2143 2144 2145
  $ECHO
  exit 1
else
  exit 0
fi