mysql-test-run.sh 52.7 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>
paul@ice.snake.net's avatar
Typo.  
paul@ice.snake.net committed
4
# Slightly updated by Monty
5
# Cleaned up again by Matt
6
# Fixed by Sergei
7
# List of failed cases (--force) backported from 4.1 by Joerg
8
# :-)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
9 10 11 12 13

#++
# Access Definitions
#--
DB=test
monty@mysql.com's avatar
monty@mysql.com committed
14
DBPASSWD=""
15
VERBOSE=""
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi 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@
bk@work.mysql.com's avatar
bk@work.mysql.com committed
21

22
# For query_cache test
monty@mysql.com's avatar
monty@mysql.com committed
23
case `uname` in
24 25 26
    SCO_SV | UnixWare | OpenUNIX )
        # do nothing (Causes strange behavior)
        ;;
monty@mysql.com's avatar
monty@mysql.com 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
#--

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
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi 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
}


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

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

105 106 107 108 109
# For the future

wait_for_pid()
{
  pid=$1
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi 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!

115 116
SED=sed

117 118
BASENAME=`which basename`
if test $? != 0; then exit 1; fi
119
DIFF=`which diff | $SED q`
120
if test $? != 0; then exit 1; fi
121 122
CAT=cat
CUT=cut
monty@bitch.mysql.fi's avatar
monty@bitch.mysql.fi 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
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi 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."
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
154
  exit 1
155
fi
156

bk@work.mysql.com's avatar
bk@work.mysql.com 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

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
167
#BASEDIR is always one above mysql-test directory
bk@work.mysql.com's avatar
bk@work.mysql.com committed
168 169 170 171
CWD=`pwd`
cd ..
BASEDIR=`pwd`
cd $CWD
172
MYSQL_TEST_DIR=$BASEDIR/mysql-test
173
export MYSQL_TEST_DIR
174
STD_DATA=$MYSQL_TEST_DIR/std_data
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
175
hostname=`hostname`		# Installed in the mysql privilege table
176

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
177
MANAGER_QUIET_OPT="-q"
178
TESTDIR="$MYSQL_TEST_DIR/t"
179
TESTSUFFIX=test
180
TOT_SKIP=0
bk@work.mysql.com's avatar
bk@work.mysql.com committed
181 182 183
TOT_PASS=0
TOT_FAIL=0
TOT_TEST=0
184 185 186
USERT=0
SYST=0
REALT=0
187
FAST_START=""
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
188
MYSQL_TMP_DIR=$MYSQL_TEST_DIR/var/tmp
sasha@mysql.sashanet.com's avatar
sasha@mysql.sashanet.com committed
189
SLAVE_LOAD_TMPDIR=../../var/tmp #needs to be same length to test logging
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
190
RES_SPACE="      "
191
MYSQLD_SRC_DIRS="strings mysys include extra regex myisam \
192
 myisammrg heap sql"
193
MY_LOG_DIR="$MYSQL_TEST_DIR/var/log" 
194 195 196
#
# Set LD_LIBRARY_PATH if we are using shared libraries
#
197 198
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"
199
export LD_LIBRARY_PATH DYLD_LIBRARY_PATH
200

201 202 203 204 205 206 207
#
# Allow anyone in the group to see the generated database files
#
UMASK=0660
UMASK_DIR=0770
export UMASK UMASK_DIR

sasha@mysql.sashanet.com's avatar
fixed  
sasha@mysql.sashanet.com committed
208
MASTER_RUNNING=0
209
MASTER1_RUNNING=0
210
MASTER_MYPORT=9306
sasha@mysql.sashanet.com's avatar
fixed  
sasha@mysql.sashanet.com committed
211
SLAVE_RUNNING=0
212
SLAVE_MYPORT=9308 # leave room for 2 masters for cluster tests
sasha@mysql.sashanet.com's avatar
sasha@mysql.sashanet.com committed
213
MYSQL_MANAGER_PORT=9305 # needs to be out of the way of slaves
214
NDBCLUSTER_PORT=9350
sasha@mysql.sashanet.com's avatar
sasha@mysql.sashanet.com committed
215 216 217
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
218
NO_SLAVE=0
219
USER_TEST=
kent@mysql.com's avatar
kent@mysql.com committed
220
FAILED_CASES=
221

222
EXTRA_MASTER_OPT=""
223
EXTRA_MYSQL_TEST_OPT=""
224
EXTRA_MYSQLDUMP_OPT=""
225
EXTRA_MYSQLSHOW_OPT=""
226
EXTRA_MYSQLBINLOG_OPT=""
227
USE_RUNNING_SERVER=0
228
USE_NDBCLUSTER=@USE_NDBCLUSTER@
tomas@mc05.(none)'s avatar
tomas@mc05.(none) committed
229
USE_RUNNING_NDBCLUSTER=""
230 231
USE_PURIFY=""
PURIFY_LOGS=""
232 233
DO_GCOV=""
DO_GDB=""
234
MANUAL_GDB=""
235
DO_DDD=""
236
DO_CLIENT_GDB=""
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
237
SLEEP_TIME_AFTER_RESTART=1
238
SLEEP_TIME_FOR_DELETE=10
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
239
SLEEP_TIME_FOR_FIRST_MASTER=400		# Enough time to create innodb tables
240
SLEEP_TIME_FOR_SECOND_MASTER=400
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
241
SLEEP_TIME_FOR_FIRST_SLAVE=400
242
SLEEP_TIME_FOR_SECOND_SLAVE=300
243
CHARACTER_SET=latin1
244
DBUSER=""
245 246
START_WAIT_TIMEOUT=10
STOP_WAIT_TIMEOUT=10
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
247
MYSQL_TEST_SSL_OPTS=""
kent@mysql.com's avatar
kent@mysql.com committed
248
USE_TIMER=""
kent@mysql.com's avatar
kent@mysql.com committed
249
USE_EMBEDDED_SERVER=""
250
TEST_MODE=""
251

252
NDB_MGM_EXTRA_OPTS=
253 254 255
NDB_MGMD_EXTRA_OPTS=
NDBD_EXTRA_OPTS=

256 257
while test $# -gt 0; do
  case "$1" in
258 259 260
    --embedded-server)
      USE_EMBEDDED_SERVER=1
      USE_MANAGER=0 NO_SLAVE=1
kent@mysql.com's avatar
kent@mysql.com committed
261
      USE_RUNNING_SERVER=0
262 263 264 265
      TEST_MODE="$TEST_MODE embedded" ;;
    --purify)
      USE_PURIFY=1
      USE_MANAGER=0
kent@mysql.com's avatar
kent@mysql.com committed
266
      USE_RUNNING_SERVER=0
267
      TEST_MODE="$TEST_MODE purify" ;;
268 269
    --user=*) DBUSER=`$ECHO "$1" | $SED -e "s;--user=;;"` ;;
    --force)  FORCE=1 ;;
kent@mysql.com's avatar
kent@mysql.com committed
270
    --timer)  USE_TIMER=1 ;;
271
    --verbose-manager)  MANAGER_QUIET_OPT="" ;;
272 273 274 275 276
    --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=;;"` ;;
277 278
    --local)   USE_RUNNING_SERVER=0 ;;
    --extern)  USE_RUNNING_SERVER=1 ;;
tomas@mc05.(none)'s avatar
tomas@mc05.(none) committed
279
    --with-ndbcluster)
280
      USE_NDBCLUSTER="--ndbcluster" ;;
281
    --ndb-connectstring=*)
282
      USE_NDBCLUSTER="--ndbcluster" ;
283
      USE_RUNNING_NDBCLUSTER=`$ECHO "$1" | $SED -e "s;--ndb-connectstring=;;"` ;;
284 285
    --ndb_mgm-extra-opts=*)
      NDB_MGM_EXTRA_OPTS=`$ECHO "$1" | $SED -e "s;--ndb_mgm-extra-opts=;;"` ;;
286 287 288 289
    --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=;;"` ;;
290
    --tmpdir=*) MYSQL_TMP_DIR=`$ECHO "$1" | $SED -e "s;--tmpdir=;;"` ;;
291 292 293 294 295
    --local-master)
      MASTER_MYPORT=3306;
      EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT --host=127.0.0.1 \
      --port=$MYSQL_MYPORT"
      LOCAL_MASTER=1 ;;
296 297
    --master_port=*) MASTER_MYPORT=`$ECHO "$1" | $SED -e "s;--master_port=;;"` ;;
    --slave_port=*) SLAVE_MYPORT=`$ECHO "$1" | $SED -e "s;--slave_port=;;"` ;;
298
    --manager-port=*) MYSQL_MANAGER_PORT=`$ECHO "$1" | $SED -e "s;--manager_port=;;"` ;;
299
    --ndbcluster_port=*) NDBCLUSTER_PORT=`$ECHO "$1" | $SED -e "s;--ndbcluster_port=;;"` ;;
300 301
    --with-openssl)
     EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT \
tonu@x153.internalnet's avatar
tonu@x153.internalnet committed
302 303 304
     --ssl-ca=$BASEDIR/SSL/cacert.pem \
     --ssl-cert=$BASEDIR/SSL/server-cert.pem \
     --ssl-key=$BASEDIR/SSL/server-key.pem"
305
     EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT \
tonu@x153.internalnet's avatar
tonu@x153.internalnet committed
306 307
     --ssl-ca=$BASEDIR/SSL/cacert.pem \
     --ssl-cert=$BASEDIR/SSL/server-cert.pem \
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
308 309 310 311
     --ssl-key=$BASEDIR/SSL/server-key.pem"
     MYSQL_TEST_SSL_OPTS="--ssl-ca=$BASEDIR/SSL/cacert.pem \
     --ssl-cert=$BASEDIR/SSL/client-cert.pem \
     --ssl-key=$BASEDIR/SSL/client-key.pem" ;;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
312
    --no-manager | --skip-manager) USE_MANAGER=0 ;;
313 314
    --manager)
     USE_MANAGER=1
315
     USE_RUNNING_SERVER=0
316
     ;;
317 318
    --start-and-exit)
     START_AND_EXIT=1
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
319
     ;;
320
    --socket=*) LOCAL_SOCKET=`$ECHO "$1" | $SED -e "s;--socket=;;"` ;;
321
    --skip-rpl) NO_SLAVE=1 ;;
322
    --skip-test=*) SKIP_TEST=`$ECHO "$1" | $SED -e "s;--skip-test=;;"`;;
323
    --do-test=*) DO_TEST=`$ECHO "$1" | $SED -e "s;--do-test=;;"`;;
324
    --start-from=* ) START_FROM=`$ECHO "$1" | $SED -e "s;--start-from=;;"` ;;
325 326 327 328
    --warnings | --log-warnings)
     EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --log-warnings"
     EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --log-warnings"
     ;;
329 330 331
    --wait-timeout=*)
     START_WAIT_TIMEOUT=`$ECHO "$1" | $SED -e "s;--wait-timeout=;;"`
     STOP_WAIT_TIMEOUT=$START_WAIT_TIMEOUT;;
332 333 334
    --record)
      RECORD=1;
      EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT $1" ;;
335 336 337 338 339
    --small-bench)
      DO_SMALL_BENCH=1
      DO_BENCH=1
      NO_SLAVE=1
      ;;
340 341 342
    --bench)
      DO_BENCH=1
      NO_SLAVE=1
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
343
      ;;
344 345
    --big*)			# Actually --big-test
      EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT $1" ;;
346 347
    --compress)
      EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT $1" ;;
348 349
    --sleep=*)
      EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT $1"
350
      SLEEP_TIME_AFTER_RESTART=`$ECHO "$1" | $SED -e "s;--sleep=;;"`
351
      ;;
352
    --ps-protocol)
353
      TEST_MODE="$TEST_MODE ps-protocol" EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT $1" ;;
354 355 356
    --user-test=*)
      USER_TEST=`$ECHO "$1" | $SED -e "s;--user-test=;;"`
      ;;
357
    --mysqld=*)
serg@serg.mysql.com's avatar
serg@serg.mysql.com committed
358
       TMP=`$ECHO "$1" | $SED -e "s;--mysqld=;;"`
359
       EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT $TMP"
360
       EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT $TMP"
361
       ;;
362 363 364 365 366 367
    --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
368
      GCOV=`which gcov`
369
      ;;
370 371
    --gprof )
      DO_GPROF=1
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
372
      ;;
373
    --gdb )
374 375
      START_WAIT_TIMEOUT=300
      STOP_WAIT_TIMEOUT=300
376
      if [ x$BINARY_DIST = x1 ] ; then
377
	$ECHO "Note: you will get more meaningful output on a source distribution compiled with debugging option when running tests with --gdb option"
378 379
      fi
      DO_GDB=1
380 381
      EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --gdb"
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --gdb"
382 383
      # This needs to be checked properly
      # USE_MANAGER=1
384
      USE_RUNNING_SERVER=0
385
      ;;
386 387 388 389 390
    --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
391 392
      EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --gdb"
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --gdb"
393
      ;;
394 395 396
    --manual-gdb )
      DO_GDB=1
      MANUAL_GDB=1
397
      USE_RUNNING_SERVER=0
398 399
      EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --gdb"
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --gdb"
400
      ;;
401 402
    --ddd )
      if [ x$BINARY_DIST = x1 ] ; then
403
	$ECHO "Note: you will get more meaningful output on a source distribution compiled with debugging option when running tests with --ddd option"
404 405
      fi
      DO_DDD=1
406
      USE_RUNNING_SERVER=0
407 408
      EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --gdb"
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --gdb"
409
      ;;
410
    --valgrind | --valgrind-all)
guilhem@mysql.com's avatar
guilhem@mysql.com committed
411 412 413
      VALGRIND=`which valgrind` # this will print an error if not found
      # Give good warning to the user and stop
      if [ -z "$VALGRIND" ] ; then
414
        $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 ."
guilhem@mysql.com's avatar
guilhem@mysql.com committed
415 416
        exit 1
      fi
417 418
      # >=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"
419
      VALGRIND="$VALGRIND --alignment=8 --leak-check=yes --num-callers=16 --suppressions=$CWD/valgrind.supp"
420 421
      EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --skip-safemalloc --skip-bdb"
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --skip-safemalloc --skip-bdb"
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
422
      SLEEP_TIME_AFTER_RESTART=10
423
      SLEEP_TIME_FOR_DELETE=60
424
      USE_RUNNING_SERVER=0
425 426 427 428
      if test "$1" = "--valgrind-all"
      then
        VALGRIND="$VALGRIND -v --show-reachable=yes"
      fi
429 430 431 432 433
      ;;
    --valgrind-options=*)
      TMP=`$ECHO "$1" | $SED -e "s;--valgrind-options=;;"`
      VALGRIND="$VALGRIND $TMP"
      ;;
434
    --skip-ndbcluster | --skip-ndb)
435
      USE_NDBCLUSTER=""
436 437
      EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT --skip-ndbcluster"
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT --skip-ndbcluster"
438
      ;;
439 440 441 442
    --skip-*)
      EXTRA_MASTER_MYSQLD_OPT="$EXTRA_MASTER_MYSQLD_OPT $1"
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT $1"
      ;;
443 444
    --strace-client )
      STRACE_CLIENT=1
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
445
      ;;
446
    --debug)
447
      EXTRA_MASTER_MYSQLD_TRACE=" \
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
448
       --debug=d:t:i:A,$MYSQL_TEST_DIR/var/log/master.trace"
449
      EXTRA_SLAVE_MYSQLD_OPT="$EXTRA_SLAVE_MYSQLD_OPT \
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
450
       --debug=d:t:i:A,$MYSQL_TEST_DIR/var/log/slave.trace"
451 452
      EXTRA_MYSQL_TEST_OPT="$EXTRA_MYSQL_TEST_OPT \
       --debug=d:t:A,$MYSQL_TEST_DIR/var/log/mysqltest.trace"
453 454
      EXTRA_MYSQLDUMP_OPT="$EXTRA_MYSQLDUMP_OPT \
       --debug=d:t:A,$MYSQL_TEST_DIR/var/log/mysqldump.trace"
455 456
      EXTRA_MYSQLSHOW_OPT="$EXTRA_MYSQLSHOW_OPT \
       --debug=d:t:A,$MYSQL_TEST_DIR/var/log/mysqlshow.trace"
457 458
      EXTRA_MYSQLBINLOG_OPT="$EXTRA_MYSQLBINLOG_OPT \
       --debug=d:t:A,$MYSQL_TEST_DIR/var/log/mysqlbinlog.trace"
459
      EXTRA_MYSQL_CLIENT_TEST_OPT="--debug=d:t:A,$MYSQL_TEST_DIR/var/log/mysql_client_test.trace"
460
      ;;
461 462 463
    --fast)
      FAST_START=1
      ;;
464 465 466
    --use-old-data)
      USE_OLD_DATA=1;
      ;;
467 468 469 470 471 472
    -- )  shift; break ;;
    --* ) $ECHO "Unrecognized option: $1"; exit 1 ;;
    * ) break ;;
  esac
  shift
done
sasha@mysql.sashanet.com's avatar
fixed  
sasha@mysql.sashanet.com committed
473

474 475 476 477 478 479 480
if [ -z "$TEST_MODE" ] ; then
  TEST_MODE="default"
else
  # Remove the leading space if any
  TEST_MODE=`echo $TEST_MODE | sed 's/^ *//'`
fi

bk@work.mysql.com's avatar
bk@work.mysql.com committed
481 482 483
#++
# mysqld Environment Parameters
#--
484

monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
485
MYRUN_DIR=$MYSQL_TEST_DIR/var/run
486 487
MANAGER_PID_FILE="$MYRUN_DIR/manager.pid"

488
MASTER_MYDDIR="$MYSQL_TEST_DIR/var/master-data"
489
MASTER_MYSOCK="$MYSQL_TMP_DIR/master.sock"
490
MASTER_MYSOCK1=$MYSQL_MYSOCK"1"
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
491 492 493
MASTER_MYPID="$MYRUN_DIR/master.pid"
MASTER_MYLOG="$MYSQL_TEST_DIR/var/log/master.log"
MASTER_MYERR="$MYSQL_TEST_DIR/var/log/master.err"
494 495

SLAVE_MYDDIR="$MYSQL_TEST_DIR/var/slave-data"
496
SLAVE_MYSOCK="$MYSQL_TMP_DIR/slave.sock"
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
497 498 499
SLAVE_MYPID="$MYRUN_DIR/slave.pid"
SLAVE_MYLOG="$MYSQL_TEST_DIR/var/log/slave.log"
SLAVE_MYERR="$MYSQL_TEST_DIR/var/log/slave.err"
500

501
CURRENT_TEST="$MYSQL_TEST_DIR/var/log/current_test"
502
SMALL_SERVER="--key_buffer_size=1M --sort_buffer=256K --max_heap_table_size=1M"
503

504
export MASTER_MYPORT SLAVE_MYPORT MYSQL_TCP_PORT MASTER_MYSOCK MASTER_MYSOCK1
sasha@mysql.sashanet.com's avatar
sasha@mysql.sashanet.com committed
505

506
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"
507
NDB_BACKUP_DIR=$MYSQL_TEST_DIR/var/ndbcluster-$NDBCLUSTER_PORT
508
NDB_TOOLS_OUTPUT=$MYSQL_TEST_DIR/var/log/ndb_tools.log
509

510 511 512 513
if [ x$SOURCE_DIST = x1 ] ; then
 MY_BASEDIR=$MYSQL_TEST_DIR
else
 MY_BASEDIR=$BASEDIR
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
514
fi
bk@work.mysql.com's avatar
bk@work.mysql.com committed
515

monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
516 517 518 519 520 521 522 523
# 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
524
[ -d $MYSQL_TEST_DIR/var/log ] || mkdir $MYSQL_TEST_DIR/var/log
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
525

526
if test ${COLUMNS:-0} -lt 80 ; then COLUMNS=80 ; fi
527
E=`$EXPR $COLUMNS - 8`
kent@mysql.com's avatar
kent@mysql.com committed
528
DASH72=`$ECHO '-------------------------------------------------------'|$CUT -c 1-$E`
529

530 531 532
# on source dist, we pick up freshly build executables
# on binary, use what is installed
if [ x$SOURCE_DIST = x1 ] ; then
kent@mysql.com's avatar
kent@mysql.com committed
533
 if [ "x$USE_EMBEDDED_SERVER" = "x1" ] ; then
534 535
   if [ -f "$BASEDIR/libmysqld/examples/mysqltest_embedded" ] ; then
     MYSQL_TEST="$VALGRIND $BASEDIR/libmysqld/examples/mysqltest_embedded"
kent@mysql.com's avatar
kent@mysql.com committed
536
   else
537
     echo "Fatal error: Cannot find embedded server 'mysqltest_embedded'" 1>&2
kent@mysql.com's avatar
kent@mysql.com committed
538 539
     exit 1
   fi
540
   MYSQL_CLIENT_TEST="$BASEDIR/libmysqld/examples/mysql_client_test_embedded"
541
 else
542 543 544 545
   MYSQLD="$BASEDIR/sql/mysqld"
   if [ -n "$VALGRIND" ] ; then
     MYSQLD="$VALGRIND $MYSQLD"
   fi
kent@mysql.com's avatar
kent@mysql.com committed
546 547 548 549 550 551 552
   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
553
   MYSQL_CLIENT_TEST="$BASEDIR/tests/mysql_client_test"
554
 fi
555
 if [ -f "$BASEDIR/client/.libs/mysqldump" ] ; then
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
556
   MYSQL_DUMP="$BASEDIR/client/.libs/mysqldump"
557
 else
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
558
   MYSQL_DUMP="$BASEDIR/client/mysqldump"
559
 fi
560 561 562 563 564
 if [ -f "$BASEDIR/client/.libs/mysqlshow" ] ; then
   MYSQL_SHOW="$BASEDIR/client/.libs/mysqlshow"
 else
   MYSQL_SHOW="$BASEDIR/client/mysqlshow"
 fi
565
 if [ -f "$BASEDIR/client/.libs/mysqlbinlog" ] ; then
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
566
   MYSQL_BINLOG="$BASEDIR/client/.libs/mysqlbinlog"
567
 else
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
568
   MYSQL_BINLOG="$BASEDIR/client/mysqlbinlog"
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
569
 fi
570 571 572
 if [ -n "$STRACE_CLIENT" ]; then
  MYSQL_TEST="strace -o $MYSQL_TEST_DIR/var/log/mysqltest.strace $MYSQL_TEST"
 fi
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
573

monty@mysql.com's avatar
monty@mysql.com committed
574 575
 CLIENT_BINDIR="$BASEDIR/client"
 MYSQLADMIN="$CLIENT_BINDIR/mysqladmin"
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
576
 WAIT_PID="$BASEDIR/extra/mysql_waitpid"
577 578 579
 MYSQL_MANAGER_CLIENT="$CLIENT_BINDIR/mysqltestmanagerc"
 MYSQL_MANAGER="$BASEDIR/tools/mysqltestmanager"
 MYSQL_MANAGER_PWGEN="$CLIENT_BINDIR/mysqltestmanager-pwgen"
monty@mysql.com's avatar
monty@mysql.com committed
580
 MYSQL="$CLIENT_BINDIR/mysql"
581
 LANGUAGE="$BASEDIR/sql/share/english/"
582
 CHARSETSDIR="$BASEDIR/sql/share/charsets"
583
 INSTALL_DB="./install_test_db"
584
 MYSQL_FIX_SYSTEM_TABLES="$BASEDIR/scripts/mysql_fix_privilege_tables"
585
 NDB_TOOLS_DIR="$BASEDIR/ndb/tools"
586
 NDB_MGM="$BASEDIR/ndb/src/mgmclient/ndb_mgm"
587 588

 if [ -n "$USE_PURIFY" ] ; then
589
   PSUP="$MYSQL_TEST_DIR/suppress.purify"
590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608
   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

609
else
610 611 612 613 614 615 616 617

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

618 619
 if test -x "$BASEDIR/libexec/mysqld"
 then
620
   MYSQLD="$VALGRIND $BASEDIR/libexec/mysqld"
621
 else
622
   MYSQLD="$VALGRIND $BASEDIR/bin/mysqld"
623
 fi
monty@mysql.com's avatar
monty@mysql.com committed
624
 CLIENT_BINDIR="$BASEDIR/bin"
625 626 627 628 629 630
 if test -d "$BASEDIR/tests"
 then
   TESTS_BINDIR="$BASEDIR/tests"
 else
   TESTS_BINDIR="$BASEDIR/bin"
 fi
monty@mysql.com's avatar
monty@mysql.com committed
631 632
 MYSQL_TEST="$CLIENT_BINDIR/mysqltest"
 MYSQL_DUMP="$CLIENT_BINDIR/mysqldump"
633
 MYSQL_SHOW="$CLIENT_BINDIR/mysqlshow"
monty@mysql.com's avatar
monty@mysql.com committed
634 635 636
 MYSQL_BINLOG="$CLIENT_BINDIR/mysqlbinlog"
 MYSQLADMIN="$CLIENT_BINDIR/mysqladmin"
 WAIT_PID="$CLIENT_BINDIR/mysql_waitpid"
637 638 639
 MYSQL_MANAGER="$CLIENT_BINDIR/mysqltestmanager"
 MYSQL_MANAGER_CLIENT="$CLIENT_BINDIR/mysqltestmanagerc"
 MYSQL_MANAGER_PWGEN="$CLIENT_BINDIR/mysqltestmanager-pwgen"
monty@mysql.com's avatar
monty@mysql.com committed
640
 MYSQL="$CLIENT_BINDIR/mysql"
641
 INSTALL_DB="./install_test_db --bin"
monty@mysql.com's avatar
monty@mysql.com committed
642
 MYSQL_FIX_SYSTEM_TABLES="$CLIENT_BINDIR/mysql_fix_privilege_tables"
643
 NDB_TOOLS_DIR="$CLIENT_BINDIR"
644
 NDB_MGM="$CLIENT_BINDIR/ndb_mgm"
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
645
 if test -d "$BASEDIR/share/mysql/english"
646 647
 then
   LANGUAGE="$BASEDIR/share/mysql/english/"
648
   CHARSETSDIR="$BASEDIR/share/mysql/charsets"
649 650
 else
   LANGUAGE="$BASEDIR/share/english/"
651
   CHARSETSDIR="$BASEDIR/share/charsets"
652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668
 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
   MYSQL_TEST="$CLIENT_BINDIR/mysqltest"
   MYSQL_CLIENT_TEST="$CLIENT_BINDIR/mysql_client_test"
 fi
669 670
fi

671 672 673 674 675 676 677 678 679 680
if [ -z "$MASTER_MYSQLD" ]
then
MASTER_MYSQLD=$MYSQLD
fi

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

681 682 683 684
# If we should run all tests cases, we will use a local server for that

if [ -z "$1" ]
then
685
   USE_RUNNING_SERVER=0
686
fi
687
if [ $USE_RUNNING_SERVER -eq 1 ]
688
then
689
   MASTER_MYSOCK=$LOCAL_SOCKET;
690
   DBUSER=${DBUSER:-test}
691
else
692
   DBUSER=${DBUSER:-root}		# We want to do FLUSH xxx commands
693
fi
694 695 696

if [ -w / ]
then
monty@mysql.com's avatar
monty@mysql.com committed
697 698 699
  # 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"
700 701
fi

702
MYSQL_CLIENT_TEST="$MYSQL_CLIENT_TEST --no-defaults --testcase --user=root --socket=$MASTER_MYSOCK --port=$MYSQL_TCP_PORT --silent $EXTRA_MYSQL_CLIENT_TEST_OPT"
703 704 705 706 707 708
# 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
709
MYSQL_DUMP="$MYSQL_DUMP --no-defaults -uroot --socket=$MASTER_MYSOCK --password=$DBPASSWD $EXTRA_MYSQLDUMP_OPT"
710
MYSQL_SHOW="$MYSQL_SHOW -uroot --socket=$MASTER_MYSOCK --password=$DBPASSWD $EXTRA_MYSQLSHOW_OPT"
711
MYSQL_BINLOG="$MYSQL_BINLOG --no-defaults --local-load=$MYSQL_TMP_DIR  --character-sets-dir=$CHARSETSDIR $EXTRA_MYSQLBINLOG_OPT"
712 713
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"
MYSQL="$MYSQL --host=localhost --port=$MASTER_MYPORT --socket=$MASTER_MYSOCK --user=root --password=$DBPASSWD"
714
export MYSQL MYSQL_DUMP MYSQL_SHOW MYSQL_BINLOG MYSQL_FIX_SYSTEM_TABLES
715
export CLIENT_BINDIR MYSQL_CLIENT_TEST CHARSETSDIR
716
export NDB_TOOLS_DIR
717
export NDB_MGM
718
export NDB_BACKUP_DIR
719
export NDB_TOOLS_OUTPUT
720
export PURIFYOPTIONS
721 722
NDB_STATUS_OK=1
export NDB_STATUS_OK
723

724
MYSQL_TEST_ARGS="--no-defaults --socket=$MASTER_MYSOCK --database=$DB \
725
 --user=$DBUSER --password=$DBPASSWD --silent -v --skip-safemalloc \
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
726
 --tmpdir=$MYSQL_TMP_DIR --port=$MASTER_MYPORT $MYSQL_TEST_SSL_OPTS"
kent@mysql.com's avatar
kent@mysql.com committed
727 728 729
if [ x$USE_TIMER = x1 ] ; then
  MYSQL_TEST_ARGS="$MYSQL_TEST_ARGS --timer-file=$MY_LOG_DIR/timer"
fi
730 731 732
MYSQL_TEST_BIN=$MYSQL_TEST
MYSQL_TEST="$MYSQL_TEST $MYSQL_TEST_ARGS"
GDB_CLIENT_INIT=$MYSQL_TMP_DIR/gdbinit.client
733 734 735
GDB_MASTER_INIT=$MYSQL_TMP_DIR/gdbinit.master
GDB_SLAVE_INIT=$MYSQL_TMP_DIR/gdbinit.slave
GCOV_MSG=$MYSQL_TMP_DIR/mysqld-gcov.out
736 737 738 739
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
740
TIMEFILE="$MYSQL_TEST_DIR/var/log/mysqltest-time"
741 742 743
if [ -n "$DO_CLIENT_GDB" -o -n "$DO_GDB" ] ; then
  XTERM=`which xterm`
fi
744

745
export MYSQL MYSQL_DUMP MYSQL_SHOW MYSQL_BINLOG MYSQL_FIX_SYSTEM_TABLES CLIENT_BINDIR MASTER_MYSOCK
monty@mysql.com's avatar
monty@mysql.com committed
746

bk@work.mysql.com's avatar
bk@work.mysql.com committed
747 748 749 750
#++
# Function Definitions
#--

751 752
prompt_user ()
{
753
 $ECHO $1
754
 read unused
755 756
}

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

759 760 761 762
show_failed_diff ()
{
  reject_file=r/$1.reject
  result_file=r/$1.result
763
  eval_file=r/$1.eval
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
764

765 766 767 768
  if [ -f $eval_file ]
  then
    result_file=$eval_file
  fi
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
769

770 771 772 773
  if [ -x "$DIFF" ] && [ -f $reject_file ]
  then
    echo "Below are the diffs between actual and expected results:"
    echo "-------------------------------------------------------"
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
774
    $DIFF -c $result_file $reject_file
775
    echo "-------------------------------------------------------"
776
    echo "Please follow the instructions outlined at"
777
    echo "http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html"
778
    echo "to find the reason to this problem and how to report this."
779
    echo ""
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
780
  fi
781
}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
782

783 784 785 786 787 788
do_gdb_test ()
{
  mysql_test_args="$MYSQL_TEST_ARGS $1"
  $ECHO "set args $mysql_test_args < $2" > $GDB_CLIENT_INIT
  echo "Set breakpoints ( if needed) and type 'run' in gdb window"
  #this xterm should not be backgrounded
monty@bitch.mysql.fi's avatar
monty@bitch.mysql.fi committed
789
  $XTERM -title "Client" -e gdb -x $GDB_CLIENT_INIT $MYSQL_TEST_BIN
790 791
}

bk@work.mysql.com's avatar
bk@work.mysql.com committed
792
error () {
793
    $ECHO  "Error:  $1"
bk@work.mysql.com's avatar
bk@work.mysql.com committed
794 795 796
    exit 1
}

797
error_is () {
798 799
    $ECHO "Errors are (from $TIMEFILE) :"
    $CAT < $TIMEFILE
800
    $ECHO "(the last lines may be the most important ones)"
801 802
}

monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
803
prefix_to_8() {
804
 $ECHO "        $1" | $SED -e 's:.*\(........\)$:\1:'
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
805 806
}

bk@work.mysql.com's avatar
bk@work.mysql.com committed
807
pass_inc () {
808
    TOT_PASS=`$EXPR $TOT_PASS + 1`
bk@work.mysql.com's avatar
bk@work.mysql.com committed
809 810 811
}

fail_inc () {
812
    TOT_FAIL=`$EXPR $TOT_FAIL + 1`
bk@work.mysql.com's avatar
bk@work.mysql.com committed
813 814
}

815 816 817 818
skip_inc () {
    TOT_SKIP=`$EXPR $TOT_SKIP + 1`
}

bk@work.mysql.com's avatar
bk@work.mysql.com committed
819
total_inc () {
820
    TOT_TEST=`$EXPR $TOT_TEST + 1`
bk@work.mysql.com's avatar
bk@work.mysql.com committed
821 822
}

823 824 825 826 827 828

skip_test() {
   USERT="    ...."
   SYST="    ...."
   REALT="    ...."
   pname=`$ECHO "$1                        "|$CUT -c 1-24`
829
   RES="$pname"
830 831 832 833
   skip_inc
   $ECHO "$RES$RES_SPACE [ skipped ]"
}

834 835 836 837 838 839 840 841 842 843 844

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

kent@mysql.com's avatar
Merge  
kent@mysql.com committed
845

846 847 848 849 850 851 852 853 854 855 856
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
}

kent@mysql.com's avatar
Merge  
kent@mysql.com committed
857

bk@work.mysql.com's avatar
bk@work.mysql.com committed
858
report_stats () {
859
    if [ $TOT_FAIL = 0 ]; then
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
860
	$ECHO "All $TOT_TEST tests were successful."
bk@work.mysql.com's avatar
bk@work.mysql.com committed
861
    else
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
862 863 864 865 866 867
	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`
868
	$ECHO  "Failed ${TOT_FAIL}/${TOT_TEST} tests, ${whole}.${deci}% were successful."
869
	$ECHO ""
870
        $ECHO "The log files in $MY_LOG_DIR may give you some hint"
871 872
	$ECHO "of what when wrong."
	$ECHO "If you want to report this error, please read first the documentation at"
873
        $ECHO "http://www.mysql.com/doc/en/MySQL_test_suite.html"
bk@work.mysql.com's avatar
bk@work.mysql.com committed
874
    fi
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
875

876
    if [ $USE_RUNNING_SERVER -eq 0 ]
877 878
    then

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
879 880 881 882
    # 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
883
    $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' \
884 885 886
        $MY_LOG_DIR/*.err \
        | $SED -e 's!Warning:  Table:.* on rename!!g' \
        > $MY_LOG_DIR/warnings.tmp
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
887 888 889 890 891

    found_error=0
    # Find errors
    for i in "^Warning:" "^Error:" "^==.* at 0x"
    do
892
      if $GREP "$i" $MY_LOG_DIR/warnings.tmp >> $MY_LOG_DIR/warnings
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
893 894 895 896 897 898 899 900 901 902
      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
903
    fi
bk@work.mysql.com's avatar
bk@work.mysql.com committed
904
}
905

bk@work.mysql.com's avatar
bk@work.mysql.com committed
906
mysql_install_db () {
907
    $ECHO "Removing Stale Files"
908 909 910 911 912
    if [ -z "$USE_OLD_DATA" ]; then
      $RM -rf $MASTER_MYDDIR $MASTER_MYDDIR"1"
      $ECHO "Installing Master Databases"
      $INSTALL_DB
      if [ $? != 0 ]; then
913
	error "Could not install master test DBs"
914 915
        exit 1
      fi
916
    fi
917 918 919 920 921 922 923 924 925
    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
926
    $ECHO "Installing Slave Databases"
927
    $RM -rf $SLAVE_MYDDIR $MY_LOG_DIR/* 
928
    $INSTALL_DB -slave
929
    if [ $? != 0 ]; then
930
	error "Could not install slave test DBs"
931
	exit 1
bk@work.mysql.com's avatar
bk@work.mysql.com committed
932
    fi
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
933

934 935
    for slave_num in 1 2 ;
    do
936
      $RM -rf var/slave$slave_num-data
937 938 939
      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
940
    done
bk@work.mysql.com's avatar
bk@work.mysql.com committed
941 942 943
    return 0
}

944 945
gprof_prepare ()
{
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
946 947
 $RM -rf $GPROF_DIR
 mkdir -p $GPROF_DIR
948 949 950 951 952
}

gprof_collect ()
{
 if [ -f $MASTER_MYDDIR/gmon.out ]; then
953
   gprof $MASTER_MYSQLD $MASTER_MYDDIR/gmon.out > $GPROF_MASTER
954 955 956
   echo "Master execution profile has been saved in $GPROF_MASTER"
 fi
 if [ -f $SLAVE_MYDDIR/gmon.out ]; then
957
   gprof $SLAVE_MYSQLD $SLAVE_MYDDIR/gmon.out > $GPROF_SLAVE
958 959 960 961
   echo "Slave execution profile has been saved in $GPROF_SLAVE"
 fi
}

962
gcov_prepare () {
963 964
    $FIND $BASEDIR -name \*.gcov \
    -or -name \*.da | $XARGS $RM
965 966 967
}

gcov_collect () {
968
    $ECHO "Collecting source coverage info..."
969 970
    [ -f $GCOV_MSG ] && $RM $GCOV_MSG
    [ -f $GCOV_ERR ] && $RM $GCOV_ERR
971 972 973
    for d in $MYSQLD_SRC_DIRS; do
	cd $BASEDIR/$d
	for f in *.h *.cc *.c; do
974
	    $GCOV $f 2>>$GCOV_ERR  >>$GCOV_MSG
975
	done
976
	cd $MYSQL_TEST_DIR
977 978
    done

monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
979
    $ECHO "gcov info in $GCOV_MSG, errors in $GCOV_ERR"
980 981
}

982 983 984 985 986
abort_if_failed()
{
 if [ ! $? = 0 ] ; then
  echo $1
  exit 1
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
987
 fi
988 989 990 991
}

start_manager()
{
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
992
 if [ $USE_MANAGER = 0 ] ; then
993 994
   echo "Manager disabled, skipping manager start."
   $RM -f $MYSQL_MANAGER_LOG
995 996
  return
 fi
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
997
 $ECHO "Starting MySQL Manager"
998 999 1000 1001 1002 1003 1004 1005 1006
 if [ -f "$MANAGER_PID_FILE" ] ; then
    kill `cat $MANAGER_PID_FILE`
    sleep 1
    if [ -f "$MANAGER_PID_FILE" ] ; then
     kill -9 `cat $MANAGER_PID_FILE`
     sleep 1
    fi
 fi

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1007
 $RM -f $MANAGER_PID_FILE
1008 1009
 MYSQL_MANAGER_PW=`$MYSQL_MANAGER_PWGEN -u $MYSQL_MANAGER_USER \
 -o $MYSQL_MANAGER_PW_FILE`
1010
 $MYSQL_MANAGER --log=$MYSQL_MANAGER_LOG --port=$MYSQL_MANAGER_PORT \
1011
  --password-file=$MYSQL_MANAGER_PW_FILE --pid-file=$MANAGER_PID_FILE
1012
  abort_if_failed "Could not start MySQL manager"
1013 1014
  mysqltest_manager_args="--manager-host=localhost \
  --manager-user=$MYSQL_MANAGER_USER \
1015 1016 1017 1018 1019
  --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"
1020 1021 1022 1023
  while [ ! -f $MANAGER_PID_FILE ] ; do
   sleep 1
  done
  echo "Manager started"
1024 1025
}

1026 1027
stop_manager()
{
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1028
 if [ $USE_MANAGER = 0 ] ; then
1029 1030
  return
 fi
1031 1032 1033 1034
 $MYSQL_MANAGER_CLIENT $MANAGER_QUIET_OPT -u$MYSQL_MANAGER_USER \
  -p$MYSQL_MANAGER_PW -P $MYSQL_MANAGER_PORT <<EOF
shutdown
EOF
1035 1036
 echo "Manager terminated"

1037 1038 1039
}

manager_launch()
1040
{
1041 1042
  ident=$1
  shift
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1043
  if [ $USE_MANAGER = 0 ] ; then
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
1044
    echo $@ | /bin/sh  >> $CUR_MYERR 2>&1  &
1045 1046
    sleep 2 #hack
    return
1047
  fi
1048
  $MYSQL_MANAGER_CLIENT $MANAGER_QUIET_OPT --user=$MYSQL_MANAGER_USER \
1049
   --password=$MYSQL_MANAGER_PW  --port=$MYSQL_MANAGER_PORT <<EOF
1050
def_exec $ident "$@"
1051 1052 1053 1054
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
1055
EOF
1056
  abort_if_failed "Could not execute manager command"
1057
}
1058

1059 1060
manager_term()
{
1061 1062
  pid=$1
  ident=$2
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1063
  if [ $USE_MANAGER = 0 ] ; then
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1064
    # Shutdown time must be high as slave may be in reconnect
1065
    $MYSQLADMIN --no-defaults -uroot --socket=$MYSQL_TMP_DIR/$ident.sock$3 --connect_timeout=5 --shutdown_timeout=70 shutdown >> $MYSQL_MANAGER_LOG 2>&1
1066 1067
    res=$?
    # Some systems require an extra connect
1068
    $MYSQLADMIN --no-defaults -uroot --socket=$MYSQL_TMP_DIR/$ident.sock$3 --connect_timeout=1 ping >> $MYSQL_MANAGER_LOG 2>&1
1069 1070 1071 1072 1073
    if test $res = 0
    then
      wait_for_pid $pid
    fi
    return $res
1074
  fi
1075 1076
  $MYSQL_MANAGER_CLIENT $MANAGER_QUIET_OPT --user=$MYSQL_MANAGER_USER \
   --password=$MYSQL_MANAGER_PW  --port=$MYSQL_MANAGER_PORT <<EOF
1077
stop_exec $ident $STOP_WAIT_TIMEOUT
1078 1079 1080 1081
EOF
 abort_if_failed "Could not execute manager command"
}

1082 1083 1084 1085
start_ndbcluster()
{
  if [ ! -z "$USE_NDBCLUSTER" ]
  then
joreland@mysql.com's avatar
merge  
joreland@mysql.com committed
1086
  rm -f $NDB_TOOLS_OUTPUT
1087 1088 1089 1090 1091
  if [ -z "$USE_RUNNING_NDBCLUSTER" ]
  then
    echo "Starting ndbcluster"
    if [ "$DO_BENCH" = 1 ]
    then
1092
      NDBCLUSTER_EXTRA_OPTS=""
1093
    else
1094
      NDBCLUSTER_EXTRA_OPTS="--small"
1095
    fi
1096 1097
    ./ndb/ndbcluster $NDBCLUSTER_OPTS $NDBCLUSTER_EXTRA_OPTS --initial || NDB_STATUS_OK=0
    if [ x$NDB_STATUS_OK != x1 ] ; then
1098 1099 1100
      if [ x$FORCE != x1 ] ; then
        exit 1
      fi
1101 1102
      USE_NDBCLUSTER=
      return
1103
    fi
1104

1105
    NDB_CONNECTSTRING="host=localhost:$NDBCLUSTER_PORT"
1106
  else
1107 1108
    NDB_CONNECTSTRING="$USE_RUNNING_NDBCLUSTER"
    echo "Using ndbcluster at $NDB_CONNECTSTRING"
1109
  fi
1110 1111
  USE_NDBCLUSTER="$USE_NDBCLUSTER --ndb-connectstring=\"$NDB_CONNECTSTRING\""
  export NDB_CONNECTSTRING
1112 1113 1114 1115 1116 1117 1118 1119 1120 1121
  fi
}

stop_ndbcluster()
{
 if [ ! -z "$USE_NDBCLUSTER" ]
 then
 if [ -z "$USE_RUNNING_NDBCLUSTER" ]
 then
   # Kill any running ndbcluster stuff
1122
   ./ndb/ndbcluster $NDBCLUSTER_OPTS --stop
1123 1124 1125 1126
 fi
 fi
}

kent@mysql.com's avatar
kent@mysql.com committed
1127 1128
# The embedded server needs the cleanup so we do some of the start work
# but stop before actually running mysqld or anything.
1129

1130 1131
start_master()
{
1132 1133
  eval "this_master_running=\$MASTER$1_RUNNING"
  if [ x$this_master_running = x1 ] || [ x$LOCAL_MASTER = x1 ] ; then
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1134 1135
    return
  fi
guilhem@mysql.com's avatar
guilhem@mysql.com committed
1136 1137 1138
  # 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
1139
    $RM -f $MYSQL_TEST_DIR/var/log/master-bin$1.*
guilhem@mysql.com's avatar
guilhem@mysql.com committed
1140 1141
  fi

1142
  # Remove old master.info and relay-log.info files
1143
  $RM -f $MYSQL_TEST_DIR/var/master-data$1/master.info $MYSQL_TEST_DIR/var/master-data$1/relay-log.info
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1144 1145 1146 1147 1148 1149 1150 1151

  #run master initialization shell script if one exists

  if [ -f "$master_init_script" ] ;
  then
      /bin/sh $master_init_script
  fi
  cd $BASEDIR # for gcov
1152 1153 1154
  if [ -n "$1" ] ; then
   id=`$EXPR $1 + 101`;
   this_master_myport=`$EXPR $MASTER_MYPORT + $1`
1155
   NOT_FIRST_MASTER_EXTRA_OPTS="--skip-innodb"
1156 1157
   eval "MASTER_MYPORT$1=$this_master_myport"
   export MASTER_MYPORT$1
1158 1159 1160
  else
   id=1;
   this_master_myport=$MASTER_MYPORT
1161
   NOT_FIRST_MASTER_EXTRA_OPTS=""
1162
  fi
1163 1164
  if [ -n "$EXTRA_MASTER_MYSQLD_TRACE" ] 
  then
1165
      CURR_MASTER_MYSQLD_TRACE="$EXTRA_MASTER_MYSQLD_TRACE$1"
1166
  fi
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1167 1168
  if [ -z "$DO_BENCH" ]
  then
1169 1170
    master_args="--no-defaults --log-bin=$MYSQL_TEST_DIR/var/log/master-bin$1 \
  	    --server-id=$id  \
1171
          --basedir=$MY_BASEDIR \
1172
          --port=$this_master_myport \
1173
          --local-infile \
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1174 1175
          --exit-info=256 \
          --core \
tomas@mc05.(none)'s avatar
tomas@mc05.(none) committed
1176
          $USE_NDBCLUSTER \
1177 1178 1179 1180
          --datadir=$MASTER_MYDDIR$1 \
          --pid-file=$MASTER_MYPID$1 \
          --socket=$MASTER_MYSOCK$1 \
          --log=$MASTER_MYLOG$1 \
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1181 1182 1183 1184
          --character-sets-dir=$CHARSETSDIR \
          --default-character-set=$CHARACTER_SET \
          --tmpdir=$MYSQL_TMP_DIR \
          --language=$LANGUAGE \
1185
          --innodb_data_file_path=ibdata1:128M:autoextend \
1186
	  --open-files-limit=1024 \
1187
          --log-bin-trust-routine-creators \
1188
	   $MASTER_40_ARGS \
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1189
           $SMALL_SERVER \
1190
           $EXTRA_MASTER_OPT $EXTRA_MASTER_MYSQLD_OPT \
1191
           $NOT_FIRST_MASTER_EXTRA_OPTS $CURR_MASTER_MYSQLD_TRACE"
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1192
  else
1193 1194
    master_args="--no-defaults --log-bin=$MYSQL_TEST_DIR/var/log/master-bin$1 \
          --server-id=$id --rpl-recovery-rank=1 \
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1195
          --basedir=$MY_BASEDIR --init-rpl-role=master \
1196
          --port=$this_master_myport \
1197
          --local-infile \
1198 1199 1200
          --datadir=$MASTER_MYDDIR$1 \
          --pid-file=$MASTER_MYPID$1 \
          --socket=$MASTER_MYSOCK$1 \
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1201 1202 1203
          --character-sets-dir=$CHARSETSDIR \
          --default-character-set=$CHARACTER_SET \
          --core \
tomas@mc05.(none)'s avatar
tomas@mc05.(none) committed
1204
          $USE_NDBCLUSTER \
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1205 1206
          --tmpdir=$MYSQL_TMP_DIR \
          --language=$LANGUAGE \
1207
          --innodb_data_file_path=ibdata1:128M:autoextend \
1208
          --log-bin-trust-routine-creators \
1209
	   $MASTER_40_ARGS \
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1210
           $SMALL_SERVER \
1211 1212
           $EXTRA_MASTER_OPT $EXTRA_MASTER_MYSQLD_OPT \
           $NOT_FIRST_MASTER_EXTRA_OPTS"
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1213 1214 1215 1216 1217
  fi

  CUR_MYERR=$MASTER_MYERR
  CUR_MYSOCK=$MASTER_MYSOCK

kent@mysql.com's avatar
kent@mysql.com committed
1218 1219 1220 1221 1222 1223 1224 1225 1226 1227 1228 1229
  # 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

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1230 1231 1232 1233
  if [ x$DO_DDD = x1 ]
  then
    $ECHO "set args $master_args" > $GDB_MASTER_INIT
    manager_launch master ddd -display $DISPLAY --debugger \
1234
    "gdb -x $GDB_MASTER_INIT" $MASTER_MYSQLD
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1235 1236
  elif [ x$DO_GDB = x1 ]
  then
1237 1238 1239 1240
    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:"
1241
      $ECHO "cd $CWD ; gdb -x $GDB_MASTER_INIT $MASTER_MYSQLD"
1242 1243 1244 1245
      wait_for_master=1500
    else
      ( $ECHO set args $master_args;
      if [ $USE_MANAGER = 0 ] ; then
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1246
    cat <<EOF
serg@serg.mysql.com's avatar
serg@serg.mysql.com committed
1247 1248
b mysql_parse
commands 1
1249
disa 1
serg@serg.mysql.com's avatar
serg@serg.mysql.com committed
1250
end
1251 1252
r
EOF
1253 1254
      fi )  > $GDB_MASTER_INIT
      manager_launch master $XTERM -display $DISPLAY \
1255
      -title "Master" -e gdb -x $GDB_MASTER_INIT $MASTER_MYSQLD
1256
    fi
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1257
  else
1258
    manager_launch master $MASTER_MYSQLD $master_args
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1259
  fi
1260
  sleep_until_file_created $MASTER_MYPID$1 $wait_for_master
1261
  wait_for_master=$SLEEP_TIME_FOR_SECOND_MASTER
1262
  eval "MASTER$1_RUNNING=1"
1263 1264 1265 1266
}

start_slave()
{
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1267 1268 1269
  [ x$SKIP_SLAVE = x1 ] && return
  eval "this_slave_running=\$SLAVE$1_RUNNING"
  [ x$this_slave_running = 1 ] && return
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1270 1271
  # When testing fail-safe replication, we will have more than one slave
  # in this case, we start secondary slaves with an argument
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1272 1273 1274 1275 1276 1277 1278 1279
  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"
1280
   slave_datadir="$SLAVE_MYDDIR/../$slave_ident-data/"
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1281 1282 1283 1284 1285 1286 1287 1288 1289 1290 1291 1292
   slave_pid="$MYRUN_DIR/mysqld-$slave_ident.pid"
   slave_sock="$SLAVE_MYSOCK-$1"
  else
   slave_server_id=2
   slave_rpl_rank=2
   slave_port=$SLAVE_MYPORT
   slave_log=$SLAVE_MYLOG
   slave_err=$SLAVE_MYERR
   slave_datadir=$SLAVE_MYDDIR
   slave_pid=$SLAVE_MYPID
   slave_sock="$SLAVE_MYSOCK"
 fi
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1293
  # Remove stale binary logs and old master.info files
guilhem@mysql.com's avatar
guilhem@mysql.com committed
1294 1295 1296 1297 1298 1299
  # 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
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1300 1301 1302 1303 1304 1305 1306 1307 1308 1309 1310

  #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 \
1311
          --master-password="" \
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1312 1313 1314 1315 1316 1317 1318 1319 1320 1321
          --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 \
1322
          --relay-log=$MYSQL_TEST_DIR/var/log/$slave_ident-relay-bin \
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1323 1324 1325 1326 1327 1328 1329 1330 1331 1332 1333 1334
          --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 \
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
1335
          --skip-innodb --skip-ndbcluster --skip-slave-start \
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1336 1337 1338
          --slave-load-tmpdir=$SLAVE_LOAD_TMPDIR \
          --report-host=127.0.0.1 --report-user=root \
          --report-port=$slave_port \
1339
          --master-retry-count=10 \
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1340
          -O slave_net_timeout=10 \
1341
          --log-bin-trust-routine-creators \
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1342 1343 1344 1345 1346 1347 1348
           $SMALL_SERVER \
           $EXTRA_SLAVE_OPT $EXTRA_SLAVE_MYSQLD_OPT"
  CUR_MYERR=$slave_err
  CUR_MYSOCK=$slave_sock

  if [ x$DO_DDD = x1 ]
  then
1349
    $ECHO "set args $slave_args" > $GDB_SLAVE_INIT
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1350 1351 1352 1353
    manager_launch $slave_ident ddd -display $DISPLAY --debugger \
     "gdb -x $GDB_SLAVE_INIT" $SLAVE_MYSQLD
  elif [ x$DO_GDB = x1 ]
  then
1354 1355
    if [ x$MANUAL_GDB = x1 ]
    then
1356
      $ECHO "set args $slave_args" > $GDB_SLAVE_INIT
1357
      echo "To start gdb for the slave, type in another window:"
1358
      echo "cd $CWD ; gdb -x $GDB_SLAVE_INIT $SLAVE_MYSQLD"
1359 1360
      wait_for_slave=1500
    else
1361 1362 1363 1364 1365 1366 1367 1368 1369 1370
      ( $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
1371 1372 1373
      manager_launch $slave_ident $XTERM -display $DISPLAY -title "Slave" -e \
      gdb -x $GDB_SLAVE_INIT $SLAVE_MYSQLD
    fi
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1374 1375 1376 1377
  else
    manager_launch $slave_ident $SLAVE_MYSQLD $slave_args
  fi
  eval "SLAVE$1_RUNNING=1"
1378
  sleep_until_file_created $slave_pid $wait_for_slave
1379
  wait_for_slave=$SLEEP_TIME_FOR_SECOND_SLAVE
1380 1381
}

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1382 1383
mysql_start ()
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1384
# We should not start the daemon here as we don't know the arguments
paul@ice.snake.net's avatar
paul@ice.snake.net committed
1385
# for the test.  Better to let the test start the daemon
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1386 1387 1388 1389

#  $ECHO "Starting MySQL daemon"
#  start_master
#  start_slave
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1390
  cd $MYSQL_TEST_DIR
1391
  start_ndbcluster
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1392
  return 1
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1393 1394
}

1395 1396
stop_slave ()
{
1397 1398 1399
  eval "this_slave_running=\$SLAVE$1_RUNNING"
  slave_ident="slave$1"
  if [ -n "$1" ] ;
1400
  then
1401 1402 1403
   slave_pid="$MYRUN_DIR/mysqld-$slave_ident.pid"
  else
   slave_pid=$SLAVE_MYPID
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1404
  fi
1405 1406
  if [ x$this_slave_running = x1 ]
  then
1407 1408
    pid=`$CAT $slave_pid`
    manager_term $pid $slave_ident
1409
    if [ $? != 0 ] && [ -f $slave_pid ]
1410
    then # try harder!
1411
      $ECHO "slave not cooperating with mysqladmin, will try manual kill"
1412 1413
      kill $pid
      sleep_until_file_deleted $pid $slave_pid
1414 1415 1416 1417 1418 1419 1420 1421 1422
      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
1423
    fi
1424
    eval "SLAVE$1_RUNNING=0"
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1425
  fi
1426
}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1427

1428 1429 1430 1431 1432 1433 1434 1435 1436 1437
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
}

1438 1439
stop_master ()
{
1440 1441
  eval "this_master_running=\$MASTER$1_RUNNING"
  if [ x$this_master_running = x1 ]
1442
  then
kent@mysql.com's avatar
kent@mysql.com committed
1443 1444 1445
    # 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
tomas@poseidon.ndb.mysql.com's avatar
Merge  
tomas@poseidon.ndb.mysql.com committed
1446
      pid=`$CAT $MASTER_MYPID$1`
1447
      manager_term $pid master $1
tomas@poseidon.ndb.mysql.com's avatar
Merge  
tomas@poseidon.ndb.mysql.com committed
1448
      if [ $? != 0 ] && [ -f $MASTER_MYPID$1 ]
kent@mysql.com's avatar
kent@mysql.com committed
1449 1450 1451
      then # try harder!
	$ECHO "master not cooperating with mysqladmin, will try manual kill"
	kill $pid
tomas@poseidon.ndb.mysql.com's avatar
Merge  
tomas@poseidon.ndb.mysql.com committed
1452 1453
	sleep_until_file_deleted $pid $MASTER_MYPID$1
	if [ -f $MASTER_MYPID$1 ] ; then
kent@mysql.com's avatar
kent@mysql.com committed
1454
	  $ECHO "master refused to die. Sending SIGKILL"
tomas@poseidon.ndb.mysql.com's avatar
Merge  
tomas@poseidon.ndb.mysql.com committed
1455 1456
	  kill -9 `$CAT $MASTER_MYPID$1`
	  $RM -f $MASTER_MYPID$1
kent@mysql.com's avatar
kent@mysql.com committed
1457 1458 1459
	else
	  $ECHO "master responded to SIGTERM "
	fi
1460
      else
kent@mysql.com's avatar
kent@mysql.com committed
1461
	sleep $SLEEP_TIME_AFTER_RESTART
1462
      fi
1463
    fi
1464
    eval "MASTER$1_RUNNING=0"
1465 1466
  fi
}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1467

1468 1469
mysql_stop ()
{
1470 1471 1472 1473 1474 1475
  if [ "$MASTER_RUNNING" = 1 ]
  then
    $ECHO  "Ending Tests"
    $ECHO  "Shutting-down MySQL daemon"
    $ECHO  ""
    stop_master
monty@mysql.com's avatar
monty@mysql.com committed
1476
    stop_master 1
1477 1478 1479 1480 1481
    $ECHO "Master shutdown finished"
    stop_slave
    stop_slave 1
    stop_slave 2
    $ECHO "Slave shutdown finished"
monty@mysql.com's avatar
monty@mysql.com committed
1482
    stop_ndbcluster
1483 1484
  fi
  return 1
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1485 1486
}

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1487 1488 1489 1490 1491
mysql_restart ()
{
  mysql_stop
  mysql_start
  return 1
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1492 1493 1494
}

mysql_loadstd () {
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1495 1496

    # cp $STD_DATA/*.frm $STD_DATA/*.MRG $MASTER_MYDDIR/test
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1497 1498 1499
    return 1
}

1500 1501 1502
run_testcase ()
{
 tf=$1
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1503
 tname=`$BASENAME $tf .test`
1504 1505
 master_opt_file=$TESTDIR/$tname-master.opt
 slave_opt_file=$TESTDIR/$tname-slave.opt
1506 1507
 master_init_script=$TESTDIR/$tname-master.sh
 slave_init_script=$TESTDIR/$tname-slave.sh
1508
 slave_master_info_file=$TESTDIR/$tname.slave-mi
kent@mysql.com's avatar
kent@mysql.com committed
1509 1510
 tsrcdir=$TESTDIR/$tname-src
 result_file="r/$tname.result"
1511
 echo $tname > $CURRENT_TEST
1512
 SKIP_SLAVE=`$EXPR \( $tname : rpl \) = 0 \& \( $tname : federated \) = 0`
1513
 if [ "$USE_MANAGER" = 1 ] ; then
guilhem@mysql.com's avatar
guilhem@mysql.com committed
1514
  many_slaves=`$EXPR \( \( $tname : rpl_failsafe \) != 0 \) \| \( \( $tname : rpl_chain_temp_table \) != 0 \)`
1515 1516 1517 1518
 fi
 if $EXPR "$tname" '<' "$START_FROM" > /dev/null ; then
   #skip_test $tname
   return
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1519 1520
 fi

1521 1522 1523 1524
 if [ "$SKIP_TEST" ] ; then
   if $EXPR \( "$tname" : "$SKIP_TEST" \) > /dev/null ; then
     skip_test $tname
     return
1525
   fi
1526
 fi
1527

1528 1529
 if [ "$DO_TEST" ] ; then
   if $EXPR \( "$tname" : "$DO_TEST" \) > /dev/null ; then
1530
     : #empty command to keep some shells happy
1531 1532 1533
   else
     #skip_test $tname
     return
1534
   fi
1535
 fi
1536

1537 1538
 if [ x${NO_SLAVE}x$SKIP_SLAVE = x1x0 ] ; then
   skip_test $tname
1539 1540 1541
   return
 fi

kent@mysql.com's avatar
kent@mysql.com committed
1542 1543 1544 1545 1546 1547
# if [ -f "$TESTDIR/$tname.disabled" ]
# then
#   comment=`$CAT $TESTDIR/$tname.disabled`;
#   disable_test $tname "$comment"
#   return
# fi
kent@mysql.com's avatar
kent@mysql.com committed
1548 1549 1550 1551 1552 1553 1554 1555
 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
kent@mysql.com's avatar
kent@mysql.com committed
1556 1557
 fi

kent@mysql.com's avatar
kent@mysql.com committed
1558 1559 1560 1561 1562 1563 1564 1565 1566 1567 1568 1569
 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 \
1570 1571
       "init_connect" \
       "init_file"
kent@mysql.com's avatar
kent@mysql.com committed
1572 1573 1574 1575 1576 1577 1578
   do
     if [ "$tname" = "$t" ] ; then
       skip_test $tname
       return
     fi
   done
 fi
1579

1580
 if [ $USE_RUNNING_SERVER -eq 0 ] ;
1581
 then
1582 1583
   if [ -f $master_opt_file ] ;
   then
1584
     EXTRA_MASTER_OPT=`$CAT $master_opt_file | $SED -e "s;\\$MYSQL_TEST_DIR;$MYSQL_TEST_DIR;"`
1585 1586 1587 1588 1589 1590 1591
     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=" "
	 ;;
1592 1593
       --result-file=*)
         result_file=`$ECHO "$EXTRA_MASTER_OPT" | $SED -e "s;--result-file=;;"`
kent@mysql.com's avatar
kent@mysql.com committed
1594
         result_file="r/$result_file.result"
1595 1596
         # Note that this must be set to space, not "" for test-reset to
# work
1597 1598
	 EXTRA_MASTER_OPT=" "
         ;;
1599
     esac
1600
     stop_master
1601
     stop_master 1
1602
     report_current_test $tname
1603
     start_master
1604
     if [ -n "$USE_NDBCLUSTER" -a -z "$DO_BENCH" ] ; then
1605 1606
       start_master 1
     fi
1607
     TZ=$MY_TZ; export TZ
1608
   else
kent@mysql.com's avatar
kent@mysql.com committed
1609 1610 1611 1612 1613
     # 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 ]
1614 1615 1616
     then
       EXTRA_MASTER_OPT=""
       stop_master
1617
       stop_master 1
1618
       report_current_test $tname
1619
       start_master
1620
       if [ -n "$USE_NDBCLUSTER"  -a -z "$DO_BENCH" ] ; then
1621 1622
         start_master 1
       fi
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1623
     else
1624
       report_current_test $tname
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1625
     fi
1626
   fi
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1627

kent@mysql.com's avatar
kent@mysql.com committed
1628 1629 1630 1631
   # 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 ] ;
1632
     then
kent@mysql.com's avatar
kent@mysql.com committed
1633
       EXTRA_SLAVE_OPT=`$CAT $slave_opt_file | $SED -e "s;\\$MYSQL_TEST_DIR;$MYSQL_TEST_DIR;"`
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1634
       do_slave_restart=1
kent@mysql.com's avatar
kent@mysql.com committed
1635 1636 1637 1638 1639 1640
     else
      if [ ! -z "$EXTRA_SLAVE_OPT" ] || [ x$SLAVE_RUNNING != x1 ] ;
      then
	EXTRA_SLAVE_OPT=""
	do_slave_restart=1
      fi
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1641
     fi
1642

kent@mysql.com's avatar
kent@mysql.com committed
1643 1644 1645 1646 1647 1648 1649 1650 1651 1652 1653 1654 1655 1656 1657 1658 1659 1660 1661 1662 1663 1664
     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
1665
   fi
sasha@mysql.sashanet.com's avatar
fixed  
sasha@mysql.sashanet.com committed
1666
 fi
1667 1668 1669 1670 1671 1672

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

1673
 cd $MYSQL_TEST_DIR
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1674

1675
 if [ -f $tf ] ; then
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1676
    $RM -f r/$tname.*reject
kent@mysql.com's avatar
kent@mysql.com committed
1677
    mysql_test_args="-R $result_file $EXTRA_MYSQL_TEST_OPT"
1678
    if [ -z "$DO_CLIENT_GDB" ] ; then
1679
      `$MYSQL_TEST  $mysql_test_args < $tf 2> $TIMEFILE`;
1680
    else
1681
      do_gdb_test "$mysql_test_args" "$tf"
1682
    fi
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1683

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1684 1685
    res=$?

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

1689 1690 1691 1692
    if [ x$many_slaves = x1 ] ; then
     stop_slave 1
     stop_slave 2
    fi
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1693

monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1694
    if [ $res = 0 ]; then
1695 1696
      total_inc
      pass_inc
kent@mysql.com's avatar
kent@mysql.com committed
1697
      TIMER=""
kent@mysql.com's avatar
kent@mysql.com committed
1698
      if [ x$USE_TIMER = x1 -a -f "$MY_LOG_DIR/timer" ]; then
kent@mysql.com's avatar
kent@mysql.com committed
1699 1700 1701 1702
	TIMER=`cat $MY_LOG_DIR/timer`
	TIMER=`$PRINTF "%13s" $TIMER`
      fi
      $ECHO "$RES$RES_SPACE [ pass ]   $TIMER"
1703
    else
1704
      # why the following ``if'' ? That is why res==1 is special ?
1705
      if [ $res = 62 ]; then
1706 1707 1708
        skip_inc
	$ECHO "$RES$RES_SPACE [ skipped ]"
      else
1709
        if [ $res -ne 1 ]; then
1710 1711
          $ECHO "mysqltest returned unexpected code $res, it has probably crashed" >> $TIMEFILE
        fi
1712
	total_inc
1713
        fail_inc
1714
	$ECHO "$RES$RES_SPACE [ fail ]"
1715 1716
        $ECHO
	error_is
kent@mysql.com's avatar
kent@mysql.com committed
1717
	show_failed_diff $tname
1718
	$ECHO
1719
	if [ x$FORCE != x1 ] ; then
1720
	 $ECHO "Aborting: $tname failed in $TEST_MODE mode. To continue, re-run with '--force'."
1721
	 $ECHO
1722
         if [ -z "$DO_GDB" ] && [ $USE_RUNNING_SERVER -eq 0 ] && \
kent@mysql.com's avatar
kent@mysql.com committed
1723
	    [ -z "$DO_DDD" ] && [ -z "$USE_EMBEDDED_SERVER" ]
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1724 1725
	 then
	   mysql_stop
1726
	   stop_manager
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1727
   	 fi
1728 1729
	 exit 1
	fi
kent@mysql.com's avatar
kent@mysql.com committed
1730
	FAILED_CASES="$FAILED_CASES $tname"
1731
        if [ -z "$DO_GDB" ] && [ $USE_RUNNING_SERVER -eq 0 ] && \
kent@mysql.com's avatar
kent@mysql.com committed
1732
	   [ -z "$DO_DDD" ] && [ -z "$USE_EMBEDDED_SERVER" ]
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1733 1734 1735
	then
	  mysql_restart
	fi
1736
      fi
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1737
    fi
1738
  fi
1739 1740
}

monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
1741 1742 1743 1744
######################################################################
# Main script starts here
######################################################################

1745 1746
[ "$DO_GCOV" -a ! -x "$GCOV" ] && error "No gcov found"

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1747 1748
[ "$DO_GCOV" ] && gcov_prepare
[ "$DO_GPROF" ] && gprof_prepare
1749

1750
if [ $USE_RUNNING_SERVER -eq 0 ]
1751
then
1752 1753 1754 1755
  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
1756
    $MYSQLADMIN --no-defaults --socket=$MASTER_MYSOCK1 -u root -O connect_timeout=5 -O shutdown_timeout=20 shutdown > /dev/null 2>&1
1757 1758
    $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
1759
    $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
1760 1761 1762
    $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
1763
    sleep_until_file_deleted 0 $MASTER_MYPID"1"
1764 1765
    sleep_until_file_deleted 0 $SLAVE_MYPID
  else
1766
    rm $MASTER_MYPID $MASTER_MYPID"1" $SLAVE_MYPID
1767
  fi
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1768 1769 1770 1771 1772 1773 1774 1775 1776 1777 1778 1779 1780

  # 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

1781
  stop_ndbcluster
tomas@mc05.(none)'s avatar
tomas@mc05.(none) committed
1782

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1783
  # Remove files that can cause problems
1784
  $RM -rf $MYSQL_TEST_DIR/var/ndbcluster
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1785 1786
  $RM -f $MYSQL_TEST_DIR/var/run/* $MYSQL_TEST_DIR/var/tmp/*

1787 1788
  # Remove old berkeley db log files that can confuse the server
  $RM -f $MASTER_MYDDIR/log.*
1789
  $RM -f $MASTER_MYDDIR"1"/log.*
1790

1791 1792
  wait_for_master=$SLEEP_TIME_FOR_FIRST_MASTER
  wait_for_slave=$SLEEP_TIME_FOR_FIRST_SLAVE
1793 1794
  $ECHO "Installing Test Databases"
  mysql_install_db
tomas@mc05.(none)'s avatar
tomas@mc05.(none) committed
1795

1796
  start_manager
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1797

paul@ice.snake.net's avatar
paul@ice.snake.net committed
1798
# Do not automagically start daemons if we are in gdb or running only one test
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1799
# case
1800 1801 1802 1803 1804 1805
  if [ -z "$DO_GDB" ] && [ -z "$DO_DDD" ]
  then
    mysql_start
  fi
  $ECHO  "Loading Standard Test Databases"
  mysql_loadstd
1806 1807
fi

1808
$ECHO  "Starting Tests"
1809

1810 1811 1812
# Some test cases need USE_RUNNING_SERVER
export USE_RUNNING_SERVER

1813 1814 1815
#
# This can probably be deleted
#
1816 1817
if [ "$DO_BENCH" = 1 ]
then
1818 1819
  start_master

1820 1821 1822 1823 1824
  if [ "$DO_SMALL_BENCH" = 1 ]
  then
    EXTRA_BENCH_ARGS="--small-test --small-tables"
  fi

1825 1826
  if [ ! -z "$USE_NDBCLUSTER" ]
  then
1827
    EXTRA_BENCH_ARGS="--create-options=TYPE=ndb $EXTRA_BENCH_ARGS"
1828 1829
  fi 

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1830 1831 1832 1833
  BENCHDIR=$BASEDIR/sql-bench/
  savedir=`pwd`
  cd $BENCHDIR
  if [ -z "$1" ]
1834
  then
1835
    ./run-all-tests --socket=$MASTER_MYSOCK --user=root $EXTRA_BENCH_ARGS --log
1836
  else
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1837 1838
    if [ -x "./$1" ]
    then
1839
       ./$1 --socket=$MASTER_MYSOCK --user=root $EXTRA_BENCH_ARGS
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1840 1841 1842
    else
      echo "benchmark $1 not found"
    fi
1843
  fi
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1844 1845 1846 1847
  cd $savedir
  mysql_stop
  stop_manager
  exit
1848 1849
fi

1850
$ECHO
kent@mysql.com's avatar
kent@mysql.com committed
1851
if [ x$USE_TIMER = x1 ] ; then
kent@mysql.com's avatar
kent@mysql.com committed
1852
$ECHO "TEST                            RESULT        TIME (ms)"
kent@mysql.com's avatar
kent@mysql.com committed
1853 1854 1855
else
$ECHO "TEST                            RESULT"
fi
1856 1857
$ECHO $DASH72

1858
if [ -z "$1" ] ;
1859
then
1860 1861 1862
  if [ x$RECORD = x1 ]; then
    $ECHO "Will not run in record mode without a specific test case."
  else
1863 1864 1865 1866
    for tf in $TESTDIR/*.$TESTSUFFIX
    do
      run_testcase $tf
    done
1867 1868
    $RM -f $TIMEFILE	# Remove for full test
  fi
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1869
else
1870 1871 1872 1873 1874 1875 1876 1877 1878 1879
  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
1880
fi
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1881

1882 1883
$ECHO $DASH72
$ECHO
1884

1885
if [ -z "$DO_GDB" ] && [ $USE_RUNNING_SERVER -eq 0 ] && [ -z "$DO_DDD" ]
1886 1887 1888
then
    mysql_stop
fi
1889
stop_manager
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1890
report_stats
1891
$ECHO
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1892

1893
[ "$DO_GCOV" ] && gcov_collect # collect coverage information
1894
[ "$DO_GPROF" ] && gprof_collect # collect coverage information
1895

kent@mysql.com's avatar
kent@mysql.com committed
1896
if [ $TOT_FAIL -ne 0 ]; then
1897
  $ECHO "mysql-test-run in $TEST_MODE mode: *** Failing the test(s):$FAILED_CASES"
kent@mysql.com's avatar
kent@mysql.com committed
1898 1899 1900 1901 1902
  $ECHO
  exit 1
else
  exit 0
fi